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 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 Soft Skills this week in the Jobs Discussion 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: