Re: Issues facing when connecting with Oracle10g

[Forrest Xia]

Can I rely on the admin console alone for deploying the database pool for
> oracle 10g?

Sure, you can use admin console db pool wizard to create one easily.

Attach a sample deployment plan for your reference.

You can use this command to deploy it:
$GERONIMO_HOME/bin/deploy.sh -u system -p manager deploy
$GERONIMO_HOME/repository/org/tranql/tranql-connector-oracle-xa/1.4/tranql-connector-oracle-xa-1.4.rar
your-ds-plan.xml

Good luck!

Forrest

<?xml version="1.0" encoding="UTF-8"?>

<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2";
  xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2";
  xmlns:naming="http://geronimo.apache.org/xml/ns/naming-1.2";>

  <dep:environment>
    <dep:moduleId>
      <dep:groupId>console.dbpool</dep:groupId>
      <dep:artifactId>fpdbpool</dep:artifactId>
      <dep:version>1.0</dep:version>
      <dep:type>car</dep:type>
    </dep:moduleId>
    <dep:dependencies>
        <dep:dependency>
             <dep:groupId>com.telelogic.focalpoint.lib</dep:groupId>
             <dep:artifactId>ojdbc14</dep:artifactId>
             <dep:version>10.2.0.1.0</dep:version>
             <dep:type>jar</dep:type>
        </dep:dependency>
    </dep:dependencies>
    <dep:hidden-classes/>
    <dep:non-overridable-classes/>
  </dep:environment>

  <resourceadapter>
                <outbound-resourceadapter>
                    <connection-definition>
                        <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                        <connectiondefinition-instance>
                            <name>jdbc/TradeDataSource</name>
                            <config-property-setting name="UserName">trade</config-property-setting>
                            <config-property-setting name="Password">trade</config-property-setting>
                            <config-property-setting name="DatabaseName">tradedb</config-property-setting>
                            <config-property-setting name="ServerName">localhost</config-property-setting>
                            <config-property-setting name="PortNumber">1521</config-property-setting>
                            <config-property-setting name="DriverType">thin</config-property-setting>
                            <connectionmanager>
                                <xa-transaction>
                                    <transaction-caching/>
                                </xa-transaction>
                                <single-pool>
                                    <max-size>100</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>
                        </connectiondefinition-instance>
                        <connectiondefinition-instance>
                            <name>jdbc/NoTxTradeDataSource</name>
                            <config-property-setting name="UserName">trade</config-property-setting>
                            <config-property-setting name="Password">trade</config-property-setting>
                            <config-property-setting name="DatabaseName">tradedb</config-property-setting>
                            <config-property-setting name="ServerName">localhost</config-property-setting>
                            <config-property-setting name="PortNumber">1521</config-property-setting>
                            <config-property-setting name="DriverType">thin</config-property-setting>
                            <connectionmanager>
                                <no-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>
                        </connectiondefinition-instance>
                    </connection-definition>
                </outbound-resourceadapter>
            </resourceadapter>
</connector>