----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hello All,
I have posted about this previously and got no response, I've ran
the system for another week or so and I am still having the same problem.
When a servlet is initialised it is not being destroyed for quite a
long period of time, now if this servlet was in constant use during this
period I could understand this long time period. But the server is only
really used on a Monday as it is used for entering timesheet information
into a database (using JDBC). Here's my jserv log file to show just how
long the servlets are been loaded for:
[16/05/2000 08:03:57:468 GMT] GenerateTimeSheet: init
[16/05/2000 08:16:14:109 GMT] GenerateLogon: init
[16/05/2000 08:17:01:000 GMT] LoggedOn: init
[16/05/2000 08:17:05:203 GMT] GenerateBlankTimesheet: init
[16/05/2000 09:45:44:921 GMT] ReviewTimesheet: init
[16/05/2000 09:45:49:609 GMT] ReviewTeamTimesheets: init
[17/05/2000 08:24:52:578 GMT] GenerateWorkPackList: init
[17/05/2000 11:58:48:546 GMT] GenerateTimeSheet: destroy
[17/05/2000 11:58:48:703 GMT] GenerateWorkPackList: destroy
[17/05/2000 11:58:48:718 GMT] ReviewTeamTimesheets: destroy
[17/05/2000 11:58:48:750 GMT] ReviewTimesheet: destroy
[17/05/2000 11:58:48:750 GMT] LoggedOn: destroy
[17/05/2000 11:58:48:765 GMT] GenerateLogon: destroy
[17/05/2000 11:58:48:781 GMT] GenerateBlankTimesheet: destroy
Now this usually wouldn't create a problem but the JDBC-ODBC bridge
driver in conjunction with Access has a problem which means a connection to
a database is only valid for a finite number of accesses. I could change
the code so that for every access a new connection is created but this would
greatly decrease the speed of the servlet.
I would like JServ to unload the server after a short period of time
(say 5 minutes). Is this possible and if so how would I do this?
Cheers,
Rich.
Richard A. Begg
�
Serco Technology,
Guisborough,
England.
e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
