Haris Papadopoulos wrote:
I also tried to connect using my own Java code and this is what I got:
(driver 1.5.1 this time)

DriverManager.getConnection("jdbc:firebirdsql:ithaki.softways.lan/3050:/usr/firebird.data/INVOICE_EX.GDB")
trying
driver[className=org.firebirdsql.jdbc.FBDriver,org.firebirdsql.jdbc.FBDriver@b60b93]
getConnection returning
driver[className=org.firebirdsql.jdbc.FBDriver,org.firebirdsql.jdbc.FBDriver@b60b93]
org.firebirdsql.jdbc.FBSQLException
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:169)
at
gr.softways.dev.jdbc.QueryProvider.provideData(QueryProvider.java:42)
at gr.softways.dev.jdbc.DataSet.refresh(DataSet.java:206)
at gr.softways.dev.poolmanager.AppACL.init(AppACL.java:64)
at gr.softways.dev.poolmanager.AppACL.<init>(AppACL.java:45)
at
gr.softways.dev.poolmanager.AppPoolManager.createPools(AppPoolManager.java:234)
at
gr.softways.dev.poolmanager.AppPoolManager.init(AppPoolManager.java:103)
at
gr.softways.dev.poolmanager.AppPoolManager.<init>(AppPoolManager.java:38)
at
gr.softways.dev.poolmanager.AppPoolManager.getInstance(AppPoolManager.java:62)
at
gr.softways.dev.poolmanager.AppPoolManager.getInstance(AppPoolManager.java:47)
at
gr.softways.dev.poolmanager.AppPoolServlet.init(AppPoolServlet.java:23)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
at
org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
at
org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
at
org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
at
org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:589)
at
org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:536)
at
org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:471)
at
org.apache.catalina.startup.HostConfig.start(HostConfig.java:1102)
at
org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at
org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1020)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalina.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:409)
SQLException: SQLState(HY000)
org.firebirdsql.jdbc.FBSQLException
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:169)
at
gr.softways.dev.jdbc.QueryProvider.provideData(QueryProvider.java:42)
at gr.softways.dev.jdbc.DataSet.refresh(DataSet.java:206)
at
gr.softways.invoice_sw.financialPeriod.Present.getFPeriods(Present.java:38)
at
org.apache.jsp.admin.login_jsp._jspService(org.apache.jsp.admin.login_jsp:412)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
SQLException: SQLState(HY000)
org.firebirdsql.jdbc.FBSQLException
at
org.firebirdsql.jdbc.AbstractStatement.executeQuery(AbstractStatement.java:169)
at
gr.softways.dev.jdbc.QueryProvider.provideData(QueryProvider.java:42)
at gr.softways.dev.jdbc.DataSet.refresh(DataSet.java:206)
at
gr.softways.invoice_sw.financialPeriod.Present.getFPeriods(Present.java:38)
at
org.apache.jsp.admin.login_jsp._jspService(org.apache.jsp.admin.login_jsp:412)
at
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
at
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
at
org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
SQLException: SQLState(HY000)

This is a freeBSD 5.4 server with firebird server 1.5.2 (native build
using ports). The driver used is working successfully with Linux and
Windows systems. I also tried to build the driver with no success. Can
somebody give me a hint?

Haris Papadopoulos

> 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
>