[jboss-user] [Datasource Configuration] New message: "Re: How to configure Oracle with my application in jboss 5.0"

Anand Kumar do-not-reply at jboss.com
Wed Feb 24 00:28:25 EST 2010


User development,

A new message was posted in the thread "How to configure Oracle with my application in jboss 5.0":

http://community.jboss.org/message/528091#528091

Author  : Anand Kumar
Profile : http://community.jboss.org/people/akstifr

Message:
--------------------------------------------------------------
Thanks once again for your reply 
 
Here are the files which u have requested for...
 
 The contents of jboss-web.xml is
 
<jboss-web>
     <resource-ref>
          <res-ref-name>jdbc/OracleDS</res-ref-name>
          <jndi-name>java:jdbc/OracleDS</jndi-name>
     </resource-ref>
</jboss-web>

 
and the contents of web.xml is:
 
<resource-ref>
          <res-ref-name>jdbc/OracleDS</res-ref-name>
          <res-type>javax.sql.DataSource</res-type>
          <res-auth>Container</res-auth>
          <res-sharing-scope>Shareable</res-sharing-scope>
     </resource-ref>



 
There are some more security-constraint also which i have already specified previously in the post here.
 
The contents of OracleDS.xm file are:
<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml,v 1.6 2004/09/15 14:37:40 loubyansky Exp $ -->
<!-- ==================================================================== -->
<!--  Datasource config for Oracle originally from Steven Coy             -->
<!-- ==================================================================== -->


<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/OracleDS</jndi-name>
    <connection-url>jdbc:oracle:thin:@xxx.yyy.zzz.www:1521:dbatest</connection-url>
     <!--
          See on WIKI page below how to use Oracle's thin JDBC driver to connect with enterprise RAC.
      -->
     <!--
          Here are a couple of the possible OCI configurations.
          For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm

     <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
          or
     <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>

          Clearly, its better to have TNS set up properly.
      -->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>xxxxx</user-name>
    <password>yyyyy</password>
 
    <min-pool-size>5</min-pool-size>
    <max-pool-size>100</max-pool-size>

    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->

        <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

 
Now what should i have to do further ???

--------------------------------------------------------------

To reply to this message visit the message page: http://community.jboss.org/message/528091#528091




More information about the jboss-user mailing list