Difference in the result returned by SQL DEVELOPER IDE and JDBC.

[timberlake1865]

I have a String query;
when i execute this query using SQL DEVELOPER IDE i am getting 34 rows.
But when execute the same query using Statement.executeQuery(query); i get 36 rows.
The extra 2 rows returned are duplicate. I am unable to find the reason for this difference in the result returned by IDE and JDBC.

The target DB is a oracle DB.

Thanks in Advance

[JosAH]

Maybe your SQL Developer IDE ate the last two rows? Who knows without seeing some relevant code ...

kind regards,

Jos

[Tolls]

Then either the queries aren't the same, the db isn't the same, or one or the other of your methods is counting incorrectly.
There may be other options as well, but you really haven't given us much to go on.

[timberlake1865]

i have checked and i am 100% sure that
1) db is same
2)user is same
3) query string is same.
4) java code counting is below

int count=0;
while(rs.next){
count++;
}

one more thing that caught my attention is i have made both odbc6.jar and odbc14.jar available to my project. i dont know which class is loaded from which jar when i call Class.forName("oracle.jdbc.driver.OracleDriver");

suspecting this issue could be due to odbc6.jar.

debugging it....

[Tolls]

Show us the queries then.
Both the JDBC code and the query you run in SQL Developer.
There is no way that you would be getting different results unless the data was different or the queries were different.

You'll really be wasting your time trying to debug the drivers.

[Tolls]

Oh yes, and it would be good manners to mention you have crossposted this at (at the least) OTN...both here and there.
Especially since both I and jschell are saying essentially the same things.

[timberlake1865]

i have checked and i am 100% sure that
1) db is same
2)user is same
3) query string is same.
4) java code counting is below

int count=0;
while(rs.next){
count++;
}

one more thing that caught my attention is i have made both odbc6.jar and odbc14.jar available to my project. i dont know which class is loaded from which jar when i call Class.forName("oracle.jdbc.driver.OracleDriver");

suspecting this issue could be due to odbc6.jar.

debugging it....

drivers are not the reason for this issue.


this post is cross posted at OTN Discussion Forums : difference in the result returned by ...

[timberlake1865]

i have checked and i am 100% sure that
1) db is same
2)user is same
3) query string is same.
4) java code counting is below

int count=0;
while(rs.next){
count++;
}

one more thing that caught my attention is i have made both odbc6.jar and odbc14.jar available to my project. i dont know which class is loaded from which jar when i call Class.forName("oracle.jdbc.driver.OracleDriver");

suspecting this issue could be due to odbc6.jar.

debugging it....

drivers are not the reason for this issue.


this post is cross posted at OTN Discussion Forums : difference in the result returned by ...

[Tolls]

I know the drivers are not the issue.
Until you post the query used on SQL Developer and the code used in Java all we can say is you are not doing the same thing, or looking at the same thing.

If you persist in not providing this information then I'm simply going to give up on this thread.