I am using the JRun 3.0 JDBC datasource facility, and am slightly confused by the 2 settings for connection pooling. 1. 'Timeout: Does this timeout refer to the connection between JRun and the database, or does it refer to a connection which has been 'borrowed' from the pool by a request? 2. Interval: This refers to the interval after which a separate process will clean up 'stale' connections. Is a 'stale' connection one which has been borrowed from the pool and not yet returned, or does it refer to a connection between the connection pool and the database which ahs not been used for the specified period? Whichever the case, I assume that a stalle connection is defined by being one which has been around for longer than its 'Timeout' period. What I'm trying to achieve is for a connection to be maintained to the database for a long period, so that it is always available in the connection pool for new requests. In my application, the requests themselves need to borrow a connection for a very short & simple query, but there may be large numbers of requests made over a short period. Apologies if these seem like stupid questions - I think I may be be missing something here.... Thank in advance for any advice/clarification. Paul ---------------------------- Paul Walk Intranet Services University of North London Email: [EMAIL PROTECTED] Telephone (Direct Dial): 020 7753 3288 Telephone (Switchboard): 020 7607 2789 ext. 2690 ---------------------------- ------------------------------------------------------------------------------ Archives: http://www.egroups.com/group/jrun-interest/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
