Hi,
I am unable to connect to Sybase DB which is on another machine.
Please let me know if I am doing anything wrong.
I am getting exceptions like " Connection already closed".
----------------------------
My code:
import java.sql.*;
public class myConnection {
public static void main( String[] args ) {
try {
// Using Sybase JCONNECT 5.2
Class.forName("com.sybase.jdbc2.jdbc.SybDataSource");
Connection conn =
DriverManager.getConnection("jdbc:sybase:Tds:localhost:2638","dba", "sql");
Statement stmt = conn.createStatement( );
ResultSet rs = stmt.executeQuery( "SELECT * FROM PROTONACCOUNT");
while ( rs.next( ) ) {
System.out.println( rs.getInt( 1 ) );
}
} catch ( Exception e ) {
System.out.println( "An exception occurred.");
e.printStackTrace();
}
} // end of main
}
------------------
I am getting the following exception
-----------------------------------------------
sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:479)
18:34:26 [INFO] Connecting: pramatisample
18:34:26 [INFO] Load driver using CLASSPATH:
com.sybase.jdbc2.jdbc.SybDataSource
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:479)
18:34:34 [INFO] Connecting: pramatisample
18:34:34 [INFO] Load driver using CLASSPATH:
com.sybase.jdbc2.jdbc.SybDataSource
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:479)
18:37:46 [INFO] Connecting: pramatisample
18:37:46 [INFO] Load driver using CLASSPATH:
com.sybase.jdbc2.jdbc.SybDataSource
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:479)
18:44:10 [INFO] Connecting: new
18:44:11 [INFO] Load driver using CLASSPATH:
com.sybase.jdbc2.jdbc.SybDataSource
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s).
at
com.sybase.jdbc2.jdbc.ErrorMessage.raiseError(ErrorMessage.java:500)
at com.sybase.jdbc2.tds.Tds.processLoginAckToken(Tds.java:3188)
at com.sybase.jdbc2.tds.Tds.doLogin(Tds.java:483)
at com.sybase.jdbc2.tds.Tds.login(Tds.java:405)
at
com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
at
com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:174)
at
com.sybase.jdbc2.jdbc.SybConnection.<init>(SybConnection.java:126)
at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:179)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:172)
at
se.pureit.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:31)
at se.pureit.dbvis.Database.doConnect(Database.java:180)
at se.pureit.dbvis.Database.access$000(Database.java:35)
at
se.pureit.dbvis.Database$ConnectionCommand.execute(Database.java:1038)
at se.pureit.util.ThreadCommand.runExecute(Unknown Source)
at se.pureit.util.ThreadCommand.run(Unknown Source)
at java.lang.Thread.run(Thread.java:479)