Don´t know if Steve did overcome this issue, but the use the
function SDO_TUNE.EXTENT_OF will prevent having a feature with 2 or more
geometry columns from an Oracle datastore. This is due an apparent bug in
the function when the table as more than one geometry column. Maybe
getOptimizedBounds
should use SDO_AGGR_MBR?
On Fri, Mar 4, 2011 at 10:05 AM, Pedro Mendes <[email protected]>wrote:
> 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
>
--
Cumprimentos,
Pedro Mendes
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
