Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2009
    Posts
    3

    Unanswered: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this

    Dear Team,

    I have sybase server (SQL anywhere 9) on windown 32 bit os.
    i have download the jdbc driverse(jconnect60) from sysbase site, Also set the JDBC_HOME and Classpath in environment variable in same sybase server.
    when i exicute the jutils-2_0/jisql ,it' working fine from same machine and connected to database using 2638 port.

    But when confugured the jconnect60 driverse & jdbcd home , classpath on different pc and exicute the jisql it's not able to connect to my sybase pc and gives the message like as below.

    "Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s). "

    Below settings in jisql winddows is correct
    username
    port
    password
    servername= serverip


    required help on urgent basis.

    2. If baove run so we can configured our main purpose of connectivity for the sap udconnect utility which also gives same error after configration and SAP eroor is as bellow.

    Test JDBC Page
    Error!
    Could not connect to database. Connection is inactive or does not support JDBC.
    Go back

    Exception Details:

    com.sap.ip.bi.sdk.exception.BIConnectionFailedExce ption: Cannot open the connection
    at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectio nFactory.getConnectionEx(JdbcConnectionFactory.jav a:238)
    at com.sap.ip.bi.sdk.trialarea.connector.servlet.mode l.JDBCModel.getConnection(JDBCModel.java:796)
    at com.sap.ip.bi.sdk.trialarea.connector.servlet.mode l.JDBCModel.getTables(JDBCModel.java:132)
    at com.sap.ip.bi.sdk.trialarea.connector.servlet.cont roller.Control2.doPost(Control2.java:25)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
    at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.runServlet(HttpHandlerImpl.java:401)
    at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.handleRequest(HttpHandlerImpl.java:266)
    at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:386)
    at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:364)
    at com.sap.engine.services.httpserver.server.RequestA nalizer.invokeWebContainer(RequestAnalizer.java:10 39)
    at com.sap.engine.services.httpserver.server.RequestA nalizer.handle(RequestAnalizer.java:265)
    at com.sap.engine.services.httpserver.server.Client.h andle(Client.java:95)
    at com.sap.engine.services.httpserver.server.Processo r.request(Processor.java:175)
    at com.sap.engine.core.service630.context.cluster.ses sion.ApplicationSessionMessageListener.process(App licationSessionMessageListener.java:33)
    at com.sap.engine.core.cluster.impl6.session.MessageR unner.run(MessageRunner.java:41)
    at com.sap.engine.core.thread.impl3.ActionObject.run( ActionObject.java:37)
    at java.security.AccessController.doPrivileged(Native Method)
    at com.sap.engine.core.thread.impl3.SingleThread.exec ute(SingleThread.java:102)
    at com.sap.engine.core.thread.impl3.SingleThread.run( SingleThread.java:172)
    Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection
    at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedCo nnection.(JdbcManagedConnection.java:123)
    at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedCo nnectionFactory.createManagedConnection(JdbcManage dConnectionFactory.java:112)
    at com.sap.engine.services.connector.jca.ConnectionHa shSet.match(ConnectionHashSet.java:320)
    at com.sap.engine.services.connector.jca.ConnectionMa nagerImpl.allocateConnection(ConnectionManagerImpl .java:188)
    at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectio nFactory.getConnectionEx(JdbcConnectionFactory.jav a:233)
    ... 19 more
    Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source
    at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connecti on.connectDB(Connection.java:336)
    at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connecti on.connect(Connection.java:99)
    at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedCo nnection.(JdbcManagedConnection.java:118)
    ... 23 more
    Caused by: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
    at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unkn own Source)
    at com.sybase.jdbc3.tds.Tds.for(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
    at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybConnection.(Unknown Source)
    at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
    at java.sql.DriverManager.getConnection(DriverManager .java:512)
    at java.sql.DriverManager.getConnection(DriverManager .java:140)
    at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connecti on.connectDB(Connection.java:320)
    ... 25 more



    Please suggest

  2. #2
    Join Date
    Mar 2009
    Location
    Michigan
    Posts
    4
    check your server log file if you can, i have seen this when the 'encrypt password' option is set on the JDBC driver and it is not licensed on the server...

  3. #3
    Join Date
    Mar 2009
    Posts
    3
    Dear jprys,

    I am very new for Sybase can you guide or send the procedure how to chack and how change 'encrypt password' option .

    Thanks in advance.

    Regards,
    Ravi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •