SAP Knowledge Base Article - Preview

2807020 - jConnect fails to login to ASE with MIT Kerberos when charset conversion is unavailable - SAP ASE

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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.