Robin,
Where do I have to specify "generic" sql engine ?
Thank you.
Patrick
----- Original Message -----
From: "Robin Hoogeboom" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 12:07 PM
Subject: Re: [castor-dev] JDO example : getBigDecimal
> 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
>
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev