RE: [Squirrel-sql-users] Attaching to database with URL

[<sun...@us...>]

Further to my earlier email. I have the following java stack trace from
Squirrel against the error and command listed below.

jdbc:firebirdsql:"//localhost/c\:\\Compiere\\data\\compiere.fdb"
- error "Unexpected Error occured attempting to open an SQL connection."
- Below is the stack trace
java.lang.NumberFormatException: For input string: "/localhost/c\"
	at java.lang.NumberFormatException.forInputString(NumberFormatException.java:48)
	at java.lang.Integer.parseInt(Integer.java:447)
	at java.lang.Integer.parseInt(Integer.java:497)
	at org.firebirdsql.jgds.GDS_Impl$DbAttachInfo.<init>(GDS_Impl.java:2054)
	at org.firebirdsql.jgds.GDS_Impl.isc_attach_database(GDS_Impl.java:246)
	at org.firebirdsql.jca.FBManagedConnectionFactory.createDbHandle(FBManagedConnectionFactory.java:515)
	at org.firebirdsql.jca.FBManagedConnectionFactory.assureDbHandle(FBManagedConnectionFactory.java:524)
	at org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:111)
	at org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBManagedConnectionFactory.java:281)
	at org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStandAloneConnectionManager.java:109)
	at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:121)
	at org.firebirdsql.jdbc.FBDriver.connect(FBDriver.java:208)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:125)
	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:381)
	at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
	at java.lang.Thread.run(Thread.java:595)

Regards
Peter

----- Original message -----
From: sun...@us...
To: "David Cook" <Dav...@ve...>
Date: Sun, 30 Apr 2006 12:14:23 +0300
Subject: RE: [Squirrel-sql-users] Attaching to database with URL

David,
Thanks for the detailed responses on the two emails. Yes definitely a
mis-understanding on my part.


[snip snip snip]