This week's book giveaway is in the Mac OS forum.
We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line!
See this thread for details.
The moose likes JDBC and the fly likes Getting different results in JSP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC
Bookmark "Getting different results in JSP" Watch "Getting different results in JSP" New topic
Author

Getting different results in JSP

Vasudevan Gopalan
Ranch Hand

Joined: Aug 29, 2003
Posts: 67
Hi all,
I am using Oracle 8.1.6 with Oracle ODBC driver 8.1.6.I have union query which works fine when i execute in SQL Plus editor.The same query if i execute in JSP gives me different result.I am getting duplicate values if i execute in JSP whereas in sql plus it is not giving me duplicate values.
Help me please...

Regards
Vasu
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

The only thing I can think of is that they may be happening inside different transaction contexts (try doing a commit in the SQLPLUS window before running the query), but you'd have to tell us more about what is happening or show us some SQL...
Dave
Vasudevan Gopalan
Ranch Hand

Joined: Aug 29, 2003
Posts: 67
Hi,
It was working fine know.I dont know why it didnt worked that time.I didnt change the code also.
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

You get that, sometimes.
If you do manage to track down the behaviour, feel free to drop it here to help others out.
Dave
 
GeeCON Prague 2014
 
subject: Getting different results in JSP