Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: pass (nike.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=dk20050327; d=earthlink.net;
  b=GSZ+4rZHWaYqSwEtNsUaaD+jewPVME55zSFJqGIIBqKXHO7QoxdZG6n8nmVULiSf;
  h=Received:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding:X-ELNK-Trace:X-Originating-IP;
Message-ID: <47F4F236.7050507@earthlink.net>
Date: Thu, 03 Apr 2008 11:05:26 -0400
From: Joe Bohn <joe.bohn@earthlink.net>
User-Agent: Thunderbird 2.0.0.12 (Macintosh/20080213)
MIME-Version: 1.0
To: user@geronimo.apache.org
Subject: Re: Problem creating a DB2 datasource
References: <16344329.post@talk.nabble.com>
 <22d56c4d0803272122tc868a97rc60911a892f2d77d@mail.gmail.com>
 <47ECE915.90500@apache.org> <16366049.post@talk.nabble.com>
 <825E7D34-2E7D-45AE-8922-B8A8DF54D6DE@yahoo.com> <47F10F32.9060706@gmail.com>
 <1644F9BA-BE9D-4CEF-8E9C-6100696AE494@yahoo.com> <47F12238.2080402@gmail.com>
In-Reply-To: <47F12238.2080402@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Hernan,

Did you get a chance to give the 1.2 version a shot and see if it fixed 
your problem?  I'm wondering if this is an issue for 2.1.1.   Also, is 
there a JIRA for this issue?

Thanks,
Joe


Hernan Cunico wrote:
> yup, using the 1.1 version available on G 2.1. I'll give 1.2 a shot
> 
> Cheers!
> Hernan
> 
> David Jencks wrote:
>> Is this with the snapshot db2 tranql adapter..
>>
>> _http://snapshots.repository.codehaus.org/org/tranql/tranql-connector-db2-xa/1.2-SNAPSHOT/tranql-connector-db2-xa-1.2-20080326.214959-2.rar_ 
>>
>>
>>
>> The released 1.1 version has a problem with setting the trace file 
>> that might be related to this.
>> thanks
>> david jencks
>>
>> On Mar 31, 2008, at 9:20 AM, Hernan Cunico wrote:
>>> I found some issues as well while deploying a pool using the db2 
>>> specific connector although my testing was on G 2.1. I'll repeat 
>>> these on 2.0.2 as soon as I can.
>>>
>>> If I use the "generic" tranql connector the pool deploys OK with the 
>>> appropriate plan and I can access the DB via such pool.
>>>
>>> If I use the tranql-connector-db2-xa connector with the corresponding 
>>> deployment plan it will deploy OK but it fail when accessing the DB, 
>>> here is the exception:
>>>
>>> 11:00:33,781 ERROR [MCFConnectionInterceptor] Error occurred creating 
>>> ManagedConnection for 
>>> org.apache.geronimo.connector.outbound.ConnectionInfo@11dc32b
>>> javax.resource.spi.ResourceAdapterInternalException: Unable to obtain 
>>> physical connection to com.ibm.db2.jcc.DB2XADataSource@15be8ff
>>>       at 
>>> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:76) 
>>>
>>>       at 
>>> org.tranql.connector.db2.XAMCF.createManagedConnection(XAMCF.java:59)
>>>       at 
>>> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getConnection(MCFConnectionInterceptor.java:48) 
>>>
>>>       at 
>>> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterceptor.getConnection(LocalXAResourceInsertionInterceptor.java:41) 
>>>
>>>       at 
>>> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor.internalGetConnection(SinglePoolConnectionInterceptor.java:70) 
>>>
>>>       at 
>>> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInterceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:80) 
>>>
>>>       at 
>>> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor.getConnection(TransactionEnlistingInterceptor.java:46) 
>>>
>>>       at 
>>> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:94) 
>>>
>>>       ...
>>> Caused by: com.ibm.db2.jcc.b.SqlException: 
>>> [ibm][db2][jcc][10257][10960] Unable to open file .
>>>       at com.ibm.db2.jcc.b.ch.a(ch.java:111)
>>>       at 
>>> com.ibm.db2.jcc.DB2BaseDataSource.computePrintWriter(DB2BaseDataSource.java:2900) 
>>>
>>>       at 
>>> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriter(DB2BaseDataSource.java:2812) 
>>>
>>>       at 
>>> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection(DB2BaseDataSource.java:2792) 
>>>
>>>       at 
>>> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnection(DB2BaseDataSource.java:2756) 
>>>
>>>       at 
>>> com.ibm.db2.jcc.DB2XADataSource.getXAConnection(DB2XADataSource.java:73)
>>>       at 
>>> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnection(AbstractXADataSourceMCF.java:74) 
>>>
>>>       ... 33 more
>>> com.ibm.db2.jcc.b.SqlException: [ibm][db2][jcc][10257][10960] Unable 
>>> to open file .
>>>       at com.ibm.db2.jcc.b.ch.a(ch.java:111)
>>>       ...
>>>
>>> I created the deployment plan using the Geronimo database pool wizard 
>>> after adding the 2 (db2jcc-9.1.2.jar and db2jcc_license_cu-9.1.2.jar) 
>>> DB2 drivers to the repo.
>>>
>>> Cheers!
>>> Hernan
>>>
>>>
>>> David Jencks wrote:
>>>> I'm not sure where you got the prototype for your plan, but I doubt 
>>>> it was the documentation you linked to, unless someone has 
>>>> completely  revised that documentation since your first post.  Your 
>>>> plan uses the geronimo 1.0 plan syntax which is incompatible with 
>>>> geronimo 1.1 and later, whereas the plan in the docs looks up to date.
>>>> The easiest way to get a working plan is to use the admin console 
>>>> wizard to generate it.  I suggest using the wizard to generate the 
>>>> plan and then deploying using the command line.  This way you can 
>>>> easily study and modify the plan as needed.
>>>> thanks
>>>> david jencks
>>>> On Mar 28, 2008, at 7:47 PM, SKService wrote:
>>>>>
>>>>> Thankyou for your fruitful reply. But still I'm stuck.
>>>>> First, I already have "tranql-connector-db2-xa-1.1" under the path
>>>>> "repository/org/tranql/tranql-connector-db2-xa/1.1/tranql-connector-db2-xa-1.1.rar" 
>>>>> . But I'm confused in using it because I'm not sure where in the 
>>>>> plan to add
>>>>> the deployment plan tag referred by you,
>>>>>    <external-path
>>>>> xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">
>>>>>      <dep:groupId>org.tranql</dep:groupId>
>>>>>      <dep:artifactId>tranql-connector-db2-xa</dep:artifactId>
>>>>>      <dep:type>rar</dep:type>
>>>>>    </external-path>
>>>>>
>>>>> Second, I've tried after correcting the command parameter sequence. 
>>>>> The
>>>>> corrected command (with my old setup) is,
>>>>> deploy --user system --password manager deploy
>>>>> ..\repository\org\tranql\tranql-connector-ra\1.4\tranql-connector-ra-1.4.rar 
>>>>>
>>>>> Please take a look at the error pasted below, which also has the 
>>>>> plan. and
>>>>> suggested whether my plan needs to be corrected.
>>>>>
>>>>> Appreciate your help.
>>>>>
>>>>> C:\geronimo-tomcat6-jee5-2.0.2\bin>deploy --user system --password 
>>>>> manager
>>>>> deploy
>>>>> ..\repository\org\tranql\tranql-connector-ra\1.4\tranql-connector-ra-1.4.rar 
>>>>>    C:\geronimo-tomcat6-jee5-2.0.2\bin\db2-geronimo-plan.xml
>>>>> Using GERONIMO_BASE:   C:\geronimo-tomcat6-jee5-2.0.2
>>>>> Using GERONIMO_HOME:   C:\geronimo-tomcat6-jee5-2.0.2
>>>>> Using GERONIMO_TMPDIR: var\temp
>>>>> Using JRE_HOME:        C:\Program Files\Java\jdk1.5.0_06\jre
>>>>>     Error: Unable to distribute tranql-connector-ra-1.4.rar:
>>>>>     org.apache.geronimo.common.DeploymentException: Could not parse
>>>>>     module descriptor
>>>>>
>>>>>         Could not parse module descriptor
>>>>>
>>>>>         Invalid deployment descriptor: errors:
>>>>>
>>>>>
>>>>>     C:\geronimo-tomcat6-jee5-2.0.2\bin\db2-geronimo-plan.xml:2:1: 
>>>>> error:
>>>>>     cvc-complex-type.3.2.1: Attribute not allowed (no wildcards
>>>>>     allowed): configId in element
>>>>>     connector@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2
>>>>>
>>>>>
>>>>>     C:\geronimo-tomcat6-jee5-2.0.2\bin\db2-geronimo-plan.xml:15:3:
>>>>>     error: cvc-complex-type.2.4a: Expected element
>>>>>     
>>>>> 'resourceadapter@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     instead of
>>>>>     'dependency@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     here in element
>>>>>     connector@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2
>>>>>
>>>>>
>>>>>     C:\geronimo-tomcat6-jee5-2.0.2\bin\db2-geronimo-plan.xml:19:3:
>>>>>     error: cvc-complex-type.2.4a: Expected element
>>>>>     
>>>>> 'resourceadapter@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     instead of
>>>>>     'dependency@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     here in element
>>>>>     connector@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2
>>>>>
>>>>>
>>>>>     C:\geronimo-tomcat6-jee5-2.0.2\bin\db2-geronimo-plan.xml:23:3:
>>>>>     error: cvc-complex-type.2.4a: Expected element
>>>>>     
>>>>> 'resourceadapter@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     instead of
>>>>>     'dependency@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
>>>>>     here in element
>>>>>     connector@http://geronimo.apache.org/xml/ns/j2ee/connector-1.2
>>>>>
>>>>>
>>>>>     Descriptor:
>>>>>
>>>>>     <xml-fragment configId="user/database-pool-DB2_Test/1/car"
>>>>>     xmlns:con="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">
>>>>>
>>>>>       <!--#####        COMMENT OUT THIS SECTION      #####-->
>>>>>
>>>>>       <!---->
>>>>>
>>>>>       <!--<dep:dependency
>>>>>     xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.0">-->
>>>>>
>>>>>   <!--<dep:uri>db2/db2jcc/8.1.7/jar</dep:uri>-->
>>>>>
>>>>>   <!--</dep:dependency>-->
>>>>>
>>>>>   <!--##### ADD THE FOLLOWING THREE DEPENDENCIES #####-->
>>>>>
>>>>>   <con:dependency>
>>>>>
>>>>>     <con:uri>db2/db2jcc/8.1.7/jar</con:uri>
>>>>>
>>>>>   </con:dependency>
>>>>>
>>>>>   <con:dependency>
>>>>>
>>>>>     <con:uri>db2/db2jcc_license_cu/8.1.7/jar</con:uri>
>>>>>
>>>>>   </con:dependency>
>>>>>
>>>>>   <con:dependency>
>>>>>
>>>>>     <con:uri>db2/db2jcc_license_cisuz/8.1.7/jar</con:uri>
>>>>>
>>>>>   </con:dependency>
>>>>>
>>>>>   <!--#####  THE REMAINING PART DOES NOT CHANGE  #####-->
>>>>>
>>>>>   <con:resourceadapter>
>>>>>
>>>>>     <con:outbound-resourceadapter>
>>>>>
>>>>>       <con:connection-definition>
>>>>>
>>>>>
>>>>> <con:connectionfactory-interface>javax.sql.DataSource</con:connectionfactory-interface> 
>>>>>
>>>>>         <con:connectiondefinition-instance>
>>>>>
>>>>>           <con:name>DB2_TEST1</con:name>
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="Password">db2admin</con:config-property-setting>
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="CommitBeforeAutocommit">false</con:config-property-setting>
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="Driver">com.ibm.db2.jcc.DB2Driver</con:config-property-setting>
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="ExceptionSorterClass">org.tranql.connector.AllExceptionsAreFatalSorter</con:config-property-setting> 
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="UserName">db2admin</con:config-property-setting>
>>>>>
>>>>>           <con:config-property-setting
>>>>> name="ConnectionURL">jdbc:db2://localhost:50000/TEST1</con:config-property-setting> 
>>>>>
>>>>>           <con:connectionmanager>
>>>>>
>>>>>             <con:local-transaction/>
>>>>>
>>>>>             <con:single-pool>
>>>>>
>>>>>               <con:match-one/>
>>>>>
>>>>>             </con:single-pool>
>>>>>
>>>>>           </con:connectionmanager>
>>>>>
>>>>>         </con:connectiondefinition-instance>
>>>>>
>>>>>       </con:connection-definition>
>>>>>
>>>>>     </con:outbound-resourceadapter>
>>>>>
>>>>>   </con:resourceadapter>
>>>>>
>>>>> </xml-fragment>
>>>>> -- 
>>>>> View this message in context: 
>>>>> http://www.nabble.com/Problem-creating-a-DB2-datasource-tp16344329s134p16366049.html 
>>>>> Sent from the Apache Geronimo - Users mailing list archive at 
>>>>> Nabble.com.
>>>>>
>>>
>>
>