Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Jconnect 5.5

9 views
Skip to first unread message

sampath

unread,
Jul 20, 2002, 9:44:16 AM7/20/02
to

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)


0 new messages