Poolman and Tomcat - I'm going nuts

[tn...@FBOS.com]

Hello,

I am having a very difficult time getting poolman to work under tomcat and
based on other posts to this forum, this should not be the case.  I have
included the "poolman.props" file in a directory which is in my CLASSPATH.
It works fine outside of tomcat from a simple java application, but when I
create a servlet or try to execute the PoolMan.jsp sample, I receive the
following error:

	Could not find 'poolman.props' -- now attempting to read deprecated
file name 'pool.props'... failed.

This is coming from SQLManager.java, although I am not sure why.

As I stated above, I have include the "poolman.props" file in a directory
which is on my CLASSPATH and have echoed out the CLASSPATH to a file to
ensure that it is in fact being used by tomcat when I execute the
bin/start.bat; the directory is in the CLASSPATH.

I am using Apache 1.3.14, Tomcat 3.2.1, PoolMan 1.4.1 under WIN 2K.

The following is the code being used:

  	Connection con = null;
  	
  	// Load the PoolMan JDBC Driver
  	try { 
  	  Class.forName("com.codestudio.sql.PoolMan").newInstance();
            } catch (Exception ex) {
    	System.out.println("Could Not Find the PoolMan Driver." + 
    	                   "Check to ensure that PoolMan.jar is in your
CLASSPATH");
           return false;
           }
    
  	try {
  	  // establish a Connection to the specified database (test)
	  con = DriverManager.getConnection("jdbc:poolman://" + "test");
<---------------------------ERRORS OUT ON THIS CALL
	} catch(SQLException sqe) {
              System.out.println("Error obtaining connection through PoolMan
to test Database");
              return false;
           }

Is there anyone out there that knows what could be causing this?  Any ideas
where to look? Is there anything which I need to set/configure under the
TOMCAT_HOME/conf ? Or, and I hope this is not the case, just going nuts? 

Todd G. Nist
Email:   tnist@fbos.com



The information in this electronic mail ("e-mail") message may
be confidential and for use of only the named recipient.  The
information may be protected by privilege, work product immunity
or other applicable law.  If you are not the intended recipient
the retention, dissemination, distribution or copying of this
e-mail message is strictly prohibited.  If you receive this e-mail
message in error please notify us immediately by telephone
at 770-723-1011 or arudesea@fbos.com  Thank you.