wood burning stoves 2.0*
The moose likes JDBC and the fly likes PreparedStatement.setFloat not entering precise values in db Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "PreparedStatement.setFloat not entering precise values in db" Watch "PreparedStatement.setFloat not entering precise values in db" New topic

PreparedStatement.setFloat not entering precise values in db

java dunce

Joined: Aug 12, 2004
Posts: 1
I have written a program where I am entering a record in to the
database using a prepared statement. The problem is for float datatypes, the
values being entered into the database are not rounded off. e.g. 1.65 is
being entered as 1.64999999
I am using the Sybase database and the driver is

If I use staement instead of prepared statement, i am getting the correct values.
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
Can you post the two code fragments you're using?
Make sure you use the UBB CODE tags.


Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 60780

"java dunce",

We're pleased to have you here with us on the Ranch, but there are a few rules that need to be followed, and one is that proper names are required. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

Forum Bartender

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
I agree. Here's the link: http://aspose.com/file-tools
subject: PreparedStatement.setFloat not entering precise values in db
Similar Threads
Can't read string with quotes around it in my bean method - Please help?????
Prepared Statement
Ignoring case in queries.........
SQL Injection
Urgent Java interview question 6+ yrs exp.