SAP Knowledge Base Article - Preview

3535051 - jConnect: Better error messages from java other than login failed - SDK for SAP ASE

Symptom

The java stack:
java.sql.SQLException: SQL Connection to the host xxxxx with user xxxxx failed. Error: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).. JDBC URL: jdbc:sybase:Tds:xxxxxxxxx:####?SQLINITSTRING=set ansi_permissions on set ansinull on set arithabort arith_overflow off set string_rtruncation on set close on endtran on&SELECT_OPENS_CURSOR=true&HOMOGENEOUS_BATCH=false&EARLY_BATCH_READ_THRESHOLD=50&IS_CLOSED_TEST=INTERNAL

    at com.sap.core.dbaas.dbserver.internal.ase.AseDatabaseManager.validateDatabaseConnection(AseDatabaseManager.java:486)
    at com.sap.core.dbaas.dbserver.internal.ase.AseDatabaseManager.validateDatabaseConnection(AseDatabaseManager.java:463)
    at com.sap.core.dbaas.dbserver.internal.ase.AseExceptionTest.givenDbServer_whenValidateDatabaseConnectionWithWrongPassword_thenNoChainedException(AseExceptionTest.java:160)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)
    at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
    at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
    at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
    at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54)
    at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54)
    at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
    at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
    at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
    at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
    at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
    at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
    at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
    at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
    at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
    at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26)
    at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
    at org.junit.rules.ExternalResource$1.evaluate(ExternalResource.java:54)
    at org.junit.rules.RunRules.evaluate(RunRules.java:20)
    at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
    at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
    at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
    at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:69)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater$1.execute(IdeaTestRunner.java:38)
    at com.intellij.rt.execution.junit.TestsRepeater.repeat(TestsRepeater.java:11)
    at com.intellij.rt.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:35)
    at com.intellij.rt.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:235)
    at com.intellij.rt.junit.JUnitStarter.main(JUnitStarter.java:54)
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:832)
    at com.sybase.jdbc4.tds.Tds.processLoginAckToken(Tds.java:5578)
    at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:728)
    at com.sybase.jdbc4.tds.Tds.login(Tds.java:582)
    at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:529)
    at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3861)
    at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:382)
    at com.sybase.jdbc4.jdbc.SybConnection.<init>(SybConnection.java:282)
    at com.sybase.jdbc4.jdbc.SybDriver.connect(SybDriver.java:258)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)
    at com.sap.core.dbaas.schema.util.dbconnection.DriverManagerWrapper.getConnectionFromDriverManager(DriverManagerWrapper.java:12)
    at com.sap.core.dbaas.schema.util.dbconnection.AseConnectionProvider.getConnection(AseConnectionProvider.java:48)
    at com.sap.core.dbaas.schema.util.dbconnection.ConnectionProvider.getConnection(ConnectionProvider.java:58)
    at com.sap.core.dbaas.schema.util.JdbcExecutor.execute(JdbcExecutor.java:29)
    at com.sap.core.dbaas.dbserver.internal.ase.AseDatabaseManager.validateDatabaseConnection(AseDatabaseManager.java:477)
    ... 37 more

In Ribo only see Login failed.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) Software Developer Kit (SDK) 16.0
  • jConnect
    • JDBC 7.07
    • JDBC 16 ( is version JDBC 7.07 )
  • java

Keywords

KBA , BC-SYB-SDK , SDK , Product Enhancement

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.