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 Thu, 03 Apr 2008 16:24:43 GMT

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.
>>>>>>>
>>>>>
>>>>
>>>


Mime
View raw message