Problem in datasource with JPA in JBoss

[rukia rukita]

Hello,

Actuallly i have the same problem, i spent a week trying to make it work but no way!!

I need to define a new oracle datasource, i am using Oracle 11g , Jboss 5.1

My oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>  
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<use-java-context>false</use-java-context>
<!--<connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url> -->
<connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>USER</user-name>
<password>passwd</password>

<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>5</min-pool-size>
<max-pool-size>200</max-pool-size>
<idle-timeout-minutes>5</idle-timeout-minutes>
<blocking-timeout-millis>10000</blocking-timeout-millis>
				
<metadata> <type-mapping>Oracle9i</type-mapping> </metadata>


</local-tx-datasource>
</datasources>

My persistence.xml

<persistence 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_1_0.xsd" version="1.0">

  <persistence-unit name="TEST">
    <jta-data-source>java:/OracleDS</jta-data-source>

        <properties>
         <property name="hibernate.hbm2ddl.auto" value="update"/>
        </properties>
         
 </persistence-unit>
</persistence>

when i deploy my ejb project on jboss i get these errors,

2012-05-24 15:37:07,908 INFO [org.jboss.jpa.deployment.PersistenceUnitDeployment] (main) Starting persistence unit persistence.unit:unitName=#TEST
2012-05-24 15:37:07,908 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#TESTstate=Create
javax.naming.NameNotFoundException: OracleDS not bound

Hello,

Actuallly i have the same problem, i spent a week trying to make it work but no way!!

I need to define a new oracle datasource, i am using Oracle 11g , Jboss 5.1

My oracle-ds.xml

<?xml version="1.0" encoding="UTF-8"?>  
<datasources>
<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:oracle:thin:@localhost:1521:test</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>USER</user-name>
<password>passwd</password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>	
<metadata> <type-mapping>Oracle9i</type-mapping> </metadata>
</local-tx-datasource>
</datasources>

My persistence.xml

<persistence 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_1_0.xsd" version="1.0">

  <persistence-unit name="Toto" transaction-type="JTA">
    <jta-data-source>java:/OracleDS</jta-data-source>

        <properties>
         <property name="hibernate.hbm2ddl.auto" value="update"/>
        </properties>
         
 </persistence-unit>
</persistence>

when i deploy my ejb project on jboss i get these errors,

2012-05-24 15:37:07,908 INFO [org.jboss.jpa.deployment.PersistenceUnitDeployment] (main) Starting persistence unit persistence.unit:unitName=#Test
2012-05-24 15:37:07,908 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#Teststate=Create
javax.naming.NameNotFoundException: OracleDS not bound


DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss.j2ee:jar=Testing.jar,name=TotoBean,service=EJB3" is missing the following dependencies:
Dependency "<UNKNOWN jboss.j2ee:jar=Testing.jar,name=TotoBean,service=EJB3>" (should be in state "Described", but is actually in state "** UNRESOLVED Demands 'persistence.unit:unitName=#Test' **")

DEPLOYMENTS IN ERROR:
Deployment "<UNKNOWN jboss.j2ee:jar=Testing.jar,name=TotoBean,service=EJB3>" is in error due to the following reason(s): ** UNRESOLVED Demands 'persistence.unit:unitName=#Test' **
Deployment "persistence.unit:unitName=#Test" is in error due to the following reason(s): javax.naming.NameNotFoundException: OracleDS not bound


but in the JMX console i can see my beans!

Please can anyone help me, i really need it :s ???