geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Hernan Cunico <hcun...@gmail.com>
Subject Re: Problem creating a DB2 datasource
Date Thu, 03 Apr 2008 16:16:14 GMT
Close but not cigar yet ;-)

I just tested tranql-connector-db2-xa-1.2-20080326.214959-2.rar and getting some weird behavior.

With 1.2 snapshot I can use the wizard, create a plan and deploy the pool; all from the admin
console but I fail to access the database defined in the pool. (for the record it deploys
OK from the console)

The weird thing is that if I use the wizard just to create a plan but then deploy it from
the command line it also deploys OK but also I CAN access the DB. So, not sure what the deal
is. Am I doing something while substituting the connectors? should I delete 1.1 from the repo?

Cheers!
Hernan

Joe Bohn wrote:
> 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.
>>>>>>
>>>>
>>>
>>
> 
> 

Mime
View raw message