Hi,
I 've been testing a FreeBSD server lately. I have built firebird 1.5.2
using the ports. The server seems to work so far, I tested it using isql
and flameRobin(linux build).
Then, I tried to connect using SQuirrel SQL client and
FirebirdSQL-1.5.5JDK_1.4 or JayBird-2.0.0RC1JDK_1.5.zip (java version:
1.5.0 - native build using ports). Both driver versions seem to have
problems connecting properly. Here is what I get from SQuirrel logs:

1. FirebirdSQL-1.5.5JDK_1.4
(a) connection string:
jdbc:firebirdsql://localhost:3050/usr/firebird.data/somedb.gdb?lc_ctype=WIN1253
org.firebirdsql.jdbc.FBSQLException: Resource Exception. bad parameters
on attach or create database
CHARACTER SET WIN1253 is not defined
Reason: bad parameters on attach or create database
CHARACTER SET WIN1253 is not defined
at
org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:112)
at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:189)

(b) connection string:
jdbc:firebirdsql://localhost:3050/usr/firebird.data/somedb.gdb
44095 [Thread-3] ERROR
net.sourceforge.squirrel_sql.client.session.SchemaInfo - failed to load
table names
java.lang.ArrayIndexOutOfBoundsException: 2
at org.firebirdsql.jgds.GDS_Impl.isc_vax_integer(GDS_Impl.java:1405)
at org.firebirdsql.jgds.GDS_Impl.parseTruncSqlInfo(GDS_Impl.java:2028)
at org.firebirdsql.jgds.GDS_Impl.parseSqlInfo(GDS_Impl.java:1992)
at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare(GDS_Impl.java:1268)
at
org.firebirdsql.jca.FBManagedConnection.prepareSQL(FBManagedConnection.java:773)
at
org.firebirdsql.jdbc.AbstractConnection.prepareSQL(AbstractConnection.java:958)
at
org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement(AbstractStatement.java:1047)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement(AbstractPreparedStatement.java:904)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:86)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:701)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232)
at
org.firebirdsql.jdbc.AbstractConnection.getStatement(AbstractConnection.java:1046)
at
org.firebirdsql.jdbc.AbstractConnection.doQuery(AbstractConnection.java:1078)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getTables(FBDatabaseMetaData.java:2330)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadTables(SchemaInfo.java:750)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:148)
at
net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:632)
at
net.sourceforge.squirrel_sql.client.session.Session.access$100(Session.java:65)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:190)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
44234 [Thread-3] ERROR
net.sourceforge.squirrel_sql.client.session.SchemaInfo - failed to load
stroed procedures
org.firebirdsql.jdbc.FBSQLException: Resource Exception. Unable to
complete network request to host "".
Reason: Unable to complete network request to host "".
at
org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:842)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:85)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:701)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232)
at
org.firebirdsql.jdbc.AbstractConnection.getStatement(AbstractConnection.java:1046)
at
org.firebirdsql.jdbc.AbstractConnection.doQuery(AbstractConnection.java:1078)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getProcedures(FBDatabaseMetaData.java:1876)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:725)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadStoredProcedures(SchemaInfo.java:178)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:159)
at
net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:632)
at
net.sourceforge.squirrel_sql.client.session.Session.access$100(Session.java:65)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:190)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
at
org.firebirdsql.gds.GDSException: Unable to complete network request to
host "".
at
org.firebirdsql.jgds.GDS_Impl.isc_start_transaction(GDS_Impl.java:555)
at
org.firebirdsql.jca.FBManagedConnectionFactory.getCurrentIscTrHandle(FBManagedConnectionFactory.java:507)
at
org.firebirdsql.jca.FBManagedConnection.findIscTrHandle(FBManagedConnection.java:1125)
at
org.firebirdsql.jca.FBManagedConnection.internalStart(FBManagedConnection.java:675)
at
org.firebirdsql.jca.FBLocalTransaction.internalBegin(FBLocalTransaction.java:111)
at
org.firebirdsql.jca.FBLocalTransaction.begin(FBLocalTransaction.java:94)
at
org.firebirdsql.jdbc.AbstractConnection.ensureInTransaction(AbstractConnection.java:838)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:85)
at
org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:34)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:701)
at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement(AbstractConnection.java:232)
at
org.firebirdsql.jdbc.AbstractConnection.getStatement(AbstractConnection.java:1046)
at
org.firebirdsql.jdbc.AbstractConnection.doQuery(AbstractConnection.java:1078)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getProcedures(FBDatabaseMetaData.java:1876)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:725)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.loadStoredProcedures(SchemaInfo.java:178)
at
net.sourceforge.squirrel_sql.client.session.SchemaInfo.load(SchemaInfo.java:159)
at
net.sourceforge.squirrel_sql.client.session.Session.loadTableInfo(Session.java:632)
at
net.sourceforge.squirrel_sql.client.session.Session.access$100(Session.java:65)
at
net.sourceforge.squirrel_sql.client.session.Session$1.run(Session.java:190)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
44791 [AWT-EventQueue-0] ERROR
net.sourceforge.squirrel_sql.fw.util.StringManager - No resource string
found for key 'SessionTextEditPopupMenu.makeeditable'
45206 [Thread-4] ERROR
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree
- Error: Haris Personal
java.lang.NullPointerException
at
org.firebirdsql.jca.FBManagedConnection.getDatabaseProductName(FBManagedConnection.java:983)
at
org.firebirdsql.jdbc.AbstractConnection.getDatabaseProductName(AbstractConnection.java:987)
at
org.firebirdsql.jdbc.FBDatabaseMetaData.getDatabaseProductName(FBDatabaseMetaData.java:205)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getDatabaseProductName(SQLDatabaseMetaData.java:153)
at
net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.supportsStoredProcedures(SQLDatabaseMetaData.java:437)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createObjectTypeNodes(DatabaseExpander.java:270)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.expanders.DatabaseExpander.createChildren(DatabaseExpander.java:137)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.loadChildren(ObjectTree.java:815)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$TreeLoader.execute(ObjectTree.java:766)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.expandNode(ObjectTree.java:398)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree.access$600(ObjectTree.java:65)
at
net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$ExpansionController.run(ObjectTree.java:717)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)
...

2. JayBird-2.0.0RC1JDK_1.5
(a) connection string:
jdbc:firebirdsql://localhost:3050/usr/firebird.data/somedb.gdb

java.sql.SQLException: Unable to create connection. Check your URL.
at
net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:127)
at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:368)
at
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Thread.java:595)


Can anyone help please?

Haris Papadopoulos