[This topic is migrated from our old forums. The original author name has been removed]
Hi. Any idea why is this blowing up after a while? Cannot reproduce it in isql session.
+set nocount on+
+declare @i int+
+declare @i2 int+
+declare @v float+
+select @i = 0, @i2 = 10000000+
+while @i <= @i2+
select @v = rand(10)
select @i = @i + 1
... Physical database connection acquired for: SYBAMR_ETMA_PRD_DS01
08:18:32 [SET - 0 row(s), 0.000 secs] [Error Code: 0, SQL State: JZ006] JZ006: Caught IOException: java.io.IOException: JZ0PA: The query has been cancelled and the response discarded. The cancel was probably issued by another statement on the connection.
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec [0 successful, 0 warnings, 1 errors]
I tried it in different environments. Same result.
Sybase ASE Sybase ASE (jTDS-7.0)
Version: DbVisualizer Pro 9.1 [Build #2050]
OS: Windows XP
OS Version: 5.1
OS Arch: x86
Java Version: 1.6.0_43
Java VM Name: Java HotSpot(TM) Client VM
Java VM Vendor: Sun Microsystems Inc.
Look and Feel: SyntheticaStandardLookAndFeel
Edited by: AlexML on Sep 18, 2013 8:24 AM
over 7 years ago
[This reply is migrated from our old forums.]
Re: Is this a driver issue?
It works for me with Sybase ASE 15.0 and the jTDS driver 1.2.7.