Subject Re: Can't connect to Firebird database with Websphere Express 5
Author Roman Rokytskyy
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