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.

dblib C programmer is confused, should I really switch to JDBC?

2 posts in JDBC Connect (product renamed to JConnect) Last posting was on 1997-04-17 22:11:46.0Z
Ulrich Becker Posted on 1997-04-17 11:53:26.0Z
From: "Ulrich Becker" <ub@ibp.de>
Subject: dblib C programmer is confused, should I really switch to JDBC?
Message-ID: <01bc4b2e$938b4cd0$0561a3c2@jeff>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.jdbcconnect
Date: Thu, 17 Apr 1997 07:53:26 -0400
Lines: 17
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:976
Article PK: 252730

Hi,
jConnect works fine, but it seems to go against the grain of what Sybase
has tought us before... .
Cursors are inefficient, they said, and now cursors everywhere! Or is this
the same word for something else?
I was so happy with the functional interface and this looks like EMBEDDED
SQL? Are long lists of questionmarks
object oriented? To my defence: I have never used ODBC.

Now, my question: Do JDBC 'cursors' map to Sybase server side cursors? This
would imply having to switch to a different transaction handling mindset
and this worries me, as I use client defined transaction heavily in my
leacy apps.

Thank You,

Ulrich Becker, ub@ibp.de


David Clegg Posted on 1997-04-17 22:11:46.0Z
Message-ID: <3356A022.51802CAD@sybase.com>
Date: Thu, 17 Apr 1997 15:11:46 -0700
From: David Clegg <davec@sybase.com>
X-Mailer: Mozilla 2.01 (X11; I; Linux 1.2.13 i586)
MIME-Version: 1.0
To: Ulrich Becker <ub@ibp.de>
Subject: Re: dblib C programmer is confused, should I really switch to JDBC?
References: <01bc4b2e$938b4cd0$0561a3c2@jeff>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.jdbcconnect
Lines: 33
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.jdbcconnect:968
Article PK: 252720

The jConnect product only uses cursors if you do:
statement.setCursorName("blah");
on your statement before you do the executeQuery().
And even in this case, we only use "language" cursors, not the
"TDS-based" cursors you get via the ct_cursor() calls or
the E/SQL DECLARE CURSOR statements.

We are looking at adding TDS-based cursor support in some future
release, but are working with Sun to update the JDBC standard
for interfacing with cursors. As the standard stands now, the
JDBC driver would have to do some really wacky things to make it
work.

dave

>
> Hi,
> jConnect works fine, but it seems to go against the grain of what Sybase
> has tought us before... .
> Cursors are inefficient, they said, and now cursors everywhere! Or is this
> the same word for something else?
> I was so happy with the functional interface and this looks like EMBEDDED
> SQL? Are long lists of questionmarks
> object oriented? To my defence: I have never used ODBC.
>
> Now, my question: Do JDBC 'cursors' map to Sybase server side cursors? This
> would imply having to switch to a different transaction handling mindset
> and this worries me, as I use client defined transaction heavily in my
> leacy apps.
>
> Thank You,
>
> Ulrich Becker, ub@ibp.de