Hi

Up to now with SQL Anywhere 12, I used jconn3.jar as JDBC Driver to connect to our Application Server (Servoy/TomCat), IDE and Modeling tool. But with SQL Anywhere 16 this driver is not in the SQLAnywhere16/System/java folder any more.

The current JDBC URL and Driver Class are specified as following: JDBC URL: jdbc:sybase:Tds:10.0.1.4:2638?ServiceName=<database>&CHARSET=utf8 Driver Class: com.sybase.jdbc3.jdbc.SybDriver

Which driver is best to use for SQL Anywhere 16 and how would it affect the JDBC URL and Driver Class description?

OS: Yosemite 10.10.5, and Windows 7, Windows Server 2008/2012, Java 1.8.0_60

Thanks a lot in advance for any hint. Robert

asked 25 Sep '15, 10:31

robert's gravatar image

robert
853475468
accept rate: 0%


Apparently, v16 uses v4 of the jConnect driver - I guess the following doc topic (and the comments there!) should be helpful:

The jConnect JDBC driver

Besides, you may also be able to use the "native" SQL Anyhwere JDBC4 driver which usually fits better.

permanent link

answered 25 Sep '15, 10:42

Volker%20Barth's gravatar image

Volker Barth
40.1k361549819
accept rate: 34%

Unfortunatly, the links in the doc show me only go.sap.xxx. So I am still a bit lost where to get the jconn4.jar file for SQL Anywhere 16 database.

(27 Sep '15, 09:24) robert
Replies hidden

Sigh, it's soo difficult to find anything in the SAP support portal...

I hope the following link may be of help (though I'm not sure whether it is the fitting jConnect version), and it seems not to include OS X:

2093510 - How to Download Free SDK for SAP ASE [Windows, Linux, Unix]

I can't tell why they let you find a "How to download" instead of the download itself...:(

(28 Sep '15, 03:07) Volker Barth

I was able to download the ASE Trial and found there the jconn4.jar driver (I described it in my other post regarding JDBC drivers). Connecting with jconn4.jar works, but still not with the native driver sajdbc4.jar. Please see my other JDBC post.

Regards, Robert

PS: And yes, I agree it is (for me) very difficult to find something on the SAP Marketplace.

(28 Sep '15, 03:45) robert
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×86
×16

question asked: 25 Sep '15, 10:31

question was seen: 4,566 times

last updated: 28 Sep '15, 03:45