SDO_GCDR.GEOCODE Fails With ORA-29532: UnsatisfiedLinkError: Java.util.TimeZone.getSystemTimeZoneID (Doc ID 2297097.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Spatial and Graph - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.4 version, Query Issues

When attempting to select sdo_gcdr.geocode('HERE_MWM',sdo_keywordarray('3200 College Ave',
'Beaver Falls, PA 15010'),'US','DEFAULT')
from dual;
the following error occurs.

ERROR
-----------------------
SQL> select sdo_gcdr.geocode('HERE_MWM',sdo_keywordarray('3200 College Ave',
'Beaver Falls, PA 15010'),'US','DEFAULT')
from dual; 2 3
select sdo_gcdr.geocode('HERE_MWM',sdo_keywordarray('3200 College Ave',
  *
ERROR at line 1:
ORA-29532: Java call terminated by uncaught Java exception:
java.lang.UnsatisfiedLinkError: java.util.TimeZone.getSystemTimeZoneID
ORA-06512: at "MDSYS.SDO_GCDR", line 738
ORA-06512: at "MDSYS.SDO_GCDR", line 767
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms