I try to connect to SqlAnywhere 17 demoDB using a tool called DbSchema. The tool is using JDBC connection.

For this I started SQL Central, then I also did dbsrv17.exe -x tcpip -n server1 to start the Tcp/IP service ( this is in the tool Help ).

Then I try to connect as DBA/sql but I get 'failed login'. I tried also creating an user in SQL Central and connect using it, but connectivity still fails. The connection is done like this:

final Properties properties = new Properties(); properties.put( "user","DBA"); properties.put( "password","sql"); driver.connect( "jdbc:sybase:Tds:localhost:2638/demo?LITERAL_PARAMS=true", properties );

The error is java.sql.SQLException: JZ00L: Login fehlgeschlagen. �berpr�fen Sie SQLWarnings zu diesem Fehler, um die Ursache zu sehen. translated Login failed. Check SQLWarnings about this error to see the cause. I don't know how to get the SQLWarnings.

Any suggestion on what should I check ?

asked 29 Jul, 07:11

dprutean's gravatar image

dprutean
263
accept rate: 0%

edited 29 Jul, 08:34

Please show how you specify the user id and password. Use copy and paste rather than re-typing. Please show us the exact text of the error message.

(29 Jul, 08:20) Breck Carter
Replies hidden

The connection is done like this:

final Properties properties = new Properties(); properties.put( "user","DBA"); properties.put( "password","sql"); driver.connect( "jdbc:sybase:Tds:localhost:2638/demo?LITERAL_PARAMS=true", properties );

The error is java.sql.SQLException: JZ00L: Login fehlgeschlagen. �berpr�fen Sie SQLWarnings zu diesem Fehler, um die Ursache zu sehen. translated Login failed. Check SQLWarnings about this error to see the cause. I don't know how to get the SQLWarnings.

(29 Jul, 08:33) dprutean
2

It seems that DbSchema defaults to using the old slow jconnect JDBC driver jconn4d.jar rather than the new fast SQL Anywhere JDBC driver sajdbc4.jar

For more information about the two drivers see https://help.sap.com/viewer/98ad9ec940e2465695685d98e308dff5/17.0/en-US/3bd02ce86c5f101482b78476939fb83a.html?q=jdbc

