geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jithu Jance" <j_ja...@hotmail.com>
Subject jdbc-oracle deplymnt
Date Fri, 05 Aug 2005 11:02:22 GMT
Hi

         I am a newbie...I have got an application [.ear] and an oracle 
database..how can i connect the app. to the database using jdbc ..which all 
descriptor whiles must b there? I have got a database plan..

its given below
<?xml version="1.0"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
  version="1.5"
  configId="OraclePool"
  parentId="org/apache/geronimo/Server">

<dependency>
  <uri>
    oracle/jars/ojdbc14.jar
  </uri>
</dependency>

<resourceadapter>
  <outbound-resourceadapter>
    <connection-definition>
      <connectionfactory-interface>
        javax.sql.DataSource
      </connectionfactory-interface>
      <connectiondefinition-instance>
        <name>OracleDataSource</name>
        <config-property-setting name="UserName">
          YARD
        </config-property-setting>
        <config-property-setting name="Password">
          YARD
        </config-property-setting>
        <config-property-setting name="Driver">
          oracle.jdbc.driver.OracleDriver
        </config-property-setting>
        <config-property-setting name="ConnectionURL">
          <!--jdbc:mysql://localhost/geronimo-->
          jdbc:oracle:thin:@10.10.10.10.10:DATA
</config-property-setting>
        <config-property-setting name="CommitBeforeAutocommit">
           false
        </config-property-setting>
        <config-property-setting name="ExceptionSorterClass">
           org.tranql.connector.NoExceptionsAreFatalSorter
        </config-property-setting>

        <connectionmanager>
          <local-transaction/>
          <single-pool>
             <max-size>10</max-size>
             <min-size>0</min-size>
             <blocking-timeout-milliseconds>
                5000
              </blocking-timeout-milliseconds>
              <idle-timeout-minutes>
                30
              </idle-timeout-minutes>
              <match-one/>
          </single-pool>
        </connectionmanager>

        <global-jndi-name>
          jdbc/OraclePool
        </global-jndi-name>

      </connectiondefinition-instance>
    </connection-definition>
  </outbound-resourceadapter>
</resourceadapter>
</connector>

_________________________________________________________________
Your opinion counts..for your chance to win a Mini Cooper click here 
http://www.qualifiedopinions.com/joinup.php?source=hotmail


Mime
View raw message