Problem in establishing a connection with Sybase IQ 16.0 database

nsingh1682493645 — Fri, 15 Nov 2024 21:50:52 GMT

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

Re: Problem in establishing a connection with Sybase IQ 16.0 database

Anonymous — Fri, 05 May 2023 04:49:38 GMT

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

Re: Problem in establishing a connection with Sybase IQ 16.0 database

nsingh1682493645 — Mon, 08 May 2023 05:59:53 GMT

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.

topic Re: Problem in establishing a connection with Sybase IQ 16.0 database in Talend Studio

Problem in establishing a connection with Sybase IQ 16.0 database

Re: Problem in establishing a connection with Sybase IQ 16.0 database

Re: Problem in establishing a connection with Sybase IQ 16.0 database