I noticed that occasionally following statement fails:
jbpmContext.getGraphSession
However, calling it again works. For example, I fixed above by
try {
jbpmContext.getGraphSession();
} catch (org.hibernate.exception.JDBCConnectionException e) {
jbpmContext.getGraphSession();
}
I have tried both hsqldb and mysqldb and I see same sporadic erros. Is this
known problem? Here is full stack trace:
org.hibernate.exception.JDBCConnectionException: Cannot open connection at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:72) at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:318)
at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:137) at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1262) at
org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
at
org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:216)
at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:427) at
com.orbitz.txn.jbpm.TransactionWorkflowImpl.initContext(TransactionWorkflowImpl.java:449)
at
com.orbitz.txn.jbpm.TransactionWorkflowImpl.init(TransactionWorkflowImpl.java:250)
at
com.orbitz.txn.jbpm.command.CommandContextImplTest.testGet(CommandContextImplTest.java:113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)Caused
by: com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception: ** BEGIN NESTED EXCEPTION **
java.net.SocketExceptionMESSAGE: java.net.ConnectException: Connection
refusedSTACKTRACE:java.net.SocketException: java.net.ConnectException:
Connection refused at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151) at
com.mysql.jdbc.MysqlIO.(MysqlIO.java:280) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1774) at
com.mysql.jdbc.Connection.(Connection.java:437) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) at
java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:140) at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
at
org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:137) at
org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57) at
org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1262) at
org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:98)
at
org.jbpm.persistence.db.DbPersistenceService.getGraphSession(DbPersistenceService.java:216)
at org.jbpm.JbpmContext.getGraphSession(JbpmContext.java:427) at
com.orbitz.txn.jbpm.TransactionWorkflowImpl.initContext(TransactionWorkflowImpl.java:449)
at
com.orbitz.txn.jbpm.TransactionWorkflowImpl.init(TransactionWorkflowImpl.java:250)
at
com.orbitz.txn.jbpm.command.CommandContextImplTest.testGet(CommandContextImplTest.java:113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)**
END NESTED EXCEPTION ** at
com.mysql.jdbc.Connection.createNewIO(Connection.java:1839) at
com.mysql.jdbc.Connection.(Connection.java:437) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268) at
java.sql.DriverManager.getConnection(DriverManager.java:512) at
java.sql.DriverManager.getConnection(DriverManager.java:140) at
org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at
org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:315)
... 25 more
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3944021#3944021
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3944021
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user