Yep, Poolman rocks, Its insanely easy to use and setup. Iam currently using it in my webapp and it works like a charm. Iam curious to know if anyone has setup poolman as a Server(ala JDBC datasources on WebSphere) and was able to do a JNDI lookup on its datasources. How did you get the InitialContext? .
Thanks for your time hemant ----- Original Message ----- From: "Martin Samm" <[EMAIL PROTECTED]> To: "Struts Users Mailing List" <[EMAIL PROTECTED]> Sent: Friday, March 22, 2002 7:08 AM Subject: Re: HOWTO: Lessons learned from using Struts, Tomcat and Oracle > alternatively, use poolman, which although 'dead' can still be had from > Sourceforge. i'm also using Struts / Tomcat (3.2 however) and Oracle (all on > *nix). I haven't tried Tomcat / Struts pooling, but opted for poolman instead > and found it easy to setup > > On Friday 22 Mar 2002 12:04 pm, you wrote: > > -------- Original Message -------- > > Subject: Lessons learned from using Struts, Tomcat and Oracle > > Date: Thu, 21 Mar 2002 19:43:22 -0800 (PST) > > From: "Walter S. So" <[EMAIL PROTECTED]> > > > > Hi Ted, > > > > I just want to share this information in case someone else also > > goes through the same problems I did. I was able to come up > > with this solution after spending an entire afternoon searching > > through the net and archives, so if it saves people a few hours > > of debugging, I'll be happy. I am not sure how to categorize it > > or even which mailing list to send this, whether it should go to > > Tomcat, Struts, or Tyrex, so I decided to send it to you since > > you are active in Jakarta. > > > > My goal was to set up a Connection Pooled DataSource using > > Oracle running Struts on Tomcat. I use Tomcat 4.0.3, Struts > > 1.1-b1-lib, Oracle 8.1.7 "classes12.zip" running on Windows 98, > > but it should work well on Solaris/Linux. > > > > Initially, I set up the Oracle JDBC drivers under my webapp and > > used the <datasource> in struts-config.xml to access Oracle. My > > application consistently hung after the pool was exhausted. > > (For example, if I set the minCount and maxCount to "10", my > > webapp would hang after 10 requests) The problem of Oracle > > connections not being returned properly by the Struts pool was > > well documented in the mailing list, so I switched the > > datasource from struts-config.xml to tomcat's server.xml. I > > followed the instructions in the Tomcat jndi-resources-howto and > > copied the Oracle drivers to common/lib after renaming the > > "classes12.zip" to "classes12.jar" as suggested by the mailing > > list. > > > > I found my webapp wasn't running properly as the servlet would > > stop executing after context.lookup(). This bothered me because > > Tomcat was not throwing any exceptions. After some more > > research, I changed the debug level in server.xml from "0" to > > "99". This time, the log generated showed a > > java.lang.ClassCastException: tyrex.jdbc.xa.EnabledDataSource > > when the lookup() is called. A post in the tomcat-dev mailing > > list provided the answer: There was a conflict in the jars of > > tomcat and the webapp. True enough, I found a > > jdbc2_0-stdext.jar (83KB) that came in tomcat\common\lib, and a > > jdbc2_0-stdext.jar (7KB) that i had unpacked from Struts to my > > web-app. After deleting the 7KB jar, the lookup() executed > > properly. > > > > To sum up, when using a DataSource in Tomcat and Struts in the > > webapp, make sure to remove the extraneous jdbc2_0-stdext.jar > > that comes with the Struts Lib. :) > > > > Hope that helps, > > > > Walter > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! Movies - coverage of the 74th Academy Awards® > > http://movies.yahoo.com/ > > -- > Martin Samm > [EMAIL PROTECTED] > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>