Hi Patrick,
>From your problemdescription I guess you are using Castor JDO.
You must specify the database you use, either in an file or lookup.
Normally this file is called database.xml
I use an JNDI setting in an xml file:
<database name="nbtis" engine="generic">
<jndi name="nbtis_nbtis" />
<mapping href="nbtis-nbtis-map.xml" />
</database>
In this file you specify your database name & engine. In this example
I use an JNDI lookup, but you can also use a connectionstring.
more info on castor site:
http://www.castor.org/database-conf.html#The-Castor-configuration-file
Good luck.
Robin
----- Origineel Bericht -----
Van: "Patrick Vanhuyse" <[EMAIL PROTECTED]>
Datum: Maandag, Januari 13, 2003 2:16 pm
Onderwerp: 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
