Failure to get features from Oracle view
----------------------------------------
Key: GEOT-2612
URL: http://jira.codehaus.org/browse/GEOT-2612
Project: GeoTools
Issue Type: Bug
Components: data jdbc-ng
Affects Versions: 2.6-M2
Reporter: Ben Caradoc-Davies
Error getting a feature type backed by an Oracle view. Seen in Geoserver
2.0-beta2, but almost certainly a GeoTools jdbc-ng regression.
GS exception:
Error occurred getting features
Error looking up primary key
ORA-01702: a view is not appropriate here
{code}
Caused by: java.io.IOException: Error looking up primary key
at org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:772)
at
org.geotools.jdbc.JDBCDataStore.createFeatureSource(JDBCDataStore.java:621)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:349)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:314)
at
org.geotools.data.store.ContentDataStore.getFeatureSource(ContentDataStore.java:613)
at
org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.getFeatureSource(AppSchemaDataAccessConfigurator.java:383)
at
org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.createFeatureTypeMappings(AppSchemaDataAccessConfigurator.java:188)
at
org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMapping
s(AppSchemaDataAccessConfigurator.java:175)
at
org.geotools.data.complex.config.AppSchemaDataAccessConfigurator.buildMappings(AppSchemaDataAccessConfigurator.java:149)
at
org.geotools.data.complex.AppSchemaDataAccessFactory.createDataStore(AppSchemaDataAccessFactory.java:91)
at
org.vfny.geoserver.util.DataStoreUtils.getDataAccess(DataStoreUtils.java:96)
at
org.geoserver.catalog.ResourcePool.getDataStore(ResourcePool.java:265)
at
org.geoserver.catalog.ResourcePool.getFeatureSource(ResourcePool.java:541)
at
org.geoserver.catalog.impl.FeatureTypeInfoImpl.getFeatureSource(FeatureTypeInfoImpl.java:84)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.geoserver.catalog.impl.ModificationProxy.invoke(ModificationProxy.java:113)
at $Proxy44.getFeatureSource(Unknown So
urce)
a
t org.geoserver.wfs.GetFeature.run(GetFeature.java:170)
... 70 more
Caused by: java.sql.SQLException: ORA-01702: a view is not appropriate here
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:936)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at
oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1706)
at
oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1674)
at oracle.jdbc.driver.OracleStatementWrapper.execute
Update(OracleStatementWrapper.java:274)
at
oracle.jdbc.OracleDatabaseMetaData.getIndexInfo(OracleDatabaseMetaData.java:3535)
at org.geotools.jdbc.JDBCDataStore.getPrimaryKey(JDBCDataStore.java:750)
{code}
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
