Hi,
I'm trying to use Turbine database connection pooling engine with my
Tomcat-based jsp application.
I configured PoolBrokerService, MapBrokerService, ResourceService and
LoggingService and
my database parameters:
database.default.driver=com.sybase.jdbc2.jdbc.SybDriver
database.default.url=jdbc:sybase:Tds:10.0.0.1:4100/dbname
database.default.username=user
database.default.password=pass
database.default.maxConnections=5
database.default.expiryTime=3600000
database.connectionWaitTimeout=10000
database.logInterval=30000
database.adaptor=DBSybase
database.adaptor.DBSybase=com.sybase.jdbc2.jdbc.SybDriver
database.idbroker.cleverquantity=true
This is how I start Turbine services - as a servlet in web.xml
<servlet>
<servlet-name>
Turbine
</servlet-name>
<servlet-class>
org.apache.turbine.Turbine
</servlet-class>
<init-param>
<param-name>properties</param-name>
<!-- This is relative to the docBase -->
<param-value>
/WEB-INF/conf/TurbineResources.properties
</param-value>
</init-param>
<load-on-startup>5</load-on-startup>
</servlet>
It all works at the beginning - I'm able to get and release connections
without any problems,
BUT when I leave Tomcat running idle for a long time - overnight when I go
home - and try to
access my application in the morning, all of a sudden the application can't
get a database connection
and Tomcat shows the following exception in its log:
org.apache.turbine.services.InstantiationException: ServiceBroker: unknown
service PoolBrokerService
requested
so I have to restart Tomcat to get it back to work.
It all looks like it gets garbage collected, unloaded or something.
Any help will be greatly appreciated.
Alexander Vorobiev
---------------------------------------------------------------------------
This message (including any attachments) is confidential and may be
privileged. If you have received it by mistake please notify the sender by
return e-mail and delete this message from your system. Any unauthorized
use or dissemination of this message in whole or in part is strictly
prohibited. Please note that e-mails are susceptible to change. ABN AMRO
Bank N.V. (including its group companies) shall not be liable for the
improper or incomplete transmission of the information contained in this
communication nor for any delay in its receipt or damage to your system.
ABN AMRO Bank N.V. (or its group companies) does not guarantee that the
integrity of this communication has been maintained nor that this
communication is free of viruses, interceptions or interference.
---------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
