Error using JDBC Oracle connection Jmeter

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Error using JDBC Oracle connection Jmeter

Gema Moreno
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.
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

jmeter tea
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 <[hidden email]> 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.
>
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

glinius@live.com
In reply to this post by Gema Moreno
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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

Gema Moreno
In reply to this post by jmeter tea
I try but it didn't work for me. thanks anyway

2018-01-08 13:19 GMT+01:00 jmeter tea <[hidden email]>:

> 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 <[hidden email]> 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.
> >
>
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

Gema Moreno
In reply to this post by glinius@live.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 [hidden email] <[hidden email]>:

> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

Felix Schumacher
In reply to this post by Gema Moreno


Am 8. Januar 2018 13:15:23 MEZ schrieb Gema Moreno <[hidden email]>:

>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: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

Gema Moreno
jmeter Version 2.13 r1665067
OS: windows 7
jre1.8.0_151


2018-01-08 17:08 GMT+01:00 Felix Schumacher <
[hidden email]>:

>
>
> Am 8. Januar 2018 13:15:23 MEZ schrieb Gema Moreno <[hidden email]>:
> >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: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

Gema Moreno
In reply to this post by Gema Moreno
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 <[hidden email]>:

> 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 [hidden email] <[hidden email]>:
>
>> 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: [hidden email]
>> For additional commands, e-mail: [hidden email]
>>
>>
>
Reply | Threaded
Open this post in threaded view
|

Re: Error using JDBC Oracle connection Jmeter

sebb-2-2
Please start a new thread for a new query.

On 9 January 2018 at 10:03, Gema Moreno <[hidden email]> 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 <[hidden email]>:
>
>> 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 [hidden email] <[hidden email]>:
>>
>>> 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: [hidden email]
>>> For additional commands, e-mail: [hidden email]
>>>
>>>
>>

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]