Connection Pool

[rmarkert]

I use two classes to ConnectionPool: DBConnectionPool and DBConnectionPool.
Where do they be located?
I put them at my Servlets directory... but I read an article that say that they must be located at the CLASSPATH used by the Servlet Engine. What is this ?

Thanks, Renata

 

[wushutwist]

I have to say that I am a bit confused by your post...

Anyways, are you saying that you wrote your own connection pool? If so then I urge you to invest a little time into researching the capabilities of your Application Server. Nearly all, including Tomcat, support connection pooling out of the box so to speak. Much better to go with a well tested and proven solution than rolling your own.

Now about where to put the classes... if you are only using Servlets/JSP than your classes will either go under WEB-INF/classes or if you decide to make it more modular put it under WEB-INF/lib. Are you even creating a war?

If the connection pool is being used by other components such as EJBs than it must either go on the CLASSPATH, in each EJB that uses it, or in the ear with a Class-Path manifest entry.

J2EE is just full of packaging and deployments issues. Have fun.

 

[rmarkert]

Thank you very much!
I'm using only JSP and Servlets!
So I put them under WEB-INF/classes!