Re: No Action is executed

[shankarr]

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"