This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes JDBC Metadata - Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC Metadata - Oracle" Watch "JDBC Metadata - Oracle" New topic

JDBC Metadata - Oracle

Steve Jolin

Joined: Oct 03, 2003
Posts: 1
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();
I agree. Here's the link:
subject: JDBC Metadata - Oracle
Similar Threads
getTableName() on ResultSetMetadata
i m new to hibernate
Problems with ResultSetMetaData getTableName()
Create a table using ResultSet ???
Problem with rs.isAfterLast() and rs.isFirst()