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

[David C. <Dav...@ve...>]

Peter -

	I can tell by your stack-trace that you are STILL
breaking the earlier rule that you were breaking before:

i.e. you are STILL INCORRECTLY trying to put a DRIVE-LETTER
and a ':' and a 'backslash' with a directory referring to
a FILE on the local system.

	You NEVER should be doing that!

	So, the poor program is doing what it knows how to
do...i.e. BLOWING UP because of goofy, unexpected input values!

Hope this helps...

		Dave

-----Original Message-----
From: sun...@us...
[mailto:sun...@us...]
Sent: Sunday, April 30, 2006 5:28 AM
To: David Cook
Cc: squirrel sql users
Subject: RE: [Squirrel-sql-users] Attaching to database with URL


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(FBManagedConne
ctionFactory.java:515)
	at
org.firebirdsql.jca.FBManagedConnectionFactory.assureDbHandle(FBManagedConne
ctionFactory.java:524)
	at
org.firebirdsql.jca.FBManagedConnection.<init>(FBManagedConnection.java:111)
	at
org.firebirdsql.jca.FBManagedConnectionFactory.createManagedConnection(FBMan
agedConnectionFactory.java:281)
	at
org.firebirdsql.jca.FBStandAloneConnectionManager.allocateConnection(FBStand
AloneConnectionManager.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(SQLDriver
Manager.java:125)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.e
xecute(OpenConnectionCommand.java:97)
	at
net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$S
heetHandler.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]