[JBoss jBPM] - Re: tomcat and mysql integration
by 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
18Â years, 5Â months
[JBoss jBPM] - JobExecutor exception
by Olivier.ch
Hello,
I am would like to use a timer with JBPM 3.2.1. and Spring framework
I found the way with a JobExecutor :
in JBPM.cfg.xml I put the JobExecutor configuration like this :
| <bean name="jbpm.job.executor" class="org.jbpm.job.executor.JobExecutor">
| <field name="jbpmConfiguration"><ref bean="jbpmConfiguration" /></field>
| <field name="name"><string value="JbpmJobExecutor" /></field>
| <field name="nbrOfThreads"><int value="1" /></field>
| <field name="idleInterval"><int value="5000" /></field>
| <field name="maxIdleInterval"><int value="3600000" /></field> <!-- 1 hour -->
| <field name="historyMaxSize"><int value="20" /></field>
| <field name="maxLockTime"><int value="20000" /></field> <!-- 20 sec -->
| <field name="lockMonitorInterval"><int value="10000" /></field> <!-- 10 sec -->
| <field name="lockBufferTime"><int value="5000" /></field> <!-- 5 seconds -->
| </bean>
|
And I put my JobExecutorServlet on the web.xml :
| <servlet>
| <servlet-name>JobExecutorServlet</servlet-name>
| <servlet-class>org.jbpm.job.executor.JobExecutorServlet</servlet-class>
| <load-on-startup>1</load-on-startup>
| </servlet>
|
| <servlet-mapping>
| <servlet-name>JobExecutorServlet</servlet-name>
| <url-pattern>/jobs</url-pattern>
| </servlet-mapping>
|
When I start my web application with this new Servlet I get an error but I can't see the relationship between my JobExecutor and the error.
The Job seems to start correctly :
| 14:30:43,689 DEBUG ObjectFactoryImpl:59 - adding object info 'jbpm.job.executor'
| 14:30:43,689 DEBUG ObjectFactoryImpl:59 - adding object info 'jbpmConfiguration'
| 14:30:43,705 DEBUG JobExecutor:41 - starting thread group 'JbpmJobExector'...
| 14:30:43,736 DEBUG JobExecutor:87 - starting new job executor thread 'JbpmJobExector:10.138.101.47:1'
|
When It try to close the JBPMContext It throws an exception about JBPM_NODE table ...
| 14:31:34,691 DEBUG JbpmContext:133 - closing JbpmContext
| 14:31:34,691 DEBUG Services:221 - closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@19ee8a
| 14:31:36,878 ERROR JobExecutorThread:83 - exception in job executor thread. waiting 5000 milliseconds
| org.hibernate.MappingException: An association from the table JBPM_NODE refers to an unmapped class: org.jbpm.graph.action.Script
| at org.hibernate.cfg.Configuration.secondPassCompileForeignKeys(Configuration.java:1249)
| at org.hibernate.cfg.Configuration.secondPassCompile(Configuration.java:1167)
| at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1283)
| at org.jbpm.persistence.db.DbPersistenceServiceFactory.getSessionFactory(DbPersistenceServiceFactory.java:91)
| at org.jbpm.persistence.db.DbPersistenceService.getSessionFactory(DbPersistenceService.java:107)
| at org.jbpm.persistence.db.DbPersistenceService.getSession(DbPersistenceService.java:111)
| at org.jbpm.persistence.db.DbPersistenceService.getJobSession(DbPersistenceService.java:401)
| at org.jbpm.JbpmContext.getJobSession(JbpmContext.java:563)
| at org.jbpm.job.executor.JobExecutorThread.acquireJobs(JobExecutorThread.java:110)
| at org.jbpm.job.executor.JobExecutorThread.run(JobExecutorThread.java:56)
|
Can somebody explain me why ? and how to correct this problem ? It seems to be a configuration problem but I don't know what to change ...
Thanks for your help
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4100257#4100257
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4100257
18Â years, 5Â months