[jboss-user] [JBoss jBPM] - Re: tomcat and mysql integration

[vsevel]

I do not have anymore the datasource problem.
I forgot to comment the datasource part of the hibernate file.

But now I have another problem:

anonymous wrote : INFO: connection properties: {user=jbossjbpm, password=****}
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | ATTENTION: Could not obtain connection metadata
  | com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: 
  | 
  | ** BEGIN NESTED EXCEPTION ** 
  | 
  | java.net.ConnectException
  | MESSAGE: Connection refused: connect
  | 
  | STACKTRACE:
  | 
  | java.net.ConnectException: Connection refused: connect
  | 	at java.net.PlainSocketImpl.socketConnect(Native Method)
  | 	at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
  | 	at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
  | 	at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
  | 	at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
  | 	at java.net.Socket.connect(Socket.java:518)
  | 	at java.net.Socket.connect(Socket.java:468)
  | 	at java.net.Socket.(Socket.java:365)
  | 	at java.net.Socket.(Socket.java:208)
  | 	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
  | 	at com.mysql.jdbc.MysqlIO.(MysqlIO.java:271)
  | 	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2771)
  | 	at com.mysql.jdbc.Connection.(Connection.java:1555)
  | 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
  | 	at java.sql.DriverManager.getConnection(DriverManager.java:582)
  | 	at java.sql.DriverManager.getConnection(DriverManager.java:154)
  | 	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  | 	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
  | 	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
  | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
  | 	at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:95)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:99)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:359)
  | 	at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
  | 	at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:112)
  | 	at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
  | 
  | 
  | ** END NESTED EXCEPTION **
  | 
  | 
  | 
  | Last packet sent to the server was 0 ms ago.
  | 	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2847)
  | 	at com.mysql.jdbc.Connection.(Connection.java:1555)
  | 	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
  | 	at java.sql.DriverManager.getConnection(DriverManager.java:582)
  | 	at java.sql.DriverManager.getConnection(DriverManager.java:154)
  | 	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
  | 	at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
  | 	at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
  | 	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
  | 	at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:95)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:99)
  | 	at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:359)
  | 	at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
  | 	at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:112)
  | 	at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:58)
  | 30 oct. 2007 14:30:19 org.hibernate.dialect.Dialect 
  | INFO: Using dialect: org.hibernate.dialect.MySQLInnoDBDialect
  | 30 oct. 2007 14:30:19 org.hibernate.transaction.TransactionFactoryFactory buildTransactionFactory
  | INFO: Transaction strategy: org.hibernate.transaction.JDBCTransactionFactory
  | 30 oct. 2007 14:30:19 org.hibernate.transaction.TransactionManagerLookupFactory getTransactionManagerLookup
  | INFO: No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Automatic flush during beforeCompletion(): disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Automatic session close at end of transaction: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Scrollable result sets: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: JDBC3 getGeneratedKeys(): disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Connection release mode: auto
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Maximum outer join fetch depth: 2
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Default batch fetch size: 1
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Generate SQL with comments: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Order SQL updates by primary key: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory createQueryTranslatorFactory
  | INFO: Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
  | 30 oct. 2007 14:30:19 org.hibernate.hql.ast.ASTQueryTranslatorFactory 
  | INFO: Using ASTQueryTranslatorFactory
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Query language substitutions: {}
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: JPA-QL strict compliance: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Second-level cache: enabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Query cache: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory createCacheProvider
  | INFO: Cache provider: org.hibernate.cache.HashtableCacheProvider
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Optimize cache for minimal puts: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Structured second-level cache entries: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Statistics: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Deleted entity synthetic identifier rollback: disabled
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Default entity-mode: pojo
  | 30 oct. 2007 14:30:19 org.hibernate.cfg.SettingsFactory buildSettings
  | INFO: Named query checking : enabled
  | 30 oct. 2007 14:30:19 org.hibernate.impl.SessionFactoryImpl 
  | INFO: building session factory
  | 30 oct. 2007 14:30:20 org.hibernate.impl.SessionFactoryObjectFactory addInstance
  | INFO: Not binding factory to JNDI, no JNDI name configured
  | 30 oct. 2007 14:30:22 org.hibernate.util.JDBCExceptionReporter logExceptions
  | ATTENTION: SQL Error: 0, SQLState: 08S01
  | 30 oct. 2007 14:30:22 org.hibernate.util.JDBCExceptionReporter logExceptions
  | GRAVE: Communications link failure due to underlying exception: 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100259#4100259

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100259