This seems kind of strange exception because SDO_TUNE isn't a table or a
view, it's an Oracle Locator package with several functions and procedures.
Doing a search for this package in the gt-jdbc-oracle module, a reference
appears at the
/org.geotools.data.oracle.OracleDialect.getOptimizedBounds(String schema,
SimpleFeatureType featureType,Connection cx) method with the expected
sintax: SELECT SDO_TUNE.EXTENT_OF(<tableName>,<columnName>) FROM DUAL.
We are working against a RC2 build and didn´t have this issue.
Can u switch your logs to GEOTOOLS_DEVELOPER_LOGGING level so we can see the
query issued against the Oracle database when the feature bounds are being
request?
Pedro Mendes
On Thu, Mar 3, 2011 at 3:22 PM, Steve Way <
[email protected]> wrote:
> Hi Everyone,
>
>
>
> I have just started testing RC2 from a fully working RC1 installation and
> receive the following error on all Oracle Vector Data. Has anyone else had
> this issue?
>
>
>
> Cheers,
>
> Steve
>
>
>
>
>
> java.lang.RuntimeException: java.io.IOException: Error occured calculating
> bounds
>
> at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:476)
>
> at
> org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java:178)
>
> at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:369)
>
> at
> org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSource.java:341)
>
> at
> org.geotools.data.SimpleFeatureSourceBridge.getBounds(SimpleFeatureSourceBridge.java:49)
>
> at
> org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatureSource.java:529)
>
> at org.geotools.map.FeatureLayer.getBounds(FeatureLayer.java:189)
>
> at org.geotools.map.MapContext.getLayerBounds(MapContext.java:463)
>
> at
> org.geotools.map.DefaultMapContext.getViewport(DefaultMapContext.java:524)
>
> at org.geotools.map.MapContent.<init>(MapContent.java:207)
>
> at org.geotools.map.MapContext.<init>(MapContext.java:170)
>
> at
> org.geotools.map.DefaultMapContext.<init>(DefaultMapContext.java:98)
>
> at
> org.geotools.renderer.shape.ShapefileRenderer.renderWithStreamingRenderer(ShapefileRenderer.java:1563)
>
> at
> org.geotools.renderer.shape.ShapefileRenderer.paint(ShapefileRenderer.java:1415)
>
> at
> org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:445)
>
> at
> org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:206)
>
> at
> org.geoserver.wms.map.RenderedImageMapOutputFormat.produceMap(RenderedImageMapOutputFormat.java:121)
>
> at org.geoserver.wms.GetMap.run(GetMap.java:461)
>
> …
>
> …
>
>
>
> Caused by: java.io.IOException: Error occured calculating bounds
>
> at
> org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1124)
>
> at
> org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:469)
>
> ... 140 more
>
> Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
>
> ORA-06512: at "MDSYS.SDO_TUNE", line 817
>
>
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
>
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
>
>
>
> ------------------------------
> DISCLAIMER:
>
> This email may contain confidential information and is intended only for
> the use of the specific individual(s) to which it is addressed. If you are
> not the intended recipient of this email, you are hereby notified that any
> unauthorized use, dissemination or copying of this email or the information
> contained in it or attached to it is strictly prohibited. If you received
> this message in error, please immediately notify the sender at Infotech or
> [email protected] and delete the original message.
>
>
> ------------------------------------------------------------------------------
> Free Software Download: Index, Search & Analyze Logs and other IT data in
> Real-Time with Splunk. Collect, index and harness all the fast moving IT
> data
> generated by your applications, servers and devices whether physical,
> virtual
> or in the cloud. Deliver compliance at lower cost and gain new business
> insights. http://p.sf.net/sfu/splunk-dev2dev
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
--
Cumprimentos,
Pedro Mendes
------------------------------------------------------------------------------
What You Don't Know About Data Connectivity CAN Hurt You
This paper provides an overview of data connectivity, details
its effect on application quality, and explores various alternative
solutions. http://p.sf.net/sfu/progress-d2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
