Hi,
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
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4144656#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...