![]() |
|
|
|
|
Issue Type:
|
![Bug]() Bug
|
|
Affects Versions:
|
9.0-beta1 |
|
Assignee:
|
Unassigned |
|
Components:
|
imagemosaic-jdbc plugin |
|
Created:
|
25/Feb/13 10:00 AM
|
|
Description:
|
I tried to insert tiles into an Oracle Spatial database using this tutorial:
http://docs.geoserver.org/stable/en/user/tutorials/imagemosaic-jdbc/imagemosaic-jdbc_tutorial.html#importing-the-image-data
My mapping file uses oracle spatial extension:
<spatialExtension name="oracle"/>
I get the following stack trace:
java.io.IOException: select srid from USER_SDO_GEOM_METADATA where table_name=? and column_name = ? has no result for osmdata_0,geom
at org.geotools.gce.imagemosaic.jdbc.Import.calculateSRS(Import.java:600)
at org.geotools.gce.imagemosaic.jdbc.Import.<init>(Import.java:203)
at org.geotools.gce.imagemosaic.jdbc.Import.start(Import.java:400)
at org.geotools.gce.imagemosaic.jdbc.Toolbox.main(Toolbox.java:46)
Main Cause is the old behaviour of Oracle to turn all entries in USER_SDO_GEOM_METADATA into upper case (see for example http://jira.codehaus.org/browse/GEOT-1965)
Resolution:
In JDBCAccessOracle, add "UPPER(..)" to the SELECT statements to:
|
|
Environment:
|
Oracle Spatial database
|
|
Project:
|
GeoTools
|
|
Priority:
|
![Minor]() Minor
|
|
Reporter:
|
Björn Höfling
|
|
|
|
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
|
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_feb
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
