where to set the database properties while installing jbpm-i
santoshkumarsamala Feb 19, 2009 12:13 PMwhen I execute jbpm-installer-3.3.1GA, the wizard will run and I give the location of jboss and also in one of the screen i say that iam using mysql , then the wizard executes completely creating jbpm folder in jboss4.2.2./server/default/deploy/
when i open that newly created jbpm folder i am able to see a file called jbpm-mysql-ds.xml, it has three lines
<xa-datasource-property name="URL">${jdbc.mysql.url}</xa-datasource-property> <user-name>${jdbc.mysql.username}</user-name> <password>${jdbc.mysql.password}</password>
From where these three values will be configured, i couldnt find any file where i can configure these values, i have declared my self a file called mysql-ds.xml in deploy folder with following values
<datasources> <local-tx-datasource> <jndi-name>JbpmDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/jbpm</connection-url> <!-- The driver class --> <driver-class>com.mysql.jdbc.Driver</driver-class> <!-- The login and password --> <user-name>root</user-name> <password>welcome</password> </local-tx-datasource> </datasources>
but it gives me an error
--- Incompletely deployed packages --- org.jboss.deployment.DeploymentInfo@ee96070 { url=file:/C:/jboss-4.2.2.GA/server/default/deploy/mysql-ds.xml } deployer: org.jboss.deployment.XSLSubDeployer@18f127c status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:service=DataSourceBinding,name=JbpmDS state: FAILED watch: file:/C:/jboss-4.2.2.GA/server/default/deploy/mysql-ds.xml altDD: null lastDeployed: 1235063072861 lastModified: 1235063072845 mbeans: --- MBeans waiting for other MBeans --- ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise.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.NullPointerException); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.NullPointerException))) --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: jboss.j2ee:service=EjbModule,module=jbpm-enterprise.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.NullPointerException); - nested throwable: (org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.NullPointerException)))
please help me to resolve this, iam breaking the head for the past 2 days