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