thanks Gavin for pointing me in the right direction. It's working great now.
here is a website that gave me a bit more information if someone needs it http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAMysqlDatasource what I had to do was copy the $JBOSS_HOME/docs/examples/jca/mysql-ds.xml file to $JBOSS_HOME/server/xxx/deploy Modify it to look like this | <datasources> | <local-tx-datasource> | <jndi-name>MySqlDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3309/healthtrackdb</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>root</user-name> | <password>MySQLr0cks</password> | then change my persistence.xml file to | <entity-manager> | <persistence-unit name="entityManager"> | <provider>org.hibernate.ejb.HibernatePersistence</provider> | <jta-data-source>java:/MySqlDS</jta-data-source> | <properties> | <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/> | and finally copy the connector file for mysql to the lib directory of the server. Now it's working great View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3930235#3930235 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3930235 ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
