On Mon, 2002-07-15 at 16:23, Rick Fincher wrote:
> Hi William,
>
> This is very strange. When I switched to the FB SQL driver (on both
> Windows and Solaris) I just put in the new jar, changed the driver
> name to FBDriver, changed the url appropriately, and it worked.

This is exactly what I did on my Laptop and it worked, but on my
development production servers it does not. So I am looking for some
sort of explanation, but have not come up with one yet?

> You might try putting in a bad db filename that you know should fail
> and see if you get the same error. If so it would indicate something
> wrong with the filename (case, underscore problem, etc).

A possibility, but I have verified, and even copy/pasted the url used in
my client side GUI to be the same as the on in the connection pool.

> I didn't see your earlier posts so I don't know the specifics of the
> problem. Can you check to see if the driver is loading (non null) and
> see if you are getting a live connection (get.connection() not null).

I know the driver is loaded, because I do not get an exception when
doing so. It's when I try to establish a connection I have problems.
Instead of getting a null connection, an exception occurs.

Here is a snippet of the base class that the connection pool just calls
multiple times.

try {
Class.forName(driverClass);
}
catch(ClassNotFoundException cnfe) {
System.err.println("Database Exception\nDriver Class Not Found
:\n"+cnfe);
}
try {
connection = DriverManager.getConnection(url,name,passwd);
}
catch(SQLException sqle) {
System.err.println("Database Exception\nCould not connect this
database,\n"+url+"\nwith the following
username/password\n"+name+"/"+passwd+"\n"+sqle);
}

So it's the exception above that keeps getting thrown.

> You may also want to use FBWrapping data source instead of FBDriver
> and get connection pooling in the bargain. I can give you the
> specifics on this if you like. It's pretty easy and it may work around
> your problem.

I will consider this, but I was planning to drop my connection pool for
one inside of Tomcat. Do you use Tomcat, and if so which one is the
preferred one to use for an app that requires a connection pool?

> Sorry if you have gone through this drill, like I say I didn't see
> your earlier posts.

It's cool, you are not really covering anything that has been discussed,
so it counts as new input.

Also I forgot to mention one other difference in the machines. My
laptop has Firebird installed but not running. I have a dedicated
Firebird server that houses the DB's I am trying to connect to. My
development and production servers do not have Firebird installed in
anyway. Could that be the problem? It would seem very strange if it was,
but I am looking for anything at this point.

--
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com
--
Sincerely,
William L. Thomson Jr.
Support Group
Obsidian-Studios Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone 707.766.9509
Fax 707.766.8989
http://www.obsidian-studios.com