Return-Path: 
 <user-return-14809-apmail-geronimo-user-archive=geronimo.apache.org@geronimo.apache.org>
Delivered-To: apmail-geronimo-user-archive@www.apache.org
Received: (qmail 6568 invoked from network); 5 May 2010 12:17:52 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 5 May 2010 12:17:52 -0000
Received: (qmail 96451 invoked by uid 500); 5 May 2010 12:17:51 -0000
Delivered-To: apmail-geronimo-user-archive@geronimo.apache.org
Received: (qmail 96392 invoked by uid 500); 5 May 2010 12:17:51 -0000
Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:user-help@geronimo.apache.org>
list-unsubscribe: <mailto:user-unsubscribe@geronimo.apache.org>
List-Post: <mailto:user@geronimo.apache.org>
Reply-To: user@geronimo.apache.org
List-Id: <user.geronimo.apache.org>
Delivered-To: mailing list user@geronimo.apache.org
Received: (qmail 96385 invoked by uid 99); 5 May 2010 12:17:50 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 May 2010 12:17:50 +0000
X-ASF-Spam-Status: No, hits=4.4 required=10.0
	tests=AWL,FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of ashjain2@gmail.com designates
 209.85.160.54 as permitted sender)
Received: from [209.85.160.54] (HELO mail-pw0-f54.google.com) (209.85.160.54)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 May 2010 12:17:46 +0000
Received: by pwi9 with SMTP id 9so2602760pwi.13
        for <user@geronimo.apache.org>; Wed, 05 May 2010 05:17:25 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:received:in-reply-to
         :references:date:message-id:subject:from:to:content-type;
        bh=pA2/u+Pl+7DPph9V06JtBVL2wKJ7eO8P/uOlPplodFI=;
        b=N8AKWrEaw31/Q80lIPdgPLeu2sVnW4OlHNgR66sbfztfD5LRsbPXgao3KziYqdsAl8
         nXydOS+xNPms4U/yLpImIzplcSC9TKTZ2FfQgnBWunPpeWJigNgi38a5nfaiSArEQYmY
         bWoC1CzHRRRbIDkM0Vr5cShKkaNInQ2N/YFws=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=VYMK4hgVEN5Q1ySlWWx7j7pZPbY00QCLdlCX7X9dt5hk1kBL94QLT686/AN8yJswK/
         oFW+lZydjEE/c0QE+Kv3R317tgFiyF9XOojXUl9dEeSM0LW4/INiKa4BOk8nyAvl9D7P
         SdX/hmCshaQJ9V74ijDbwZMgW0klnaavDbT4Q=
MIME-Version: 1.0
Received: by 10.114.188.16 with SMTP id l16mr1339302waf.87.1273061845672;
 Wed,
	05 May 2010 05:17:25 -0700 (PDT)
Received: by 10.115.18.3 with HTTP; Wed, 5 May 2010 05:17:25 -0700 (PDT)
In-Reply-To: <1273007303094-777380.post@n3.nabble.com>
References: <1273007303094-777380.post@n3.nabble.com>
Date: Wed, 5 May 2010 17:47:25 +0530
Message-ID: <g2y14af40511005050517vd1c3da01ha618f0e0bb18c974@mail.gmail.com>
Subject: Re: Question on DB Pool Creation using Tranql XA Resource Adapter
From: Ashish Jain <ashjain2@gmail.com>
To: user@geronimo.apache.org
Content-Type: multipart/alternative; boundary=0016e64ca6c016a6820485d7cfe1

--0016e64ca6c016a6820485d7cfe1
Content-Type: text/plain; charset=ISO-8859-1

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

--0016e64ca6c016a6820485d7cfe1
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

try specifying tnsentryname and servername in the plan.<br><br><div class=
=3D"gmail_quote">On Wed, May 5, 2010 at 2:38 AM, Anshuk <span dir=3D"ltr">&=
lt;<a href=3D"mailto:Anshuk_Chaudhuri@infosys.com">Anshuk_Chaudhuri@infosys=
.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><br>
Hello All,<br>
<br>
I am trying to create a db connection pool in geronimo 2.1.4 for oracle<br>
database using. Tranql XA Resource Adapter.<br>
<br>
The plan which is created looks like this:<br>
<br>
&lt;?xml version=3D&quot;1.0&quot; encoding=3D&quot;UTF-8&quot;?&gt;<br>
&lt;connector xmlns=3D&quot;<a href=3D"http://geronimo.apache.org/xml/ns/j2=
ee/connector-1.2" target=3D"_blank">http://geronimo.apache.org/xml/ns/j2ee/=
connector-1.2</a>&quot;&gt;<br>
 =A0 =A0&lt;dep:environment<br>
