If it's due to connection losses, I've normally got something like this in
tomcat server.xml (with my driver in TOMCAT_HOME/common/lib):
<Resource name="jdbc/mysql" type="javax.sql.DataSource" auth="Container"/>
<ResourceParams name="jdbc/mysql">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
[...] Usual username/pswd/url params<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>0</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>60000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<value>300</value>
</parameter>
</ResourceParams>
With other servers, the configuration can be defined elsewhere, can't
necessarily help you to locate the config files, but the params should be
the same,
hth,
sv
On Sun, 28 Aug 2005, Satyanarayana Desu wrote:
Hi sv,
We are using mysql as the backend database and manipulating using Torque
services. can you please let me know where shoud I need to specify the
connection setting for checking it.
Regds
Satya
[EMAIL PROTECTED] 08/26/05 10:14 PM >>>
Hi Satya,
It might be a driver problem. Do you use mysql with a connection pool? If
so, you need to specify when to check if the connections have been closed
(by the db). If this is the problem, I can probably help you out.
HTH,
sv
On Fri, 26 Aug 2005, Satyanarayana Desu wrote:
Hi,
For the turbine based applications, if the server is idle for 24 hours,
the Login (Authentication, Login.vm) page does not respond for the first 3
attempts, it says invalid user/password even if we give the right userid and
password.
it works well for the fourth attempt.
we are doing a workaround for this is restarting the server through crontab for
every 24 hrs.
can you pl. suggest a remedy for it.
Regds
Satya
---------------------------------
Start your day with Yahoo! - make it your home page
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------
Start your day with Yahoo! - make it your home page
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
