|
From: Matthew D. <mda...@su...> - 2006-05-03 09:57:42
|
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 |
