Re: Problem creating a DB2 datasource

Mon, 31 Mar 2008 10:42:10 -0700 

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 [EMAIL PROTECTED] javax.resource.spi.ResourceAdapterInternalException: Unable to obtain physical connection to [EMAIL PROTECTED] 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
    [EMAIL PROTECTED]://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
'[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2' 
    instead of
    '[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
    here in element
    [EMAIL PROTECTED]://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
'[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2' 
    instead of
    '[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
    here in element
    [EMAIL PROTECTED]://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
'[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2' 
    instead of
    '[EMAIL PROTECTED]://geronimo.apache.org/xml/ns/j2ee/connector-1.2'
    here in element
    [EMAIL PROTECTED]://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.

Reply via email to