-
1. Re: unable to setup mysql database on JBoss 5.1.0GA
jbossq Jun 27, 2010 6:14 AM (in response to rsoika)Maybe you run into a bug about DataSource, please see http://community.jboss.org/message/539774#539774 and https://jira.jboss.org/browse/JBAS-7984
-
2. Re: unable to setup mysql database on JBoss 5.1.0GA
rsoika Jun 27, 2010 8:24 AM (in response to jbossq)Thanks for your reply. I found out the the database connection is ok and it is working as defined.
My fault was that I defined in my pesistence.xml the jta-data-source with
<jta-data-source>jdbc/workflow-db</jta-data-source>
but the prafix "java:/" is necessary for jboss (?). After I changed the jta-data-source tag to:
<jta-data-source>java:/jdbc/workflow-db</jta-data-source>
the application works well and all tables in my database were generated correctly.
This is confusing because on a Glassfish Server the jta-data-source is always declared without the prafix "java:/" . So it seems to me that the persistence.xml configuration is depending on the app-server platform :-/
-
3. Re: unable to setup mysql database on JBoss 5.1.0GA
jbossq Jun 27, 2010 9:57 PM (in response to rsoika)By default Datasource in JBoss is declared with the prefix "java:/", but you can set use-java-context to false in xx-ds.xml to remove the "java:/" prefix.
-
4. Re: unable to setup mysql database on JBoss 5.1.0GA
rsoika Jun 28, 2010 5:04 AM (in response to jbossq)Thanks a lot - yes this works !