Skip to Content
0
Former Member
Mar 25, 2017 at 07:02 PM

JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

23190 Views Last edit Mar 28, 2017 at 03:08 AM 3 rev

Hi,

I am trying to connect to a Sybase Database using java, using the jConn3 library. It exists on the class path.

Sample Code:

sybDriver = (SybDriver) Class.forName( "com.sybase.jdbc3.jdbc.SybDriver").newInstance(); con = DriverManager .getConnection("jdbc:sybase:Tds:<IP>:<PORT>?serviceName=C1603", "USER", "PWD");

Statement stmt = con.createStatement();

// Execute the query ResultSet rs = stmt.executeQuery("select * from dba.attempt where disposition=1100");

However, I end up receiving an error -

Exception in thread "main" java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s). at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source) at com.sybase.jdbc3.tds.Tds.for(Unknown Source) at com.sybase.jdbc3.tds.Tds.case(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.handleHAFailover(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source) at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source) at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at example.SybaseConnectivity.makeConnection(SybaseConnectivity.java:24) at example.SybaseConnectivity.main(SybaseConnectivity.java:50)

Is there a way to fix this?

Sybase Version being used : 11.0.1.2627.

The problem occurs when we are trying to obtain data out of Sybase using Java (jconn3 library which is in the classpath). The sybase data is embedded with a third party software called Wincati from Sawtooth Technologies.

How do we apply the EBF to the sybase version so to find the SQL warnings in the console of an IDE like eclipse?

Thanks & Regards,

-Rajarshi