Subject RE: [Firebird-Java] Re: Can't connect to Firebird database with Websphere Express 5
Author David Clunes
Post date 2004-01-23T05:14:44Z
Roman,
 
Have you implemented  ConnectionPoolDataSource in Jaybird 1.5?
 
DC
-----Original Message-----
From: Roman Rokytskyy [mailto:rrokytskyy@...]
Sent: Tuesday, January 20, 2004 1:55 AM
To: Firebird-Java@yahoogroups.com
Subject: [Firebird-Java] Re: Can't connect to Firebird database with Websphere Express 5

Hi,

> Yes, an error is logged as follows: Datasource class cannot be used
> as one-phase: ClassCastException: org.firebirdsql.jdbc.FBDriver.
>
> It appears that the enable2phase property needs to be set to false.
> Is this correct? How is this done?

JayBird does not support JTA via java.sql.Driver interface (seems to
be your case). You have to specify that your datasource is JDBC, not
JTA. See WebSpehere documentation on this topic.

If you need support for two-phase commit, you have to use JCA. In this
case you will have to take firebirdsql.rar and correct deployment
descriptor to fit your configuration. Probably you will have to add
some WebSpehere-specific properties. To get more information on how to
configure JCA datasources, please refer to your Websphere
documentation and/or call IBM support.

Best regards,
Roman Rokytskyy



Yahoo! Groups Links