Mailing-List: contact user-help@jmeter.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "JMeter Users List" <user@jmeter.apache.org>
Subject: Re: Trying to setup test plan for Oracle Database
To: user@jmeter.apache.org
References: <1887406832.887791.1481056944048.ref@mail.yahoo.com>
 <1887406832.887791.1481056944048@mail.yahoo.com>
From: Felix Schumacher <felix.schumacher@internetallee.de>
Message-ID: <24cfbdbd-c8f9-2db5-4bd2-7b61bf4d556c@internetallee.de>
Date: Tue, 6 Dec 2016 21:47:22 +0100
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.5.1
MIME-Version: 1.0
In-Reply-To: <1887406832.887791.1481056944048@mail.yahoo.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
archived-at: Tue, 06 Dec 2016 20:47:29 -0000

Am 06.12.2016 um 21:42 schrieb o haya:
> Hi,
>
> Thanks for your help.  Got it working.
>
> To repeat, if I leave out the Validation query, I get an error (that was just to kind of make it clear).
Can you tell us, what version of ojdbc you are using? Or even better, 
try with a recent one, see if it works and report back?

Felix
>
> For Validation query, I have to have:
>
> select 1 from dual   --> with NO ending semi-colon
>
>
>
> For the JDBC query, I have to have:
>
> select * from departments   --> with NO ending semi-colon
>
>
>
> Now it works.  Picky, picky :)!!
>
>
> Now I have to setup some loops or something with different users.
>
>
> Thanks!
>
> Jim
>
>
>
>
>
>
>
>
> --------------------------------------------
> On Tue, 12/6/16, Felix Schumacher <felix.schumacher@internetallee.de> wrote:
>
>   Subject: Re: Trying to setup test plan for Oracle Database
>   To: user@jmeter.apache.org
>   Date: Tuesday, December 6, 2016, 3:37 PM
>   
>   Am 06.12.2016 um 21:34
>   schrieb o haya:
>   > Hi,
>   >
>   > Validation Query:
>   >
>   > Hmm.  I got a
>   different error if I leave this out, and yes, that was a
>   typo on my part.  I already had it as:
>   >
>   > select 1 from
>   dual;
>   Can you post the error you get? (The
>   isValid method is relatively new,
>   so you
>   should use a recent oracle jdbc driver. I think that should
>   be
>   ojdbc6.jar)
>   >
>   >
>   >
>   >
>   About the URL, yes, again, my typing error here, it was
>   already a ":"
>   >
>   >
>   > So still getting the
>   same error, but don't know why.  I remember doing this
>   (Jmeter+Oracle ) a long long time ago, and don't
>   remember it being this difficult, plus I am following most
>   of my old notes.
>   Have you removed the
>   semicolons?
>   
>   Do you have any
>   error/warning logs in jmeter.log?
>   
>   Felix
>   >
>   >
>   Thanks,
>   > Jim
>   >
>   >
>   >
>   >
>   >
>   --------------------------------------------
>   > On Tue, 12/6/16, Felix Schumacher <felix.schumacher@internetallee.de>
>   wrote:
>   >
>   >   Subject: Re: Trying to setup
>   test plan for Oracle Database
>   >   To: user@jmeter.apache.org
>   >   Date: Tuesday, December 6,
>   2016, 3:27 PM
>   >
>   >   Am 06.12.2016 um 21:21
>   >   schrieb o haya:
>   >   > Hi,
>   >   >
>   >   > I'm just starting
>   >   to try to setup a test plan
>   for testing Oracle Database
>   >   using Jmeter 3.1.  The
>   Jmeter is running on Windows.
>   >   >
>   >   > I have setup the test
>   >   plan with:
>   >   >
>   >   > Thread
>   >   Group
>   >   >      - JDBC
>   Connection
>   >   Configuration
>   >   >      - JDBC
>   Request
>   >   >      -
>   View results in tree
>   >   >
>   >   > I have added
>   >   ojdbc.jar to the Jmeter's
>   'lib' directory
>   >   >
>   >   > For the JDBC
>   >   Connection Configuration, I
>   have:
>   >   >
>   >   Variable Name: mydb
>   >   >
>   >   > Validation Query: select
>   * from dual;
>   >   With 3.1 you
>   can leave the validation query
>   >   empty and the pool will
>   try
>   >   to use the jdbc
>   >   method isValid to validate
>   the connection. If you want
>   >   to specify a validation query
>   by hand, the
>   >   usual query
>   for oracle is
>   >   "select
>   1
>   >   from dual".
>   >   >
>   >   >
>   >   Database URL:
>   >   jdbc.oracle:thing:@//myhostname:myhostport/mysid
>   >   The . between jdbc and oracle
>   looks like a
>   >   typo, I think
>   there should be
>   >   a colon
>   and
>   >   the "thing"
>   is probably a typo and should be
>   >   "thin", right?
>   >   > Username:
>   >   <db username>
>   >   > Password: <db
>   >   password>
>   >   >
>   >   >
>   >   >
>   >   > For the JDBC Request
>   >   I have is:
>   >   > Vraiable name: mydb
>   >   > Query Type: Select
>   >   >
>   >   Query has: select * from
>   departments;
>   >   >
>   >   > Handle Result Set:
>   >   Store as string (this is
>   grayed out)
>   >   >
>   >   >
>   >   >
>   >   >
>   >   When I run the test plan I am
>   getting:
>   >   >
>   >   > Sampler result:
>   >   > Thread Name: Thread
>   Group 1-1
>   >   > Sample
>   Start: 2016-12-06 15:18:03 EST
>   >   > Load time: 33
>   >   > Connect
>   >   Time: 33
>   >   > Latency: 0
>   >   > Size in bytes: 84
>   >   >
>   >   Sent bytes:0
>   >   > Headers size in
>   bytes:
>   >   0
>   >   > Body size in bytes:
>   84
>   >   > Sample Count: 1
>   >   > Error
>   >   Count: 1
>   >   > Data type
>   >   ("text"|"bin"|""):
>   text
>   >   > Response code:
>   null 0
>   >   >
>   >   Response message:
>   java.sql.SQLException: Cannot create
>   >   PoolableConnectionFactory
>   (ORA-00933: SQL command not
>   >   properly ended
>   >   > )
>   >   >
>   >   > Response headers:
>   >   >
>   >   > SampleResult
>   >   fields:
>   >   > ContentType:
>   text/plain
>   >   >
>   DataEncoding: UTF-8
>   >   >
>   >   >
>   >   >
>   >   > Request: [Select
>   >   Statement] select * from
>   departments;
>   >   >
>   >   >
>   >   >
>   >   >
>   >   >
>   >   Response: Cannot create
>   PoolableConnectionFactory
>   >   (ORA-00933: SQL command not
>   properly ended
>   >   > )
>   >   >
>   >   >
>   >   >
>   >   >
>   >   > I have tried a bunch
>   >   of things, but cannot
>   eliminate this error.  Can anyone
>   >   tell me why this error is
>   occurring?
>   >   Have
>   >   you tried to remove the
>   semicolons at the end of your
>   >   statements?
>   >
>   >   Felix
>   >   >
>   >   > Thanks!
>   >   >
>   >   > Jim
>   >   >
>   >   >
>   >   ---------------------------------------------------------------------
>   >   > To unsubscribe, e-mail:
>   user-unsubscribe@jmeter.apache.org
>   >   > For additional commands,
>   e-mail: user-help@jmeter.apache.org
>   >   >
>   >
>   >
>   >   ---------------------------------------------------------------------
>   >   To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>   >   For additional commands,
>   e-mail: user-help@jmeter.apache.org
>   >
>   >
>   >
>   >
>   ---------------------------------------------------------------------
>   > To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>   > For additional commands, e-mail: user-help@jmeter.apache.org
>   >
>   
>   
>   ---------------------------------------------------------------------
>   To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>   For additional commands, e-mail: user-help@jmeter.apache.org
>   
>   
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>


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