Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

client side cursor

843859Aug 1 2006 — edited Aug 2 2006
how do i specify a client side cursor on a Statement object?

I am using jasper to generate reports and when i try generating a csv report I get the following stacktrace:

com.jnetdirect.jsql.u: A server cursor is not allowed on a remote stored procedu
re or stored procedure with more than one SELECT statement. Use a default result
set or client cursor.
at com.jnetdirect.jsql.ar.a(Unknown Source)
at com.jnetdirect.jsql.ae.h(Unknown Source)
at com.jnetdirect.jsql.ae.int(Unknown Source)
at com.jnetdirect.jsql.ae.for(Unknown Source)
at com.jnetdirect.jsql.l.execute(Unknown Source)
at com.jnetdirect.jsql.ae.case(Unknown Source)
at com.jnetdirect.jsql.ae.executeQuery(Unknown Source)
at com.tci.groovecar.servlets.StatsReportGeneratorServlet.exportCsv(Stat
sReportGeneratorServlet.java:846)
at com.tci.groovecar.servlets.StatsReportGeneratorServlet.access$200(Sta
tsReportGeneratorServlet.java:67)
at com.tci.groovecar.servlets.StatsReportGeneratorServlet$ReportRequestJ
ob.executeJob(StatsReportGeneratorServlet.java:1218)
at com.tci.groovecar.servlets.StatsReportGeneratorServlet$ReportRequestJ
ob.run(StatsReportGeneratorServlet.java:1180)
at EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(Unknown So
urce)
at java.lang.Thread.run(Thread.java:484)
*******************************

please help

Comments

843859
I found the solution myself...
I set the type_forward_only and Concur_read_only cursor for the createstatement and it worked.
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 30 2006
Added on Aug 1 2006
#java-database-connectivity-jdbc
1 comment
142 views