I am actually looking at log4j now, but haven't implemented it yet.
Let's stay in touch on that issue?
Andy Timm wrote:
>
> Ok, this is embarrassing. Peter, I re-read your
> message, and realized I was already doing everything
> you were (I got everything running FIRST, now I'm
> going back and adding security, connection pooling,
> etc.). All I had to do was delete the 'work'
> directory and poof. I've been burned by that so many
> times in my company's app, I can't believe I missed it
> here. How about logging - do you use log4j?
> (currently I've got a boatload of printlns). Thanks
> again.
> --- Peter Kordel <[EMAIL PROTECTED]> wrote:
> > Andy, I use Poolman in a Struts application and did
> > it this way:
> > Downloaded poolman-2.1-b1 (you can even use CVS to
> > pull the latest
> > version from their site)
> > Configured poolman.xml to work with mysql
> > 3.23.46/mm.mysql-2.0.8 and
> > stuck it in WEB-INF/classes of my web app
> > BTW this works for both tomcat 3.2.4 and 4.0.1 -
> > with struts-1.0
> > Then I preload an initservlet on startup that grabs
> > a Poolman
> > datasource.
> > It also tears down all pools in destroy()
> > This datasource is stored in a connectionholder
> > object in the
> > servletcontext that acts as a wrapper for Poolman.
> > I used this extra layer of abstraction so I can pull
> > a generic
> > datasource from the servletcontext and call methods
> > such as
> > getConnection() and closeConnection() that in turn
> > call the correct
> > methods in Poolman. That way, I can plug-and-play
> > with alternative
> > connection pools without modifying my application
> > objects.
> >
> > // set up a connection pool with
> > // <dbName> from web.xml initparam
> > javax.sql.DataSource defaultPool =
> > PoolMan.findDataSource(dbName);
> >
> > zConnectionHolder dsPool =
> > new zConnectionHolder();
> >
> > dsPool.setDefaultPool(defaultPool);
> > context.setAttribute("dsPool", dsPool);
> >
> > Then I proceed like you:
> > zConnectionHolder dsPool =
> > (zConnectionHolder) servlet.getServletContext()
> > .getAttribute("dsPool");
> > java.sql.Connection con =
> > dsPool.getConnection();
> >
> > dsPool.closeConnection();
> >
> > Works like a charm. Your error makes no mention of
> > anything that looks
> > like a non-tomcat or non-struts object, so it's
> > probably a config error
> > in setting up you web app with tomcat/struts
> > I work like this: develop in a source directory,
> > then deploy to the
> > servlet container (with ant), with a "clean" target
> > if needed, and then
> > bounce tomcat (and apache, if in the loop). I have
> > even run into the
> > need to shut down tomcat, whack my web app *and*
> > tomcat/work directories
> > before deploying - primarily on Unix. And - turn on
> > as much debugging as
> > possible initially. *Logs are your friend*
> > Many pieces have to be happy for it all to work, and
> > they will be happy
> > to let you know if they don't play well with other
> > children. Also, don't
> > do what I do: fix 50 things at once, instead debug
> > incrementally by
> > changing one thing at a time.
> >
> > Be aware that mysql versions 3.23.36 and below fail
> > miserably with
> > Poolman, as Poolman tries to set transaction levels
> > and mysql barfs in
> > technicolor.
> >
> >
> > Andy Timm wrote:
> > >
> > > Hello. I am trying to implement a DB connection
> > > manager with my Struts webapp. I created a
> > servlet
> > > that gets called when Tomcat is initialized, that
> > > creates a DbConnectionBroker, and puts it in the
> > > ServletContext:
> > > getServletContext().setAttribute("dbPool",
> > dbPool);
> > >
> > > In a 'ActionForm', I'm validating a username
> > against
> > > the database, so I grab the dbPool object to pass
> > into
> > > my database bean:
> > > DbConnectionBroker pool =
> > >
> >
> (DbConnectionBroker)servlet.getServletContext().getAttribute("dbPool");
> > >
> > > This works fine for the first page. When I
> > attempt to
> > > access the next page (any other following page),
> > right
> > > after the "checkLogin" tag is called, it throws
> > the
> > > exception below. Two questions... First, I would
> > > like to utilize Struts datasource mapping, but
> > don't
> > > know how to do so while using a different
> > connection
> > > manager. (There was a post yesterday suggesting
> > > Poolman... ) Second, what am I doing wrong so that
> > I
> > > cannot access my next page? The 'Action' called
> > after
> > > the working page executes normally, then it dies.
> > I'm
> > > loading two servlets (action, and my initDBPool)
> > in
> > > web.xml. Is there some rule about which must be
> > > loaded first? I'm new to the whole servlet thing,
> > but
> > > it seems like it's looking to my initDBPool
> > servlet
> > > for information it should find elsewhere (hence
> > the
> > > IncompatibleClassChangeError). I would be most
> > > grateful if someone could explaine the 'proper'
> > method
> > > for merging connectionPooling with Struts - but
> > I'd be
> > > happy for a solution for my problem at hand too...
> > > Thanks, Andy Timm
> > >
> > > java.lang.IncompatibleClassChangeError
> > > at
> > >
> >
> _0002fregister_0002ejspregister_jsp_0._jspService(_0002fregister_0002
> > > ejspregister_jsp_0.java:578)
> > > at
> > >
> >
> org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
> > > at
> > >
> >
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > at
> > >
> >
> org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspSer
> > > vlet.java:177)
> > > at
> > >
> >
> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:3
> > > 18)
> > > at
> > >
> >
> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:391)
> > > at
> > >
> >
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > at
> > >
> >
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4
> > > 04)
> > > at
> > >
> >
> org.apache.tomcat.core.Handler.service(Handler.java:286)
> > > at
> > >
> >
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372
> > > )
> > > at
> > >
> >
> org.apache.tomcat.facade.RequestDispatcherImpl.forward(RequestDispatc
> > > herImpl.java:194)
> > > at
> > >
> >
> org.apache.struts.action.ActionServlet.processActionForward(ActionSer
> > > vlet.java:1758)
> > > at
> > >
> >
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:159
> > > 5)
> > > at
> > >
> >
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:491)
> > > at
> > >
> >
> javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> > > at
> > >
> >
> javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> > > at
> > >
> >
> org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:4
> > > 04)
> > > at
> > >
> >
> org.apache.tomcat.core.Handler.service(Handler.java:286)
> > > at
> > >
> >
> org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372
> >
> === message truncated ===
>
> __________________________________________________
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for all of
> your unique holiday gifts! Buy at http://shopping.yahoo.com
> or bid at http://auctions.yahoo.com
>
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
Peter Kordel
Software Engineer
Zvolve Systems, Inc.
770-551-4528
http://www.zvolve.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
