Subject | Re: [Firebird-Java] error when connect to fb using squirrel (java based SQL client) |
---|---|
Author | Jitu Tivari |
Post date | 2005-09-15T10:51:26Z |
Hi FB Group,
The server is running:
[root@linuxdb examples]# ps -elf |grep fb
0 S firebird 20886 1 0 80 0 - 892 wait
10:43 pts/3 00:00:00 /opt/firebird/bin/fbguard -f
0 S firebird 20887 20886 0 76 0 - 11752 stext
10:43 ? 00:00:01 /opt/firebird/bin/fbserver
0 S root 21796 19877 0 76 0 - 941 pipe_w
11:46 pts/3 00:00:00 grep fb
however there is no port information in netstat:
[root@linuxdb examples]# netstat |grep 3050
[root@linuxdb examples]# netstat |grep fb
when i try to use squirrel i get the following errors:
jdbc:firebirdsql://127.0.0.1:3050//opt/firebird/examples/employee.fdb?lc_ctype=UNICODE_FSS
java.lang.NoClassDefFoundError: java/sql/Savepoint
at
org.firebirdsql.jca.FBManagedConnection.getConnection(FBManagedConnection.java:298)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:62)
at
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
at
org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:112)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:345)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65)
at java.lang.Thread.run(Thread.java:479)
**************************************************************************************************************
Also tried :
jdbc:firebirdsql://127.0.0.1//opt/firebird/examples/employee.fdb?lc_ctype=UNICODE_FSS
and the permissions seem ok:
-rw-rw-rw- 1 firebird firebird 1028096 Sep 15 10:55 /opt/firebird/examples/employee.fdb
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com
The server is running:
[root@linuxdb examples]# ps -elf |grep fb
0 S firebird 20886 1 0 80 0 - 892 wait
10:43 pts/3 00:00:00 /opt/firebird/bin/fbguard -f
0 S firebird 20887 20886 0 76 0 - 11752 stext
10:43 ? 00:00:01 /opt/firebird/bin/fbserver
0 S root 21796 19877 0 76 0 - 941 pipe_w
11:46 pts/3 00:00:00 grep fb
however there is no port information in netstat:
[root@linuxdb examples]# netstat |grep 3050
[root@linuxdb examples]# netstat |grep fb
when i try to use squirrel i get the following errors:
jdbc:firebirdsql://127.0.0.1:3050//opt/firebird/examples/employee.fdb?lc_ctype=UNICODE_FSS
java.lang.NoClassDefFoundError: java/sql/Savepoint
at
org.firebirdsql.jca.FBManagedConnection.getConnection(FBManagedConnection.java:298)
at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:62)
at
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:109)
at
org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:112)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:345)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:65)
at java.lang.Thread.run(Thread.java:479)
**************************************************************************************************************
Also tried :
jdbc:firebirdsql://127.0.0.1//opt/firebird/examples/employee.fdb?lc_ctype=UNICODE_FSS
and the permissions seem ok:
-rw-rw-rw- 1 firebird firebird 1028096 Sep 15 10:55 /opt/firebird/examples/employee.fdb
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail http://uk.messenger.yahoo.com