Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC Metadata - Oracle

 
Steve Jolin
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic