Jboss JPA Config
mattias1 Apr 16, 2008 6:12 PMHi,
Do anyone have time to sort this out once and for all? I know this has been discussed several times, but different websites and forums have different answers. I'm getting the following error when deploying a small ejb3 project:
--- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM --- ObjectName: persistence.units:unitName=tinyphotoalbum State: NOTYETINSTALLED Depends On Me: jboss.j2ee:jar=ImageServices.jar,name=ImageDetailManagementBean,service=EJB3
The jarfile/META-INF/persistance.xml looks like:
<?xml version="1.0" encoding="UTF-8" ?> <persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0" xmlns="http://java.sun.com/xml/ns/persistence"> <persistence-unit name="tinyphotoalbum"> <jta-data-source>java:/MySqlDS</jta-data-source> <class>se.hexabit.tinyphotoalbum.beans.ImageDetails</class> <properties> <property name="hibernate.archive.autodetection" value="class, hbm"/> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/> <property name="hibernate.connection.password" value="tinyphotoalbum"/> <property name="hibernate.connection.url" value="jdbc:mysql://192.168.0.138:3306/TinyPhotoAlbum"/> <property name="hibernate.connection.username" value="tinyphotoalbum"/> <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/> </properties> </persistence-unit> </persistence>
And the JBOSS_HOME\server\default\deploy\mysql-ds.xml:
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>MySqlDS</jndi-name> <connection-url>jdbc:mysql://192.168.0.138:3306/TinyPhotoAlbum</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>tinyphotoalbum</user-name> <password>tinyphotoalbum</password> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name> <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml --> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
Finnally i placed the driver in the lib-dir as:
JBOSS_HOME\server\default\lib\mysql-connector-java-5.1.6-bin.jar
Is there any more configuration that needs to be done?
BR,
Mattias