Problem in establishing a connection with Sybase IQ 16.0 database

[nsingh1682493645]

Connection failure. You must change the Database Settings.

 java.sql.SQLException: JZ0SB: Parameter index out of range: 1.

   at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(Unknown Source)

   at com.sybase.jdbc4.jdbc.ParamManager.int(Unknown Source)

   at com.sybase.jdbc4.jdbc.ParamManager.doSetParam(Unknown Source)

   at com.sybase.jdbc4.jdbc.ParamManager.setParam(Unknown Source)

   at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)

   at com.sybase.jdbc4.jdbc.SybPreparedStatement.a(Unknown Source)

   at com.sybase.jdbc4.jdbc.SybPreparedStatement.setNull(Unknown Source)

   at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.a(Unknown Source)

   at com.sybase.jdbc4.jdbc.SybDatabaseMetaData.getSchemas(Unknown Source)

   at org.talend.commons.utils.database.PackageFakeDatabaseMetadata.getSchemas(PackageFakeDatabaseMetadata.java:114)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.checkSchemaConnection(ExtractMetaDataFromDataBase.java:423)

   at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:334)

   at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:290)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.runWithCancel(DatabaseForm.java:4556)

   at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$75.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.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)

   at java.base/java.lang.Thread.run(Thread.java:834)

[Anonymous]

Hello @nirmal singh​ ,

Regarding to the error log, the problem is that sybase jdbc driver jar is not the correct one.

As a workaround, please setup the DB version to "Sybase 16" as the below while creating a sybase db connection in studio Metadata

java.sql.SQLException: The sajdbc.jar build does not match the shared object build

[nsingh1682493645]

Sir,

what willl be the correct Sybase jdbc driver jar  file ,where I can download it and how I can setup it in my it talend,so that I can connect SybaseIQ db through Talend Open Studio.