Hi Wolf-Dieter Fink,
Thanks for your inputs.
My oracle-ds.xml looks as per the attached image also the text contents of this file are pasted below. Yes I use plain jdbc (saved the ojdbc6.jar in my lib dir of the default server profile of JBoss). Yes i can connect to the database using an SQL client ( I use TOAD to do this) and could see the users, active session etc...on the database which in my case is ORACLE11gR2 installed on another RHEL 6 machine.
http://community.jboss.org/servlet/JiveServlet/downloadImage/17645/oracle-ds.xml.png
Oracle-ds.xml
<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->
<!-- $Id: oracle-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->
<datasources>
<local-tx-datasource>
<jndi-name>DefaultDS</jndi-name>
<connection-url>jdbc:oracle:thin:@I4483-vm6.abc.com:1521:pocjbsoadb</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>myusername</user-name>
<password>abcdefgh</password>
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<min-pool-size>15</min-pool-size>
<max-pool-size>50</max-pool-size>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
If anything else required please do let me know. Thanks.
