Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes Using ResultSet.getString( ) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Using ResultSet.getString( )" Watch "Using ResultSet.getString( )" New topic

Using ResultSet.getString( )

Ravi Singh
Ranch Hand

Joined: Aug 02, 2004
Posts: 51
When using the result set methods getInt(), getString() etc to get the values returned from the database do the database column types have to be of type number or varchar2 respectively?

Or, do the methods attempt to parse the value of the database column as a string (for the getString() method) or as a int (for the getInt() method)?
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
The JDBC specification dictates the mappings between JDBC types and Java types. In addition, the JDBC driver can perform some type conversions if you ask for another type using getString() and so on. There's a table in the JDBC spec; an appendix, if I'm not mistaken.

- Peter
I agree. Here's the link:
subject: Using ResultSet.getString( )
It's not a secret anymore!