This week's book giveaway is in the Features new in Java 9 forum.
We're giving away four copies of Java 9 Revealed and have Kishori Sharan on-line!
See this thread for details.
Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC Metadata - Oracle  RSS feed

 
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
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!