Skip to Content.
Sympa Menu

freetds - freetds JDBC + Stack Overflow Error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Steve Sherwood" <stephens AT cabletron.com>
  • To: "freetds AT franklin.oit.unc.edu" <freetds AT franklin.oit.unc.edu>
  • Subject: freetds JDBC + Stack Overflow Error
  • Date: Thu, 28 Oct 1999 16:37:19 +0100


Using the lastest version of the freetds JDBC drivers.

Bit complex this. Using MSSQL7, I have a stored procedure like
the following :-

BEGIN TRANSACTION
DECLARE @LOWER int, @UPPER int, @COUNT
SET @LOWER=0
SET @UPPER=0

SET @COUNT=0
WHILE (@COUNT < 255)
BEGIN
INSERT INTO subnet VALUES (@COUNT, <data>)
SET @COUNT = @COUNT+1
END
COMMIT TRANSACTION

Then in my Java code I call this
Statement s = connection.createStatement();
s.execute("EXEC StoredProc");
s.close();

I get the exception :-

[28/10/1999 16:24:34:609 GMT+01:00] java.lang.StackOverflowError
at com.internetcds.jdbc.tds.TdsComm.skip(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processDoneInProc(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processSubPacket(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processSubPacket(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processDoneInProc(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processSubPacket(Compiled Code)
at com.internetcds.jdbc.tds.Tds.processSubPacket(Compiled Code)
...etc (lots of lines removed - Possibly 255 sets)

I can decrease the count to about 124 and then the exception
goes away. I'm assuming it's something to do with multiple
rowsets, but I can't find a way around it.

Anyone help ?

Rgds
Steve



---
Steve Sherwood - stephens AT ctron.com - (01635) 810517
O---------------------------------+-----------------------O
| Just like Pariah I have no name | Never feed your cat |
| Living in a blaze of obscurity | anything that clashes |
| Need courage to survive the day | with the carpet... |
O---------------------------------+-----------------------O
(A)bort (R)etry (I)nfluence with large hammer






Archive powered by MHonArc 2.6.24.

Top of Page