[jboss-user] [jBPM] - Re: username and password in jbpm-console

kais ben slama do-not-reply at jboss.com
Fri Apr 1 05:40:38 EDT 2011


kais ben slama [http://community.jboss.org/people/kaissun] created the discussion

"Re: username and password in jbpm-console"

To view the discussion, visit: http://community.jboss.org/message/597118#597118

--------------------------------------------------------------
So I think that we don't have a solution for this problem.
I have this problem too and I think that the data base schema is not really created.
So that we cannot load the example users and groups from ${jbpm.home}/install/src/demo/example.identities.sql
 (+)  this file contains the list of users/password mentioned in the user guide. 

 (+)  the creation of DB schema by create.jbpm.schema give me an error : 

[java] 10:53:42,560 FIN | [HibernateSessionResource] ----- beginning hibernate tx 6829563 ----------------------------------------
[java] 10:53:43,567 WRN | [JDBCExceptionReporter] SQL Error: -80, SQLState: 08000
[java] 10:53:43,567 SEV | [JDBCExceptionReporter] socket creation error
[java] ### EXCEPTION ###########################################
[java] 10:53:43,567 SEV | [HibernateSessionResource] hibernate transaction begin failed.  closing hibernate session
[java] org.hibernate.exception.JDBCConnectionException: Cannot open connection
[java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
[java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
[java]     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
[java]     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
[java]     at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
[java]     at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
[java]     at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
[java]     at org.jbpm.pvm.internal.tx.HibernateSessionResource.<init>(HibernateSessionResource.java:44)
[java]     at org.jbpm.pvm.internal.wire.descriptor.HibernateSessionDescriptor.construct(HibernateSessionDescriptor.java:87)
[java]     at org.jbpm.pvm.internal.wire.WireContext.construct(WireContext.java:487)
[java]     at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:466)
[java]     at org.jbpm.pvm.internal.wire.WireContext.create(WireContext.java:455)
[java]     at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:429)
[java]     at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:339)
[java]     at org.jbpm.pvm.internal.wire.WireContext.get(WireContext.java:704)
[java]     at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:132)
[java]     at org.jbpm.pvm.internal.env.BasicEnvironment.get(BasicEnvironment.java:123)
[java]     at org.jbpm.db.Create$1.execute(Create.java:55)
[java]     at org.jbpm.db.Create$1.execute(Create.java:51)
[java]     at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
[java]     at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
[java]     at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
[java]     at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
[java]     at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
[java]     at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
[java]     at org.jbpm.pvm.internal.processengine.ProcessEngineImpl.execute(ProcessEngineImpl.java:300)
[java]     at org.jbpm.db.Create.main(Create.java:51)
[java] Caused by: java.sql.SQLException: socket creation error
[java]     at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
[java]     at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
[java]     at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
[java]     at org.hsqldb.jdbcDriver.connect(Unknown Source)
[java]     at java.sql.DriverManager.getConnection(DriverManager.java:525)
[java]     at java.sql.DriverManager.getConnection(DriverManager.java:140)
[java]     at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:133)
[java]     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
[java]     ... 24 more
[java] ### EXCEPTION ###########################################
[java] ### EXCEPTION ###########################################
[java] 10:53:43,740 INF | [DefaultCommandService] exception while executing command org.jbpm.db.Create$1 at 18e261d
[java] org.hibernate.exception.JDBCConnectionException: Cannot open connection
[java]     at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97)
[java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[java]     at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
[java]     at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449)
[java]     at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
...

could you help us please ??
and thanks in advance      :)
--------------------------------------------------------------

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

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20110401/ad3feb76/attachment-0001.html 


More information about the jboss-user mailing list