Oracle, OBJ-Mapping and BigDecimals

[Torsten Trzeciak <to...@trzeciak.de>]

Hi,
usually I use a special ID field in every DB table which has a generated ID.
Now I have Oracle 8.x.x and for me it seems that Oracle only accepts numbers
which are Converted to BigDecimals.

After mapping the table with OJB I got an exception because the long (java
class) to number conversion seems to fail.

Is it necessary to use BigDecimals for generated IDs in the classes?

Is there any OJB-Mail-Archive active at the moment??????

Re: Oracle, OBJ-Mapping and BigDecimals

[Armin Waibel <ar...@code-au-lait.de>]

seems mail-archive.com is temporary down
try this
user list:
http://news.gmane.org/thread.php?group=gmane.comp.jakarta.ojb.user

dev-list:
http://news.gmane.org/thread.php?group=gmane.comp.jakarta.ojb.devel

regards,
Armin

----- Original Message -----
From: "Thomas Mahler" <th...@web.de>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, June 02, 2003 11:45 AM
Subject: Re: Oracle, OBJ-Mapping and BigDecimals


> Hi Torsten,
>
> Torsten Trzeciak wrote:
> > Hi,
> > usually I use a special ID field in every DB table which has a
generated ID.
> > Now I have Oracle 8.x.x and for me it seems that Oracle only accepts
numbers
> > which are Converted to BigDecimals.
> >
> > After mapping the table with OJB I got an exception because the long
(java
> > class) to number conversion seems to fail.
> >
> > Is it necessary to use BigDecimals for generated IDs in the classes?
>
> AFAIK the Oracles generic datatype NUMBER must be mapped to Java
BigDecimal!
>
> >
> > Is there any OJB-Mail-Archive active at the moment??????
>
> you can use the mail archive links provided here:
> http://db.apache.org/ojb/mail-lists.html
>
> Thomas
>
> >
>
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> > For additional commands, e-mail: ojb-user-help@db.apache.org
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>

Re: Oracle, OBJ-Mapping and BigDecimals

[Thomas Mahler <th...@web.de>]

Hi Torsten,

Torsten Trzeciak wrote:
> Hi,
> usually I use a special ID field in every DB table which has a generated ID.
> Now I have Oracle 8.x.x and for me it seems that Oracle only accepts numbers
> which are Converted to BigDecimals.
> 
> After mapping the table with OJB I got an exception because the long (java
> class) to number conversion seems to fail.
> 
> Is it necessary to use BigDecimals for generated IDs in the classes?

AFAIK the Oracles generic datatype NUMBER must be mapped to Java BigDecimal!

> 
> Is there any OJB-Mail-Archive active at the moment??????

you can use the mail archive links provided here:
http://db.apache.org/ojb/mail-lists.html

Thomas

> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
> 
>