JBoss + JPA + Hibernate + MySql

[Iori Yagami Oroche]

Hi, I'm trying to deploy a JBoss AS 5.0 web application but I think I have some problems with using JPA persistence.
Here's my persistence.xml file :

<?xml version="1.0" encoding="UTF-8"?>
<persistence 
	version="2.0" xmlns="http://java.sun.com/xml/ns/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_2_0.xsd">
	<persistence-unit name="IDPConfigurer">
		<provider>org.hibernate.ejb.HibernatePersistence</provider>
		<jta-data-source>MysqlDS</jta-data-source>
		<class>org.idpconfigurer.dto.Component</class>
		<properties>
			<property 
				name="hibernate.dialect"
				value="org.hibernate.dialect.OracleDialect"/>
		</properties>
	</persistence-unit>
</persistence>

I put a "mysql-ds.xml" file in the deploy folder as a datasource :

<datasources> 
    <local-tx-datasource> 
        <jndi-name>MySqlDS</jndi-name> 
        <connection-url>jdbc:mysql://localhost:3306/idp</connection-url> 
        <driver-class>com.mysql.jdbc.Driver</driver-class> 
        <user-name>root</user-name> 
        <password>rootroot</password> 
    </local-tx-datasource> 
</datasources>

and finally, a MySql connector in the "/JBoss_Dest/server/default/lib" folder.

I got this error :

09:05:19,085 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
 
DEPLOYMENTS MISSING DEPENDENCIES:
  Deployment "persistence.unit:unitName=#IDPConfigurer" is missing the following dependencies:
    Dependency "jboss.jca:name=MysqlDS,service=DataSourceBinding" (should be in state "Create", but is actually in state "** NOT FOUND Depends on 'jboss.jca:name=MysqlDS,service=DataSourceBinding' **")
 
DEPLOYMENTS IN ERROR:
  Deployment "jboss.jca:name=MysqlDS,service=DataSourceBinding" is in error due to the following reason(s): ** NOT FOUND Depends on 'jboss.jca:name=MysqlDS,service=DataSourceBinding' **

any help? I think it's a quite simple

[Jaikiran Pai]

<jta-data-source>MysqlDS</jta-data-source>

I see 2 issues in that value in persistence.xml:

1) MysqlDS should be MySqlDS (because that's what you have set in the -ds.xml). It is case sensitive.
2) By default the datasource is bound to java: namespace, so your jta-data-source element should be:

<jta-data-source>java:/MySqlDS</jta-data-source>  

[Iori Yagami Oroche]

thank you Jaikiran Pai, in fact, I should use a <non-jta-data-source> too.
If you have any document about how the namespaces that could be used and in which cases... it would be helpful, just in case..

[Nick Carag]

I'm sorry for using your post, but I have your same configuration (even if I'm using Spring 3.0.5) and I didn't succeed to make it work with jboss 5/6. I have resolved the datasource's problem but now it's like there are two autodetections of the annotated entities classes. In the first the entities are found and bounded, in the second not so any queries failed for entity "not mapped". Do you have a similar problem?

Sorry again and thanks