Hi Sebb - Apologies for the late response.
2005/04/29 07:13:33 INFO - jmeter.JMeter: Version 2.0.2 2005/04/29 07:13:33 INFO - jmeter.JMeter: java.version=1.4.2_07 2005/04/29 07:13:33 INFO - jmeter.JMeter: Copyright (c) 1998-2004 The Apache Software Foundation 2005/04/29 07:13:50 INFO - jmeter.gui.action.Load: Loading file: C:\Projects\xACT\- Software\xACTGateway\tests\jMeter\xActTest.jmx 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Running the test! 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: About to call test listeners 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listener: org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listener: org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listener: org.apache.jmeter.reporters.ResultCollector 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listener: org.apache.jmeter.gui.MainFrame 2005/04/29 07:14:04 INFO - jmeter.gui.util.JMeterMenuBar: setRunning(true,local) 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Starting 1 threads for group Thread Group. Ramp up = 1. 2005/04/29 07:14:04 INFO - jmeter.engine.StandardJMeterEngine: Continue on error 2005/04/29 07:14:04 INFO - jmeter.threads.JMeterThread: Thread Thread Group 1-1 started 2005/04/29 07:14:06 INFO - jmeter.threads.JMeterThread: Thread Thread Group 1-1 is done 2005/04/29 07:14:06 INFO - jmeter.engine.StandardJMeterEngine: Notifying listeners of end of test 2005/04/29 07:14:06 INFO - jmeter.engine.StandardJMeterEngine: Notifying test listener: org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler This is all that's being logged before jMeter hangs. There are two JDBC samplers - one for Oracle and one for MSSQL. You'll see at the end that there's one notification, when there should be two - I imagine that it's hanging, like you've suggested, while trying to close the connection. I can't figure out if it's the MSSQL or ORACLE jdbc driver that's having the problem... -----Original Message----- From: sebb [mailto:[EMAIL PROTECTED] Sent: 19 April 2005 01:07 PM To: JMeter Users List Subject: Re: Oracle JDBC Sampler problem On 4/19/05, Kumar Krishnan (K) <[EMAIL PROTECTED]> wrote: > Hi all - > > I seem to be having a problem with a jdbc request sampler. I've got > two - one for ms sql server and one for oracle. > The tests execute alright, but jmeter seems to hand indefinitely. I > think the notfication of the test end seems to fail. > This occurs everytime I include an oracle jdbc sampler - it's not a > problem with the ms sql server jdbc sampler. > > Has anyone ever had this problem? Maybe there's a bug in the oracle > jdbc implementation? > > Here's a sample of my jmeter log file - it doesn't get beyond the > notification at the end... > > 2005/04/19 09:04:14 INFO - jmeter.engine.StandardJMeterEngine: > Continue on error > 2005/04/19 09:04:14 INFO - jmeter.threads.JMeterThread: Thread Thread > Group 1-1 started > 2005/04/19 09:04:37 INFO - jmeter.assertions.BeanShellAssertion: > Running InValidSchedule : > 2005/04/19 09:04:37 INFO - jmeter.assertions.BeanShellAssertion: > <?xml version="1.0" encoding="utf-8"?><soap:Envelope > xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" > xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><VerifyStatusR > esponse > xmlns="http://Telkom.co.za"><VerifyStatusResult><Parameters><Item><Nam > e>Result</Name><Value>OK</Value></Item><Item><Name>TransactionStartTim > e</Name><Value>09:04 > AM</Value></Item><Item><Name>TransactionEndTime</Name><Value>09:04 > AM</Value></Item></Parameters></VerifyStatusResult></VerifyStatusRespo > nse></soap:Body></soap:Envelope> > 2005/04/19 09:04:37 INFO - jmeter.assertions.BeanShellAssertion: > Running InValidSchedule : > 2005/04/19 09:04:37 INFO - jmeter.assertions.BeanShellAssertion: > Description > Passed > 2005/04/19 09:04:37 INFO - jmeter.threads.JMeterThread: Thread Thread > Group 1-1 is done > 2005/04/19 09:04:37 INFO - jmeter.engine.StandardJMeterEngine: > Notifying listeners of end of test > 2005/04/19 09:04:37 INFO - jmeter.engine.StandardJMeterEngine: > Notifying test listener: > org.apache.jmeter.protocol.jdbc.sampler.JDBCSampler > Does the last sample complete OK? What does the MS JDBC test look like at the end of the log file? Looks there may be a problem closing the JDBC Connection. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

