This week's book giveaway is in the Java 8 forum.
We're giving away four copies of Java 8 in Action and have Raoul-Gabriel Urma, Mario Fusco, and Alan Mycroft on-line!
See this thread for details.
The moose likes JDBC and the fly likes Invalid Cursor sate Error...  :argh: Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Invalid Cursor sate Error...  :argh: " Watch "Invalid Cursor sate Error...  :argh: " New topic
Author

Invalid Cursor sate Error... :argh:

H Melua
Ranch Hand

Joined: Jan 04, 2005
Posts: 172
Hi

Now that i solved one of the problems i had, i got into another one

Can some one please debug this code for me , i dont have a clue why its doing that! All my coding is the same, the only difference in this code is the UNION...



Dont worry about "why would you want drivers and cars combined!"

MS Access Database i'm using

Thanks
HannaH
[ April 03, 2006: Message edited by: H Melua ]
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
While it's not your problem with cursor state, you should learn the difference between UNION and UNION ALL.

UNION ALL is what you want here, not UNION, not least because it's more efficient.
H Melua
Ranch Hand

Joined: Jan 04, 2005
Posts: 172
Thank you stu

As far as i know, the difference is that Union removes duplicate values! and thats what i want!

HannaH
stu derby
Ranch Hand

Joined: Dec 15, 2005
Posts: 333
Originally posted by H Melua:
Thank you stu

As far as i know, the difference is that Union removes duplicate values! and thats what i want!

HannaH


OK.. If you can actually have a car and a driver that are the same, then you've got a very weird data model, but whatever...
H Melua
Ranch Hand

Joined: Jan 04, 2005
Posts: 172
You see Stu, i knew i will be asked similar questions to this, thats why i stated in my first post...

Originally posted by H Melua:
Dont worry about "why would you want drivers and cars combined!"


Thanks
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Invalid Cursor sate Error... :argh:
 
Similar Threads
Help with this error PLEASE!!!!!
how to retrive values of aggregate sql functions from resultset
SQL Server 2000 and JDBC,Registering cursor as OUT param
Another SQL Question: Union/Union All
Union