This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
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

Win a copy of Elasticsearch in Action this week in the Big Data forum!
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"
Consider Paul's rocket mass heater.
subject: Connection pooling problem