tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt Barre" <mba...@digiterra.com>
Subject Re: PoolMan woes
Date Thu, 05 Jul 2001 21:32:07 GMT
One more thing to go and I think I'll be there :) My dev system uses SQL Server which
works perfectly with PoolMan currently. My prod system is running MySQL. Currently MySQL
gives an error saying user:'web@' not valid. I have made multiple entries in the mysql
user table for the same user...from the hosts: localhost, 127.0.0.1 etc....doesn't seem to
help...even have one with a blank host and one with a %.  I did some very primitive load
testing this afternoon with PoolMan and was really impressed. It appears to do a better
job of connection pooling than JBoss which is what I was using before this, and simply for
its connection pooling. Thanks for all the help so far. Anyone happen to know offhand why
PoolMan doesn't work with Tomcat4b5?

Matt


----- Original Message -----
From: "Eoin Woods" <woods@intertrust.com>
To: <tomcat-user@jakarta.apache.org>
Cc: "'Matt Barre '" <IMCEAMAILTO-mbarre+40digiterra+2Ecom@intertrust.com>
Sent: Thursday, July 05, 2001 12:11 PM
Subject: RE: PoolMan woes


> Hi Matt,
>
> PoolMan comes with a bunch of third party JAR files in the "lib"
> subdirectory.  PoolMan relies upon these JAR files as well as poolman.jar.
>
> The one you are missing here is jta.jar.
>
> According to the PoolMan User Guide the jdbc2_0-stdext.jar, jmxri.jar,
> jta.jar and xerces.jar libraries are REQUIRED.  The jmxtools.jar, ant.jar,
> junit.jar and poolman-testsuite.jar files are OPTIONAL (jmxtools.jar is used
> for the HTML admin agent, the rest are for development and testing).
>
> Cheers,
>
> Eoin.
> -----Original Message-----
> From: Matt Barre [mailto:mbarre@digiterra.com]
> Sent: Thursday, July 05, 2001 10:06 AM
> To: tomcat-user@jakarta.apache.org
> Subject: Re: PoolMan woes
>
>
> Thank you for the help. I upgraded to jdk1.3.1 which got PoolMan running. I
> can now setup
> the config file and tomcat presents me with a list of available pools when I
> use the
> packaged poolman application. I ran queries against the pool and had no
> problems. I
> shutdown Tomcat, and changed the poolman.xml. Next time I ran PoolMan it
> gave me the error
> listed below. I restored a backup copy of poolman.xml that had worked
> before, but the
> error persists. What's the trick I'm still missing? My problem now is that I
> get a weird
> error:
>
> java.lang.NoClassDefFoundError: javax/transaction/xa/XAResource
> at com.codestudio.util.JDBCPool.create(JDBCPool.java:328)
> at com.codestudio.util.ObjectPool.checkOut(ObjectPool.java:214)
> at com.codestudio.util.JDBCPool.requestConnection(JDBCPool.java:407)
> at
> com.codestudio.util.SQLManager.requestConnection(SQLManager.java:193)
> at com.codestudio.util.SQLUtil.executeSql(SQLUtil.java:234)
> at com.codestudio.util.PoolManBean.getResults(PoolManBean.java:62)
>
> I have PoolMan.jar in tomcat/lib as well as in /jdk1.3.1/jre/lib/ext. I
> would appear that
> it finds the .jar. Thanks for the help from everyone! Sometimes I wonder if
> I'm ever going
> to get this working. :)
>
> ----- Original Message -----
> From: "Eoin Woods" <woods@intertrust.com>
> To: "'Matt Barre'" <mbarre@digiterra.com>; <tomcat-user@jakarta.apache.org>
> Sent: Tuesday, July 03, 2001 3:20 PM
> Subject: RE: PoolMan woes
>
>
> > > Method getDataSource(java.lang.String) not found in class
> > com.codestudio.sql.PoolMan
> >
> > I use findDataSource(java.lang.String) - although both are documented in
> the
> > JavaDoc.
> >
> > Is poolman.jar in your CLASSPATH when you compile?  I've just tested this
> > with 2.0.1 and both findDataSource() and getDataSource() are found.
> >
> > Cheers,
> >
> > Eoin.
> > -----Original Message-----
> > From: Matt Barre [mailto:mbarre@digiterra.com]
> > Sent: Tuesday, July 03, 2001 1:47 PM
> > To: Eoin Woods; tomcat-user@jakarta.apache.org
> > Subject: Re: PoolMan woes
> >
> >
> > Thanks for the tip. By taking the two suggestions I now have Tomcat
> somewhat
> > stabilized. I
> > am working on a jsp to get all the kinks worked out. I import the PoolMan
> > packages but I
> > get the following/weird error:
> >
> > Method getDataSource(java.lang.String) not found in class
> > com.codestudio.sql.PoolMan
> >
> > According to the javadocs that is a valid function call
> > Any further ideas?
> >
> > Thanks,
> >
> > Matt
> > ----- Original Message -----
> > From: "Eoin Woods" <woods@intertrust.com>
> > To: <tomcat-user@jakarta.apache.org>
> > Cc: <mbarre@digiterra.com>
> > Sent: Tuesday, July 03, 2001 1:18 PM
> > Subject: RE: PoolMan woes
> >
> >
> > > We're using PoolMan 2.0.x with Tomcat 3.2.x without too many problems.
> > >
> > > PoolMan does respond rather violently when it can't find its
> configuration
> > > file - which is "poolman.xml" in version 2.  I put this in
> > > $TOMCAT_HOME/classes and it appears to be found OK.
> > >
> > > If PoolMan doesn't find its configuration file, it ends up throwing a
> > > NullPointerException however, I've never seen this floor Tomcat - you
> just
> > > get an exception in the logs.
> > >
> > > How are you using PoolMan from within Tomcat?  We just import it into
> our
> > > servlets and call PoolMan.findDataSource("MyDataSource") to retrieve a
> > data
> > > source from it and then call ds.getConnection() to force initialisation.
> > >
> > > One difference is that we're on Solaris with JDK 1.3.1 and you have a
> W2K
> > > JVM.
> > >
> > > Eoin.
> > > -----Original Message-----
> > > From: Matt Barre [mailto:mbarre@digiterra.com]
> > > Sent: Tuesday, July 03, 2001 11:25 AM
> > > To: tomcat-user@jakarta.apache.org
> > > Subject: PoolMan woes
> > >
> > >
> > > I am trying to get PoolMan and TomCat to play nicely together.
> > > I am developing on Win2k, Tomcat 3.2.
> > >
> > > My first attempt was to use version 2.0.4 of Poolman with Tomcat
> > 3.2...upon
> > > access
> > > PoolMan.jsp, Tomcat stops running. No errors, no warnings, its terminal
> > > window just
> > > vanishes. I tried increasing the heap size, but that didn't seem to
> help.
> > >
> > > Next I tried installing PoolMan 1.4.1. This doesn't crash TomCat but
> > > mysteriously it can't
> > > find its poolman.props file. I've tried putting it in directories that
> I'm
> > > absolutely
> > > positive are in my ClassPath without luck.
> > >
> > > I've read the docs pretty extensively I think, but can't seem to come up
> > > with an answer.
> > > My overall goal is to simply add connection pooling to tomcat. If anyone
> > can
> > > give me some
> > > pointers, thanks in advance.
> > >
> > > Matt


Mime
View raw message