Symptom
- Adaptive Server is configured with MIT Kerberos for identification and authentication, and "enable unicode conversion" configuration parameter is 0.
- When a jConnect application with the following settings tries to connect to the Adaptive Server, a SQLException with JZ00L is raised and the login attempt fails.
- CHARSET connection property is set to a different charset from the server's charset and character set conversion is not available between the jConnect's charset and the server's charset.
- REQUEST_KERBEROS_SESSION connection property is set to true.
- SERVICE_PRINCIPAL_NAME connection property is set to a value corresponding to the server entry in Key Distribution Center (KDC).
Error and stack trace sample:
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:5525)
at com.sybase.jdbc4.tds.Tds.doLogin(Tds.java:709)
at com.sybase.jdbc4.tds.Tds.login(Tds.java:581)
at com.sybase.jdbc4.jdbc.SybConnection.tryLogin(SybConnection.java:530)
at com.sybase.jdbc4.jdbc.SybConnection.handleHAFailover(SybConnection.java:3824)
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:245)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:678)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:190)
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL08 or later
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL06 or later
- jConnect
Product
Keywords
CR819538, CR#819538, 819538, JZ00L, Login failed, 2401, character set, conversion , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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.