I'm a newbie to JBoss and EJB. I tried to use JBoss for an existing project(in tomcat) that uses connection pooling. I've set up the JBoss3.2.0 and deployed my files, but I get error when connecting to Oracle datasource thro' connection pooling. I found in this forum, I need to change jboss-web.xml, standardjaws.xml and oracle-ds.xml. I tried and included it in my ear file. But still no use. There is no error while booting. But when I perform access DB, I get connection not established erro. This error is my user-defined error in the catch block of where i get a connection. There is no error in the jndi or context lookup too. I have some doubts:

1. In which location of the ear/war file should I put the jboss-web.xml, standardjaws.xml and oracle-ds.xml?
2. Is any of these files common or should I need to add in every ear/war file?
3. What other files do I need to modify?


Here is what i have changed in the files:

1. jboss-web.xml
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/XYZ_CRM</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<jndi-name>java:/XYZ_CRM</jndi-name>
</resource-ref>
</jboss-web>

2. standardjaws.xml
java:/InfoCRM
<type-mapping>Oracle8</type-mapping>
false


<default-entity>
<create-table>true</create-table>
<remove-table>false</remove-table>
<tuned-updates>true</tuned-updates>
<read-only>false</read-only>
<time-out>300</time-out>
<row-locking>false</row-locking>
<read-ahead>false</read-ahead>
</default-entity>

3. oracle-ds.xml

<local-tx-datasource>
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@xyz_crm.xyz_inc.com:1521:XYZ_CRM</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>abc</user-name>
abc
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>




Sorry if these question are meaningless. It means a lot to me. Thanks.