Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)
Anton van Straaten
anton at appsolutions.com
Mon Sep 10 06:39:20 EDT 2001
Thanks very much for the prompt assistance.
I tried your unit test against jtds-0.1.1.jar, and it failed with the same
error. I then did a full checkout from CVS, built it, modified
conf\connection.properties (my connection string is
"url=jdbc:freetds:sqlserver://localhost/epas"), tested that everything was
working, and then ran "doTest freetds.AsTest". This gave the same error.
Here's the tail end of the output:
Total time: 1 second
There was 1 error:
java.sql.SQLException: Protocol confusionFound a
com.internetcds.jdbc.tds.PacketResult (packet type 0x7c)
Tests run: 1, Failures: 0, Errors: 1
I also verified that if I remove "insert #tmp" from the string on line 58 of
AsTest.java, the test succeeds.
Is this working for you with MS SQL 6.5? Any other ideas?
> -----Original Message-----
> From: bounce-freetds-132811 at franklin.oit.unc.edu
> [mailto:bounce-freetds-132811 at franklin.oit.unc.edu]On Behalf Of Schörk,
> Sent: Monday, September 10, 2001 4:16 AM
> To: TDS Development Group
> Subject: [freetds] Re: Why can't this stored procedure be called? (Fre
> eTDS_JDBC and jtds)
> I created in the newest sourceforge-version a JUNIT-Test- Called AsTest.
> you can call it by:
> doTest freetds.AsTest
> I fear you have to access the CVS-Repository to do this.
> There are problems at the moment with the mixing of
> Resultset-producing and
> not producing Batches. But they normally return at least the Resultsets.
> Could you look at the code in AsTest.java and suggest the changes
> that lead
> your problem ?
More information about the FreeTDS