How to add an Interbase connection pool to glassfish?

Question

Hi,

I am attempting to add an Interbase connection pool to GlassFish v3 to use EJB 3.1 in a project. The glassfish log appears to be connecting to my database properly, it spits out all my table names and indices. However, I get an error

INFO: fetching database metadata SEVERE: could not complete schema update java.lang.NullPointerException at interbase.interclient.ResultSet.local_Close(Unknown Source) ...

And when I ping the connection pool from within Glassfish I receive "Ping failed Exception - null".

I have the following properties set with my connectionpool:

resource type: javax.sql.DataSource

Datasource Classname: interbase.interclient.DataSource

portNumber: 3050

as well as my database info.

I can't seem to find information elsewhere. This question is similar but did not receive an answer.

thanks.

Answer 1

If the ping fails at the connection pool level then things are very likely not going to work. Any chances to use another database? If yes, really do it because Interbase seems to be an outdated product and I'm not very confident with the quality of available JDBC drivers (drivers listed in this page are all so old and dusty). It looks like time has been suspended with J2EE 1.3... If not, then maybe try another driver (the Firebird one for example).

Update: As pointed out by Craig in a comment, InterBase is maintained by Embarcadero and includes a Type 4 JDBC Driver. But, still, the Borland/CodeGear/Embarcadero products are IMHO on a dying trend.