Skip to Content

How to connect from "Oracle SQL Developer" to "SQL Anywhere 16" DB?

Dec 28, 2017 at 03:47 PM


avatar image

Test Connection from "Oracle SQL Developer" was successful but get the DB via button "Datenbank abrufen" failed with error:

"Status: Nicht erfolgreich -SQL Anywhere Error -110: Item 'jtds00001' already exists"

any idea?


10 |10000 characters needed characters left characters exceeded

The error -110 cause is "You attempted to create a file, table, view, column, constraint, foreign key, or publication with the same name as an existing one.". The object jtds00001 is not a SQL Anywhere object - a google search suggests it is related to jTDS. Are you using jTDS? Have you considered the SQL Anywhere JDBC driver or jConnect?


You are right, I'm using jTDS to connect to SQL Anywhere because it was the only I found for SQL Anywhere.


You did not post the version of SQL Anywhere you are using. I have provided documentation links that outline the JDBC connectivity options for currently supported versions:

SQL Anywhere 16

SQL Anywhere 17

The jConnect driver is not shipped with SQL Anywhere.

* Please Login or Register to Answer, Follow or Comment.

2 Answers

Martin Haack Jan 04 at 03:33 PM

I use "SQL Anywhere 16" on Linux.

On this installation a "jconn4.jar" file is available which I copied to "Oracle SQL Developer" (Win) and set it as JDBC driver within but without success which means adding a further connection to "SQL Anywhere"-Sybase was not possible as no tab is shown in the "Add connection" menu of the "Oracle SQL Developer" !

Using jtds-1.3.1.jar always show two tabs for SQL Server and Sybase.

Maybe it is the wrong jonn4.jar file ...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

It is not clear that SQL Developer supports any third party JDBC - it appears to support mySQL and jTDS only. There is mixed messages about jTDS use with SQL Anywhere. In theory, jTDS should work with SQL Anywhere unless it is executing specific statements that are not valid in SQL Anywhere.

The SQL Anywhere administration and IDE is SQL Central.

Martin Haack Jan 04 at 03:37 PM

checking "jconn4.jar" shows:

# java -jar ./SYMCOpsCenterServer/lib/jconn4.jar
jConnect (TM) for JDBC(TM)/16.0 PL04 (Build 27080)/P/EBF23431/JDK 1.6.0/jdbcmain/OPT/Mon Sep 1 05:57:43 PDT 2014

10 |10000 characters needed characters left characters exceeded