wood burning stoves 2.0*
The moose likes JDBC and the fly likes Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc" Watch "Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc" New topic
Author

Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc

Vasudevan Gopalan
Ranch Hand

Joined: Aug 29, 2003
Posts: 67
Hi all,
I am using oracle 8i as database.I tried to execute the following query in JSP.
select phase_id,0 work_package_id,0 activity_id,0 sub_activity_id,0 template_id,seq_no,phase_name name,1 level_id,null mandatory from phase_master
union
select phase_id,work_package_id,0,0,0,seq_no,work_package_name,2,mandatory from work_package_master
union
select wm.phase_id,am.work_package_id,am.activity_id,0,0,am.seq_no,am.activity_name,3 ,am.mandatory from activity_master am,work_package_master wm where am.work_package_id= wm.work_package_id union select wm.phase_id,wm.work_package_id,am.activity_id,sm.sub_activity_id,0,sm.seq_no,sm.sub_activity_name,4,sm.mandatory from sub_activity_master sm,activity_master am,work_package_master wm where sm.activity_id=am.activity_id and am.work_package_id=wm.work_package_id
order by 1,2,3,4,5,6
I am getting the following error:
[ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinct clause, union, intersect or minus or on read only result set
The same above query is working in Oracle sql editor but not in JSP.I am not sure that error is because of driver i am using.I am using Microsoft ODBC for oracle.Could u suggest any solution to my problem.

Regards
Vasu
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error - [ODBC driver for Oracle]Cannot use Keyset-driven cursor on join, with distinc