Skip to Main Content

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!

Problem in Inputing/Updating float value in SQL Server

843859Jan 7 2006 — edited Jan 10 2006
I'm trying to update float values in SQL Server2000 using PreparedStatement with setFloat(colNo, floatValue) method.

The floatValue was 1.1 as I typed it in and printed out (System.out.print) but that value will be 1,10000002384186 inside the database.

That column in SQLServer is typed float

Please help..
What've I done wrong

David
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 7 2006
Added on Jan 7 2006
1 comment
218 views