Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

jConnect and CTLib....

8 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-07-08 13:48:39.0Z
Linda McCarthy Posted on 1997-04-30 21:51:27.0Z
Message-ID: <3367BEDF.291C@exabyte.com>
Date: Wed, 30 Apr 1997 14:51:27 -0700
From: Linda McCarthy <mccarthy@exabyte.com>
Organization: Exabyte Corporation
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: jConnect and CTLib....
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:892
Article PK: 252644

Has anyone used jConnect and CTLib to connect to an SQL Server?

I looked at the jConnect white paper in www.sybase.com but it doesn't
go into any detail about this sort of implementation.

*Any* information anyone has about this would be appreciated.

Thanks in advance!
Linda


David Clegg Posted on 1997-05-05 17:22:31.0Z
Message-ID: <336E1757.511DE9BC@sybase.com>
Date: Mon, 05 May 1997 10:22:31 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Linda McCarthy <mccarthy@exabyte.com>
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:879
Article PK: 252631

CTlib and jConnect are totally separate products, they do not share
connections or transactions or anything else.

jConnect is 100% Java - it reads/writes Sybase's TDS communication
protocol directly to the network w/out any native calls to ODBC, DBlib
or CTlib. This makes it possible for jConnect-based JDBC applets to
be downloaded as needed over the network - 0-client install.

Other JDBC vendors have built implementations that sit atop the
C-libraries. If you REALLY want a JDBC that calls down to CTlib,
you might try WebLogic. I do not know whether their driver will
allow you to add your own CTlib code or whether they provide any
extensions that allow you access to additional CTlib functionality
from your Java code.

dave

> Has anyone used jConnect and CTLib to connect to an SQL Server?
>
> I looked at the jConnect white paper in www.sybase.com but it doesn't
> go into any detail about this sort of implementation.
>
> *Any* information anyone has about this would be appreciated.
>
> Thanks in advance!
> Linda


Michel van der List Posted on 1997-05-08 11:33:32.0Z
Message-ID: <3371BA0C.41C6@sbphrd.com>
Date: Thu, 08 May 1997 07:33:32 -0400
From: Michel van der List <vanderlistmj@sbphrd.com>
Organization: SmithKline Beecham Pharmaceuticals R & D, Bioinformatics
X-Mailer: Mozilla 3.0Gold (X11; I; OSF1 V4.0 alpha)
MIME-Version: 1.0
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com> <336E1757.511DE9BC@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 34
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:860
Article PK: 252611


David Clegg wrote:

> CTlib and jConnect are totally separate products, they do not share
> connections or transactions or anything else.
>
> jConnect is 100% Java - it reads/writes Sybase's TDS communication
> protocol directly to the network w/out any native calls to ODBC, DBlib
> or CTlib. This makes it possible for jConnect-based JDBC applets to
> be downloaded as needed over the network - 0-client install.
>
> Other JDBC vendors have built implementations that sit atop the
> C-libraries. If you REALLY want a JDBC that calls down to CTlib,
> you might try WebLogic. I do not know whether their driver will
> allow you to add your own CTlib code or whether they provide any
> extensions that allow you access to additional CTlib functionality
> from your Java code.

Does this mean that I will be able to use the jConnect stuff to access
any open server (now, in the future)?

We have some code here which is using the open server product. It would
be real nice to be able to access that using jConnect.

Michel

-------------------------------------------------------------------
Michel van der List SmithKline Beecham Pharmaceuticals R & D
vanderlistmj@sbphrd.com UW2230, 709 Swedeland Road, P.O. Box 1539
(610) 270-4525 King of Prussia, PA 19406-0939


Lance Andersen Posted on 1997-05-08 13:56:20.0Z
Message-ID: <3371DB84.1807@sybase.com>
Date: Thu, 08 May 1997 09:56:20 -0400
From: Lance Andersen <lancea@sybase.com>
X-Mailer: Mozilla 3.01Gold (X11; I; SunOS 5.5.1 sun4m)
MIME-Version: 1.0
To: Michel van der List <vanderlistmj@sbphrd.com>
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com> <336E1757.511DE9BC@sybase.com> <3371BA0C.41C6@sbphrd.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 50
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:856
Article PK: 252607

