Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Arithmetic flow error for type money

843854Mar 28 2003 — edited Mar 28 2003

folks

I have an Multi-tier application which consists of JSP,EJB,JMS etc...using SQL Server as backend, I am facing some problem which i guess is related to Datatype's , From my JSP i have a field named Money, which is an Double Datatype, in backend we are using "money" as the datatype, If i try to enter more than the value of "money" can handle its throwing java.sql.SQL Exception:Arithmetic overflow error for type money,value=90000000000000000.000000.Severity 16, If any one knows about this please guide me how to go about changing the Datatype from my side(JSP), First time i guessed its because of "Attempt to update or insert row failed because resultant row of size %d bytes is larger than the maximum size (%d bytes) allowed for this table. ",

thanks
kirk

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 25 2003

Added on Mar 28 2003

#java-database-connectivity-jdbc

5 comments

225 views