-
1. Re: Missing db\persistence.xml
salaboy21 Dec 1, 2012 9:01 AM (in response to lauradp)Did you do a filesystem search? that's probably the simple way. In linux:
find . |grep persistence.xml
-
2. Re: Missing db\persistence.xml
thomas.setiabudi Dec 1, 2012 9:53 AM (in response to lauradp)Hi Laura Delli Paoli,
I see you put your question in JBPM5.4 category, does it mean you use jbpm5.4 final full installer?
if you are using JBPM5.4 full installer, there is no more db/persistence.xml file, it has been replaced and unfortunately the guide for jbpm5.4 is not updated yet
http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609
it still shows db/persistence.xml while actually that file does not exist in jbpm5.4 final full installer.
I know you are trying to use MySQL Database, but maybe my explanation on setting SQL Server 2008 Database here https://community.jboss.org/wiki/SetUpJBPM54FinalInstallerToUseMSSQLServer2008UsingJTDS
can be useful just for you to know which files needs to be updated as of JBPM5.4
Regards,
Thomas Setiabudi
-
3. Re: Missing db\persistence.xml
lauradp Dec 1, 2012 12:05 PM (in response to thomas.setiabudi)Thanks,
I'll use your instruction
-
4. Re: Missing db\persistence.xml
lauradp Dec 3, 2012 5:20 AM (in response to thomas.setiabudi)Hi Thomas,
I followed your tutorial and when I start my service I get this error:
JBAS014775: New missing/unsatisfied dependencies:
service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/jbpmDS]
How can I fix it?
Laura
-
5. Re: Missing db\persistence.xml
thomas.setiabudi Dec 3, 2012 5:21 AM (in response to lauradp)Have you copied the jdbc jar?
What is your standalone.xml looks like? especially in <datasources> and <drivers>
Regards,
Thomas Setiabudi
-
6. Re: Missing db\persistence.xml
lauradp Dec 3, 2012 5:35 AM (in response to thomas.setiabudi)Thanks for your answer.
I copied both jdbc.jar and module.xml in jboss-as-7.1.1.Final\modules\MySQL\jdbc\main folder.
This is my datasources configuration:
<subsystem xmlns="urn:jboss:domain:datasources:1.0">
<datasources>
<datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS" enabled="true" use-java-context="true">
<connection-url>jdbc:mysql://10.21.101.175:3306/jbpm5</connection-url>
<driver>mysql</driver>
<security>
<user-name>jbpm5</user-name>
<password>jbpm5</password>
</security>
</datasource>
<drivers>
<driver name="mysql" module="MySQL.jdbc">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>
</datasources>
</subsystem>
-
7. Re: Missing db\persistence.xml
thomas.setiabudi Dec 3, 2012 5:49 AM (in response to lauradp)I never used mysql before, but by looking at this guide here
http://docs.jboss.org/jbpm/v5.4/userguide/ch.installer.html#d0e609
Isn't the <drivers> part should be like this:
<drivers>
<driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
</driver>
</drivers>Regards,
Thomas Setiabudi
-
8. Re: Missing db\persistence.xml
lauradp Dec 3, 2012 6:01 AM (in response to thomas.setiabudi)I thought
module="MySQL.jdbc">
should represent the modulees subfolder
-
9. Re: Missing db\persistence.xml
thomas.setiabudi Dec 3, 2012 6:13 AM (in response to lauradp)hmm..
then how about your jbpm-installer\db\mysql_module.xml file?
is it like this?
<module xmlns="urn:jboss:module:1.0" name="com.mysql">
<resources>
<resource-root path="mysql-connector-java.jar"/>
</resources><dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>or is it
<module xmlns="urn:jboss:module:1.0" name="MySQL.jdbc">
<resources>
<resource-root path="mysql-connector-java.jar"/>
</resources><dependencies>
<module name="javax.api"/>
<module name="javax.transaction.api"/>
</dependencies>
</module>you are using mysql-connector-java.jar right?
-
10. Re: Missing db\persistence.xml
lauradp Dec 3, 2012 6:18 AM (in response to thomas.setiabudi)mmmm I think there's a problem:
My jbpm-installer\db\mysql_module.xml looks like this: <module xmlns="urn:jboss:module:1.0" name="MySQL.jdbc">.....
but the installer places my connector under com/...
I'll try to run again the installation using module xmlns="urn:jboss:module:1.0" name="com.mysql">
-
11. Re: Missing db\persistence.xml
thomas.setiabudi Dec 3, 2012 6:24 AM (in response to lauradp)I think the problem is in the
jbpm-installer\build.properties
look at this property (default value)
db.driver.module.prefix=com/mysql
this value determine the folder that will be created on the JBOSS AS module.