Skip to Content.
Sympa Menu

freetds - JDBC Cursor help

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Stephanie Lewis <slewis AT thinweb.com>
  • To: TDS Development Group <freetds AT franklin.oit.unc.edu>
  • Subject: JDBC Cursor help
  • Date: Fri, 08 Sep 2000 14:46:23 -0300


Just looking for some advice,

The current JDBC FreeTds driver does not have any cursor
support. Just to see what is returned, I've tried test queries like:

rs = stmt.executeQuery("DECLARE cursor1 CURSOR FOR SELECT FirstName FROM
Employees OPEN cursor1 FETCH NEXT FROM cursor1");

expecting a result set containing the first row. When examining the
return packet, all I get is a TDS_END_TOKEN and nothing more. I've also
played with:

rs = stmt.executeQuery("declare @P1 int set @P1=NULL sp_cursoropen @P1
output, 'select FirstName from Employees', 8, 1, 1 Select @P1");

to see if I could get a handle on the cursor returned but again to no
avail. I realize I should not be using sp_cursoropen directly from my
app but have seen it used in other drivers.

Any direction in cursor manipulation would be great,

Cheers,
Stephanie


Using: SQL Server 7.0 on NT Server
Tds 7.0 on NT Workstation
FreeTds Aug.12/00 snapshot






Archive powered by MHonArc 2.6.24.

Top of Page