You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Chris Hall <ch...@yahoo.com> on 2009/09/22 16:16:28 UTC
Problems with Oracle & JDBC query
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
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-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
Another point - I reverted to my original ojdbc14.jar - and it works fine too. No need to update to latest version.
Chris
________________________________
From: sebb <se...@gmail.com>
To: JMeter Users List <jm...@jakarta.apache.org>
Sent: Tuesday, September 22, 2009 5:08:25 PM
Subject: Re: Problems with Oracle & JDBC query
On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
> moving the Request as a Sibling and not a child solved the problem. So simple when you know how :)
It's not supposed to be possible to add Samplers to Config elements -
one cannot do so for most (any?) of the others. Not sure why JDBC
Config allows this; it's a bug...
> The responses are appearing in both listeners now btw.
>
> Thanks Sebb
>
>
>
>
> ________________________________
> From: sebb <se...@gmail.com>
> To: JMeter Users List <jm...@jakarta.apache.org>
>
> Sent: Tuesday, September 22, 2009 4:55:17 PM
>
> Subject: Re: Problems with Oracle & JDBC query
>
> On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
> >
> > My test is as follows now:
> >
> > Plan
> > - View Results Tree
> > - Aggregate Report
> > - Thread Group
> > - Java Request
> > - JDBC Configuration
> > - JDBC Request
>
> Try making the JDBC Request a sibling of the Config - rather than a child.
>
> > - Java Request
> >
>
> Do the Java requests appear in both Listeners?
>
> >
> > 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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > > To: JMeter Users List
> > <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > > >
> > > >
> > > >
> > >
> > >
> > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > jmeter-user-help@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-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by sebb <se...@gmail.com>.
On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
> moving the Request as a Sibling and not a child solved the problem. So simple when you know how :)
It's not supposed to be possible to add Samplers to Config elements -
one cannot do so for most (any?) of the others. Not sure why JDBC
Config allows this; it's a bug...
> The responses are appearing in both listeners now btw.
>
> Thanks Sebb
>
>
>
>
> ________________________________
> From: sebb <se...@gmail.com>
> To: JMeter Users List <jm...@jakarta.apache.org>
>
> Sent: Tuesday, September 22, 2009 4:55:17 PM
>
> Subject: Re: Problems with Oracle & JDBC query
>
> On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
> >
> > My test is as follows now:
> >
> > Plan
> > - View Results Tree
> > - Aggregate Report
> > - Thread Group
> > - Java Request
> > - JDBC Configuration
> > - JDBC Request
>
> Try making the JDBC Request a sibling of the Config - rather than a child.
>
> > - Java Request
> >
>
> Do the Java requests appear in both Listeners?
>
> >
> > 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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > > To: JMeter Users List
> > <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > > > >
> > > > >
> > > >
> > > >
> > ---------------------------------------------------------------------
> > > > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > > >
> > > >
> > > >
> > >
> > >
> > ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> > jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > jmeter-user-help@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-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> > jmeter-user-help@jakarta.apache.org
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
moving the Request as a Sibling and not a child solved the problem. So simple when you know how :)
The responses are appearing in both listeners now btw.
Thanks Sebb
________________________________
From: sebb <se...@gmail.com>
To: JMeter Users List <jm...@jakarta.apache.org>
Sent: Tuesday, September 22, 2009 4:55:17 PM
Subject: Re: Problems with Oracle & JDBC query
On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
>
> My test is as follows now:
>
> Plan
> - View Results Tree
> - Aggregate Report
> - Thread Group
> - Java Request
> - JDBC Configuration
> - JDBC Request
Try making the JDBC Request a sibling of the Config - rather than a child.
> - Java Request
>
Do the Java requests appear in both Listeners?
>
> 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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > To: JMeter Users List
> <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > >
> > > >
> > >
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jmeter-user-help@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-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by sebb <se...@gmail.com>.
On 22/09/2009, Chris Hall <ch...@yahoo.com> wrote:
>
> My test is as follows now:
>
> Plan
> - View Results Tree
> - Aggregate Report
> - Thread Group
> - Java Request
> - JDBC Configuration
> - JDBC Request
Try making the JDBC Request a sibling of the Config - rather than a child.
> - Java Request
>
Do the Java requests appear in both Listeners?
>
> 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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > > To: JMeter Users List
> <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > > >
> > > >
> > >
> > >
> ---------------------------------------------------------------------
> > > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> > >
> > >
> > >
> >
> >
> ---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail:
> jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jmeter-user-help@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-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> jmeter-user-help@jakarta.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
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 <se...@gmail.com>
To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Problems with Oracle & JDBC query
Posted by sebb <se...@gmail.com>.
On 22/09/2009, Chris Hall <ch...@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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> > To: JMeter Users List <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> > >
> > >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
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.
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
Chris
________________________________
From: sebb <se...@gmail.com>
To: JMeter Users List <jm...@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 <ch...@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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by sebb <se...@gmail.com>.
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 <ch...@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 <se...@gmail.com>
> To: JMeter Users List <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
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 <se...@gmail.com>
To: JMeter Users List <jm...@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 <ch...@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-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by sebb <se...@gmail.com>.
On 22/09/2009, Chris Hall <ch...@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-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: Problems with Oracle & JDBC query
Posted by Chris Hall <ch...@yahoo.com>.
Hi Rajiv,
I tried the ojdbc5 and 6 jars (changing my java version appropriately) - but that didnt work.
I have the same problem as I had originally.
Chris
________________________________
From: rpaliath <ra...@hotmail.com>
To: jmeter-user@jakarta.apache.org
Sent: Tuesday, September 22, 2009 3:29:24 PM
Subject: Re: Problems with Oracle & JDBC query
Try using the 11g JDBC drivers. I had success when started using the
"ojdbc6.jar".
Rajiv
Chris Hall 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
>
> 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-tp25530752p25530760.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: Problems with Oracle & JDBC query
Posted by rpaliath <ra...@hotmail.com>.
Try using the 11g JDBC drivers. I had success when started using the
"ojdbc6.jar".
Rajiv
Chris Hall 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
>
> 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-tp25530752p25530760.html
Sent from the JMeter - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org