Re: ORA-01882: timezone region not found

[George DRAGU]

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+unsubscr...@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.

Re: ORA-01882: timezone region not found

[joergpra...@gmail.com]

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


On Thu, Jul 31, 2014 at 10:22 AM, George DRAGU 
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 
>> 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 
>>> 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
 
 .
 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+unsubscr...@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.
>

-- 
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+unsubscr...@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.

Re: ORA-01882: timezone region not found

[George DRAGU]

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 > > 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
>>>  
>>> 
>>> .
>>> 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+unsubscr...@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.

Re: ORA-01882: timezone region not found

[joergpra...@gmail.com]

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

Jörg


On Wed, Jul 30, 2014 at 7:59 PM, joergpra...@gmail.com <
joergpra...@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 
> 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+unsubscr...@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.
>>
>
>

-- 
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+unsubscr...@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.

Re: ORA-01882: timezone region not found

[joergpra...@gmail.com]

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 
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+unsubscr...@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.
>

-- 
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+unsubscr...@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.

ORA-01882: timezone region not found

[George DRAGU]

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+unsubscr...@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.