JDBC BigDecimal Problem. Castor - WebLogic - Sybase

D

davo_java

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
 
D

davo_java

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top