Yes you can access an openserver via jConnect.

In fact that is how we currently access SQL Anywhere.


Regards,

-Lance

Michel van der List wrote:
>
> David Clegg wrote:
>
> > CTlib and jConnect are totally separate products, they do not share
> > connections or transactions or anything else.
> >
> > jConnect is 100% Java - it reads/writes Sybase's TDS communication
> > protocol directly to the network w/out any native calls to ODBC, DBlib
> > or CTlib. This makes it possible for jConnect-based JDBC applets to
> > be downloaded as needed over the network - 0-client install.
> >
> > Other JDBC vendors have built implementations that sit atop the
> > C-libraries. If you REALLY want a JDBC that calls down to CTlib,
> > you might try WebLogic. I do not know whether their driver will
> > allow you to add your own CTlib code or whether they provide any
> > extensions that allow you access to additional CTlib functionality
> > from your Java code.
>
> Does this mean that I will be able to use the jConnect stuff to access
> any open server (now, in the future)?
>
> We have some code here which is using the open server product. It would
> be real nice to be able to access that using jConnect.
>
> Michel
>
> -------------------------------------------------------------------
> Michel van der List SmithKline Beecham Pharmaceuticals R & D
> vanderlistmj@sbphrd.com UW2230, 709 Swedeland Road, P.O. Box 1539
> (610) 270-4525 King of Prussia, PA 19406-0939

--
===============================================================================
Lance J. Andersen Email: lancea@sybase.com
Sybase Technical Support Phone:(617) 564-6336
77 South Bedford Street Fax: (617) 564-6148
Burlington, MA 01803

The Dark Knight Returns!!! Let's Go Penguins!!!
===============================================================================


Michel van der List Posted on 1997-05-08 14:09:59.0Z
Message-ID: <3371DEB7.41C6@sbphrd.com>
Date: Thu, 08 May 1997 10:09:59 -0400
From: Michel van der List <vanderlistmj@sbphrd.com>
Organization: SmithKline Beecham Pharmaceuticals R & D, Bioinformatics
X-Mailer: Mozilla 3.0Gold (X11; I; OSF1 V4.0 alpha)
MIME-Version: 1.0
To: Lance Andersen <lancea@sybase.com>
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com> <336E1757.511DE9BC@sybase.com> <3371BA0C.41C6@sbphrd.com> <3371DB84.1807@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 18
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:853
Article PK: 252608


Lance Andersen wrote:
>
> Yes you can access an openserver via jConnect.
>
> In fact that is how we currently access SQL Anywhere.

Thanks. I talked to my openserver guy, who now asked me (we're just
figuring out if what we want to do is possible, so please bear with
me...) 'so how do you do an rpc call this way'? We've so far only
used CT_LIB calls (from C), but I can't use those...

Michel.

-------------------------------------------------------------------
Michel van der List SmithKline Beecham Pharmaceuticals R & D
vanderlistmj@sbphrd.com UW2230, 709 Swedeland Road, P.O. Box 1539
(610) 270-4525 King of Prussia, PA 19406-0939


David Clegg Posted on 1997-05-21 16:29:30.0Z
Message-ID: <338322EA.5D4E5560@sybase.com>
Date: Wed, 21 May 1997 09:29:30 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Michel van der List <vanderlistmj@sbphrd.com>
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com> <336E1757.511DE9BC@sybase.com> <3371BA0C.41C6@sbphrd.com> <3371DB84.1807@sybase.com> <3371DEB7.41C6@sbphrd.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:800
Article PK: 252553


Michel van der List wrote:
>
> Lance Andersen wrote:
> >
> > Yes you can access an openserver via jConnect.
> >
> > In fact that is how we currently access SQL Anywhere.
>
> Thanks. I talked to my openserver guy, who now asked me (we're just
> figuring out if what we want to do is possible, so please bear with
> me...) 'so how do you do an rpc call this way'? We've so far only
> used CT_LIB calls (from C), but I can't use those...

