My test is as follows now:

Plan
 - View Results Tree
 - Aggregate Report
 - Thread Group
     - Java Request
     - JDBC Configuration
         - JDBC Request
     - Java Request


2009/09/22 16:44:38 INFO  - jmeter.engine.StandardJMeterEngine: Running the 
test! 
>2009/09/22 16:44:39 INFO  - jmeter.gui.util.JMeterMenuBar: 
>setRunning(true,*local*) 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Starting 1 
>threads for group Thread Group. Ramp up = 1. 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Continue on 
>error 
>2009/09/22 16:44:43 INFO  - jmeter.threads.JMeterThread: Thread Thread Group 
>1-1 started 
>2009/09/22 16:44:43 INFO  - jmeter.threads.JMeterThread: Thread Thread Group 
>1-1 is done 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Ending thread 
>Thread Group 1-1 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Stopping test 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Notifying test 
>listeners of end of test 
>2009/09/22 16:44:43 INFO  - jmeter.gui.util.JMeterMenuBar: 
>setRunning(false,*local*) 
>2009/09/22 16:44:43 INFO  - jmeter.engine.StandardJMeterEngine: Test has ended 



________________________________
From: sebb <seb...@gmail.com>
To: JMeter Users List <jmeter-user@jakarta.apache.org>
Sent: Tuesday, September 22, 2009 4:21:45 PM
Subject: Re: Problems with Oracle & JDBC query

On 22/09/2009, Chris Hall <chrishall...@yahoo.com> wrote:
> Hi Sebb,
>   ok - I disabled debug in log4j, lowered the thread count to 1 and added the 
> new java samplers before & after.
>   Neither appear in my results tree - but both do in my Aggregate Report 
> Listener.

That will depend where you put the listeners; I suggest you put them
at top-level in the thread group (or even directly under the test
plan).

>   The same problem exists - with no errors thrown in the console.
>   My jmeter.log now looks like so for the test run:
>
>  2009/09/22 15:59:51 INFO  - jmeter.gui.util.JMeterMenuBar: 
> setRunning(true,*local*)
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Starting 1 
> threads for group Thread Group. Ramp up = 1.
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Continue on 
> error
>  >2009/09/22 15:59:51 INFO  - jmeter.threads.JMeterThread: 
> jmeterthread.startearlier=true (see jmeter.properties)
>  >2009/09/22 15:59:51 INFO  - jmeter.threads.JMeterThread: Running 
> PostProcessors in forward order
>  >2009/09/22 15:59:51 INFO  - jmeter.threads.JMeterThread: Thread Thread 
> Group 1-1 started
>  >2009/09/22 15:59:51 INFO  - jmeter.threads.JMeterThread: Thread Thread 
> Group 1-1 is done
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Ending 
> thread Thread Group 1-1
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Stopping 
> test
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Notifying 
> test listeners of end of test
>  >2009/09/22 15:59:51 INFO  - jmeter.gui.util.JMeterMenuBar: 
> setRunning(false,*local*)
>  >2009/09/22 15:59:51 INFO  - jmeter.engine.StandardJMeterEngine: Test has 
> ended

OK, so no errors reported, but the test lasts less than a second,
which suggests the JDBC sampler may not have been run.

>  Chris
>
>
>
>  ________________________________
>  From: sebb <seb...@gmail.com>
>  To: JMeter Users List <jmeter-user@jakarta.apache.org>
>
> Sent: Tuesday, September 22, 2009 3:51:44 PM
>
> Subject: Re: Problems with Oracle & JDBC query
>
>  Try adding Java samplers before and after the JDBC sampler and make
>  sure they show up in the listener.
>
>  Check the console window for any errors - sometimes JMeter is unable
>  to capture all errors.
>
>  Unless you know the code well, I would switch off debug logging - it
>  makes the log file harder to read. If you want to use debug, just
>  enable it for the JDBC sampler (you can do this from the Help menu)
>
>  Start with 1 thread; I suggest you use a max pool of 0 to disable
>  connection pooling.
>
>  On 22/09/2009, Chris Hall <chrishall...@yahoo.com> wrote:
>  > I already have one in place - nothing is being displayed there either.
>  >
>  >  I can see the "green light" go - run for a second or so - then complete.
>  >
>  >
>  >
>  >  ________________________________
>  >  From: sebb <seb...@gmail.com>
>  >  To: JMeter Users List <jmeter-user@jakarta.apache.org>
>  >  Sent: Tuesday, September 22, 2009 3:27:21 PM
>  >  Subject: Re: Problems with Oracle & JDBC query
>  >
>  >
>  >  On 22/09/2009, Chris Hall <chrishall...@yahoo.com> wrote:
>  >  >
>  >  >  Hi guys,
>  >  >   I've searched the forums for a similar problem - and I havent found 
> any
>  >  >  like this one.
>  >  >   When I'm running a basic "select count(*)...." - nothing seems to 
> happen
>  >  >  in JMeter - and I've no errors etc in the logs.
>  >  >
>  >  >   I added both classes12.jar & ojdbc14.jar to my %JMETER%/lib directory.
>  >  >
>  >  >   I've setup my test-plan as follows:
>  >  >
>  >  >  Thread Group
>  >  >   - JDBC Connection Configuration
>  >  >       -JDBC Request
>  >
>  >  Add a View Results Tree Listener
>  >
>  >  >  My Configuration is like so:
>  >  >  Database URL: jdbc:oracle:thin:@127.0.0.1:1521:xe
>  >  >  JDBC Driver Class: oracle.jdbc.driver.OracleDriver
>  >  >  UserName: myUser
>  >  >  Password: myPassword
>  >  >
>  >  >  I've attached the jmeter.log which I hope might help...
>  >  >  http://www.nabble.com/file/p25530752/jmeterJDBC.log jmeterJDBC.log
>  >  >
>  >  >  Thanks all,
>  >  >  Chris
>  >  >
>  >  >
>  >  >  --
>  >  >  View this message in context: 
> http://www.nabble.com/Problems-with-Oracle---JDBC-query-tp25530752p25530752.html
>  >  >  Sent from the JMeter - User mailing list archive at Nabble.com.
>  >  >
>  >  >
>  >  >  ---------------------------------------------------------------------
>  >  >  To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
>  >  >  For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
>  >  >
>  >  >
>  >
>  >  ---------------------------------------------------------------------
>  >  To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
>  >  For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
>  >
>  >
>  >
>
>  ---------------------------------------------------------------------
>  To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
>  For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org
>
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscr...@jakarta.apache.org
For additional commands, e-mail: jmeter-user-h...@jakarta.apache.org

Reply via email to