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 17:58:49 GMT
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.
>>>>>>>>
>>>>>>
>>>>>
>>>>
> 
> 

Mime
View raw message