Home » Developer & Programmer » JDeveloper, Java & XML » Asynchronous query execution in JDBC??
Asynchronous query execution in JDBC?? [message #366585] Mon, 16 August 1999 11:22
kamal m
Messages: 1
Registered: August 1999
Junior Member
Does anyone know if Oracle's JDBC driver may provide this enhanced support for asynchronous JDBC calls.

Here is the scenario I am trying to solve. We are using a Java client to access the Oracle DB using JDBC. THere is a query which takes about 5 minutes to complete and return the whole resultset (about 250,000 rows). What I would like to explore, if possible, is if I can fire the query, and then start getting the data by doing rs.next() and say get only first 50 rows first but not have to wait for the whole query to be completed..

Is it possible?

Thanks very much. kamal.
Previous Topic: htp.p in Java ?
Next Topic: jdbc thin and jdbc odbc differences oracle 7.3
Goto Forum:

Current Time: Sun Jul 25 11:24:21 CDT 2021