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

Query working in sql worksheet but in the program

 
Sawan Mishra
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi everyone,
yesterday I got a very strange error.
my worked fine in sql worksheet but query didn't work in eclipse.
resultset had no element.
In sql worksheet with same query i got 2 elements.

I've cleaned the project and pressed build all.thereafter I restarted eclipse but I got
same very peculiar output.I dunno how to resolve this problem.


pleas help me out.

thanks in advance.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34839
369
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The first things to check are:
1) Are you pointing to the same database?
2) Are you using the same user id to connect?
3) Is the data committed?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic