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 mesaj� gizli olup, ayn� zamanda ayr�cal�kl�
olabilir; �artlar ne olursa olsun, g�ndericinin �nceden onay�n� almaks�z�n,
ba�kalar�na iletmemeniz, i�eri�ini kopyalamaman�z veya ba�kalar�na
a��klamaman�z gerekmektedir. Bu mesaj�n muhatab� de�ilseniz, bu durumu
derhal taraf�m�za bildirmenizi rica ederiz.
Internet �zerinden yap�lan ileti�im g�venli olmay�p, verilerin kasten veya
tesad�fen bozulmas� ve vir�s i�ermesi olas�l��� vard�r. Ayr�ca, elektronik
posta, resmi olmayan ve �o�unlukla k�salt�lm�� bir ileti�im y�ntemidir.
Dolay�s�yla, burada yer alan bilgi veya tavsiyelere, g�nderici ile ayr�ca
g�r��meden g�venmeniz normal �artlar alt�nda uygun olmayacakt�r.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