xmlns:dep=3D&quot;<a href=3D"http://geronimo.apache.org/xml/ns/deployment-1=
.2" target=3D"_blank">http://geronimo.apache.org/xml/ns/deployment-1.2</a>&=
quot;&gt;<br>
 =A0 =A0 =A0 =A0&lt;dep:moduleId&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:groupId&gt;console.dbpool&lt;/dep:groupId&g=
t;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:artifactId&gt;test_webdb_pool&lt;/dep:artif=
actId&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:version&gt;1.0&lt;/dep:version&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:type&gt;rar&lt;/dep:type&gt;<br>
 =A0 =A0 =A0 =A0&lt;/dep:moduleId&gt;<br>
 =A0 =A0 =A0 =A0&lt;dep:dependencies&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:dependency&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:groupId&gt;ojdbc&lt;/dep:groupId&gt=
;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:artifactId&gt;ojdbc&lt;/dep:artifac=
tId&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:version&gt;14&lt;/dep:version&gt;<b=
r>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;dep:type&gt;jar&lt;/dep:type&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;/dep:dependency&gt;<br>
 =A0 =A0 =A0 =A0&lt;/dep:dependencies&gt;<br>
 =A0 =A0&lt;/dep:environment&gt;<br>
 =A0 =A0&lt;resourceadapter&gt;<br>
 =A0 =A0 =A0 =A0&lt;outbound-resourceadapter&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;connection-definition&gt;<br>
<br>
&lt;connectionfactory-interface&gt;javax.sql.DataSource&lt;/connectionfacto=
ry-interface&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;connectiondefinition-instance&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;name&gt;test_webdb_pool&lt;/nam=
e&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;NetworkProtocol&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting<br>
name=3D&quot;PortNumber&quot;&gt;1521&lt;/config-property-setting&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;TNSEntryName&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;MaxStatements&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;DataSourceName&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting<br>
name=3D&quot;DriverType&quot;&gt;thin&lt;/config-property-setting&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting<br>
name=3D&quot;Password&quot;&gt;anshuk&lt;/config-property-setting&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;ServerName&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;Description&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;LoginTimeout&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting<br>
name=3D&quot;DatabaseName&quot;&gt;TESTING&lt;/config-property-setting&gt;<=
br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting name=3D=
&quot;ServiceName&quot;/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;config-property-setting<br>
name=3D&quot;UserName&quot;&gt;anshuk&lt;/config-property-setting&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;connectionmanager&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;xa-transaction&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;transaction-cac=
hing/&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;/xa-transaction&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;single-pool&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;max-size&gt;10&=
lt;/max-size&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;min-size&gt;0&l=
t;/min-size&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;match-one/&gt;<=
br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;/single-pool&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;/connectionmanager&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0&lt;/connectiondefinition-instance&gt;<br>
 =A0 =A0 =A0 =A0 =A0 =A0&lt;/connection-definition&gt;<br>
 =A0 =A0 =A0 =A0&lt;/outbound-resourceadapter&gt;<br>
 =A0 =A0&lt;/resourceadapter&gt;<br>
&lt;/connector&gt;<br>
<br>
I am using oracle thin driver.<br>
It is cretaed and deployed, but it is not connecting to the database. When<=
br>
from the geronimo console, I am running a sql to test the database<br>
connection, it is failing.<br>
the database related parameters is 100% correct, as I am using the same<br>
details for generic tranql resource adapter, and it gets conncected.<br>
<br>
The error I am getting:<br>
<br>
Io exception: SO Exception was generated *<br>
<br>
<br>
Anybody faced similar issue? or any workarounds?<br>
<br>
Anshuk<br>
<font color=3D"#888888"><br>
<br>
--<br>
View this message in context: <a href=3D"http://apache-geronimo.328035.n3.n=
abble.com/Question-on-DB-Pool-Creation-using-Tranql-XA-Resource-Adapter-tp7=
77380p777380.html" target=3D"_blank">http://apache-geronimo.328035.n3.nabbl=
e.com/Question-on-DB-Pool-Creation-using-Tranql-XA-Resource-Adapter-tp77738=
0p777380.html</a><br>

Sent from the Users mailing list archive at Nabble.com.<br>
</font></blockquote></div><br>

--0016e64ca6c016a6820485d7cfe1--