topic Re: java.sql.SQLException: JZ00L: Login to Sysbase failed in Talend Studio

java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Tue, 16 Oct 2018 12:56:38 GMT

Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1095)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.runWithCancel(DatabaseForm.java:3983)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$62.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.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
      at com.sybase.jdbc4.jdbc.ErrorMessage.raiseError(ErrorMessage.java:775)
      at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5389)
      at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:725)
      at com.sybase.jdbc4.tds.Tds.login(Tds.java:579)
      at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:442)
      at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3584)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:355)
      at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:260)
      at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:224)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 9 more

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Tue, 16 Oct 2018 13:13:34 GMT

connection string is jdbc:sybase:TdsBSTJVMLX622.SUNTECSBS.COM:5001/SYBASE?

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Thu, 18 Oct 2018 04:33:48 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

Here is a closed jira issue:https://jira.talendforge.org/browse/TUP-9169. Feel free to let us know if it helps.

Best regards

Sabrina

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Fri, 19 Oct 2018 03:42:43 GMT

Hi Talend,
Version 6, screenshot of parameters passed us attached in the post.

Thank you,
Rajeswary S

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Sat, 20 Oct 2018 15:44:29 GMT

hello,

version is TOS_DI-20170623_1246-V6.4.1, kindly help I am stuck.

regards,

rajewary s

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Mon, 22 Oct 2018 05:14:55 GMT

hello,

version is TOS_DI-20170623_1246-V6.4.1, kindly help I am stuck.

regards,

rajeswary s

Re: java.sql.SQLException: JZ00L: Login to Sysbase failed

Anonymous — Tue, 23 Oct 2018 12:15:51 GMT

checked the port in Sybase server and found that it is 5000, could connect to server post this.