ORA-01882: timezone region not found


(gdragu) #1

Hello,

Is it any possibility to specify a parameter value to java command line
behind the JDBC River?
I think at a -Duser.timezone=Europe/Istanbul, for exemple.
When I try to create a JDBC River for an Oracle database (with jprante
plugin) I catch this error.

Thanks

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Jörg Prante) #2

This is ES related, but, what Oracle JDBC version is this and what Oracle
Database Server version?

Jörg

On Wed, Jul 30, 2014 at 3:59 PM, George DRAGU george.gd.dragu@gmail.com
wrote:

Hello,

Is it any possibility to specify a parameter value to java command line
behind the JDBC River?
I think at a -Duser.timezone=Europe/Istanbul, for exemple.
When I try to create a JDBC River for an Oracle database (with jprante
plugin) I catch this error.

Thanks

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHqCoSbbw_OidTVbyr7AB14R07Ag%2Bg1x6dBU2uUteV2Sg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(Jörg Prante) #3

Ups, I mean of course, this is not ES related ...

Jörg

On Wed, Jul 30, 2014 at 7:59 PM, joergprante@gmail.com <
joergprante@gmail.com> wrote:

This is ES related, but, what Oracle JDBC version is this and what Oracle
Database Server version?

Jörg

On Wed, Jul 30, 2014 at 3:59 PM, George DRAGU george.gd.dragu@gmail.com
wrote:

Hello,

Is it any possibility to specify a parameter value to java command line
behind the JDBC River?
I think at a -Duser.timezone=Europe/Istanbul, for exemple.
When I try to create a JDBC River for an Oracle database (with jprante
plugin) I catch this error.

Thanks

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFSnRensOgxnZ73HKTNocSwfPJ%3DdbT4S14TzQfctogYtg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(gdragu) #4

We have multiple Oracle installations, but we tested with 9i and 10g. My OS
is an OS X Mavericks, JDK is the last one (1.7). The only JDBC driver which
works with (JDK 1.7) is for Oracle 12c Release 1
(http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html).
As I noted, with 10g server there is no problem, but with 9i I catch the
error "timezone region not found". As a general rule, in production
environment is recommended to use the last JDK (or JRE) so 7 version
(http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase14-419411.html).
Here we could found a warning about older versions:

"WARNING: These older versions of the JRE and JDK are provided to help
developers debug issues in older systems. They are not updated with the
latest security patches and are not recommended for use in production."

But what if our customs still use Oracle 9i? We are forced to use a JDK
version 4 (1.4)?

miercuri, 30 iulie 2014, 21:31:48 UTC+3, Jörg Prante a scris:

Ups, I mean of course, this is not ES related ...

Jörg

On Wed, Jul 30, 2014 at 7:59 PM, joerg...@gmail.com <javascript:> <
joerg...@gmail.com <javascript:>> wrote:

This is ES related, but, what Oracle JDBC version is this and what Oracle
Database Server version?

Jörg

On Wed, Jul 30, 2014 at 3:59 PM, George DRAGU <george....@gmail.com
<javascript:>> wrote:

Hello,

Is it any possibility to specify a parameter value to java command line
behind the JDBC River?
I think at a -Duser.timezone=Europe/Istanbul, for exemple.
When I try to create a JDBC River for an Oracle database (with jprante
plugin) I catch this error.

Thanks

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5b2ae4be-9459-43cf-9542-83eb3412f3fe%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(Jörg Prante) #5

With an Oracle JDBC client jar of 11gR2 or later, you will receive timezone
issues when connecting to Oracle DB 9i. Check Oracle Metalink ID 1068063.1

I feel a bit odd to give Oracle support on ES community mailing list. Sorry
for the noise. You could also open an issue at

Jörg

On Thu, Jul 31, 2014 at 10:22 AM, George DRAGU george.gd.dragu@gmail.com
wrote:

We have multiple Oracle installations, but we tested with 9i and 10g. My
OS is an OS X Mavericks, JDK is the last one (1.7). The only JDBC driver
which works with (JDK 1.7) is for Oracle 12c Release 1 (
http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12c-download-1958347.html).
As I noted, with 10g server there is no problem, but with 9i I catch the
error "timezone region not found". As a general rule, in production
environment is recommended to use the last JDK (or JRE) so 7 version (
http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase14-419411.html).
Here we could found a warning about older versions:

"WARNING: These older versions of the JRE and JDK are provided to help
developers debug issues in older systems. They are not updated with the
latest security patches and are not recommended for use in production."

But what if our customs still use Oracle 9i? We are forced to use a JDK
version 4 (1.4)?

miercuri, 30 iulie 2014, 21:31:48 UTC+3, Jörg Prante a scris:

Ups, I mean of course, this is not ES related ...

Jörg

On Wed, Jul 30, 2014 at 7:59 PM, joerg...@gmail.com joerg...@gmail.com
wrote:

This is ES related, but, what Oracle JDBC version is this and what
Oracle Database Server version?

Jörg

On Wed, Jul 30, 2014 at 3:59 PM, George DRAGU george....@gmail.com
wrote:

Hello,

Is it any possibility to specify a parameter value to java command line
behind the JDBC River?
I think at a -Duser.timezone=Europe/Istanbul, for exemple.
When I try to create a JDBC River for an Oracle database (with jprante
plugin) I catch this error.

Thanks

--
You received this message because you are subscribed to the Google
Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to elasticsearc...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/5b2ae4be-9459-43cf-9542-83eb3412f3fe%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/5b2ae4be-9459-43cf-9542-83eb3412f3fe%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHA8JReMKVt4pV5Y29jZ_QnWVeDD3tVWOdjAupN5drijQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.


(gdragu) #6

Thanks for your answer and excuse me for bothering you with unrelated ES
problems.

joi, 31 iulie 2014, 11:46:51 UTC+3, Jörg Prante a scris:

With an Oracle JDBC client jar of 11gR2 or later, you will receive
timezone issues when connecting to Oracle DB 9i. Check Oracle Metalink ID
1068063.1

I feel a bit odd to give Oracle support on ES community mailing list.
Sorry for the noise. You could also open an issue at
https://github.com/jprante/elasticsearch-river-jdbc/issues

Jörg

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/254d40d7-8b2f-4f82-a484-1aef5ab30142%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


(system) #7