Skip to Content.
Sympa Menu

freetds - Re: Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Anton van Straaten" <anton AT appsolutions.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: Why can't this stored procedure be called? (Fre eTDS_JDBC and jtds)
  • Date: Mon, 10 Sep 2001 06:39:20 -0400


Andreas,

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:

BUILD SUCCESSFUL

Total time: 1 second
.E
Time: 0.89
There was 1 error:
1) testProc1(freetds.AsTest)
java.sql.SQLException: Protocol confusionFound a
com.internetcds.jdbc.tds.PacketResult (packet type 0x7c)
at
com.internetcds.jdbc.tds.PreparedStatement_base.executeCall(PreparedStatemen
t_base.java:273)
at
com.internetcds.jdbc.tds.PreparedStatement_base.execute(PreparedStatement_ba
se.java:184)
at
com.internetcds.jdbc.tds.PreparedStatement_base.executeQuery(PreparedStateme
nt_base.java:349)
at freetds.AsTest.testProc1(AsTest.java:61)
at freetds.AsTest.main(AsTest.java:43)

FAILURES!!!
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?

Thanks,
Anton


> -----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,
> Andreas
> 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
> to
> your problem ?
> Andreas
>





Archive powered by MHonArc 2.6.24.

Top of Page