I'm using hibernate successfully with MySQL

When I try to connect remotely to an Interbase database (IB 5.6, with Interclient 2.01 from Firebird) I've got a message :

GRAVE: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported.
See API reference for exception interbase.interclient.DriverNotCapableException

8 mars 2004 17:34:44 net.sf.hibernate.JDBCException <init>

GRAVE: Could not load object

interbase.interclient.DriverNotCapableException: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported.
See API reference for exception interbase.interclient.DriverNotCapableException

at interbase.interclient.ResultSet.getBigDecimal(Unknown Source)

at net.sf.hibernate.type.BigDecimalType.get(BigDecimalType.java:23)


in fact, the method getBigDecimal() seems to be unimplemented in this release of the jdbc driver (which is actually recommanded in hibernate specs)

what can I do ? any idea ?

thanks in advance

JDBC Support for Interbase is not particularly great. I think there is a Borland supported version of Interclient, probably use this one? Interclient is no longer supported by the Firebird team, the only developed JDBC driver is JayBird.

But we can't really do anything about this, either find a better JDBC driver, use a better database (Firebird) or don't use BigDecimals.

I've tried with the original 1.51 interclient driver, with 1.6, but the problem is still the same ; borland 2.0 driver works only with jdk1.2, so I cannot execute it, but I think the lack of implementation is still the same for bigdecimal

I can't obtain the "new" 2.5 driver because it isn't opensource and available only with interbase 6

Unfortunately, I cannot switch to firebird database

Can I use Jaybird driver with my old interbase 5.6 ?

what can I use to avoid BigDecimal type ?

You can not use something which requires jdk 1.1 but you manage to use Hibernate? How?

I don't think there is a solution, you could try JayBird, but I am not sure it is compatible. Otherwise, don't use types which translate to a BigDecimal when accessing the Database.

borland interclient 2.0 works ONLY with jdk1.2, not with 1.1, and not with my jdk1.4 !!! (neither with 1.3, by the way)

as I said, my test program works fine with hibernate and mysql, I only tried to redirect the db within interbase

what a great driver, with a lot of methods not implemented, and a great compatibility as you see.....