geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anshuk <Anshuk_Chaudh...@infosys.com>
Subject Question on DB Pool Creation using Tranql XA Resource Adapter
Date Tue, 04 May 2010 21:08:23 GMT

Hello All,

I am trying to create a db connection pool in geronimo 2.1.4 for oracle
database using. Tranql XA Resource Adapter.

The plan which is created looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
    <dep:environment
xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
        <dep:moduleId>
            <dep:groupId>console.dbpool</dep:groupId>
            <dep:artifactId>test_webdb_pool</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>rar</dep:type>
        </dep:moduleId>
        <dep:dependencies>
            <dep:dependency>
                <dep:groupId>ojdbc</dep:groupId>
                <dep:artifactId>ojdbc</dep:artifactId>
                <dep:version>14</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
               
<connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>test_webdb_pool</name>
                    <config-property-setting name="NetworkProtocol"/>
                    <config-property-setting
name="PortNumber">1521</config-property-setting>
                    <config-property-setting name="TNSEntryName"/>
                    <config-property-setting name="MaxStatements"/>
                    <config-property-setting name="DataSourceName"/>
                    <config-property-setting
name="DriverType">thin</config-property-setting>
                    <config-property-setting
name="Password">anshuk</config-property-setting>
                    <config-property-setting name="ServerName"/>
                    <config-property-setting name="Description"/>
                    <config-property-setting name="LoginTimeout"/>
                    <config-property-setting
name="DatabaseName">TESTING</config-property-setting>
                    <config-property-setting name="ServiceName"/>
                    <config-property-setting
name="UserName">anshuk</config-property-setting>
                    <connectionmanager>
                        <xa-transaction>
                            <transaction-caching/>
                        </xa-transaction>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
</connector>

I am using oracle thin driver.
It is cretaed and deployed, but it is not connecting to the database. When
from the geronimo console, I am running a sql to test the database
connection, it is failing.
the database related parameters is 100% correct, as I am using the same
details for generic tranql resource adapter, and it gets conncected.

The error I am getting:

Io exception: SO Exception was generated *


Anybody faced similar issue? or any workarounds?

Anshuk


-- 
View this message in context: http://apache-geronimo.328035.n3.nabble.com/Question-on-DB-Pool-Creation-using-Tranql-XA-Resource-Adapter-tp777380p777380.html
Sent from the Users mailing list archive at Nabble.com.

Mime
View raw message