Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Getting different results in JSP

 
Vasudevan Gopalan
Ranch Hand
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 67
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 13459
Android Eclipse IDE Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You get that, sometimes.
If you do manage to track down the behaviour, feel free to drop it here to help others out.
Dave
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic