[jboss-user] [Datasource Configuration] - unable to setup mysql database on JBoss 5.1.0GA

[Ralph Soika]

Ralph Soika [http://community.jboss.org/people/rsoika] replied to the discussion

"unable to setup mysql database on JBoss 5.1.0GA"

To view the discussion, visit: http://community.jboss.org/message/549804#549804

--------------------------------------------------------------
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 :-/

--------------------------------------------------------------

Reply to this message by going to Community
[http://community.jboss.org/message/549804#549804]

Start a new discussion in Datasource Configuration at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100627/67aa8794/attachment.html