I am back from 1 week Vacation . Yesterday , When I was working on writing JDBC code, i found that returning auto generated keys is supported by JDBC 3.0 . So I went ahead and downloaded the latest ojdbc14.jar and deployed my war in tomcat. Worked without any issues. However, when i deployed the same in 10g AS it gave an abstract method error. Then , when I printed out the driver version property to my utter dismay i found that it was printing 9 and not 10 . After further investigations i found that you need to force 10g AS to use the new jdbc driver.
I went to Java Options for the oc4j instance and added the following as suggested by Oracle forums :
Then after restarting the oc4j instance, it started working as expected. I am still left wondering though why it did not use the ojdbc14.jar that is in my web-inf/lib directory of the project. Any suggestions/comments are welcome