Thanks Tormod, these drivers seem to work fine with Sql 2000 using JRun tags for Selects, Inserts and Deletes. I'm a little concerned that Microsoft still refers to them as beta though.
-----Original Message----- From: Tormod Hystad [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 12:39 AM To: JRun-Talk Subject: RE: IIS 4 dies, no memory leak: NT4SP6 + JRun 3.0 Test it with the free Microsoft Type 4 JDBC driver for MS SQl Server 2000: http://www.microsoft.com/SQL/downloads/2000/jdbc.asp Source code licenced from Merant, I believe, but packaged and supported as a Microsoft product. It has reasonable performance, from the benchmarks I have seen, only beaten by inet software's drivers. - Tormod -----Original Message----- From: Fishwick, Randall [mailto:[EMAIL PROTECTED]] Sent: 25. oktober 2001 18:30 To: JRun-Talk Subject: RE: IIS 4 dies, no memory leak: NT4SP6 + JRun 3.0 Lars, It appears bug #26844 is related to the supplied JDBC drivers in jrun_drivers.jar. I was getting the following error using the updated jrun_drivers.jar to access SQL Server 2000: "The cursor identifier value provided (abcdef0) is not valid.", and Allaire's response is: "This problem is logged as a bug # 27241. Please refer to next fix and use any other third party JDBC driver for this CMP implementation till that time." We have been using Oracle's Type 4 drivers to access Oracle without problems using the JRun Custom Tag Library. Additionally, I am using the original jrun_drivers.jar supplied with JRun 3.1 to access SQL Server with the Tag Library without a problem. So I'm wondering if using good third party JDBC drivers would eliminate bug #26844? Randy -----Original Message----- From: lars [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 25, 2001 7:35 AM To: JRun-Talk Subject: RE: IIS 4 dies, no memory leak: NT4SP6 + JRun 3.0 Randall: This is a documented (but as-yet unaddressed) bug with the Allaire/Macromedia folks, #26844 according to the JRun forums. Allaire JRun forum links: http://forums.allaire.com/jrun/messageview.cfm?catid=69&threadid=208338 is the first mention of the bug report -- sadly for us, Allaire/Macromedia doesn't publish their bug lists, but no doubt they have their reasons. http://forums.allaire.com/jrun/messageview.cfm?catid=66&threadid=227136 promises a fix "will be released soon" (as of Oct.23rd). Searching the JRun forums for the bug number or "java.lang.OutOfMemoryError" will turn up more references. Also, I started a thread in this list September 13, asking whether anyone had tried using JRun 3.1 with the custom tag library from JRun 3.0 (the Allaire/Macromedia engineers said it was a bad idea). The bug affects only use of the custom tag library for SQL queries -- I presume you're connecting & doing your queries via the usual Java classes. Laurence Middleton code wrangler ecentricarts inc. 416 644-5000 ext.225 > -----Original Message----- > From: Fishwick, Randall [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 23, 2001 2:27 PM > To: JRun-Talk > Subject: RE: IIS 4 dies, no memory leak: NT4SP6 + JRun 3.0 > > > Lars, > > Your background info indicates a "known issue" regarding INSERT & UPDATE > queries using classes12.zip, but we've been running IIS 4 and 5 with 3.1 > JRun using that Oracle JDBC driver for a while without any problems doing > inserts or updates. Where is the problem documented? > > Thanks, > Randy > > -----Original Message----- > From: lars [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 23, 2001 10:29 AM > To: JRun-Talk > Subject: IIS 4 dies, no memory leak: NT4SP6 + JRun 3.0 > > > Hello, all. > > Our customer has a dual-processor Dell server running NT4 SP6 > with JRun 3.0 > installed. The server isn't used for anything except the site we > built them > plus a couple of dev versions which are not in use at present; all > unnecessary services have been turned off. Java version is 1.30_02. > > The behaviour is that IIS stops without warning after hours or a few days. > Task Manager shows no creep or spike in memory usage; there are no useful > entries in either the NT logs or JRun's logs (which have had all > the options > turned on, to catch as much as possible). > > Other background: the JRun installation cannot be upgraded from 3.0 to 3.1 > because of the known issue in which the 3.1 custom taglib cannot perform > INSERT & UPDATE queries thru the classes12.zip Oracle thin > driver. (The live > version of the site does not at present use the Oracle data source; that > phase is due to roll out in a few weeks.) > The JRun 3.0 installation is fully up-to-date with service packs. > > The customer has opened a ticket with Microsoft support and obtained a > number of tools for monitoring and testing their server. One of them > provided a dump which was excerpted to us as follows: > > ===== > > There is a second chance dump: > PID-196__Inetinfo.exe__Date_10-17-2001__Time_18-55-53PM__2nd_chanc > e_access_v > iolation__full.dmp > > Partial stack: > > 025ee694 77f76406 025ee6ac 025ee6c8 025ee6ac > ntdll!RtlDispatchException+0x77 > 025ee790 77f97396 025ee858 025efc7c 025ee874 > ntdll!KiUserExceptionDispatcher+0xe > 025ee7b4 77f8926b 025ee858 025efc7c 025ee874 ntdll!ExecuteHandler+0x26 > 025ee840 77f76406 025ee858 025ee874 025ee858 > ntdll!RtlDispatchException+0x77 > 025ee93c 77f97396 025eea04 025efc7c 025eea20 > ntdll!KiUserExceptionDispatcher+0xe > 025ee960 77f8926b 025eea04 025efc7c 025eea20 ntdll!ExecuteHandler+0x26 > 025ee9ec 77f76406 025eea04 025eea20 025eea04 > ntdll!RtlDispatchException+0x77 > 025eeae8 100020e4 025efb98 00000009 10007314 > ntdll!KiUserExceptionDispatcher+0xe > 10007314 50545448 00000000 48206e49 45707474 jrun!HttpFilterProc+0x814 > 5f4c4c41 00000000 00000000 00000000 00000000 0x50545448 > > ===== > > The conclusion of the MS person was that "E:\InetPub\scripts\jrun.dll is > failing". (We don't know how to read the dump so can't agree or disagree.) > > Questions: > - has anyone had similar experiences? The distinguishing feature: > IIS stops > but with no sign of increased memory use. > - There was a newer jrun.dll posted in thread: > http://forums.allaire.com/jrun/messageview.cfm?catid=69&threadid=216877 > Can I replace the existing jrun.dll (from JRun 3.0) with this newer > version, NOT upgrading JRun to 3.1? > - Is there a known bug or issue I can track? (didn't find a close match to > my customer's symptoms in the forums) > > -- Laurence > > Laurence Middleton > code wrangler > ecentricarts inc. > 416 644-5000 ext.225 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists