Skip to Content.
Sympa Menu

freetds - sprocs from jdbc?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Brett Knights <knights AT tanner.com>
  • To: "'TDS Development Group'" <freetds AT franklin.oit.unc.edu>
  • Subject: sprocs from jdbc?
  • Date: Wed, 23 Feb 2000 09:35:26 -0800


Hi,
I have just downloaded the freetds jdbc driver and it can't find my
stored procedures.

it returns with a message that the stored procedure cannot be found.

would someone give me an example of the syntax to use for a
prepareStatement call with freeTds?

I have tried :

PreparedStatement pstmt = con.prepareStatement("{sproc ?, ?}");
and
PreparedStatement pstmt = con.prepareStatement("sproc ?, ?");
and
PreparedStatement pstmt = con.prepareStatement("exec sproc ?, ?");

TIA

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Brett Knights Tanner Research, Inc.
MIS Analyst 2650 E. Foothill Blvd.
brett.knights AT tanner.com Pasadena, CA 91107

voice 626-432-5767 fax 626-792-0300
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

> -----Original Message-----
> From: bounce-freetds-101769 AT franklin.oit.unc.edu
> [mailto:bounce-freetds-101769 AT franklin.oit.unc.edu]On Behalf
> Of Michael
> Peppler
> Sent: Tuesday, February 22, 2000 5:25 PM
> To: TDS Development Group
> Subject: [freetds] Re: SybPerl
>
>
> Brian Bruns writes:
> >
> >
> > On Tue, 22 Feb 2000, Dave Blob wrote:
> >
> > > Does anyone use freetds with sybperl? A lot of the test
> seem to fail -
> > > often times significant ones - having 2 connection open,
> using message
> > > handlers, etc. I decided to try to use it anyhow, and
> the sql() function
> > > returns no data, but individual
> dbcmd/dbsqlexec/dbresults work fine. I
> > > haven't had a chance to debug too far yet.
> > >
> > Hmmm...most people use DBD::Sybase. I had it working ages
> ago, but really
> > haven't kept up with it.
>
> Note that if sybperl fails in the DBlib side it indicates some
> problems with the DBlibrary code in FreeTDS...
>
> Michael
> --
> Michael Peppler -||- Data Migrations Inc.
> mpeppler AT peppler.org -||- http://www.mbay.net/~mpeppler
> Int. Sybase User Group -||- http://www.isug.com
> Sybase on Linux mailing list: ase-linux-list AT isug.com
>
> ---
> You are currently subscribed to freetds as: knights AT tanner.com
> To unsubscribe, forward this message to
> $subst('Email.Unsub')
>
>



  • sprocs from jdbc?, Brett Knights, 02/23/2000

Archive powered by MHonArc 2.6.24.

Top of Page