(nabble stripped the excerpt from the logfile)
Caused by: java.io.IOException: Error occured calculating bounds for
xxxx_oracle
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1360)
at
org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.java:514)
... 117 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00907: missing right
parenthesis
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at
oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at
oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at
oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
at
oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.geotools.jdbc.JDBCDataStore.getBounds(JDBCDataStore.java:1329)
... 118 more
Caused by: Error : 907, Position : 102, Sql = SELECT
SDO_AGGR_MBR(SDOGEOMETRY)FROM (SELECT * FROM ( SELECT * FROM
gisdb.xxxx_oracleWHERE (NAME LIKE 'Wien%' AND NAME IS NOT NULL )) WHERE
ROWNUM <= 50) GT2_BOUNDS_, OriginalSql = SELECT
SDO_AGGR_MBR(SDOGEOMETRY)FROM (SELECT * FROM ( SELECT * FROM
gisdb.xxxx_oracleWHERE (NAME LIKE 'Wien%' AND NAME IS NOT NULL )) WHERE
ROWNUM <= 50) GT2_BOUNDS_, Error Msg = ORA-00907: missing right parenthesis
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
--
Sent from: http://osgeo-org.1560.x6.nabble.com/GeoServer-User-f3786390.html
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
