Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Issue with general JDBC and sybase sqlanywhere 16

Hello,
I created a db connection with general JDBC and sybase sql anywhere 16 on my system : windows 2012R2.

I connect to the database only once and after I receive the following error message:
Echec de la connexion Vous devez modifier les paramètres de la base de données.
  java.lang.RuntimeException: java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\SQL Anywhere 16\Bin64\dbjdbc16.dll already loaded in another classloader
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:164)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1033)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:314)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2648)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
  Caused by: java.lang.UnsatisfiedLinkError: Native Library C:\Program Files\SQL Anywhere 16\Bin64\dbjdbc16.dll already loaded in another classloader
      at java.lang.ClassLoader.loadLibrary1(Unknown Source)
      at java.lang.ClassLoader.loadLibrary0(Unknown Source)
      at java.lang.ClassLoader.loadLibrary(Unknown Source)
      at java.lang.Runtime.loadLibrary0(Unknown Source)
      at java.lang.System.loadLibrary(Unknown Source)
      at sybase.jdbc4.sqlanywhere.IDriver.try_load(IDriver.java:483)
      at sybase.jdbc4.sqlanywhere.IDriver.<clinit>(IDriver.java:421)
      at java.lang.Class.forName0(Native Method)
      at java.lang.Class.forName(Unknown Source)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getDriver(JDBCDriverLoader.java:90)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:115)
      ... 9 more
What's wrong?
Please help, thanks.
Ben
Labels (4)
3 Replies
Anonymous
Not applicable
Author

Hi bpat,
Have you tried to use ODBC connection to see if it works?
Best regards
Sabrina
Anonymous
Not applicable
Author

Hello Sabrina,

Thank you for your reply. I'm tried odbc connection with x64 driver, but I have many error, I have found post with problem in x64 odbc connection and I tried odbc connection with x86 driver and talend. Apparently problems have disappeared.  But I would connect to jdbc connection for test and I don't understand how to install and configure  java driver sybase sajdbc.jar, have you an idea to solve driver already loaded in another classloader ?
Best regards
Ben
Anonymous
Not applicable
Author

Hello,
I tried the JDBC connection to sqlanywhere 16 and it is working when I use it in a Job, however it throws the error you mentioned when you do a Check connection in Metadata -> DB Connections. So go ahead and try this in a Job.