Patrick,
Which SQL engine setting do you use?. I use the "Generic" setting
and has no problem with BigDecimal whatsoever. I use Castor with
Jrun 4 and a Progress 9.1D database, combined with a type 2 jdbc
driver.
You could try setting the "generic" sql engine and test if your
setting is ok.
Good luck,
Robin Hoogeboom
----- Origineel Bericht -----
Van: "Patrick Vanhuyse" <[EMAIL PROTECTED]>
Datum: Maandag, Januari 13, 2003 11:40 am
Onderwerp: [castor-dev] JDO example : getBigDecimal
> 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.idFROM 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 ?
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
