Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-users] exception when clicking "show selection" in table view 
Dear all,

I have a question how UDig is showing a feature that I selected in the
table view. In my case it is not possible to do that and I get this
exception, caused by the oracle exception ORA-00936.

The below query has two predicates: first he filters the features within
 the window query (values taken from the R-Tree specified in
MDSYS.USER_SDO_GEOM_METADATA). The second predicate is empty, but I
expect there must be a id selection. Am I right here or not? Can
somebody of you explain me, what kind of attribute must be taken?

SELECT "GEOMETRY" FROM "BZ_PEDESTRIAN_LINKS" WHERE
(SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,82344,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(677216.0491581481,5150670.881841266,683917.4670566666,5153424.051093548)),'mask=anyinteract 
querytype=WINDOW') = 'TRUE'  AND ())


thanks for your help


regards Markus

**********************************

This is the complete stack trace from the log:

Jul 28, 2009 12:46:49 PM org.geotools.data.jdbc.JDBC1DataStore executeQuery
SEVERE: Error Performing SQL query: SELECT "GEOMETRY" FROM
"BZ_PEDESTRIAN_LINKS" WHERE ()
java.sql.SQLException: ORA-00936: missing expression

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
	at
oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431)
	at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)
	at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)
	at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1184)
	at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922)
	at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:672)
	at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
	at
org.geotools.data.DefaultFeatureResults.getBounds(DefaultFeatureResults.java:193)
	at net.refractions.udig.tool.select.internal.ZoomSelection.run(Unknown
Source)
	at
net.refractions.udig.project.ui.internal.tool.display.ToolProxy$4.run(Unknown 
Source)
	at net.refractions.udig.ui.PlatformGIS$Runner.run(Unknown Source)
	at net.refractions.udig.ui.PlatformGIS$Runner.run(Unknown Source)
net.refractions.udig.project.render.RenderException: Problem rendering:
Exception rendering layer DefaultMapLayer[ Test, VISIBLE,
style=StyleImpl<NO_PARENT>[ name=Default Styler],
data=org.geotools.data.jdbc.JDBCFeatureSource@7cdd92, query=Query:
   feature type: BZ_PEDESTRIAN_LINKS
   filter: [ BZ_PEDESTRIAN_LINKS.-422ba278:122c0efce90:-440e ]
   [properties:  ALL ]]
	at
net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(Unknown 
Source)
	at
net.refractions.udig.render.internal.feature.basic.BasicFeatureRenderer.render(Unknown 
Source)
	at
net.refractions.udig.project.internal.render.impl.RenderJob.startRendering(Unknown 
Source)
	at
net.refractions.udig.project.internal.render.impl.RenderJob.run(Unknown
Source)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: java.lang.Exception: Exception rendering layer
DefaultMapLayer[ Test, VISIBLE, style=StyleImpl<NO_PARENT>[ name=Default
Styler], data=org.geotools.data.jdbc.JDBCFeatureSource@7cdd92, query=Query:
   feature type: BZ_PEDESTRIAN_LINKS
   filter: [ BZ_PEDESTRIAN_LINKS.-422ba278:122c0efce90:-440e ]
   [properties:  ALL ]]
	at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:467)
	at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:374)
	... 5 more
Caused by: org.geotools.data.DataSourceException: Error Performing SQL
query: SELECT "GEOMETRY" FROM "BZ_PEDESTRIAN_LINKS" WHERE
(SDO_RELATE("GEOMETRY",MDSYS.SDO_GEOMETRY(2003,82344,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(677216.0491581481,5150670.881841266,683917.4670566666,5153424.051093548)),'mask=anyinteract 
querytype=WINDOW') = 'TRUE'  AND ())
	at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:933)
	at
org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:672)
	at
org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
	at
org.geotools.renderer.lite.StreamingRenderer.getReader(StreamingRenderer.java:1178)
	at
org.geotools.renderer.lite.StreamingRenderer.processStylers(StreamingRenderer.java:1275)
	at
org.geotools.renderer.lite.StreamingRenderer.paint(StreamingRenderer.java:464)
	... 6 more
Caused by: java.sql.SQLException: ORA-00936: missing expression

	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
	at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
	at
oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431)
	at
oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:965)
	at
oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463)
	at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1051)
	at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1184)
	at
org.geotools.data.jdbc.JDBC1DataStore.executeQuery(JDBC1DataStore.java:922)
	... 11 more

Back to the top