geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashish Jain <ashja...@gmail.com>
Subject Re: Question on DB Pool Creation using Tranql XA Resource Adapter
Date Wed, 05 May 2010 12:17:25 GMT
try specifying tnsentryname and servername in the plan.

On Wed, May 5, 2010 at 2:38 AM, Anshuk <Anshuk_Chaudhuri@infosys.com> wrote:

>
> 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