File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting different results in JSP