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.
SAP Knowledge Base Article - Preview