Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

OraResultSet and ResutSet

 
Steve Jiang
Ranch Hand
Posts: 127
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I hope to use the function getINTERVALDS() in OracleResultSet, and find the existing code is using standard java interface ResultSet and PrearedStatement, I am thinking to change the existing ResultSet to OracleResultSet , but not sure if it will affect the existing code somwhat.

My application is only run in Oracle Env, so no concern for the interface with other DBs. Can I change the ResultSet tr OracleResultSet without the effect for existing code? What is the difference between OracleResultSet and ResultSet?


Thanks,


 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34837
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Steve Jiang wrote: What is the difference between OracleResultSet and ResultSet?

It's Oracle's implementation.

By changing to OracleResultSet, you run the risk of making your code harder to maintain. As a rule of thumb, I wouldn't switch unless what you want to do can't be accomplished by other means. Looking at the JavaDoc for IntervalDS, it looks like a date type object. What do you need from it that getTimestamp() doesn't?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic