JDBC BigDecimal Problem. Castor - WebLogic

JDBC BigDecimal Problem. Castor - WebLogic - Sybase

Thread view:

davo_java - 16 Jun 2005 22:42 GMT

Hi there!

I'm using Castor V. 0.9.4.3 as Persistence Framework, a Sybase Database
(JConnect JDBC), and BEA WebLogic 8.1.

The problem is: I have several fields defined as NUMERIC(20,2) in DB
Tables. Those fields are defined in Castor Mapping file as:

<field name="tasa" type="big-decimal">
<sql name="tasa" type="numeric" />
</field>

In addition, debuggin my domain objects and business methods, all
object members are defined as BigDecimal with scale=2 and its values
are right, but when the crate(object) method executes, a number like
145.56 is stored as 145.00 in DB.

Can anybody help me?

Thanks a lot!

Dave

Reply to this Message

davo_java - 23 Jun 2005 19:33 GMT

Does anybody know about any bug realted with Sybase JDBC driver and
BigDeciaml data type?

The problem seems to be a scale loss when Castor is binding SQL query
(INSERT/UPDAET) parameters. (SetObject().... GetObject()... )

Thanks!

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...