You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Joe Bohn <jo...@earthlink.net> on 2008/04/03 17:05:26 UTC
Re: Problem creating a DB2 datasource
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.
>>>>>
>>>
>>
>
Re: Problem creating a DB2 datasource
Posted by Hernan Cunico <hc...@gmail.com>.
Created https://issues.apache.org/jira/browse/GERONIMO-3949
Cheers!
Hernan
David Jencks wrote:
>
> On Apr 3, 2008, at 9:16 AM, Hernan Cunico wrote:
>
>> 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?
>
> probably. The connector version might be hardcoded somewhere in the
> stuff that deploys the datasource. If it is I'd expect console
> deployment to fail. If this happens we should see if we can stop
> specifying the version. A jira would be in order.
> Hopefully I'll get a minute to release the connector today...
> thanks
> david jencks
>>
>> 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.
>>>>>>>>
>>>>>>
>>>>>
>>>>
>
>
Re: Problem creating a DB2 datasource
Posted by David Jencks <da...@yahoo.com>.
On Apr 3, 2008, at 9:16 AM, Hernan Cunico wrote:
> 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?
probably. The connector version might be hardcoded somewhere in the
stuff that deploys the datasource. If it is I'd expect console
deployment to fail. If this happens we should see if we can stop
specifying the version. A jira would be in order.
Hopefully I'll get a minute to release the connector today...
thanks
david jencks
>
> 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.getPhysicalConne
>>>>> ction(AbstractXADataSourceMCF.java:76)
>>>>> at org.tranql.connector.db2.XAMCF.createManagedConnection
>>>>> (XAMCF.java:59)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.ge
>>>>> tConnection(MCFConnectionInterceptor.java:48)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInt
>>>>> erceptor.getConnection(LocalXAResourceInsertionInterceptor.java:
>>>>> 41)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterce
>>>>> ptor.internalGetConnection(SinglePoolConnectionInterceptor.java:
>>>>> 70)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectio
>>>>> nInterceptor.getConnection
>>>>> (AbstractSinglePoolConnectionInterceptor.java:80)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.TransactionEnlistingInterce
>>>>> ptor.getConnection(TransactionEnlistingInterceptor.java:46)
>>>>> at
>>>>> org.apache.geronimo.connector.outbound.TransactionCachingIntercept
>>>>> or.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.computeJccLogWriterForNewConnect
>>>>> ion(DB2BaseDataSource.java:2792)
>>>>> at
>>>>> com.ibm.db2.jcc.DB2BaseDataSource.computeJccLogWriterForNewConnect
>>>>> ion(DB2BaseDataSource.java:2756)
>>>>> at com.ibm.db2.jcc.DB2XADataSource.getXAConnection
>>>>> (DB2XADataSource.java:73)
>>>>> at
>>>>> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConne
>>>>> ction(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.AllExceptionsAr
>>>>>>> eFatalSorter</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.
>>>>>>>
>>>>>
>>>>
>>>
Re: Problem creating a DB2 datasource
Posted by Hernan Cunico <hc...@gmail.com>.
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.
>>>>>>
>>>>
>>>
>>
>
>