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?
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?