Thanks for the tip!
On Thursday, August 23, 2001 10:48 AM, Mohamed Bangura [SMTP:[EMAIL PROTECTED]]
wrote:
> I don't know how you close your connections, but it's common for an
> application to encounter non-Sql errors before it hits the code for closing
> a connection. This results in outstanding connections accumulating outside
> the pool. The best option is always to include the code for closing
> connections inside a "finally" method. Since the "finally" method is always
> executed, you're guaranteed your code for closing the connection is called.
>
> Also, new JSP programmers have the bad habit of inserting the JSP forward or
> redirection tag before the code that closes the connection. Make sure you do
> the reverse as this is a common connection pool time bomb!
> Mohamed.
>
> -----Original Message-----
> From: Robert Jose [mailto:[EMAIL PROTECTED]]
> Sent: 23 August 2001 15:13
> To: JRun-Talk
> Subject: RE: MS-SQL Connections are increasing- JRUN pooling???
>
>
> Don't count on it fixing your problems. I am having similar problems with
> Jrun 3.1. A couple of differences are I am using IIS 4.0 and I use the JDBC
> drivers from Merant (provided by Jrun). My connections seem to release
> though, so maybe you will be ok. I am still trying to find out what my
> problem is exactly. The only thing that I know is that around 12 hours
> after restarting the servers (both SQL and Jrun), the SQL Server crashes
> hard.
>
> If you find a solution to your problem, please let me know, maybe there is a
> tie in someplace.
>
> Thanks
> Rob
>
> -----Original Message-----
> From: Mohamed Bangura [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 23, 2001 12:48 AM
> To: JRun-Talk
> Subject: RE: MS-SQL Connections are increasing- JRUN pooling???
>
> This is a well known problem with the version of JRun you're using. The best
> advice is for you to upgrade to 3.1 for free. This will fix all of your JDBC
> problems!
> Mohamed.
>
> -----Original Message-----
> From: Arif Senol [mailto:[EMAIL PROTECTED]]
> Sent: 23 August 2001 08:41
> To: JRun-Talk
> Subject: MS-SQL Connections are increasing- JRUN pooling???
>
>
> Hi all,
>
> I am using JRun 3.0 Service Pack 2a Version 3.02a.11614 on Netscape
> EnterPrise 4.1. I am using Weblogic JDBC drivers to connect to MS-SQL 7.0
> DB. I am using JRUN's connection pooling to connect to DB. I have created
> JDBC data source for my DB connection inn JRUN admin console. Than I used
> this data source in my JSPs. I open connection , execute my statements and
> close connection.
>
> The problem is after a while the number of SQL server processes are
> increasing.This means alot of memory&CPU usage When I checked the SQL server
> Process info after 2 days I restarted SQL server, I saw many connections are
> waiting on sleeping mode which is created by my applications and weblogic
> drivers. I traced SQL server for invalid statement executions but nothing
> found. I think JRUN cannot release the connections. May be because of
> drivers. I also have some servlets using stored procedures from another
> MS-SQL server but they didnot cause any problems. Only for these jsp files
> and this SQL server! servlets also working with same method (JRUN data
> sources).
>
> Can somebody help me to solve this problem?
>
> M. Arif Senol
> Technology Integration
> Global Securities
> Phone: +90-212-2114900x1731
> mailto: [EMAIL PROTECTED]
>
>
>
>
>
> NOTE: This e-mail is confidential and may also be privileged; under no
> circumstances should you forward it, or copy or disclose its contents, to
> any other person without the prior consent of the sender. If you are not an
> intended recipient of this e-mail, please notify us immediately.
> Internet communications are not secure and subject to possible data
> corruption, either accidentally or on purpose, and may contain viruses.
> Furthermore e-mail is an informal and often abbreviated method of
> communication. For these reasons, it will normally be inappropriate to rely
> on any information or advice contained herein without also discussing it
> with the sender.
>
> (The note below is a Turkish version of the above disclaimer)
>
> NOT: Bu elektronik posta mesajy gizli olup, ayny zamanda ayrycalykly
> olabilir; ?artlar ne olursa olsun, gondericinin onceden onayyny almaksyzyn,
> ba?kalaryna iletmemeniz, iceri?ini kopyalamamanyz veya ba?kalaryna
> acyklamamanyz gerekmektedir. Bu mesajyn muhataby de?ilseniz, bu durumu
> derhal tarafymyza bildirmenizi rica ederiz.
> Internet uzerinden yapylan ileti?im guvenli olmayyp, verilerin kasten veya
> tesadufen bozulmasy ve virus icermesi olasyly?y vardyr. Ayryca, elektronik
> posta, resmi olmayan ve co?unlukla kysaltylmy? bir ileti?im yontemidir.
> Dolayysyyla, burada yer alan bilgi veya tavsiyelere, gonderici ile ayryca
> goru?meden guvenmeniz normal ?artlar altynda uygun olmayacaktyr.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
