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.

Why there is no pure jdbc driver provided for sql anywhere?

3 posts in General Discussion (old) Last posting was on 2009-05-26 12:22:44.0Z
Xiaofeng Wei Posted on 2009-05-26 03:06:06.0Z
From: "Xiaofeng Wei" <Xiaofeng.WeiNOSPAM@n0spam.sybase.com>
Newsgroups: sybase.public.sqlanywhere
Subject: Why there is no pure jdbc driver provided for sql anywhere?
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a1b5c9e@forums-1-dub>
Date: 25 May 2009 20:06:06 -0700
X-Trace: forums-1-dub 1243307166 10.22.241.152 (25 May 2009 20:06:06 -0700)
X-Original-Trace: 25 May 2009 20:06:06 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:288
Article PK: 866724

It is dissatisfying that SQL anywhere can not provide a pure JDBC driver for
client connection! It is commonly inderstood pure jdbc driver is faster
than jdbc bridge + odbc, because there is no conversions between jdbc and
odbc protocols.

We wrote a Java stored procedure and installed in SQL anywhere 11. When we
tried to connect to SQL anywhere 11 and invoke the stored procedure by using
Sybase jconnect3 JDBC driver, the SQL anywhere 11 server always crash.

I have looked into the SQL Anywhere 11 documentation and it states that:
"The jConnect driver is a pure Java solution. The iAnywhere JDBC driver
requires the SQL Anywhere ODBC driver and is not a pure Java solution." "The
iAnywhere JDBC driver is the recommended JDBC driver for connecting to SQL
Anywhere databases." "The iAnywhere JDBC driver provides better performance
for most purposes than the jConnect driver." The driver class is located in
jodbc.jar.

Can anybody help on this? Thank you!

Xiaofeng Wei


Markus KARG Posted on 2009-05-26 08:59:11.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <4a1b5c9e@forums-1-dub>
Subject: Re: Why there is no pure jdbc driver provided for sql anywhere?
Lines: 41
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a1baf5f@forums-1-dub>
Date: 26 May 2009 01:59:11 -0700
X-Trace: forums-1-dub 1243328351 10.22.241.152 (26 May 2009 01:59:11 -0700)
X-Original-Trace: 26 May 2009 01:59:11 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:289
Article PK: 866725

There IS a pure JDBC driver for SQL Anyhwere, called jConnect. It is
mentioned in the manual. Maybe you missed this section? It is up to you to
decide for either iAnywhere driver of jConnect driver.

But I must tell you that I have done several performance tests and the
iAnywhere driver was faster than the jConnect driver. So you assumption is
wrong that a pure Java driver is always faster. The iAnywhere driver is so
well done that it outperforms the pure Java driver.

Regards
Markus

"Xiaofeng Wei" <Xiaofeng.WeiNOSPAM@n0spam.sybase.com> schrieb im Newsbeitrag
news:4a1b5c9e@forums-1-dub...

> It is dissatisfying that SQL anywhere can not provide a pure JDBC driver
> for client connection! It is commonly inderstood pure jdbc driver is
> faster than jdbc bridge + odbc, because there is no conversions between
> jdbc and odbc protocols.
>
> We wrote a Java stored procedure and installed in SQL anywhere 11. When
> we tried to connect to SQL anywhere 11 and invoke the stored procedure by
> using Sybase jconnect3 JDBC driver, the SQL anywhere 11 server always
> crash.
>
> I have looked into the SQL Anywhere 11 documentation and it states that:
> "The jConnect driver is a pure Java solution. The iAnywhere JDBC driver
> requires the SQL Anywhere ODBC driver and is not a pure Java solution."
> "The iAnywhere JDBC driver is the recommended JDBC driver for connecting
> to SQL Anywhere databases." "The iAnywhere JDBC driver provides better
> performance for most purposes than the jConnect driver." The driver class
> is located in jodbc.jar.
>
> Can anybody help on this? Thank you!
>
> Xiaofeng Wei
>
>
>
>


Jeff Albion [Sybase iAnywhere] Posted on 2009-05-26 12:22:44.0Z
From: "Jeff Albion [Sybase iAnywhere]" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
Newsgroups: sybase.public.sqlanywhere
Subject: Re: Why there is no pure jdbc driver provided for sql anywhere?
References: <4a1b5c9e@forums-1-dub>
In-Reply-To: <4a1b5c9e@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a1bdf14$1@forums-1-dub>
Date: 26 May 2009 05:22:44 -0700
X-Trace: forums-1-dub 1243340564 10.22.241.152 (26 May 2009 05:22:44 -0700)
X-Original-Trace: 26 May 2009 05:22:44 -0700, vip152.sybase.com
Lines: 47
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:290
Article PK: 866726


Xiaofeng Wei wrote:
> It is dissatisfying that SQL anywhere can not provide a pure JDBC driver for
> client connection! It is commonly inderstood pure jdbc driver is faster
> than jdbc bridge + odbc, because there is no conversions between jdbc and
> odbc protocols.

As Markus mentioned, the "Type 4" (Pure) Java JDBC driver provided with
SQL Anywhere is jConnect. (Also found here:
http://downloads.sybase.com/swd/summary.do?baseprod=63&client=ianywhere&timeframe=0
). jConnect is slower than the iAnywhere "Type 2" (Mixed Native/Java)
JDBC driver in many tests due to the underlying protocol (TDS versus
ODBC/CmdSeq). Also, execution time in Java (on the JVM) for the Java
components is generally slower in tests than executing native compiled
C++ code via JNI, which is what the iA JDBC driver does.

> We wrote a Java stored procedure and installed in SQL anywhere 11. When we
> tried to connect to SQL anywhere 11 and invoke the stored procedure by using
> Sybase jconnect3 JDBC driver, the SQL anywhere 11 server always crash.

Please provide the details regarding this situation. If you can provide
the procedure and/or database for us to look at, we can determine why
the server is crashing and if it's a fixed bug or not. You can then file
a bug via CaseXpress (http://casexpress.sybase.com/) with the details.
Which version of 11 are you running?

> I have looked into the SQL Anywhere 11 documentation and it states that:
> "The jConnect driver is a pure Java solution. The iAnywhere JDBC driver
> requires the SQL Anywhere ODBC driver and is not a pure Java solution." "The
> iAnywhere JDBC driver is the recommended JDBC driver for connecting to SQL
> Anywhere databases." "The iAnywhere JDBC driver provides better performance
> for most purposes than the jConnect driver." The driver class is located in
> jodbc.jar.

All of that is true. Were there any issues with what the documentation
stated?

Regards,

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/