0 Replies Latest reply on May 25, 2003 12:21 AM by abcdef

    Oracle Datasource Config in JBoss3.2.0

    abcdef Newbie

      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.