geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From David Jencks <david_jen...@yahoo.com>
Subject Re: Problem creating a DB2 datasource
Date Mon, 31 Mar 2008 17:00:14 GMT
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.getPhysicalConnectio 
> n(AbstractXADataSourceMCF.java:76)
>       at org.tranql.connector.db2.XAMCF.createManagedConnection 
> (XAMCF.java:59)
>       at  
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCon 
> nection(MCFConnectionInterceptor.java:48)
>       at  
> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterce 
> ptor.getConnection(LocalXAResourceInsertionInterceptor.java:41)
>       at  
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor 
> .internalGetConnection(SinglePoolConnectionInterceptor.java:70)
>       at  
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInt 
> erceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java: 
> 80)
>       at  
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor 
> .getConnection(TransactionEnlistingInterceptor.java:46)
>       at  
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.g 
> etConnection(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.getPhysicalConnectio 
> n(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.AllExceptionsAreFat 
>>> alSorter</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.
>>>
>


Mime
View raw message