Overflow Exception trying to bind NaN
432472Nov 3 2005 — edited Nov 4 2005Hello,
Can somebody help me? I'm just trying to use MapViewer to see the results of a spatial query on an predifined Image Theme. I've done all that's explained in the MapViwer documentation but it seems to be a problem with the Image Theme. Here is the part of the log file where the error appears:
...
05/10/26 16:12:41 [oracle.sdovis.ImageTheme, Wed Oct 26 16:12:41 CEST 2005, FINEST] [ImageTheme p] query=SELECT ROWID, raster
FROM Base_map WHERE MDSYS.SDO_FILTER(raster, MDSYS.SDO_GEOMETRY(2003, 327680, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
05/10/26 16:12:41 [oracle.sdovis.ImageTheme, Wed Oct 26 16:12:41 CEST 2005, ERROR] java.sql.SQLException: Overflow Exception trying to bind NaN
at oracle.jdbc.driver.DoubleBinder.bind(OraclePreparedStatement.java:13793)
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2871)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:2156)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3334)
at oracle.sdovis.ImageTheme.loadImagesFromDBCached(ImageTheme.java:390)
at oracle.sdovis.ImageTheme.prepareData(ImageTheme.java:281)
at oracle.sdovis.DBMapMaker$LoadThemeData.run(DBMapMaker.java:1300)
05/10/26 16:12:41 [oracle.sdovis.DBMapMaker, Wed Oct 26 16:12:41 CEST 2005, DEBUG] LoadThemeData running thread: Thread-9
...
Thanks for your help.