[castor-dev] JDO example : getBigDecimal

[Patrick Vanhuyse]

Using Castor with Interbase. I think I have the latest Interbase JDBC driver. I have seen in the list archive other people having the same problem with mysql and oracle. I have the following error when running the example with a non empty db :   [test] Begin transaction [test] SELECT prod.id,prod.name,prod.price,prod.group_id,prod_detail.id FROM prod LEFT OUTER JOIN prod_detail ON prod.id=prod_detail.prod_id WHERE prod.id = ? [test] Castor: Loading myapp.Product (4) [test] org.exolab.castor.persist.PersistenceExceptionImpl: Nested error: interbase.interclient.DriverNotCapableException: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported. [test] See API reference for exception interbase.interclient.DriverNotCapableException [test] interbase.interclient.DriverNotCapableException: [interclient] Unsupported feature: Using a JDBC 2 method which is not yet supported. [test] See API reference for exception interbase.interclient.DriverNotCapableException [test]  at interbase.interclient.ResultSet.getBigDecimal(Unknown Source) [test]  at org.exolab.castor.jdo.engine.SQLTypes.getObject(SQLTypes.java:293) [test]  at org.exolab.castor.jdo.engine.SQLEngine$SQLQuery.fetch(SQLEngine.java:104 2) [test]  at org.exolab.castor.persist.CacheEngine.fetch(CacheEngine.java:553) [test]  at org.exolab.castor.persist.QueryResults.fetch(QueryResults.java:259) [test]  at org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQuer yImpl.java:1129) [test]  at org.exolab.castor.jdo.engine.OQLQueryImpl$OQLEnumeration.hasMore(OQLQuer yImpl.java:1095) [test]  at Test.run(Test.java:97) [test]  at Test.main(Test.java:51) I can't get a more recent driver because I have the most recent.   Is there any solution ? Can I use NUMERIC or DECIMAL with less digits ? How many digits ?