You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Gema Moreno <gm...@gmail.com> on 2018/01/08 12:15:23 UTC
Error using JDBC Oracle connection Jmeter
Hi, I just configure a JDBC Oracle connection to test, this is my
configuration:
url: jdbc:oracle:thin:@//192.168.110.103:1521/rdgolf
driver: oracle.jdbc.OracleDriver
I copy the ojdbc6.jar in the library folder
But when I execute the jmeter, it returns the next error:
ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
Many thanks and best regards.
Re: Error using JDBC Oracle connection Jmeter
Posted by sebb <se...@gmail.com>.
Please start a new thread for a new query.
On 9 January 2018 at 10:03, Gema Moreno <gm...@gmail.com> wrote:
> I try to run jmeter from the cmd with this command
>
> C:\apache-jmeter-2.13\bin> jmeter -Duser.timezone=GMT -n -t BddGOFL.jmx -l
> result.jtl
>
> but it returns the next error:
> findstr is not recognised as a command program or batch executable program
> Not able to find Java executable or version. Please check your Java
> installation.
>
> do you know what i am doing wrong?
>
> Thanks a lot.
>
> 2018-01-08 13:42 GMT+01:00 Gema Moreno <gm...@gmail.com>:
>
>> I tried it copying the ojdbc6.jar i have in the oracle folder to the
>> JMeter library, and it fails anyway. Where can i find the /system.properties/
>> file of the Java System ?
>>
>> 2018-01-08 13:25 GMT+01:00 glinius@live.com <gl...@live.com>:
>>
>>> Most likely there is a mismatch between Oracle and JDBC driver versions, I
>>> would recommend using JDBC driver which lives under "jdbc" folder of your
>>> Oracle installation.
>>>
>>>
>>> Alternatively you can try explicitly setting the timezone using the
>>> relevant
>>> Java System Property, add the next line to /system.properties/ file
>>>
>>>
>>> > user.timezone=GMT
>>>
>>> or pass it via -D command-line argument like:
>>>
>>>
>>> > jmeter -Duser.timezone=GMT -n -t test.jmx -l result.jtl
>>>
>>> More information:
>>>
>>> 1. Force Java timezone as GMT/UTC
>>> <https://stackoverflow.com/questions/2627992/force-java-time
>>> zone-as-gmt-utc>
>>> 2. Apache JMeter Properties Customization Guide
>>> <https://www.blazemeter.com/blog/apache-jmeter-properties-customization>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html
>>>
>>> ---------------------------------------------------------------------
>>> 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
Re: Error using JDBC Oracle connection Jmeter
Posted by Gema Moreno <gm...@gmail.com>.
I try to run jmeter from the cmd with this command
C:\apache-jmeter-2.13\bin> jmeter -Duser.timezone=GMT -n -t BddGOFL.jmx -l
result.jtl
but it returns the next error:
findstr is not recognised as a command program or batch executable program
Not able to find Java executable or version. Please check your Java
installation.
do you know what i am doing wrong?
Thanks a lot.
2018-01-08 13:42 GMT+01:00 Gema Moreno <gm...@gmail.com>:
> I tried it copying the ojdbc6.jar i have in the oracle folder to the
> JMeter library, and it fails anyway. Where can i find the /system.properties/
> file of the Java System ?
>
> 2018-01-08 13:25 GMT+01:00 glinius@live.com <gl...@live.com>:
>
>> Most likely there is a mismatch between Oracle and JDBC driver versions, I
>> would recommend using JDBC driver which lives under "jdbc" folder of your
>> Oracle installation.
>>
>>
>> Alternatively you can try explicitly setting the timezone using the
>> relevant
>> Java System Property, add the next line to /system.properties/ file
>>
>>
>> > user.timezone=GMT
>>
>> or pass it via -D command-line argument like:
>>
>>
>> > jmeter -Duser.timezone=GMT -n -t test.jmx -l result.jtl
>>
>> More information:
>>
>> 1. Force Java timezone as GMT/UTC
>> <https://stackoverflow.com/questions/2627992/force-java-time
>> zone-as-gmt-utc>
>> 2. Apache JMeter Properties Customization Guide
>> <https://www.blazemeter.com/blog/apache-jmeter-properties-customization>
>>
>>
>>
>>
>>
>> --
>> Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
>> For additional commands, e-mail: user-help@jmeter.apache.org
>>
>>
>
Re: Error using JDBC Oracle connection Jmeter
Posted by Gema Moreno <gm...@gmail.com>.
I tried it copying the ojdbc6.jar i have in the oracle folder to the JMeter
library, and it fails anyway. Where can i find the /system.properties/
file of the Java System ?
2018-01-08 13:25 GMT+01:00 glinius@live.com <gl...@live.com>:
> Most likely there is a mismatch between Oracle and JDBC driver versions, I
> would recommend using JDBC driver which lives under "jdbc" folder of your
> Oracle installation.
>
>
> Alternatively you can try explicitly setting the timezone using the
> relevant
> Java System Property, add the next line to /system.properties/ file
>
>
> > user.timezone=GMT
>
> or pass it via -D command-line argument like:
>
>
> > jmeter -Duser.timezone=GMT -n -t test.jmx -l result.jtl
>
> More information:
>
> 1. Force Java timezone as GMT/UTC
> <https://stackoverflow.com/questions/2627992/force-java-
> timezone-as-gmt-utc>
> 2. Apache JMeter Properties Customization Guide
> <https://www.blazemeter.com/blog/apache-jmeter-properties-customization>
>
>
>
>
>
> --
> Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
Re: Error using JDBC Oracle connection Jmeter
Posted by "glinius@live.com" <gl...@live.com>.
Most likely there is a mismatch between Oracle and JDBC driver versions, I
would recommend using JDBC driver which lives under "jdbc" folder of your
Oracle installation.
Alternatively you can try explicitly setting the timezone using the relevant
Java System Property, add the next line to /system.properties/ file
> user.timezone=GMT
or pass it via -D command-line argument like:
> jmeter -Duser.timezone=GMT -n -t test.jmx -l result.jtl
More information:
1. Force Java timezone as GMT/UTC
<https://stackoverflow.com/questions/2627992/force-java-timezone-as-gmt-utc>
2. Apache JMeter Properties Customization Guide
<https://www.blazemeter.com/blog/apache-jmeter-properties-customization>
--
Sent from: http://www.jmeter-archive.org/JMeter-User-f512775.html
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: Error using JDBC Oracle connection Jmeter
Posted by Gema Moreno <gm...@gmail.com>.
jmeter Version 2.13 r1665067
OS: windows 7
jre1.8.0_151
2018-01-08 17:08 GMT+01:00 Felix Schumacher <
felix.schumacher@internetallee.de>:
>
>
> Am 8. Januar 2018 13:15:23 MEZ schrieb Gema Moreno <gm...@gmail.com>:
> >Hi, I just configure a JDBC Oracle connection to test, this is my
> >configuration:
> >
> >url: jdbc:oracle:thin:@//192.168.110.103:1521/rdgolf
> >driver: oracle.jdbc.OracleDriver
> >
> >I copy the ojdbc6.jar in the library folder
> >
> >But when I execute the jmeter, it returns the next error:
> >
> >ORA-00604: error occurred at recursive SQL level 1
> >ORA-01882: timezone region not found
>
> Could you tell us the used jmeter version and the used OS and jvm?
>
> Apart from that https://stackoverflow.com/questions/9156379/ora-01882-
> timezone-region-not-found seems to have some good pointers to solve that
> problem.
>
> Regards,
> Felix
>
> >
> >Many thanks and best regards.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>
>
Re: Error using JDBC Oracle connection Jmeter
Posted by Felix Schumacher <fe...@internetallee.de>.
Am 8. Januar 2018 13:15:23 MEZ schrieb Gema Moreno <gm...@gmail.com>:
>Hi, I just configure a JDBC Oracle connection to test, this is my
>configuration:
>
>url: jdbc:oracle:thin:@//192.168.110.103:1521/rdgolf
>driver: oracle.jdbc.OracleDriver
>
>I copy the ojdbc6.jar in the library folder
>
>But when I execute the jmeter, it returns the next error:
>
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01882: timezone region not found
Could you tell us the used jmeter version and the used OS and jvm?
Apart from that https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found seems to have some good pointers to solve that problem.
Regards,
Felix
>
>Many thanks and best regards.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: Error using JDBC Oracle connection Jmeter
Posted by Gema Moreno <gm...@gmail.com>.
I try but it didn't work for me. thanks anyway
2018-01-08 13:19 GMT+01:00 jmeter tea <jm...@gmail.com>:
> probably ojdbc driver issue. see
> https://stackoverflow.com/questions/9156379/ora-01882-
> timezone-region-not-found
> "using ojdbc6.jar (version 11.2.0.3.0) to connect to an Oracle 9.2.0.4.0
> server. Replacing it with ojdbc6.jar version 11.1.0.7.0 solved the issue."
>
> On Mon, Jan 8, 2018 at 2:15 PM, Gema Moreno <gm...@gmail.com> wrote:
>
> > Hi, I just configure a JDBC Oracle connection to test, this is my
> > configuration:
> >
> > url: jdbc:oracle:thin:@//192.168.110.103:1521/rdgolf
> > driver: oracle.jdbc.OracleDriver
> >
> > I copy the ojdbc6.jar in the library folder
> >
> > But when I execute the jmeter, it returns the next error:
> >
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01882: timezone region not found
> >
> > Many thanks and best regards.
> >
>
Re: Error using JDBC Oracle connection Jmeter
Posted by jmeter tea <jm...@gmail.com>.
probably ojdbc driver issue. see
https://stackoverflow.com/questions/9156379/ora-01882-timezone-region-not-found
"using ojdbc6.jar (version 11.2.0.3.0) to connect to an Oracle 9.2.0.4.0
server. Replacing it with ojdbc6.jar version 11.1.0.7.0 solved the issue."
On Mon, Jan 8, 2018 at 2:15 PM, Gema Moreno <gm...@gmail.com> wrote:
> Hi, I just configure a JDBC Oracle connection to test, this is my
> configuration:
>
> url: jdbc:oracle:thin:@//192.168.110.103:1521/rdgolf
> driver: oracle.jdbc.OracleDriver
>
> I copy the ojdbc6.jar in the library folder
>
> But when I execute the jmeter, it returns the next error:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01882: timezone region not found
>
> Many thanks and best regards.
>