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

[Former Member]

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?

Thanks.

[chris_keating]

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?

[Former Member]

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

[chris_keating]

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.

[Former Member]

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

[Former Member]

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 ...

[chris_keating]

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.