File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Connection pooling problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Connection pooling problem " Watch "Connection pooling problem " New topic

Connection pooling problem

Deepthi Mudidani

Joined: Jan 24, 2006
Posts: 19
Hi Iam using tomcat 5.5.7 and oracle 9i and struts 1.2.8.
I have configured a connection pool jdbc/myoracle in server.xml and web.xml.
When i try to access the jsp which calls UserRegAction it throws this exception.

contents of server.xml includes..

in web.xml

and the UserRegAction contains

Iam not sure if this is a struts specific problem or not.
amit bhadre
Ranch Hand

Joined: Jan 23, 2006
Posts: 124
Hi Deepti

Be confirm on what u r doing...Be confident on ur side...then ask questions on corresponding forums...OK

OK I try to solve ur problem....

Well if u r doing in JSP den write one another jsp page and make it as isErrorpage. Then u r getting Servlet exception means is JSP or Server error dont get too knock head cool. Den make page which is throwing error redirect to that new created page.

Try it....

How the gc() come to know that the objects are no longer usable ? There may be case of objects later may be used....then big dragging back of int it...? :-)

["If C & C++ are sea and Java is Ocean/Galaxies/ whole Universe"]

amit bhadre

Thanks advance who ever answers this question.

amit bhadre
Deepthi Mudidani

Joined: Jan 24, 2006
Posts: 19
Thanks for ur suggestion
The problem is with the configuration element in server.xml
With tomcat 5.5 we should use
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc racle:thin:@localhost:1521 racle"
username="scott" password="tiger" maxActive="4" maxIdle="2"
I agree. Here's the link:
subject: Connection pooling problem
jQuery in Action, 3rd edition