You may need to install the SAP Java Development Kit (JDK) to get jconn4d.jar. For more information ( good luck! you'll need it :) see https://wiki.scn.sap.com/wiki/display/SQLANY/Downloading+the+jConnect+driver

sajdbc4.jar comes with SQL Anywhere, but you may have to tell DbSchema how to use it (see the Manage Drivers button).

I got stuck on the funky DbSchema - Manage Drivers - +New - "JDBC URL with tags" field.

I tried these wild guesses...

JDBC URL with tags  jdbc:sqlanywhere:<host>:<port>/<db>?LITERAL_PARAMS=true
Edit the JDBC URL   jdbc:sqlanywhere:localhost:2638/demo?LITERAL_PARAMS=true

FYI the driver is located here C:\Program Files\SQL Anywhere 17\Java\sajdbc4.jar

Got this far...

java.lang.UnsatisfiedLinkError: no dbjdbc17 in java.library.path: 
[c:\program files\common files\i4j_jres\14.0.1\bin, 
C:\Windows\System32, C:\Windows, C:\Windows\System32\wbem, 
C:\Windows\System32\WindowsPowerShell\v1.0\, 
C:\Windows\Microsoft.NET\Framework\v2.0.50727, C:\Windows\System32, 
C:\Windows, C:\Windows\System32\wbem, 
C:\Windows\System32\WindowsPowerShell\v1.0\, 
C:\Windows\System32\OpenSSH\]
  at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2680)
  at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:807)
  at java.base/java.lang.System.loadLibrary(System.java:1907)
  at sap.jdbc4.sqlanywhere.IDriver.try_load(IDriver.java:451)
  at sap.jdbc4.sqlanywhere.IDriver.<clinit>(IDriver.java:413)
  at java.base/java.lang.Class.forName0(Native Method)
  at java.base/java.lang.Class.forName(Class.java:427)
  at com.wisecoders.dbs.rdbms.driver.model.a.a(DriverClassLoader.java:141)
  at com.wisecoders.dbs.rdbms.driver.model.a.b(DriverClassLoader.java:107)
  at com.wisecoders.dbs.rdbms.driver.model.a.a(DriverClassLoader.java:85)
  at com.wisecoders.dbs.rdbms.driver.model.a.a(DriverClassLoader.java:64)
  at com.wisecoders.dbs.rdbms.driver.model.a.<init>(DriverClassLoader.java:34)
  at com.wisecoders.dbs.rdbms.driver.model.RdbmsDriverManager.i(RdbmsDriverManager.java:131)
  at com.wisecoders.dbs.dialogs.system.FxUploadDriverTask.succeeded(FxUploadDriverTask.java:78)
  at com.wisecoders.dbs.rdbms.driver.fx.FxDriversDialog$4.succeeded(FxDriversDialog.java:244)
  at com.wisecoders.dbs.sys.fx.Dialog$.showDialog(Dialog$.java:196)
  at com.wisecoders.dbs.sys.fx.Dialog$.showDialog(Dialog$.java:168)
  at com.wisecoders.dbs.rdbms.driver.fx.FxDriversDialog.<init>(FxDriversDialog.java:112)
  at com.wisecoders.dbs.rdbms.connect.fx.FxConnectorEditor.addDriver(FxConnectorEditor.java:785)
  at com.wisecoders.dbs.sys.Rx.a(Rx.java:148)
  at com.wisecoders.dbs.sys.fx.Dialog$.showDialog(Dialog$.java:196)
  at com.wisecoders.dbs.sys.fx.ButtonDialog$.isDialogResultOk(ButtonDialog$.java:20)
  at com.wisecoders.dbs.sys.fx.ButtonDialog$.editingOk(ButtonDialog$.java:26)
  at com.wisecoders.dbs.project.fx.frame.FxFrame.newProjectFromDb(FxFrame.java:297)
  at com.wisecoders.dbs.project.fx.frame.FxWelcome.newProjectAction(FxWelcome.java:98)
  at com.wisecoders.dbs.sys.Rx.a(Rx.java:148)
  ...

Maybe the DbSchema folks can help.

(29 Jul, 15:12) Breck Carter
Replies hidden
1

I am unconvinced that DbSchema supports SQL Anywhere. This tool incorrect supplies only the jar file and misses a number of native libraries that must be the same version as the jar. Copying your SQLA install sajdbc4.jar to the c:\Users\<user>.DbSchema\drivers\SQLAnywhere and adding the following into DbSchema.vmoptions (in the root of the install) -Djava.library.path=<path_to_sqla_binaries>. This allows you to connect but then it incorrectly attempts to treat tables as databases (or schemas) resulting in exceptions. There are also exceptions after a successful connection with using jConnect (I had no issues with making a connection to the demo DB - although it is assuming that you are connecting to ASE so modifications to the URL may be needed in a SA context). If I understand the exception, it also appears to be tripping up trying to deal with schemas.

(30 Jul, 00:07) Chris Keating
Replies hidden

Great, thank you! This works for me as well with the same issues. I wrote to DbSchema team and they will check the exception right this days. I will write again here when is fixed.

(30 Jul, 02:38) dprutean

Thank you as well for checking this. Same issue, I will write back when I have an update from DbSchema.

(30 Jul, 02:39) dprutean

> unconvinced that DbSchema supports SQL Anywhere

That may be true, but the inverse may also be true; i.e., you can make SQL Anywhere support DbSchema :)

(30 Jul, 08:13) Breck Carter
showing 3 of 7 show all flat view

copy the dbjdbc17.dll found in your SQL Anywhere\Bin64 directory into the same directory that you copied the sajdbc4.jar and try it again.

permanent link

answered 30 Jul, 09:15

BBuck's gravatar image

BBuck
111
accept rate: 0%

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:

×146
×80
×71

question asked: 29 Jul, 07:11

question was seen: 66 times

last updated: 30 Jul, 09:15