I had my jta-data-source to <jta-data-source>java:java/profile</jta-data-source> all the time.
And then when I tried with jndi-name with <jndi-name>java:java/profile</jndi-name> , I got the below error.
java.lang.Error: Invalid ObjectName: jboss.jca:service=ManagedConnectionFactory,name=java:java/profile; javax.management.MalformedObjectNameException: Invalid character ':' in value part of property
So I changed to <jndi-name>java/profile</jndi-name>, then the above error was gone.
So I tried with the persistence.xml, oracle-ds.xml and standardjbosscmp-jdbc.xml which I poted in my previous reply and got the errors which I even posted in my previous email. Please take a look at my previous reply and let me know if I am missing something.
This is my Oracle setup:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE datasources
PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
"http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
<datasources>
<local-tx-datasource>
<jndi-name>FooDatasource</jndi-name>
<connection-url>jdbc:oracle:thin:@host:port:dbid</connection-url>
<user-name>u</user-name>
<password>p</password>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>Oracle10g</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
and
<?xml version="1.0" encoding="ISO-8859-1"?>
<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_2_0.xsd"
version="2.0">
<persistence-unit name="Foo">
<jta-data-source>java:/FooDatasource</jta-data-source>
<properties>
<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect" />
<property name="hibernate.show-sql" value="true" />
</properties>
</persistence-unit>
</persistence>