# ORA-01882: timezone region not found **URL:** \ **Category:** Elasticsearch\ **Created:** [July 30, 2014, 1:59pm UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977 "2014-07-30T13:59:54Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gdragu](https://avatars.discourse-cdn.com/v4/letter/g/ebca7d/32.png) [@gdragu](https://discuss.elastic.co/u/gdragu)\ **Post date:** [July 30, 2014, 1:59pm UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/1 "2014-07-30T13:59:54Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [July 30, 2014, 5:59pm UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/2 "2014-07-30T17:59:56Z")
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](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHqCoSbbw_OidTVbyr7AB14R07Ag%2Bg1x6dBU2uUteV2Sg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [July 30, 2014, 6:31pm UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/3 "2014-07-30T18:31:37Z")
Ups, I mean of course, this is _not_ ES related ... Jörg On Wed, Jul 30, 2014 at 7:59 PM, [joergprante@gmail.com](mailto:joergprante@gmail.com) \< [joergprante@gmail.com](mailto: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](mailto: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](mailto: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) > > [https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFSnRensOgxnZ73HKTNocSwfPJ%3DdbT4S14TzQfctogYtg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFSnRensOgxnZ73HKTNocSwfPJ%3DdbT4S14TzQfctogYtg%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![gdragu](https://avatars.discourse-cdn.com/v4/letter/g/ebca7d/32.png) [@gdragu](https://discuss.elastic.co/u/gdragu)\ **Post date:** [July 31, 2014, 8:22am UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/4 "2014-07-31T08:22:03Z")
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 ([JDBC and UCP Downloads page](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 ([Java Archive Downloads - Java SE 1.4](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](mailto:joerg...@gmail.com) \ \< > [joerg...@gmail.com](mailto: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](mailto: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](mailto: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) > > > [https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [July 31, 2014, 8:46am UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/5 "2014-07-31T08:46:42Z")
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 > **[Issues · jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc/issues)** > > JDBC importer for Elasticsearch. Contribute to jprante/elasticsearch-jdbc development by creating an account on GitHub. Jörg On Thu, Jul 31, 2014 at 10:22 AM, George DRAGU [george.gd.dragu@gmail.com](mailto: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 ( > [JDBC and UCP Downloads page](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 ( > [Java Archive Downloads - Java SE 1.4](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](mailto:joerg...@gmail.com) [joerg...@gmail.com](mailto: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](mailto: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](mailto:elasticsearc...@googlegroups.com). > > > > > > > > To view this discussion on the web visit [https://groups.google.com/d/](https://groups.google.com/d/) > > > > msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa% > > > > [40googlegroups.com](http://40googlegroups.com) > > > > [https://groups.google.com/d/msgid/elasticsearch/a75e8e67-01f8-4b20-a2e9-86caba59e5aa%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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) > > [https://groups.google.com/d/msgid/elasticsearch/5b2ae4be-9459-43cf-9542-83eb3412f3fe%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHA8JReMKVt4pV5Y29jZ\_QnWVeDD3tVWOdjAupN5drijQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHA8JReMKVt4pV5Y29jZ_QnWVeDD3tVWOdjAupN5drijQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![gdragu](https://avatars.discourse-cdn.com/v4/letter/g/ebca7d/32.png) [@gdragu](https://discuss.elastic.co/u/gdragu)\ **Post date:** [July 31, 2014, 9:17am UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/6 "2014-07-31T09:17:58Z")
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 > [Issues · jprante/elasticsearch-jdbc · GitHub](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](mailto: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](https://groups.google.com/d/msgid/elasticsearch/254d40d7-8b2f-4f82-a484-1aef5ab30142%40googlegroups.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:12am UTC](https://discuss.elastic.co/t/ora-01882-timezone-region-not-found/18977/7 "2017-07-06T01:12:00Z")