squirrel-sql-users

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

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

Peter -

	Yes, your problem stems from what appears to be a mis-understanding
on your part about how database-SERVERS work.  One does NOT ever specify
an actual driver-letter, file and directory (as you tried to do).
The SERVER knows where the data comes from...the client does NOT!

	I presume that you've inserted a few records into your sample
database (using whatever sofware came with 'Firebird').  So, the
server would then know TWO NAMES:
	o a 'DB' name (e.g. 'employees')
	o a 'table' name (e.g. 'employeedata')

	So, the jdbc 'URL' would contain ONLY that DB-name (as one piece of
the URL).  (The 'table' name you would reference in a later SQL statement,
such as "select * from employeedata") AFTER you have connected to the DB
thru the server.)
	The two OTHER parts of a JDBC 'url' are the HOST and the PORT.
The host is either a REMOTE machine name (e.g. such as 'myserver.ibm.com'
or if it is on the SAME machine that your SQuirreL pgm is running on, then
the HOST would be just 'localhost').  The PORT is of course typically
a 2- to 4-digit number (that your server is listening on), such as 3050
(as you stated in your msg).
	The JDBC 'url' is similar to the way web-servers are addressed...where
the PROTOCOl, HOST and PORT are specified:
	HTTP://GOOGLE.COM:80   (etc)
In that case, GOOGLE.COM is the 'host' and '80' is the port that the
HTML server is listening on.

Hope this helps...

	Dave [just another SQuirreL user]


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
sun...@us...
Sent: Saturday, April 29, 2006 5:14 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Attaching to database with URL


I have installed the drivers for Firebird and then look to add an alias
for the required database. However when I try to do a test connection I
get an error message, "CF: Problem getting connection: could not get a
db connection" or get the error message "CF:Unable to create connection.
Check your URL"

The syntax presented for Firebird is:
jdbc:firebirdsql:[//host[:port]/]<database>

I have tried and got the error Problem getting connection:
jdbc:firebirdsql:c\compiere\data\compiere.fdb
jdbc:firebirdsql:c:\\compiere\\data\\compiere.fdb

Check your URL error:
jdbc:firebirdsql://taurus/c:\compiere\data\compiere.fdb
jdbc:firebirdsql://taurus/c:\\compiere\\data\\compiere.fdb
jdbc:firebirdsql://taurus/taurus-c:\\compiere\\data\\compiere.fdb

I obtained the original syntax from Compiere properties file as:
taurus{taurus-c\:\\compiere\\data\\compiere.fdb-SYSDBA}

I'm using:
- Windows XP Professional
- Java 1.5
- Machine name: taurus
- apps port: 1099
- DB port: 3050
- DB User: SYSDBA
- DB Pwd: masterkey

If anyone can point me to the correct syntax or if there is anything
else I am missing, would be appreciated.

Thanks
Peter




-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

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

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

Peter -

	I should have also added, when comparing web-servers
to JDBC-servers, that HTTP-protocol and web-servers are
a SPECIAL case.  With HTML-files, when you specify an
actual FILE location to a browser, you are doing the SPECIAL
case of SERVER-LESS browsing, which is supported ONLY for
HTML (because people want to view 'local' content without
the need to install/configure their own local web-SERVER).
And, notice that case that the URL begins with: file://
which says you are NOT using a server at all.  It is ONLY
in that special case that the url would include a reference
to an actual 'file' in your (local) file-system.

	But, most all the OTHER server types, such as JDBC, FTP, etc
do NOT support the notion of SERVER-less access.

	One other point:  I mentioned that one 'typically' creates
the DB and inserts a few DB-records using the client-software
the comes with the DB-server.

	Of course, the SQuirreL software CAN be used to create and
insert records (just like the vendor-supplied software client can).
There should ALREADY be some 'sample' DB defined and known to your
DB-server, which you should NOW be able to access using
SQuirreL.  Likewise, there will be a predefined USER and PWD
that you would use to connect (before possibly defining ADDITIONAL
user/pwd info, which typically then ALSO need to be GRANTed
addtional access rights, etc.)  So, for getting STARTED, it is
usually simplest to use the PREDEFINED user and pwd, because it
has ALSO been predefined with its GRANTed privs, etc.

Hope this helps...

		Dave [just another SQuirreL user]



-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of
sun...@us...
Sent: Saturday, April 29, 2006 5:14 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Attaching to database with URL


I have installed the drivers for Firebird and then look to add an alias
for the required database. However when I try to do a test connection I
get an error message, "CF: Problem getting connection: could not get a
db connection" or get the error message "CF:Unable to create connection.
Check your URL"

The syntax presented for Firebird is:
jdbc:firebirdsql:[//host[:port]/]<database>

I have tried and got the error Problem getting connection:
jdbc:firebirdsql:c\compiere\data\compiere.fdb
jdbc:firebirdsql:c:\\compiere\\data\\compiere.fdb

Check your URL error:
jdbc:firebirdsql://taurus/c:\compiere\data\compiere.fdb
jdbc:firebirdsql://taurus/c:\\compiere\\data\\compiere.fdb
jdbc:firebirdsql://taurus/taurus-c:\\compiere\\data\\compiere.fdb

I obtained the original syntax from Compiere properties file as:
taurus{taurus-c\:\\compiere\\data\\compiere.fdb-SYSDBA}

I'm using:
- Windows XP Professional
- Java 1.5
- Machine name: taurus
- apps port: 1099
- DB port: 3050
- DB User: SYSDBA
- DB Pwd: masterkey

If anyone can point me to the correct syntax or if there is anything
else I am missing, would be appreciated.

Thanks
Peter




-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

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]

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]

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

[Matthew D. <mda...@su...>]

Hi Peter,

It's possible that the problem is as simple as some typos in your url. You
may have the correct idea after all.

David's comments were a bit overstated when he wrote, "You NEVER should be
doing that!" In general his point is correct: your url ought to be
specifying the information needed to reach the server. But in fact there are
cases where you can specify the path to the database in your url.

For example this is a perfectly good url with Derby (the old Cloudscape):
jdbc:derby:c:/databases/salesdb

I have not worked with Firebird. But examples on the web make it clear that
it allows you to connect to a database by specifying the database file in
the url as you were attempting. I found lots of examples like this:
jdbc:firebirdsql:localhost/3050:c:/data/data.gdb
jdbc:firebirdsql:localhost/3050:E:\\database\\carwash.gdb

more generally:
jdbc:firebirdsql:[host[/port]:]<database>

Your examples below all seem to have this form:
jdbc:firebirdsql://localhost...
Apparently there are 2 different allowable forms for the Firebird url:
"Standard format" and "FB old format". Try the form above that doesn't use
the double slash and see if you have any more success.

On the other hand, the problem might not be directly related to the url.
Take a look at this link:
http://forum.java.sun.com/thread.jspa?threadID=554002&messageID=4193912
It claims "Actually the problem is the installer for firebird 2.0 rc1..." If
you are unlucky enough to have this bug apply to you... then I'm not sure
what to suggest.

Good luck!

Regards,
Matt


-----Original Message-----
From: squ...@li...
[mailto:squ...@li...] On Behalf Of
sun...@us...
Sent: Wednesday, May 03, 2006 16:49 PM
To: David Cook
Cc: 'squirrel sql users'
Subject: RE: [Squirrel-sql-users] Attaching to database with URL

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

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]



-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Squirrel-sql-users mailing list
Squ...@li...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users

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

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

Hi Matthew & David,
I printed out both sets of comments and final got the chance to sit down
and read and see where it takes me.

I didn't have to go to far, as the solution popped out with Matthew's
first suggestion. The syntax is nothing close to what is presented when
you create a new connection in Squirrel.

The Firebird / Squirrel syntax is
jdbc:firebirdsql:[//host[:port]/]<database>.

I provided the syntax
jdbc:firebirdsql:localhost/3050:c:/Compiere/data/compiere.fdb and
received connection to the database.

Thanks for taking the time to reply. I'll have to practice my internet
search technique more to fine tune the relevant hits.

David, Thanks for hanging in there to answer my questions. I appreciate
the time taken to try and assist with a serious of questions.

Regards
Peter


----- Original message -----
From: "Matthew Dahlman" <mda...@su...>
To: sun...@us..., "'squirrel sql users'"
<squ...@li...>
Date: Wed, 3 May 2006 17:57:25 +0800
Subject: RE: [Squirrel-sql-users] Attaching to database with URL

Hi Peter,

It's possible that the problem is as simple as some typos in your url.
You
may have the correct idea after all.

[snip snip]

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

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

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

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.

Is there anyway to get a more detailed response to see where I'm going
wrong?

After writing the above I decided to try and find out how to use ISQL to
connect to the database.
I executed the following in ISQL:
- CONNECT "C:\Compiere\data\compiere.fdb" user 'SYSDBA' password
'masterkey'

I connected and was able to show the database details and table details.

I then tried the following in Squirrel:
- jdbc:firebirdsql:"C:\Compiere\data\compiere.fdb"
and got the error message "Unexpected Error occured attempting to open
an SQL connection"
This suggested to me that I am getting closer.

I then tried
"jdbc::firebirdsql:"//localhost/compiere"
and received error "Problem getting connection could not get a db
connection"

So I know I can connect to the database and can see the database
contents. Plus I get the open an SQL connection error when ever I use
the directory path.

Sorry to put such a basic question to the list. I appreciate any
suggestions and pointers to getting me going again.

Thanks




----- Original message -----
From: "David Cook" <Dav...@ve...>
To: sun...@us...
Date: Sat, 29 Apr 2006 07:52:59 -0400
Subject: RE: [Squirrel-sql-users] Attaching to database with URL


Peter -

	Yes, your problem stems from what appears to be a mis-understanding
on your part about how database-SERVERS work.  One does NOT ever specify
an actual driver-letter, file and directory (as you tried to do).
The SERVER knows where the data comes from...the client does NOT!

[snip snip snip]

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]