Re: PoolMan woes
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 etcdoesn'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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "'Matt Barre '" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 10:06 AM > To: [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > To: "'Matt Barre'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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:[EMAIL PROTECTED]] > > Sent: Tuesday, July 03, 2001 1:47 PM > > To: Eoin Woods; [EMAIL PROTECTED] > > 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" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Cc: <[EMAIL PROTECTED]> > > Sent: Tuesday, July 03, 2001 1:18 PM > > Subject: RE: PoolMan woes > > > > > > > We're using PoolMa
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:[EMAIL PROTECTED]]
Sent: Thursday, July 05, 2001 10:06 AM
To: [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: "'Matt Barre'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> Sent: Tuesday, July 03, 2001 1:47 PM
> To: Eoin Woods; [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 03, 2001 11:25 AM
> > To: [EMAIL PROTECTED]
> > 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
> > wind
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" <[EMAIL PROTECTED]>
To: "'Matt Barre'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> Sent: Tuesday, July 03, 2001 1:47 PM
> To: Eoin Woods; [EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> 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:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 03, 2001 11:25 AM
> > To: [EMAIL PROTECTED]
> > 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
Re: PoolMan woes
Hi Matt, I've the same problems in the beginning (Tomcat stops without a message). I put the property-file in the /tomcat/classes directory and the poolman.jar file in the classpath (set classpath=/poolman.jar;%classpath%) then it works. Hth Peter Matt Barre wrote: > > 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
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:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 1:47 PM
To: Eoin Woods; [EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> Sent: Tuesday, July 03, 2001 11:25 AM
> To: [EMAIL PROTECTED]
> 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
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> Sent: Tuesday, July 03, 2001 11:25 AM
> To: [EMAIL PROTECTED]
> 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
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:[EMAIL PROTECTED]]
Sent: Tuesday, July 03, 2001 11:25 AM
To: [EMAIL PROTECTED]
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
Re: PoolMan woes
Matt: I ran into the same problem several days ago. If I used the poolman.xml.example as poolman.xml... tomcat just plain died without warning. No errors, nothing. When I tried using the poolman.xml.template as poolman.xml... it worked flawlessly. Hope it helps, Jack Lauman Matt Barre wrote: > > 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
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