You can execute RPCs in your OpenServer by using a CallableStatement.

CallableStatement cs = conn.prepareCall("{?=call yourRPC(?,?)}");
cs.registerOutParameter(1, Types.INTEGER);
cs.setInt(2, 47);
cs.setString(3, "Yadda");
cs.registerOutParameter(3, Types.VARCHAR);
cs.executeUpdate();
int returnStatus = cs.getInt(1);
String outputStringParam = cs.getString(3);

The above code segment would execute the "yourRPC" rpc, passing in
2 input parameters (an integer and a string), and receiving back
the return status and the output string value.

dave


Warren Master Posted on 1997-07-08 13:48:39.0Z
Message-ID: <33C24537.36CE@nac.net>
Date: Tue, 08 Jul 1997 09:48:39 -0400
From: Warren Master <wsm@nac.net>
Reply-To: wsm@nac.net
Organization: MCS
X-Mailer: Mozilla 3.0 (Win95; I)
MIME-Version: 1.0
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com> <336E1757.511DE9BC@sybase.com> <3371BA0C.41C6@sbphrd.com> <3371DB84.1807@sybase.com> <3371DEB7.41C6@sbphrd.com> <338322EA.5D4E5560@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:582
Article PK: 252334


David Clegg wrote:
>
> Michel van der List wrote:
> >
> > Lance Andersen wrote:
> > >
> > > Yes you can access an openserver via jConnect.
> > >
> > > In fact that is how we currently access SQL Anywhere.
> >
> > Thanks. I talked to my openserver guy, who now asked me (we're just
> > figuring out if what we want to do is possible, so please bear with
> > me...) 'so how do you do an rpc call this way'? We've so far only
> > used CT_LIB calls (from C), but I can't use those...
>
> You can execute RPCs in your OpenServer by using a CallableStatement.
>
> CallableStatement cs = conn.prepareCall("{?=call yourRPC(?,?)}");
> cs.registerOutParameter(1, Types.INTEGER);
> cs.setInt(2, 47);
> cs.setString(3, "Yadda");
> cs.registerOutParameter(3, Types.VARCHAR);
> cs.executeUpdate();
> int returnStatus = cs.getInt(1);
> String outputStringParam = cs.getString(3);
>
> The above code segment would execute the "yourRPC" rpc, passing in
> 2 input parameters (an integer and a string), and receiving back
> the return status and the output string value.
>
> dave

What about recieving callbacks from the execution of registered stored
procs in openserver. I remember I asked this a while ago and someone
said something was coming from sybase that could do this, any word on
this product?

warren master
Chase Manhttan Bank


David Clegg Posted on 1997-05-05 17:20:55.0Z
Message-ID: <336E16F7.636C23B1@sybase.com>
Date: Mon, 05 May 1997 10:20:55 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Linda McCarthy <mccarthy@exabyte.com>
Subject: Re: jConnect and CTLib....
References: <3367BEDF.291C@exabyte.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:880
Article PK: 252632

CTlib and jConnect are totally separate products, they do not share
connections or transactions or anything else.

jConnect is 100% Java - it reads/writes Sybase's TDS communication
protocol directly to the network w/out any native calls to ODBC, DBlib
or CTlib. This makes it possible for jConnect-based JDBC applets to
be downloaded as needed over the network - 0-client install.

Other JDBC vendors have built implementations that sit atop the
C-libraries. If you REALLY want a JDBC that calls down to CTlib,
you might try WebLogic. I do not know whether their driver will
allow you to add your own CTlib code or whether they provide any
extensions that allow you access to additional CTlib functionality
from your Java code.

dave

> Has anyone used jConnect and CTLib to connect to an SQL Server?
>
> I looked at the jConnect white paper in www.sybase.com but it doesn't
> go into any detail about this sort of implementation.
>
> *Any* information anyone has about this would be appreciated.
>
> Thanks in advance!
> Linda