This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes problem in fetching data from database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in fetching data from database" Watch "problem in fetching data from database" New topic
Author

problem in fetching data from database

suresh gonuguntla
Greenhorn

Joined: Feb 22, 2006
Posts: 11
In database it is showing the value of the 3rd column is in decimal form (i.e. 123.45)

String getInfo = "{CALL PKG_TICKET.IF_TINFO" + "(?, ?, ?)}";
gcs_getInfo = (OracleCallableStatement)go_dbConn.prepareCall(getInfo);
System.out.println("The amount in the Database:"+gcs_getInfo.getString(3));

But after executing this code, I got 123,45 in my log file, while it's value is 123.45 in DB.

Is there any problem in code or any conversion problem in database or what???

Plz provide the solution as quick as possible
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3710
    
    5

Try using getLong() or getDouble() instead of getString(). Then you can use a java number formatter to display the number properly.


My Blog: Down Home Country Coding with Scott Selikoff
 
jQuery in Action, 2nd edition
 
subject: problem in fetching data from database