Hi David,

Yes, this actually helped, thank you very much!

However, the deployment plan I provided was generated by database pool
wizard in the console, as follows: 

Console Navigation - Services - Database Pools
Create a new database pool: Using the Geronimo database pool wizard
Database Type: Derby embedded XA
Driver JAR: org.apache.derby/derby/10.2.2.0/jar

This seems to be a logical and trivial way.
And org.apache.geronimo.configs is absent in the "Driver JAR" list.

So, maybe there's a problem with database pool wizard that generates a
deployment plan that doesn't work as expected?

Vasily


-----Original Message-----
From: David Jencks [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, October 10, 2007 4:16 AM
To: [email protected]
Subject: Re: ClassCastException at Derby EmbeddedDataSource

Hi Vasily,

when you use a derby datasource you have to make sure you get the  
derby classes from the same classloader as the embedded derby  
database.  You normally do this by replacing the derby dependency in  
your plan with something like

             <dep:dependency>
                 <dep:groupId>org.apache.geronimo.configs</dep:groupId>
                 <dep:artifactId>system-database</dep:artifactId>
                 <dep:type>car</dep:type>
             </dep:dependency>

Hope this helps
david jencks



On Oct 9, 2007, at 2:16 PM, Zakharov, Vasily M wrote:

> Hi, all,
>
> I've come into a strange situation, that looks like maybe a bug, while
> working on SPECjAppServer2004 deployment on G2.0.1.
>
> When working with Embedded XA TranQL connector to internal Derby
> database, class org.apache.geronimo.jdbc.DelegatingDriver (implements
> java.sql.Driver) comes out in a place where either
> org.apache.derby.jdbc.AutoloadedDriver (implements java.sql.Driver) or
> org.apache.derby.jdbc.InternalDriver (implements
> org.apache.derby.iapi.services.monitor.ModuleControl) is expected, and
> this causes a ClassCastException on server side:
>
> java.lang.ClassCastException:  
> org.apache.geronimo.jdbc.DelegatingDriver
>         at org.apache.derby.jdbc.EmbeddedDataSource.findDriver(Unknown
> Source)
>         at
> org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
>         at
> org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown Source)
>         at
> org.apache.derby.jdbc.EmbeddedXADataSource.setupResourceAdapter 
> (Unknown
> Source)
>         at
> org.apache.derby.jdbc.EmbeddedXADataSource.getXAConnection(Unknown
> Source)
>         at
> org.tranql.connector.jdbc.AbstractXADataSourceMCF.getPhysicalConnectio

> n(
> AbstractXADataSourceMCF.java:74)
>         at
> org.tranql.connector.derby.EmbeddedXAMCF.createManagedConnection 
> (Embedde
> dXAMCF.java:52)
>         at
> org.apache.geronimo.connector.outbound.MCFConnectionInterceptor.getCon

> ne
> ction(MCFConnectionInterceptor.java:48)
>         at
> org.apache.geronimo.connector.outbound.LocalXAResourceInsertionInterce

> pt
> or.getConnection(LocalXAResourceInsertionInterceptor.java:41)
>         at
> org.apache.geronimo.connector.outbound.SinglePoolConnectionInterceptor

> .i
> nternalGetConnection(SinglePoolConnectionInterceptor.java:67)
>         at
> org.apache.geronimo.connector.outbound.AbstractSinglePoolConnectionInt

> er
> ceptor.getConnection(AbstractSinglePoolConnectionInterceptor.java:78)
>         at
> org.apache.geronimo.connector.outbound.TransactionEnlistingInterceptor

> .g
> etConnection(TransactionEnlistingInterceptor.java:46)
>         at
> org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.g

> et
> Connection(TransactionCachingInterceptor.java:88)
>         at
> org.apache.geronimo.connector.outbound.ConnectionHandleInterceptor.get

> Co
> nnection(ConnectionHandleInterceptor.java:43)
>         at
> org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection 
> (TCC
> LInterceptor.java:39)
>         at
> org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.g

> et
> Connection(ConnectionTrackingInterceptor.java:66)
>         at
> org.apache.geronimo.connector.outbound.AbstractConnectionManager.alloc

> at
> eConnection(AbstractConnectionManager.java:87)
>         at
> org.tranql.connector.jdbc.DataSource.getConnection(DataSource.java:56)
>         ...
>
> The deployment plan for the connector can be found here:
> http://cwiki.apache.org/confluence/download/attachments/64828/sjas- 
> db.xm
> l
>
> This plan is deployed with
> repository/org/tranql/tranql-connector-derby-embed-xa/1.3/tranql- 
> connect
> or-derby-embed-xa-1.3.rar
>
> Vasily Zakharov
> Intel ESSD
>
>
> ---
> --------------------------------------------------------------------
> Closed Joint Stock Company Intel A/O
> Registered legal address: 125252, Moscow, Russian Federation,
> Chapayevsky Per, 14.
>
> This e-mail and any attachments may contain confidential material for
> the sole use of the intended recipient(s). Any review or distribution
> by others is strictly prohibited. If you are not the intended
> recipient, please contact the sender and delete all copies.
--------------------------------------------------------------------
Closed Joint Stock Company Intel A/O
Registered legal address: 125252, Moscow, Russian Federation, 
Chapayevsky Per, 14.

This e-mail and any attachments may contain confidential material for
the sole use of the intended recipient(s). Any review or distribution
by others is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete all copies.

Reply via email to