Thanks for your tip.
Where do I get more Infos about the parameters you have set (any good web
adress)?
Am I able to set all of this parameters (I use Oracle DB) or is this
dependend on the driver?
ConnectionPooling must be implemented within the dbDriver?
Do I have to devide statements and prepared statements in the config file?
Greetings, Manuel
An
"Struts Users Mailing List"
shankarr <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> Kopie
17.02.2004 12:54
Thema
Re: No Action is executed
Bitte antworten an
"Struts Users Mailing List"
<[EMAIL PROTECTED]
org>
Hi Manuel,
Do have a look at my data source configuration. Probably, it might help.
Set the timeout value lower and try.
<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="org.gjt.mm.mysql.Driver" />
<set-property property="url" value="jdbc:mysql://localhost/" />
<set-property property="maxCount" value="500"/>
<set-property property="minCount" value="10"/>
<set-property property="minIdle" value="10"/>
<set-property property="testWhileIdle" value="true"/>
<set-property property="timeBetweenEvictionRunsMillis"
value="1800"/>
<set-property property="testOnBorrow" value="true"/>
<set-property property="maxActive" value="8"/>
<set-property property="maxIdle" value="2"/>
<set-property property="poolPreparedStatements" value="true"/>
<set-property property="maxOpenPreparedStatements" value="2500"/>
<set-property property="removeAbandoned" value="true"/>
<set-property property="removeAbandonedTimeout" value="3"/>
<set-property property="logAbandoned" value="true"/>
<set-property property="validationQuery" value="select 1+1"/>
<set-property property="user" value="root"/>
<set-property property="password" value=""/>
</data-source>
</data-sources>
Richie
At 01:48 PM 2/17/2004, you wrote:
>Hi to all,
>my struts-webApplication is used by almost 80 people.
>After 1-2 weeks my application doesn´t react anymore,
>if I do call an ActionClass which will connect to an oracle database.
>
>So I guess I do have a problem with the database connection.
>My database config shows that:
> <data-source>
> <set-property property="driverClass"
>value="oracle.jdbc.driver.OracleDriver"/>
> <set-property property="url"
>value="jdbc:oracle:thin:@hostname:1521:tablespace"/>
> <set-property property="maxCount" value="20"/>
> <set-property property="minCount" value="1"/>
> <set-property property="user" value="test"/>
> <set-property property="password" value="test"/>
> </data-source>
>
>
>I do work with normal statements and with prepared statements.
>I guess there might by to much opened result sets, statements and database
>connection.
>But our serverAdministrator says, that there are only 5 unused database
>connections left. Max value is 20.
>
>Does anybody have an idea?
>
>Greetings, Manuel
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
"To achieve all that is possible, one must attempt the impossible"
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
