File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC 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
Bookmark "Using ResultSet.getString( )" Watch "Using ResultSet.getString( )" New topic
Author

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
author
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: http://aspose.com/file-tools
 
subject: Using ResultSet.getString( )