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]

Reply via email to