Robin,
If it's the engine in database.xml, I have tried and I have got the same
result with both "interbase" and "generic".
I think it's a problem with the interbase JDBC driver.
Thank you.
Patrick
----- Original Message -----
From: "Patrick Vanhuyse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 2:16 PM
Subject: Re: [castor-dev] JDO example : getBigDecimal
> 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
>
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
