Discussion:
[jboss-user] [jBPM] - error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5
Kehua Gao
2012-10-19 09:05:36 UTC
Permalink
Kehua Gao [https://community.jboss.org/people/kehuagao] created the discussion

"error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/766988#766988

--------------------------------------------------------------
check.jboss.version:
start.jboss5:
check.jboss.version:
start.jboss7:
start.human.task:
    [mkdir] Created dir: D:\jbpm-installer\task-service\target
    [javac] Compiling 1 source file to D:\jbpm-installer\task-service\target
     [copy] Copying 6 files to D:\jbpm-installer\task-service\target
     [java] 0    19/10 17:00:09,210[main] ERROR tool.hbm2ddl.SchemaExport.execut
e  - schema export unsuccessful
     [java] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communicati
ons link failure
     [java]
     [java] The last packet sent successfully to the server was 0 milliseconds a
go. The driver has not received any packets from the server.
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLErro
r.java:1116)
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
     [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java
:2332)
     [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp
l.java:2369)
     [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java
:2153)
     [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
     [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47
)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java
:381)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:305)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:154)
     [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC
onnection(DriverManagerConnectionProvider.java:133)
     [java]     at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnecti
onHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51)
     [java]     at org.hibernate.tool.hbm2ddl.SchemaExport.execute(SchemaExport.
java:252)
     [java]     at org.hibernate.tool.hbm2ddl.SchemaExport.create(SchemaExport.j
ava:211)
     [java]     at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryIm
pl.java:353)
     [java]     at org.hibernate.cfg.Configuration.buildSessionFactory(Configura
tion.java:1341)
     [java]     at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory
(AnnotationConfiguration.java:867)
     [java]     at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory
(Ejb3Configuration.java:669)
     [java]     at org.hibernate.ejb.HibernatePersistence.createEntityManagerFac
tory(HibernatePersistence.java:126)
     [java]     at javax.persistence.Persistence.createEntityManagerFactory(Pers
istence.java:52)
     [java]     at javax.persistence.Persistence.createEntityManagerFactory(Pers
istence.java:34)
     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)
     [java] Caused by: java.net.UnknownHostException:  localhost
     [java]     at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1083)
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1019)
     [java]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFa
ctory.java:247)
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
     [java]     ... 26 more
     [java] 3198 19/10 17:00:12,408[main] ERROR hibernate.util.JDBCExceptionRepo
rter.logExceptions  - Communications link failure
     [java]
     [java] The last packet sent successfully to the server was 0 milliseconds a
go. The driver has not received any packets from the server.
     [java] 3198 19/10 17:00:12,408[main] WARN  service.persistence.TaskLocalTra
nsactionManager.begin  - Unable to begin transaction
     [java] javax.persistence.PersistenceException: org.hibernate.exception.JDBC
ConnectionException: Cannot open connection
     [java]     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceE
xception(AbstractEntityManagerImpl.java:614)
     [java] Exception in thread "main" java.lang.RuntimeException: Unable to beg
in transaction
     [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:
41)
     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager
.begin(TaskLocalTransactionManager.java:46)
     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager
.begin(TaskLocalTransactionManager.java:42)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.begi
nTransaction(TaskPersistenceManager.java:79)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.begi
nTransaction(TaskPersistenceManager.java:79)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getU
nescalatedDeadlines(TaskPersistenceManager.java:144)
     [java]     at org.jbpm.task.service.persistence.TaskPersistenceManager.getU
nescalatedDeadlines(TaskPersistenceManager.java:144)
     [java]     at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedD
eadlines(TaskServiceSession.java:231)
     [java]     at org.jbpm.task.service.TaskServiceSession.scheduleUnescalatedD
eadlines(TaskServiceSession.java:231)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java
:116)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java
:101)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java
:116)
     [java]     at org.jbpm.task.service.TaskService.<init>(TaskService.java:79)
     [java]     at org.jbpm.task.service.TaskService.initialize(TaskService.java
:101)
     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)
     [java]     at org.jbpm.task.service.TaskService.<init>(TaskService.java:79)
     [java] Caused by: javax.persistence.PersistenceException: org.hibernate.exc
eption.JDBCConnectionException: Cannot open connection
     [java]     at org.jbpm.DemoTaskService.main(Unknown Source)
     [java]     at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceE
xception(AbstractEntityManagerImpl.java:614)
     [java] Caused by: org.hibernate.exception.JDBCConnectionException: Cannot o
pen connection
     [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:
41)
     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateCon
verter.java:97)
     [java]     at org.jbpm.task.service.persistence.TaskLocalTransactionManager
.begin(TaskLocalTransactionManager.java:42)
     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:66)
     [java]     ... 7 more
     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:52)
     [java] Caused by: org.hibernate.exception.JDBCConnectionException: Cannot o
pen connection
     [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:449)
     [java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateCon
verter.java:97)
     [java]     at org.hibernate.jdbc.ConnectionManager.getConnection(Connection
Manager.java:167)
     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:66)
     [java]     at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:14
2)
     [java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExcep
tionHelper.java:52)
     [java]     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransacti
on.java:85)
     [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:449)
     [java]     at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.j
ava:1354)
     [java]     at org.hibernate.jdbc.ConnectionManager.getConnection(Connection
Manager.java:167)
     [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:
38)
     [java]     at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:14
2)
     [java]     ... 8 more
     [java]     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransacti
on.java:85)
     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure
     [java]     at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.j
ava:1354)
     [java]
     [java]     at org.hibernate.ejb.TransactionImpl.begin(TransactionImpl.java:
38)
     [java] The last packet sent successfully to the server was 0 milliseconds a
go. The driver has not received any packets from the server.
     [java]     ... 8 more
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java] Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:
Communications link failure
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java] The last packet sent successfully to the server was 0 milliseconds a
go. The driver has not received any packets from the server.
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLErro
r.java:1116)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java
:2332)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp
l.java:2369)
     [java]     at com.mysql.jdbc.SQLError.createCommunicationsException(SQLErro
r.java:1116)
     [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java
:2153)
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:344)
     [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
     [java]     at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java
:2332)
     [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47
)
     [java]     at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImp
l.java:2369)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java]     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java
:2153)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:792)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java]     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47
)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeC
onstructorAccessorImpl.java:39)
     [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java
:381)
     [java]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Del
egatingConstructorAccessorImpl.java:27)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:305)
     [java]     at java.lang.reflect.Constructor.newInstance(Constructor.java:51
3)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:154)
     [java]     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java
:381)
     [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC
onnection(DriverManagerConnectionProvider.java:133)
     [java]     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDri
ver.java:305)
     [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:446)
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:582)
     [java]     ... 13 more
     [java]     at java.sql.DriverManager.getConnection(DriverManager.java:154)
     [java] Caused by: java.net.UnknownHostException:  localhost
     [java]     at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
     [java]     at org.hibernate.connection.DriverManagerConnectionProvider.getC
onnection(DriverManagerConnectionProvider.java:133)
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1083)
     [java]     at org.hibernate.jdbc.ConnectionManager.openConnection(Connectio
nManager.java:446)
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1019)
     [java]     ... 13 more
     [java]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFa
ctory.java:247)
     [java] Caused by: java.net.UnknownHostException:  localhost
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
     [java]     at java.net.InetAddress.getAllByName0(InetAddress.java:1157)
     [java]     ... 29 more
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1083)
     [java]     at java.net.InetAddress.getAllByName(InetAddress.java:1019)
     [java]     at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFa
ctory.java:247)
     [java]     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:294)
     [java]     ... 29 more
     [java] Java Result: 1
start.demo.db:
BUILD SUCCESSFUL
Total time: 11 seconds
D:\jbpm-installer>
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/766988#766988]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Chris Melas
2012-10-19 10:39:13 UTC
Permalink
Chris Melas [https://community.jboss.org/people/melc] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/767018#767018

--------------------------------------------------------------
Seems that the db is not reachable.
http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai http://stackoverflow.com/questions/2983248/com-mysql-jdbc-exceptions-jdbc4-communicationsexception-communications-link-fai
Is mysql installed in the same machine as jboss i.e. localhost?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/767018#767018]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Kehua Gao
2012-10-19 11:00:32 UTC
Permalink
Kehua Gao [https://community.jboss.org/people/kehuagao] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/767024#767024

--------------------------------------------------------------
mysql is installed in the same machine as jboss,I can connect with mysql in myeclipse
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/767024#767024]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Chris Melas
2012-10-19 11:30:59 UTC
Permalink
Chris Melas [https://community.jboss.org/people/melc] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/767035#767035

--------------------------------------------------------------
have you modified persistence.xml files and datasource in jboss? which jboss version are you using? make sure that the credentials for connecting are properly configured
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/767035#767035]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Kehua Gao
2012-10-19 13:09:52 UTC
Permalink
Kehua Gao [https://community.jboss.org/people/kehuagao] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/767069#767069

--------------------------------------------------------------
thank you for your reply,Chris Melas
I have modified these files
db/persistence.xml
task-service/resources/META-INF/persistence.xml
standalone.xml

I am using the JBoss AS 7 server
follow up "3.7. 10-Minute Tutorial: Using your own database with jBPM" in jBPM User Guide Version 5.3.0.Final
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/767069#767069]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Tan Vu
2013-01-24 21:07:11 UTC
Permalink
Tan Vu [https://community.jboss.org/people/tanvu] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/794170#794170

--------------------------------------------------------------
Did you ever get this to work?  I don't even see the persistence.xml file in the db folder.  Attached is the pic of all the files in db folder.  Loading Image... Loading Image...
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/794170#794170]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Thomas Setiabudi
2013-01-25 23:50:19 UTC
Permalink
Thomas Setiabudi [https://community.jboss.org/people/thomas.setiabudi] created the discussion

"Re: error when run "ant start.demo.db" with jbpm5.3 and mysql 5.5"

To view the discussion, visit: https://community.jboss.org/message/794402#794402

--------------------------------------------------------------
Hi Tan Vu,

Looks like you are using JBPM5.4 and not JBPM 5.3 there. Thats why you do not have persistence.xml in your db folder.

unfortunately the current guide for jbpm5.4 still refers to the old file names
http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609 http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609

I wrote about changing db for jbpm5.4 but it was for ms sql server, maybe this can help you
https://community.jboss.org/docs/DOC-47975 https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMSSQLServer2008UsingJTDS
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/794402#794402]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]
Loading...