Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Java > Java and JDK > JSP Basics
| Search | Today's Posts | Mark Forums Read
JSP Basics Beginning-level questions on JSP. More advanced coders should post to Pro JSP.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the JSP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old September 1st, 2004, 10:50 AM
Registered User
 
Join Date: Jul 2004
Location: Chicago, IL, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to eacostl
Default Struts Data Source

I just wrote a simple search application with Struts, and used the <data-sources> element of struts-config.xml to manage the database connection.
The problem that I am having is that after time, the system stops responding and the logs are filling up with:
org.apache.struts.legacy.GenericDataSource getConnection
INFO: Check for timeout, activeCount=2, useCount=8559

There are plenty of these, several per second.

Section from struts-config
<data-source key="pw">
  <set-property property="password" value="PASS" />
  <set-property property="minCount" value="0" />
  <set-property property="maxCount" value="4" />
  <set-property property="maxWait" value="2500" />
  <set-property property="user" value="USERNAME" />
  <set-property property="driverClass" value="com.mysql.jdbc.Driver"/>
  <set-property property="description" value="FS0" />
  <set-property property="url"
    value="jdbc:mysql://localhost/DBNAME" />
  <set-property property="readOnly" value="true" />
  <set-property property="autoCommit" value="false" />
  <set-property property="loginTimeout" value="2500" />
</data-source>


How can I make this connection work properly?


Similar Threads
Thread Thread Starter Forum Replies Last Post
Struts 2.2, Json data and jsp problem, help pls ish Struts 0 July 8th, 2008 04:59 AM
Displaying data in a struts form - Need help! pintovc@hotmail.com Struts 2 March 13th, 2007 01:17 PM
How to submit repeated data in formbean in struts somnathp Struts 0 July 26th, 2005 12:37 AM
Submit repeated data item in a form using Struts somnathp Javascript How-To 0 July 26th, 2005 12:34 AM
Looking for source code for Professional struts ap right_move Wrox Book Feedback 1 March 7th, 2004 09:45 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.