11:41 p.m.
I am having problems with getting jbpm working.
eclipse-jee-ganymede-SR1-win32.zip
jboss-4.2.3.GA.zip
jbpm-installer-3.3.0.GA.jar
jbpm-jpdl-designer-suite-3.1.5.zip
jdk-6u5-windows-i586-p.exe
mysql-5.0.67-win32.exe
mysql-connector-java-3.1.14.zip
OS = Windows 2003 Server SP2 (x86 32 bit)
MySQL on same server in C:/jboss-4.2.3.GA
I copied the mysql-connector-java-3.1.14-bin.jar into
c:/jboss-4.2.3.GA/server/default/lib/
I have updated c:/jboss-4.2.3.GA/server/default/conf/login-config.xml
| <application-policy name = "MySqlDbRealm">
| <authentication>
| <login-module code =
"org.jboss.resource.security.ConfiguredIdentityLoginModule"
| flag = "required">
| <module-option name =
"principal">jboss</module-option>
| <module-option name =
"userName">jboss</module-option>
| <module-option name =
"password">password</module-option>
| <module-option name =
"managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=DefaultDS</module-option>
| </login-module>
| </authentication>
| </application-policy>
|
I have created c:/jboss-4.2.3.GA/server/default/deploy/mysql-default-ds.xml
| <?xml version="1.0" encoding="UTF-8"?>
|
| <!-- $Id: mysql-ds.xml 71535 2008-04-01 07:05:03Z adrian(a)jboss.org $ -->
| <!-- Datasource config for MySQL using 3.0.9 available from:
| http://www.mysql.com/downloads/api-jdbc-stable.html
| -->
|
| <datasources>
| <local-tx-datasource>
| <jndi-name>DefaultDS</jndi-name>
| <connection-url>jdbc:mysql://localhost:3306/jbossdb</connection-url>
| <driver-class>com.mysql.jdbc.Driver</driver-class>
| <user-name>jboss</user-name>
| <password>password</password>
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
| <!-- should only be used on drivers after 3.22.1 with "ping" support
-->
|
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-checker-class-name>
| <!-- sql to call when connection is created
| <new-connection-sql>some arbitrary sql</new-connection-sql>
| -->
| <!-- sql to call on an existing pooled connection when it is obtained from pool -
MySQLValidConnectionChecker is preferred for newer drivers
| <check-valid-connection-sql>some arbitrary
sql</check-valid-connection-sql>
| -->
|
| <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional)
-->
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </local-tx-datasource>
|
| </datasources>
|
I copied c:/jboss-4.2.3.GA/docs/examples/jms/mysql-jdbc2-service.xml
to c:/jboss-4.2.3.GA/server/default/deploy/jms/mysql-jdbc2-service.xml
and updated with the following fragment (updated name=DefaultDS)
| <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager"
| name="jboss.mq:service=PersistenceManager">
| <depends
optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDS</depends>
|
I then created a database in MySQL called 'jbossdb' and a user 'jboss'
which has full control over the 'jbossdb' database.
I boot jBoss and the jms tables appeared and everything appeares to operate correctly.
I then shutdown jBoss and then install 'jbpm' using jboss-4.2.3.GA
I install into c:/jbpm-3.3.0.GA
* point it at C:/jboss-4.2.3.GA
* use MySQL
I then created a database in MySQL called 'jbpmdb' and a user 'jbpm' which
has full control over all databases (in my desparation)
I then edit c:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-mysql-ds.xml
| <?xml version="1.0" encoding="UTF-8"?>
| <datasources>
|
| <xa-datasource>
| <jndi-name>JbpmDS</jndi-name>
|
|
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
| <xa-datasource-property
name="URL">jdbc:mysql://localhost:3306/jbpmdb</xa-datasource-property>
| <user-name>jbpm</user-name>
| <password>password</password>
|
| <!-- reduce isolation from the default level (repeatable read) -->
|
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
| <!-- separate connections used with and without JTA transaction -->
| <no-tx-separate-pools />
| <!-- disable transaction interleaving -->
| <track-connection-by-tx />
|
| <!-- leverage mysql integration features -->
| <exception-sorter-class-name>
| com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter
| </exception-sorter-class-name>
| <valid-connection-checker-class-name>
| com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker
| </valid-connection-checker-class-name>
|
| <!-- corresponding type-mapping in conf/standardjbosscmp-jdbc.xml -->
| <metadata>
| <type-mapping>mySQL</type-mapping>
| </metadata>
| </xa-datasource>
|
| </datasources>
|
I then copied c:/jbpm-3.3.0.GA/config/hibernate.cfg.mysql.xml into
c:/jbpm-3.3.0.GA/config/hibernate.cfg.xml
and edited the following fragment
| <session-factory>
|
| <!-- hibernate dialect -->
| <property
name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
|
| <!-- JDBC connection properties (begin) -->
| <property
name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
| <property
name="hibernate.connection.url">jdbc:mysql://localhost:3306/jbpmdb</property>
| <property name="hibernate.connection.username">jbpm</property>
| <property
name="hibernate.connection.password">Password1</property>
| <property name="hibernate.query.substitutions">true 1, false
0</property>
| <!-- JDBC connection properties (end) -->
|
|
| <!-- DataSource properties (begin) -->
| <property
name="hibernate.connection.datasource">java:comp/env/jdbc/JbpmDataSource</property>
| <!-- DataSource properties (end) -->
|
I then copied this into
C:\jboss-4.2.3.GA\server\default\deploy\jbpm\jbpm-service.sar\hibernate.cfg.xml
When I boot JBOSS, the following diagnostics are generated..
| --- Incompletely deployed packages ---
| org.jboss.deployment.DeploymentInfo@8ebe4553 {
url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/
}
| deployer: MBeanProxyExt[jboss.web:service=WebServer]
| status: Deployment FAILED reason: URL
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/
deployment failed
| state: FAILED
| watch:
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/WEB-INF/web.xml
| altDD: null
| lastDeployed: 1227111755625
| lastModified: 1227087751875
| mbeans:
|
| org.jboss.deployment.DeploymentInfo@c3886145 {
url=file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/ }
| deployer: org.jboss.deployment.EARDeployer@1b158db
| status: Deployment FAILED reason: URL
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/
deployment failed
| state: FAILED
| watch:
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/META-INF/application.xml
| altDD: null
| lastDeployed: 1227111755625
| lastModified: 1227087751562
| mbeans:
|
| --- MBeans waiting for other MBeans ---
| ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
| State: FAILED
| Reason: org.jboss.deployment.DeploymentException: Error while fixing table name;
- nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (java.lang.reflect.UndeclaredThrowableException); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.lang.reflect.UndeclaredThrowableException)))
|
| ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
| State: FAILED
| Reason: org.jboss.deployment.DeploymentException: URL
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/
deployment failed
|
| --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
| ObjectName: jboss.web.deployment:war=jsf-console.war,id=-1900133037
| State: FAILED
| Reason: org.jboss.deployment.DeploymentException: URL
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jsf-console.war/
deployment failed
|
| ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
| State: FAILED
| Reason: org.jboss.deployment.DeploymentException: Error while fixing table name;
- nested throwable: (org.jboss.util.NestedSQLException: Could not create connection; -
nested throwable: (java.lang.reflect.UndeclaredThrowableException); - nested throwable:
(org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.lang.reflect.UndeclaredThrowableException)))
|
with more detailed logs from the first failure.
| 2008-11-20 02:52:36,000 DEBUG [org.jboss.system.ServiceController] starting
service jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
| 2008-11-20 02:52:36,000 DEBUG [org.jboss.ejb.EjbModule] Starting
jboss.j2ee:service=EjbModule,module=jbpm-enterprise-beans.jar
| 2008-11-20 02:52:36,000 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean] Initializing CMP plugin
for TimerEntityBean
| 2008-11-20 02:52:36,015 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean] Loading
standardjbosscmp-jdbc.xml :
file:/C:/jboss-4.2.3.GA/server/default/conf/standardjbosscmp-jdbc.xml
| 2008-11-20 02:52:36,312 DEBUG
[org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.TimerEntityBean]
file:/C:/jboss-4.2.3.GA/server/default/deploy/jbpm/jbpm-enterprise-bundle.ear/jbpm-enterprise-beans.jar/META-INF/jbosscmp-jdbc.xml
found. Overriding defaults
| 2008-11-20 02:52:36,437 DEBUG [org.jboss.resource.connectionmanager.IdleRemover]
internalRegisterPool: registering pool with interval 900000 old interval: 450000
| 2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.parentTraceEnabled=true
| 2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.nestedTraceEnabled=false
| 2008-11-20 02:52:36,468 DEBUG [org.jboss.util.NestedThrowable]
org.jboss.util.NestedThrowable.detectDuplicateNesting=true
| 2008-11-20 02:52:36,468 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Throwable while
attempting to get a new connection: null
| org.jboss.resource.JBossResourceException: Could not create connection; - nested
throwable: (java.lang.reflect.UndeclaredThrowableException)
| at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:155)
| at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:619)
| at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:264)
| at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:575)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:347)
| at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:330)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:402)
| at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:849)
| at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
| at org.jboss.ejb.plugins.cmp.jdbc.SQLUtil.fixTableName(SQLUtil.java:172)
| at
org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCEntityBridge.init(JDBCEntityBridge.java:157)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.initStoreManager(JDBCStoreManager.java:435)
| at
org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.start(JDBCStoreManager.java:368)
| at
org.jboss.ejb.plugins.CMPPersistenceManager.start(CMPPersistenceManager.java:172)
| at org.jboss.ejb.EjbModule.startService(EjbModule.java:414)
| at
org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
| at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
| at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
| at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| ...
|
I edited a copy of C:\jbpm-3.3.0.GA\database\jbpm.jpdl.mysql.sql to put a ';' at
the end of each line
then used 'mysql' to execute it, generating all the tables in the jbpmdb
database.
This makes no difference.
I tried changing the password of the 'jbpm' user - instead of unable to connect, I
then receive authorisation
failures, so this indicates, at least to me, that I am successfully connecting to MySQL
but something is going wrong.
I use phpMyAdmin on a different server to administer MySQL, so I am quite confident that
MySQL is ok.
Suggestions as to where I am going wrong would be greatly appreciated.
...Lyall
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4190316#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...