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

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

Hi David,
Thanks for keeping with me.

I guess I got carried away and my original information got lost amongs
the stack trace, etc.

To go back to the basics of what you did teach me in the first response
and the information I got back from that.

I tried "jdbc:firebirdsql://localhost:3050/compiere" but still get the
error "CF: Problem getting connection: could not get a db connection".
I've tried capitalized Compiere, uppercase and lowercase for the
database name, and user, but no success. I even tried without the port
number.

java.sql.SQLException: Problem getting connection: could not get a db
connection!
	at org.firebirdsql.jdbc.FBDataSource.getConnection(FBDataSource.java:124)
	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)

Is there anyway to get a more detailed response to see where I'm going
wrong? Anything else I can look at?

Thanks again.
Peter

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


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

[snip snip snip]