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 JDBC Metadata - Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "JDBC Metadata - Oracle" Watch "JDBC Metadata - Oracle" New topic
Author

JDBC Metadata - Oracle

Steve Jolin
Greenhorn

Joined: Oct 03, 2003
Posts: 1
Hello,
In the following code using JDBC against Oracle, when the metadata is retrieved using the getMetaData() call, does this make a call back to the Oracle database or is this data already local in memory following the creation of the ResultSet. We are trying to determine if it pays to cache and reuse the ResultSetMetaData object locally, since we may be accessing the same table multiple times.
// shadowRs is a ResultSet from the execution of a "select * from <table>" query
ResultSetMetaData rsmd = shadowRs.getMetaData();
Thx,
Steve
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: JDBC Metadata - Oracle
 
Similar Threads
Create a table using ResultSet ???
getTableName() on ResultSetMetadata
Problem with rs.isAfterLast() and rs.isFirst()
Problems with ResultSetMetaData getTableName()
i m new to hibernate