Oracle and CMP

[hoffz31]

I am having trouble trying to connect to oracle datasource using CMP beans.

Here is my oracle-service.xml


<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:sunydvl</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>fincore</user-name>
12345
<min-pool-size>5</min-pool-size>
</local-tx-datasource>


here is the top of my jbosscmp-jdbc.xml


java:/OracleDS
<datasource-mapping>OracleDS</datasource-mapping>
<create-table>false</create-table>
<remove-table>false</remove-table>


Any help would be appreciated.

[peejay]

I think the datasource-mapping attribute must be Oracle7, Oracle8 or Oracle9i, which are defined in the conf/standardjbosscmp-jdbc.xml.

bye

peejay