"select null" while reading feature collection
----------------------------------------------
Key: GEOT-938
URL: http://jira.codehaus.org/browse/GEOT-938
Project: GeoTools
Issue Type: Bug
Affects Versions: 2.2.0
Environment: Oracle 10.2, jdk 1.5
Reporter: Alessio Soldano
Priority: Critical
Attachments: LiteRendererTest2.java
We're reading feature collections through the OracleDataStore. Calling method
feature() on an instance of FeatureCollection cause this error:
org.geotools.data.jdbc.JDBC1DataStore executeQuery
GRAVE: Error Performing SQL query: SELECT "null", "LINK_ID", "ST_NAME",
"FEAT_ID", "ST_LANGCD", "NUM_STNMES", "ST_NM_PREF", "ST_TYP_BEF", "ST_NM_BASE",
"ST_NM_SUFF", "ST_TYP_AFT", "ST_TYP_ATT", "ADDR_TYPE", "L_REFADDR",
"L_NREFADDR", "L_ADDRSCH", "L_ADDRFORM", "R_REFADDR", "R_NREFADDR",
"R_ADDRSCH", "R_ADDRFORM", "REF_IN_ID", "NREF_IN_ID", "N_SHAPEPNT",
"FUNC_CLASS", "SPEED_CAT", "SPEED_LIM", "TO_LANES", "FROM_LANES", "ENH_GEOM",
"LANE_CAT", "DIVIDER", "DIR_TRAVEL", "L_AREA_ID", "R_AREA_ID", "L_POSTCODE",
"R_POSTCODE", "L_NUMZONES", "R_NUMZONES", "NUM_AD_RNG", "AR_AUTO", "AR_BUS",
"AR_TAXIS", "AR_CARPOOL", "AR_PEDEST", "AR_TRUCKS", "AR_TRAFF", "AR_DELIV",
"AR_EMERVEH", "PAVED", "PRIVATE", "FRONTAGE", "BRIDGE", "TUNNEL", "RAMP",
"TOLLWAY", "POIACCESS", "CONTRACC", "ROUNDABOUT", "INTERINTER", "UNDEFTRAFF",
"FERRY_TYPE", "MULTIDIGIT", "MAXATTR", "SPECTRFIG", "INDESCRIB", "MANOEUVRE",
"DIVIDERLEG", "INPROCDATA", "FULL_GEOM", "URBAN", "ROUTE_TYPE", "DIRONSIGN",
"EXPLICATBL", "NAME
ONRDSN", "POSTALNAME", "STALENAME", "VANITYNAME", "JUNCTIONNM", "EXITNAME",
"GEOMETRY" FROM "LAGO"
java.sql.SQLException: ORA-00904: "null": invalid identifier
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:330)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:287)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:742)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:206)
at
oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:789)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1038)
at
oracle.jdbc.driver.T4CStatement.executeMaybeDescribe(T4CStatement.java:829)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1131)
at
oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1271)
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.store.DataFeatureCollection.openIterator(DataFeatureCollection.java:225)
at
org.geotools.data.store.DataFeatureCollection.iterator(DataFeatureCollection.java:201)
at
org.geotools.data.store.DataFeatureCollection.features(DataFeatureCollection.java:192)
at LiteRendererTest2.printFeatures(LiteRendererTest2.java:82)
This only happen using Geotools version 2.2.0; running the same code on the
same data (same db) with version 2.2-RC3 we are able to read the feature
collection.
The attached file contains the code used.
Thank you
Alessio Soldano
--
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
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
