freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
FreeTDS-JDBC driver: Intermittent and random SQLException
- From: "Suddaby, Rod" <RSuddaby AT NRCan.gc.ca>
- To: "'freetds AT franklin.oit.unc.edu'" <freetds AT franklin.oit.unc.edu>
- Subject: FreeTDS-JDBC driver: Intermittent and random SQLException
- Date: Tue, 7 Dec 1999 12:47:22 -0500
Hi all,
When INSERTing rows into a MS SQLServer 7.0 DB I get a SQLException error
with
the following stack trace:
java.sql.SQLException: Statement was not known by the connection
at java.lang.Throwable.fillInStackTrace (Native Method)
at java.lang.Throwable.fillInStackTrace (Compiled Code)
at java.lang.Throwable.<init> (Compiled Code)
at java.lang.Exception.<init> (Compiled Code)
at java.sql.SQLException.<init> (Compiled Code)
at com.internetcds.jdbc.tds.Statement.close (Compiled Code)
at com.internetcds.jdbc.tds.Statement.finalize
(Statement.java:96)
at java.lang.ref.Finalizer.runFinalizer (Compiled Code)
at java.lang.ref.Finalizer.access$1 (Compiled Code)
at java.lang.ref.Finalizer$FinalizerThread.run (Compiled Code)
This exception is thrown during a batch update to the DB using the
Statement.executeUpdate() method.
(I'm just reading in a text file of space delimited values and inserting
into SQLServer)
The odd thing is:
a) the record being inserted at the time the exception is thrown is
inserted successfully into the DB table.
b) the exception is not thrown every time the process executes, and
c) if run on the same input data file, it is not thrown at the same
location
Does anyone have any pointers?
Thanks for any advice.
Rod.
Rod M. Suddaby
rsuddaby AT NRCan.gc.ca
Information Systems Specialist Phone: (780)
435-7246
Canadian Forest Service
Northern Forestry Centre
Edmonton, Alberta
- FreeTDS-JDBC driver: Intermittent and random SQLException, Suddaby, Rod, 12/07/1999
Archive powered by MHonArc 2.6.24.