This content has been marked as final. Show 5 replies
Obviously it is 99.999% certain that the problem is with the JDBC version of your code rather than the driver itself.
But, JDBC Code is very simple. It calls this SQL and maps the result in to objects
I have generate logs from java.sql.ResultSet and it shows that JDBC Driver is fetching smaller number of rows.
rozdev29 wrote:Seeing the downloads page:
When I fire a SQL query using Toad, I get correct results but firing the same query using JDBC Driver - ojdbc14.jar (ORacle 11g R1)
There IS no ojdbc14.jar for Oracle 11g. The minimum is Java 5. So correct me if I'm wrong, but you seem to be using a very old driver here. I would try a newer one if I were you.
rozdev29 wrote:An assumption is wrong. Some possible examples. There could be others.
- Not using the same database
- Uncommited data
- The SQL is not the same.
- The 'way' you verify the result in java is incorrect.
In the end, We figured out that it was due to a code defect.
Thanks for all the inputs