14 Replies Latest reply on Nov 9, 2006 9:09 AM by Branislav Nemec

    Oracle Maps RC1 - java.sql.SQLException: No more data to read from socket

    Branislav Nemec
      Hi,

      Trying to render basemap with theme containing around 400 000 polygons I got several not rendered tiles and in log file I found following error:
      .
      .
      .
      java.sql.SQLException: No more data to read from socket
      .
      .
      .

      Seems like mapviewer server has some problem with database connection pooling?

      thanks,

      Branislav
        • 1. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
          Branislav Nemec
          more from log file:

          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.sdovis.CacheMgr2] Spatial Data Cache opened. Region=SDOVIS_DATA.
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.sdovis.CacheMgr2]      max_cache_size=32 MB.
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.sdovis.CacheMgr2] sub region sdovis_subreg_mvdemo_jdbc:oracle:thin:@ntsvr01:1521:dblic created in cache.
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.lbs.mapserver.core.MapperConfig] Map Recycling thread started.
          Tue Oct 24 16:56:40 CEST 2006 INFO [oracle.lbs.mapserver.oms] *** Oracle MapViewer started. ***
          Tue Oct 24 16:56:41 CEST 2006 INFO [oracle.sdovis.DBSRSCache] Loading SRS information from MDSYS.cs_srs (srid=8307).
          Tue Oct 24 16:56:41 CEST 2006 INFO [oracle.sdovis.DBSRSCache] Loading SRS information from MDSYS.cs_srs (srid=2065).
          Tue Oct 24 16:59:34 CEST 2006 INFO [oracle.sdovis.CacheMgr2] Creating/replacing a geometry cache group: sdovis_subreg_mvdemo_jdbc:oracle:thin:@ntsvr01:1521:dblic : TM_DU_SR_GEOMETRY_PDT_GEOM.
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 2844ms.
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 2844ms.
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 15ms
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 62ms.
          Tue Oct 24 16:59:37 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
          Tue Oct 24 17:01:22 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 105062ms.
          Tue Oct 24 17:01:29 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 6219ms
          Tue Oct 24 17:02:06 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: UZIVANIE_SR
          Tue Oct 24 17:02:06 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: No more data to read from socket
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
               at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
               at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1375)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalNBytes(T4CMAREngine.java:1343)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalBuffer(T4CMAREngine.java:1787)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1684)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1722)
               at oracle.jdbc.driver.T4CNamedTypeAccessor.unmarshalOneRow(T4CNamedTypeAccessor.java:134)
               at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:790)
               at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:716)
               at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:549)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
               at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:692)
               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:590)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:02:06 CEST 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: UZIVANIE_SR
          Description: Nested exception is:
          java.sql.SQLException: No more data to read from socket
          java.sql.SQLException: No more data to read from socket
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
               at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
               at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1375)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalNBytes(T4CMAREngine.java:1343)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalBuffer(T4CMAREngine.java:1787)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1684)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1722)
               at oracle.jdbc.driver.T4CNamedTypeAccessor.unmarshalOneRow(T4CNamedTypeAccessor.java:134)
               at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:790)
               at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:716)
               at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:549)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
               at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:692)
               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:590)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:02:06 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 151594ms.
          Tue Oct 24 17:02:06 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 47ms
          Tue Oct 24 17:03:49 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 140453ms.
          Tue Oct 24 17:04:00 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 11015ms
          Tue Oct 24 17:05:46 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: UZIVANIE_SR
          Tue Oct 24 17:05:46 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: No more data to read from socket
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
               at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:994)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:951)
               at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:448)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
               at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:692)
               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:590)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:05:46 CEST 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: UZIVANIE_SR
          Description: Nested exception is:
          java.sql.SQLException: No more data to read from socket
          java.sql.SQLException: No more data to read from socket
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
               at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.java:898)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:994)
               at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:951)
               at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:448)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
               at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:692)
               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:590)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:05:46 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 91906ms.
          Tue Oct 24 17:05:46 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 31ms
          Tue Oct 24 17:05:49 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: UZIVANIE_SR
          Tue Oct 24 17:05:49 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: OALL8 is in an inconsistent state.
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.T4C8Oall.init(T4C8Oall.java:325)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:170)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
               at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
               at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:576)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:05:49 CEST 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: UZIVANIE_SR
          Description: Nested exception is:
          java.sql.SQLException: OALL8 is in an inconsistent state.
          java.sql.SQLException: OALL8 is in an inconsistent state.
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.T4C8Oall.init(T4C8Oall.java:325)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:170)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
               at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
               at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:576)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Tue Oct 24 17:05:49 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 0ms.
          Tue Oct 24 17:05:49 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
          Tue Oct 24 17:05:52 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 1844ms.
          Tue Oct 24 17:05:52 CEST 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
          Tue Oct 24 17:05:52 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: UZIVANIE_SR
          Tue Oct 24 17:05:52 CEST 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: OALL8 is in an inconsistent state.
               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
               at oracle.jdbc.driver.T4C8Oall.init(T4C8Oall.java:325)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:170)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
               at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
               at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
               at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:576)
               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:270)
               at oracle.sdovis.Theme.prepareData(Theme.java:174)
               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

          Branislav
          • 2. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
            Branislav Nemec
            reposted,

            it's quite urgent - I still can't make tiles of map containing many polygons because of that error

            thanks,

            Branislav
            • 3. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
              Branislav Nemec
              repost

              could anybody try to reproduce it?

              thanks

              Branislav
              • 4. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                Lqian-Oracle
                This may be a JDBC driver related issue; to test this, you can switch MapViewer's logging level to finest, and get the SQL query MapViewer is sending to the database that caused this SQL Exception. Then, use this same SQL query in the following sample code to see if it casuses the same error. Note you may need to replace the 4 question marks in the query string with the actual quering window x1,y1,x2,y2 also found in the log.

                TO run the following code make sure you have the JDBC driver from your OC4J/iAS installation, and also the sdovis.jar from oc4j/j2ee/home/applications/mapviewer/web/WEB-INF/lib direcotry in its classpath.
                import java.sql.Connection;
                import java.sql.Driver;
                import java.sql.DriverManager;
                import java.sql.ResultSet;
                import java.sql.SQLException;
                import java.sql.Statement;
                
                import java.util.ArrayList;
                import oracle.jdbc.OracleDriver;
                import oracle.sdovis.JSDOGeometry;
                import oracle.sql.STRUCT;
                
                
                /**
                 * A very simple program that shows how to get spatial stuff from db
                 */
                public class JDBCGeoms
                {  
                
                  public static void getStuff() throws Exception
                  {
                    System.out.println("Loading geometry...");
                    Connection conn = getConnection("foo.com", "1521", "orcl", "mvdemo", "mvdemo");
                    Statement  stmt = conn.createStatement();
                    ResultSet  rset = stmt.executeQuery("select geom from counties");
                    ArrayList geoms = new ArrayList(1024);
                    while(rset.next())
                    {
                      STRUCT st = (STRUCT) rset.getObject(1);
                      JSDOGeometry geom = JSDOGeometry.loadFromDB(st);                  
                      geoms.add(geom);
                    }
                  
                    rset.close();
                    stmt.close();
                    conn.close();      
                  }
                    
                  private static Connection getConnection(String host, 
                                                          String port, 
                                                          String sid, 
                                                          String username, 
                                                          String password) 
                    throws SQLException
                  {
                    String thinConn = "jdbc:oracle:thin:@"+host+":"+port+":"+sid;
                    Driver d = new OracleDriver();
                    Connection conn = DriverManager.getConnection(thinConn,username,password);
                    conn.setAutoCommit(false);
                    return conn;
                  }
                    
                  public static void main(String[] args) 
                  {
                      
                    try{
                      getStuff();
                    }catch(Exception e)
                    {
                      e.printStackTrace(System.err);
                    }  
                  }
                }
                thanks
                LJ
                • 5. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                  Lqian-Oracle
                  Another possiblility, from reading your error traces, is that you may be loading too much data from the database when generating maps. You may want to either increase the heap memory assigned to the OC4J instance, or (the better option i think) to simplify your map layers/data.

                  thanks
                  LJ
                  • 6. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                    Lqian-Oracle
                    Further update: you may also want to upgrade the 10.1.3. JDBC thin driver that comes with Oracle AS 10.1.3 to 10.2.0.2 JDBC driver, which seems to fix the error (java.sql.SQLException: OALL8 is in an inconsistent state.) for some people.
                    • 7. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                      Branislav Nemec
                      Hi,

                      I set Mapviewer logging to FINEST, upgraded JDBC driver to 10.2.0.2, set -Xmx1024 for jvm but without success:

                      ----------------------------------------------------------------------------------------------------------------------
                      Fri Nov 03 23:30:46 CET 2006 FINEST [oracle.lbs.mapserver.core.MapperConfig]
                      Allowed IPs:
                      Excluded IPs:

                      Fri Nov 03 23:30:46 CET 2006 FINEST [oracle.lbs.mapserver.core.MapperConfig] Non-Spatial Data Provider registered: defaultNSDP
                      Fri Nov 03 23:30:48 CET 2006 FINEST [oracle.sdovis.DBSRSCache] Number of geodetic srids loaded: 748.
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.sdovis.CacheMgr2] Spatial Data Cache opened. Region=SDOVIS_DATA.
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.sdovis.CacheMgr2]      max_cache_size=32 MB.
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.sdovis.CacheMgr2] sub region sdovis_subreg_mvdemo_jdbc:oracle:thin:@localhost:1521:dblic created in cache.
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.lbs.mapserver.core.MapperConfig] Map Recycling thread started.
                      Fri Nov 03 23:30:48 CET 2006 INFO [oracle.lbs.mapserver.oms] *** Oracle MapViewer started. ***
                      Fri Nov 03 23:30:49 CET 2006 INFO [oracle.lbs.mapserver.core.MapRecycleThread, ,#Thread-27] cleansing old maps
                      Fri Nov 03 23:30:49 CET 2006 INFO [oracle.sdovis.DBSRSCache] Loading SRS information from MDSYS.cs_srs (srid=8307).
                      Fri Nov 03 23:30:49 CET 2006 DEBUG [oracle.sdovis.DBSRSCache] Registering srs 8307, isGeodetic=true, unit=DECIMAL DEGREE
                      Fri Nov 03 23:30:49 CET 2006 INFO [oracle.sdovis.DBSRSCache] Loading SRS information from MDSYS.cs_srs (srid=2065).
                      Fri Nov 03 23:30:49 CET 2006 DEBUG [oracle.sdovis.DBSRSCache] Registering srs 2065, isGeodetic=false, unit=METER
                      Fri Nov 03 23:31:58 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                      Fri Nov 03 23:31:58 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                      Fri Nov 03 23:31:58 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                      Fri Nov 03 23:31:58 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                      Fri Nov 03 23:31:58 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                      Fri Nov 03 23:31:58 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                      Fri Nov 03 23:31:59 CET 2006 FINEST [oracle.sdovis.ThemeTable] key_column specified by user: ID_JPRL
                      Fri Nov 03 23:31:59 CET 2006 INFO [oracle.sdovis.CacheMgr2] Creating/replacing a geometry cache group: sdovis_subreg_mvdemo_jdbc:oracle:thin:@localhost:1521:dblic : TM_DU_SR_GEOMETRY_PDT_GEOM.
                      Fri Nov 03 23:31:59 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-44
                      Fri Nov 03 23:31:59 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-45
                      Fri Nov 03 23:31:59 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -445346.1687500002,-1222673.084375,-380568.9257812502,-1157895.8414062501
                      Fri Nov 03 23:31:59 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                      Fri Nov 03 23:31:59 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -380568.92578125,-1287450.32734375,-315791.6828125,-1222673.084375
                      Fri Nov 03 23:31:59 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                      Fri Nov 03 23:32:31 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 17343ms, total time loading 64801 features: 31859ms.
                      Fri Nov 03 23:32:31 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 31875ms.
                      Fri Nov 03 23:32:31 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.010034388161805135 0.0 0.0 -0.010034388161805144 4468.776323610274 -11618.776323610284
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 64801 styled features: 6062ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 64801 styled features: 47ms
                      Fri Nov 03 23:32:37 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 6297ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 453ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 38172ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 62ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 38687ms
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                      Fri Nov 03 23:32:37 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                      Fri Nov 03 23:32:37 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-47
                      Fri Nov 03 23:32:37 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -380568.92578125,-1222673.084375,-315791.6828125,-1157895.8414062501
                      Fri Nov 03 23:32:37 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                      Fri Nov 03 23:32:43 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 26797ms, total time loading 53662 features: 44016ms.
                      Fri Nov 03 23:32:43 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 44047ms.
                      Fri Nov 03 23:32:43 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.010034388161805135 0.0 0.0 -0.010034388161805144 3818.7763236102724 -12268.776323610284
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 53662 styled features: 4406ms
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 53662 styled features: 31ms
                      Fri Nov 03 23:32:47 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 4437ms
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 453ms
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 48500ms
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 78ms
                      Fri Nov 03 23:32:47 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 49031ms
                      Fri Nov 03 23:32:48 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                      Fri Nov 03 23:32:48 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                      Fri Nov 03 23:32:48 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                      Fri Nov 03 23:32:48 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-49
                      Fri Nov 03 23:32:48 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -315791.68281250005,-1222673.084375,-251014.43984375003,-1157895.8414062501
                      Fri Nov 03 23:32:48 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 46640ms, total time loading 39340 features: 61359ms.
                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: DU_SR
                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: No more data to read from socket
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
                           at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1525)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalNBytes(T4CMAREngine.java:1490)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalBuffer(T4CMAREngine.java:2004)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1879)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1925)
                           at oracle.jdbc.driver.T4CNamedTypeAccessor.unmarshalOneRow(T4CNamedTypeAccessor.java:143)
                           at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:905)
                           at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:843)
                           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:628)
                           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
                           at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1027)
                           at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:302)
                           at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
                           at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                           at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                           at oracle.sdovis.Theme.prepareData(Theme.java:174)
                           at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: DU_SR
                      Description: Nested exception is:
                      java.sql.SQLException: No more data to read from socket
                      java.sql.SQLException: No more data to read from socket
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
                           at oracle.jdbc.driver.T4CMAREngine.getNBytes(T4CMAREngine.java:1525)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalNBytes(T4CMAREngine.java:1490)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalBuffer(T4CMAREngine.java:2004)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1879)
                           at oracle.jdbc.driver.T4CMAREngine.unmarshalCLR(T4CMAREngine.java:1925)
                           at oracle.jdbc.driver.T4CNamedTypeAccessor.unmarshalOneRow(T4CNamedTypeAccessor.java:143)
                           at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:905)
                           at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:843)
                           at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:628)
                           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
                           at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1027)
                           at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:302)
                           at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:213)
                           at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                           at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                           at oracle.sdovis.Theme.prepareData(Theme.java:174)
                           at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                      Fri Nov 03 23:33:39 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 61469ms.
                      Fri Nov 03 23:33:39 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.010034388161805135 0.0 0.0 -0.010034388161805144 3818.7763236102724 -11618.776323610284
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                      Fri Nov 03 23:33:39 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 61469ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 62ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 61531ms
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                      Fri Nov 03 23:33:39 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-51
                      Fri Nov 03 23:33:39 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -445346.1687500002,-1287450.32734375,-380568.9257812502,-1222673.084375
                      Fri Nov 03 23:33:39 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                      Fri Nov 03 23:33:39 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: -1162593219437ms, total time loading 0 features: 0ms.
                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: DU_SR
                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: OALL8 is in an inconsistent state
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
                           at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
                           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
                           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
                           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1114)
                           at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
                           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1224)
                           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3322)
                           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3367)
                           at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:623)
                           at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                           at oracle.sdovis.Theme.prepareData(Theme.java:174)
                           at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                      Fri Nov 03 23:33:39 CET 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: DU_SR
                      Description: Nested exception is:
                      java.sql.SQLException: OALL8 is in an inconsistent state
                      java.sql.SQLException: OALL8 is in an inconsistent state
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
                           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
                           at oracle.jdbc.driver.T4C8Oall.marshal(T4C8Oall.java:352)
                           at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:202)
                           at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
                           at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1114)
                           at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
                           at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1224)
                           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3322)
                           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3367)
                           at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:623)
                           at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                           at oracle.sdovis.Theme.prepareData(Theme.java:174)
                           at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)
                      .
                      .
                      .
                      -------------------------------------------------------------------------------------------------------------------------------
                      I also tried your sample but it ends up with error:
                      Loading geometry...
                      java.lang.ClassCastException: java.math.BigDecimal
                      at JDBCGeoms.getStuff(JDBCGeoms.java:29)
                      at JDBCGeoms.main(JDBCGeoms.java:57)
                      when I use following select:
                      SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(-315791.68281250005,-1222673.084375,-251014.43984375003,-1157895.8414062501)), 'querytype=WINDOW') = 'TRUE'

                      The same select runs ok in sqldeveloper.

                      Just to imagine my scenario: I want to make map that contains all parcels of land of whole city thematically colored. When I zoom only one part of city - mapviewer renders it well but I need bird's eye view of whole city - so I can't simplify my layer - so how to prepare tiles for oracle maps if mapviewer always fails?

                      thanks,

                      Branislav
                      • 8. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                        Lqian-Oracle
                        well this certainly looks like a JDBC driver issue. Can you try with the OCI driver (create your mapviewer data source with mode set to "oci8" instead of "thin") and see if that makes a difference?
                        • 9. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                          Branislav Nemec
                          Hi,

                          I tried but with the same result (the same tiles are made and the same ones are not).
                          In log file this time with error: ORA-12152: TNS:unable to send break message
                          ---------------------------------------------------------------------------------------------------------------------------
                          Sun Nov 05 19:08:11 CET 2006 FINEST [oracle.lbs.mapserver.core.MapperConfig]
                          Allowed IPs:
                          Excluded IPs:

                          Sun Nov 05 19:08:11 CET 2006 WARN [oracle.sdovis.gvc] will use 96 as default dpi.
                          Sun Nov 05 19:08:11 CET 2006 FINEST [oracle.lbs.mapserver.core.MapperConfig] Non-Spatial Data Provider registered: defaultNSDP
                          Sun Nov 05 19:08:11 CET 2006 INFO [oracle.lbs.mapserver.core.MapperConfig] Map Recycling thread started.
                          Sun Nov 05 19:08:11 CET 2006 INFO [oracle.lbs.mapserver.oms] *** Oracle MapViewer started. ***
                          Sun Nov 05 19:08:12 CET 2006 INFO [oracle.lbs.mapserver.core.MapRecycleThread, ,#Thread-18] cleansing old maps
                          Sun Nov 05 19:09:13 CET 2006 INFO [oracle.sdovis.SRS] Using 96 as default dpi.
                          Sun Nov 05 19:09:14 CET 2006 FINEST [oracle.sdovis.DBSRSCache] Number of geodetic srids loaded: 748.
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.sdovis.CacheMgr2] Spatial Data Cache opened. Region=SDOVIS_DATA.
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.sdovis.CacheMgr2]      max_cache_size=32 MB.
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.sdovis.CacheMgr2] sub region sdovis_subreg_mvdemo_jdbc:oracle:oci8:@dblic created in cache.
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                          Sun Nov 05 19:09:14 CET 2006 INFO [oracle.lbs.mapserver.core.MapperPool] added a mapper instance to the pool [data src=mvdemo]
                          Sun Nov 05 19:09:57 CET 2006 FINEST [oracle.mapviewer.webconsole.beans.newMCI] createMapCache xml request:
                          <?xml version="1.0" standalone="yes"?>
                          <map_cache_admin_request>
                          <create_cache_instance data_source="MVDEMO">
                          <cache_instance
                          name="du_map"
                          image_format="PNG">
                          <internal_map_source base_map="DU_MAP" bgcolor="none"/>
                          <cache_storage root_path="/private/scrtach" />
                          <coordinate_system
                          srid="2065"
                          minX="-2000000.0" maxX="2000000.0" minY="-2000000.0" maxY="2000000.0"/>
                          <tile_image width="256" height="256" />
                          <zoom_levels levels="10" min_scale="1000" max_scale="5000000">
                          </zoom_levels>
                          </cache_instance>
                          </create_cache_instance>
                          </map_cache_admin_request>

                          Sun Nov 05 19:09:57 CET 2006 INFO [oracle.sdovis.DBSRSCache] Loading SRS information from MDSYS.cs_srs (srid=2065).
                          Sun Nov 05 19:09:57 CET 2006 DEBUG [oracle.sdovis.DBSRSCache] Registering srs 2065, isGeodetic=false, unit=METER
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.ThemeTable] key_column specified by user: ID_JPRL
                          Sun Nov 05 19:10:15 CET 2006 INFO [oracle.sdovis.CacheMgr2] Creating/replacing a geometry cache group: sdovis_subreg_mvdemo_jdbc:oracle:oci8:@dblic : TM_DU_SR_GEOMETRY_PDT_GEOM.
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-25
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -422545.39520000014,-1408454.5232000002,-225363.56960000016,-1211272.6976
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:10:15 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-26
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -422545.39520000014,-1211272.6976,-225363.56960000016,-1014090.8720000001
                          Sun Nov 05 19:10:15 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:11:03 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 10422ms, total time loading 131981 features: 47406ms.
                          Sun Nov 05 19:11:03 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 47531ms.
                          Sun Nov 05 19:11:03 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720637 1645.7645755441274 -3949.764575544127
                          Sun Nov 05 19:11:13 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 131981 styled features: 10422ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 131981 styled features: 125ms
                          Sun Nov 05 19:11:14 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 10656ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 672ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 58203ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 58891ms
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:11:14 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:11:14 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-28
                          Sun Nov 05 19:11:14 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -619727.2208000002,-1408454.5232000002,-422545.39520000026,-1211272.6976
                          Sun Nov 05 19:11:14 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 51406ms, total time loading 144070 features: 89828ms.
                          Sun Nov 05 19:11:45 CET 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: DU_SR
                          Sun Nov 05 19:11:45 CET 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ORA-12152: TNS:unable to send break message

                               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
                               at oracle.jdbc.driver.T2CPreparedStatement.fetch(T2CPreparedStatement.java:1204)
                               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
                               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
                               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                               at oracle.sdovis.Theme.prepareData(Theme.java:174)
                               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                          Sun Nov 05 19:11:45 CET 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: DU_SR
                          Description: Nested exception is:
                          java.sql.SQLException: ORA-12152: TNS:unable to send break message

                          java.sql.SQLException: ORA-12152: TNS:unable to send break message

                               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
                               at oracle.jdbc.driver.T2CPreparedStatement.fetch(T2CPreparedStatement.java:1204)
                               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
                               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
                               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                               at oracle.sdovis.Theme.prepareData(Theme.java:174)
                               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                          Sun Nov 05 19:11:45 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 89828ms.
                          Sun Nov 05 19:11:45 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720615 1645.7645755441274 -4717.764575544124
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:11:45 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 47ms
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 688ms
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 89875ms
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 0ms
                          Sun Nov 05 19:11:45 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 90563ms
                          Sun Nov 05 19:11:46 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:11:46 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:11:46 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:11:46 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-30
                          Sun Nov 05 19:11:46 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -816909.0464000001,-1408454.5232000002,-619727.2208000001,-1211272.6976
                          Sun Nov 05 19:11:46 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 45000ms, total time loading 23100 features: 50515ms.
                          Sun Nov 05 19:12:05 CET 2006 ERROR [oracle.sdovis.theme.pgtp] *** Exception while querying theme: DU_SR
                          Sun Nov 05 19:12:05 CET 2006 ERROR [oracle.sdovis.theme.pgtp] java.sql.SQLException: ORA-12152: TNS:unable to send break message

                               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
                               at oracle.jdbc.driver.T2CPreparedStatement.fetch(T2CPreparedStatement.java:1204)
                               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
                               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
                               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                               at oracle.sdovis.Theme.prepareData(Theme.java:174)
                               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                          Sun Nov 05 19:12:05 CET 2006 ERROR [oracle.sdovis.ltd] Message:Exception while querying theme: DU_SR
                          Description: Nested exception is:
                          java.sql.SQLException: ORA-12152: TNS:unable to send break message

                          java.sql.SQLException: ORA-12152: TNS:unable to send break message

                               at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
                               at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
                               at oracle.jdbc.driver.T2CPreparedStatement.fetch(T2CPreparedStatement.java:1204)
                               at oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:277)
                               at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:206)
                               at oracle.sdovis.theme.PredGeomThemeProducer.loadFeaturesInWindow(PredGeomThemeProducer.java:637)
                               at oracle.sdovis.theme.PredGeomThemeProducer.prepareData(PredGeomThemeProducer.java:295)
                               at oracle.sdovis.Theme.prepareData(Theme.java:174)
                               at oracle.sdovis.LoadThemeData.run(LoadThemeData.java:66)

                          Sun Nov 05 19:12:05 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 50593ms.
                          Sun Nov 05 19:12:05 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720615 2413.7645755441276 -4717.764575544124
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:12:05 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 50593ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 50609ms
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:12:05 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:12:05 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-32
                          Sun Nov 05 19:12:05 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -619727.2208000002,-1211272.6976,-422545.39520000026,-1014090.8720000001
                          Sun Nov 05 19:12:05 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:17:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:17:05 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:17:05 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:17:05 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-35
                          Sun Nov 05 19:17:05 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -225363.56960000028,-1211272.6976,-28181.744000000297,-1014090.8720000001
                          Sun Nov 05 19:17:05 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:17:19 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 6328ms, total time loading 29886 features: 13297ms.
                          Sun Nov 05 19:17:19 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 13407ms.
                          Sun Nov 05 19:17:19 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720637 877.7645755441278 -3949.764575544127
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 29886 styled features: 1984ms
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 29886 styled features: 16ms
                          Sun Nov 05 19:17:21 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 2000ms
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 15422ms
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 0ms
                          Sun Nov 05 19:17:21 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 15422ms
                          Sun Nov 05 19:20:08 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:20:08 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:20:08 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:20:08 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-38
                          Sun Nov 05 19:20:08 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -619727.2208000002,-1211272.6976,-422545.39520000026,-1014090.8720000001
                          Sun Nov 05 19:20:08 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:20:38 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 11453ms, total time loading 89898 features: 29765ms.
                          Sun Nov 05 19:20:38 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 29906ms.
                          Sun Nov 05 19:20:38 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720637 2413.7645755441276 -3949.764575544127
                          Sun Nov 05 19:20:41 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 89898 styled features: 4906ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 89898 styled features: 47ms
                          Sun Nov 05 19:20:43 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 4953ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 34859ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 34875ms
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) interrupted and trying again...
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:20:43 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-40
                          Sun Nov 05 19:20:43 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -619727.2208000002,-1211272.6976,-422545.39520000026,-1014090.8720000001
                          Sun Nov 05 19:20:43 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:20:43 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:03 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 3187ms, total time loading 89898 features: 20484ms.
                          Sun Nov 05 19:21:04 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 20516ms.
                          Sun Nov 05 19:21:04 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720637 2413.7645755441276 -3949.764575544127
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 89898 styled features: 5156ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 89898 styled features: 47ms
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 5203ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) interrupted and trying again...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 2063ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 25719ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 27782ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-42
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -619727.2208000002,-1605636.3488,-422545.39520000026,-1408454.5232000002
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 16ms, total time loading 0 features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 31ms.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.003894882287772066 2413.7645755441276 -5485.764575544131
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 16ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 25235ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 47ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 46ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 25328ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-44
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -225363.56960000028,-1605636.3488,-28181.744000000297,-1408454.5232000002
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 16ms, total time loading 0 features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 31ms.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.003894882287772066 877.7645755441278 -5485.764575544131
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 31ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 47ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-47
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -816909.0464000001,-1211272.6976,-619727.2208000001,-1014090.8720000001
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 16ms, total time loading 0 features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720637 3181.764575544127 -3949.764575544127
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 16ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 32ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-49
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -816909.0464000001,-1605636.3488,-619727.2208000001,-1408454.5232000002
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 16ms, total time loading 0 features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 16ms.
                          Sun Nov 05 19:21:09 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.003894882287772066 3181.764575544127 -5485.764575544131
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:09 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 15ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 31ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:21:09 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 47ms
                          Sun Nov 05 19:21:10 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:10 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:10 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:10 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-51
                          Sun Nov 05 19:21:10 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -225363.56960000028,-1408454.5232000002,-28181.744000000297,-1211272.6976
                          Sun Nov 05 19:21:10 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:17 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 3390ms, total time loading 15438 features: 7656ms.
                          Sun Nov 05 19:21:17 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 7672ms.
                          Sun Nov 05 19:21:17 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720615 877.7645755441278 -4717.764575544124
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 15438 styled features: 1015ms
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 15438 styled features: 0ms
                          Sun Nov 05 19:21:18 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 1031ms
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 8703ms
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 0ms
                          Sun Nov 05 19:21:18 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 8703ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:21:19 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-53
                          Sun Nov 05 19:21:19 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -422545.39520000014,-1605636.3488,-225363.56960000016,-1408454.5232000002
                          Sun Nov 05 19:21:19 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 15ms, total time loading 0 features: 15ms.
                          Sun Nov 05 19:21:19 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 15ms.
                          Sun Nov 05 19:21:19 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.003894882287772066 1645.7645755441274 -5485.764575544131
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:21:19 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 15ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:21:19 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 31ms
                          Sun Nov 05 19:24:29 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper(MVDEMO) begins...
                          Sun Nov 05 19:24:29 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] getMapper() succeeded.
                          Sun Nov 05 19:24:29 CET 2006 FINEST [oracle.sdovis.DBMapMaker] adding predefined theme [name=DU_SR]
                          Sun Nov 05 19:24:29 CET 2006 DEBUG [oracle.sdovis.ltd] LoadThemeData running thread: Thread-56
                          Sun Nov 05 19:24:29 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: -816909.0464000001,-1408454.5232000002,-619727.2208000001,-1211272.6976
                          Sun Nov 05 19:24:29 CET 2006 FINEST [oracle.sdovis.theme.pgtp] [ DU_SR ]: SELECT ID_JPRL, GEOMETRY, 'C.ZM', null, 'null', -1 FROM TM_DU_SR WHERE MDSYS.SDO_FILTER(GEOMETRY, MDSYS.SDO_GEOMETRY(2003, 2065, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1003, 3), MDSYS.SDO_ORDINATE_ARRAY(?, ?, ?, ?)), 'querytype=WINDOW') = 'TRUE'
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.sdovis.theme.pgtp] [ DU_SR ] sql exec time: 672ms, total time loading 0 features: 672ms.
                          Sun Nov 05 19:24:30 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on loading features: 672ms.
                          Sun Nov 05 19:24:30 CET 2006 FINEST [oracle.sdovis.RE] xfm: 0.0038948822877720637 0.0 0.0 -0.0038948822877720615 3181.764575544127 -4717.764575544124
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to render theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.sdovis.VectorRenderer] time to label theme DU_SR with 0 styled features: 0ms
                          Sun Nov 05 19:24:30 CET 2006 INFO [oracle.sdovis.DBMapMaker] **** time spent on rendering: 0ms
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.lbs.mapserver.core.MapperPool] freeMapper() begins...
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] preparation time: 0ms
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] querying/rendering time: 672ms
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] packing time: 16ms
                          Sun Nov 05 19:24:30 CET 2006 DEBUG [oracle.lbs.mapserver.core.RealWorker] [RealWorker] --------------- total time: 688ms
                          ---------------------------------------------------------------------------------------------------------------------------

                          thanks,

                          Branislav
                          • 10. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                            Lqian-Oracle
                            Have a look on the database server itself. You most probably will find a core dump there causing these errors. It looks like you are running into an RDBMS bug. Check the alert.log file of the database for an ORA-7445 and the corresponding trace file of the dump.

                            feel free to contact me offline (lj@qian@oracle@com - replace @ with dot except the second one).

                            thanks
                            • 11. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                              544543
                              Hi,
                              I have same problem with 10gEX at home but i have no problem with 10g at work.
                              Both codes and drivers are same..
                              I just trying to use sys user and inital PLSExtProc service for connection and i could not get a connection.
                              Here is alert.log content,

                              Dump file c:\oraclexe\app\oracle\admin\xe\bdump\alert_xe.log
                              Wed Nov 08 05:06:37 2006
                              ORACLE V10.2.0.1.0 - Production vsnsta=0
                              vsnsql=14 vsnxtr=3
                              Windows XP Version V5.1 Service Pack 2
                              CPU : 1 - type 586
                              Process Affinity : 0x00000000
                              Memory (Avail/Total): Ph:286M/1022M, Ph+PgF:1903M/2459M, VA:1944M/2047M
                              Wed Nov 08 05:06:37 2006
                              Starting ORACLE instance (normal)
                              LICENSE_MAX_SESSION = 0
                              LICENSE_SESSIONS_WARNING = 0
                              Picked latch-free SCN scheme 2
                              Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
                              Autotune of undo retention is turned on.
                              IMODE=BR
                              ILAT =10
                              LICENSE_MAX_USERS = 0
                              SYS auditing is disabled
                              ksdpec: called for event 13740 prior to event group initialization
                              Starting up ORACLE RDBMS Version: 10.2.0.1.0.
                              System parameters with non-default values:
                              sessions = 49
                              __shared_pool_size = 83886080
                              __large_pool_size = 8388608
                              __java_pool_size = 4194304
                              __streams_pool_size = 0
                              spfile = C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DBS\SPFILEXE.ORA
                              sga_target = 285212672
                              control_files = C:\ORACLEXE\ORADATA\XE\CONTROL.DBF
                              __db_cache_size = 184549376
                              compatible = 10.2.0.1.0
                              db_recovery_file_dest = C:\oraclexe\app\oracle\flash_recovery_area
                              db_recovery_file_dest_size= 10737418240
                              undo_management = AUTO
                              undo_tablespace = UNDO
                              remote_login_passwordfile= EXCLUSIVE
                              dispatchers = (PROTOCOL=TCP) (SERVICE=XEXDB)
                              shared_servers = 4
                              job_queue_processes = 4
                              audit_file_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\ADUMP
                              background_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\BDUMP
                              user_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP
                              core_dump_dest = C:\ORACLEXE\APP\ORACLE\ADMIN\XE\CDUMP
                              db_name = XE
                              open_cursors = 300
                              os_authent_prefix =
                              pga_aggregate_target = 94371840
                              PMON started with pid=2, OS id=2292
                              PSP0 started with pid=3, OS id=3912
                              MMAN started with pid=4, OS id=2424
                              DBW0 started with pid=5, OS id=3444
                              LGWR started with pid=6, OS id=1972
                              CKPT started with pid=7, OS id=4088
                              SMON started with pid=8, OS id=2760
                              RECO started with pid=9, OS id=2320
                              CJQ0 started with pid=10, OS id=2532
                              MMON started with pid=11, OS id=1192
                              Wed Nov 08 05:06:37 2006
                              starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
                              MMNL started with pid=12, OS id=1340
                              Wed Nov 08 05:06:37 2006
                              starting up 4 shared server(s) ...
                              Oracle Data Guard is not available in this edition of Oracle.
                              Wed Nov 08 05:06:37 2006
                              alter database mount exclusive
                              Wed Nov 08 05:06:42 2006
                              Setting recovery target incarnation to 2
                              Wed Nov 08 05:06:42 2006
                              Successful mount of redo thread 1, with mount id 2487007261
                              Wed Nov 08 05:06:42 2006
                              Database mounted in Exclusive Mode
                              Completed: alter database mount exclusive
                              Wed Nov 08 05:06:42 2006
                              alter database open
                              Wed Nov 08 05:06:42 2006
                              Thread 1 opened at log sequence 13
                              Current log# 2 seq# 13 mem# 0: C:\ORACLEXE\APP\ORACLE\FLASH_RECOVERY_AREA\XE\ONLINELOG\O1_MF_2_2NLB7JWS_.LOG
                              Successful open of redo thread 1
                              Wed Nov 08 05:06:42 2006
                              SMON: enabling cache recovery
                              Wed Nov 08 05:06:45 2006
                              Successfully onlined Undo Tablespace 1.
                              Wed Nov 08 05:06:45 2006
                              SMON: enabling tx recovery
                              Wed Nov 08 05:06:45 2006
                              Database Characterset is WE8MSWIN1252
                              replication_dependency_tracking turned off (no async multimaster replication found)
                              Starting background process QMNC
                              QMNC started with pid=19, OS id=2164
                              Wed Nov 08 05:06:52 2006
                              Completed: alter database open
                              Wed Nov 08 05:06:54 2006
                              db_recovery_file_dest_size of 10240 MB is 0.98% used. This is a
                              user-specified limit on the amount of space that will be used by this
                              database for recovery-related files, and does not reflect the amount of
                              space available in the underlying filesystem or ASM diskgroup.

                              I hope this helps.
                              • 12. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                                544543
                                I just found this in ms event log, while oracle sevice starting it gives a warning

                                Event Type:     Warning
                                Event Source:     Oracle.xe
                                Event Category:     None
                                Event ID:     12
                                Date:          08.11.2006
                                Time:          05:26:55
                                User:          N/A
                                Computer:     NOMAD
                                Description:
                                The description for Event ID ( 12 ) in Source ( Oracle.xe ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: xe.
                                • 13. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                                  544543
                                  Also found listener.log has produced these,
                                  -------------------------------------------------------------------------------------------------------
                                  TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 08-KAS-2006 05:33:54

                                  Copyright (c) 1991, 2005, Oracle. All rights reserved.

                                  System parameter file is C:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora
                                  Log messages written to C:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log
                                  Trace information written to C:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc
                                  Trace level is currently 0

                                  Started with pid=3948
                                  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc)))
                                  Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nomad)(PORT=1521)))
                                  Listener completed notification to CRS on start

                                  TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
                                  08-KAS-2006 05:34:15 * (CONNECT_DATA=(SID=PLSExtProc)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.2)(PORT=2660)) * establish * PLSExtProc * 0
                                  08-KAS-2006 05:41:04 * (CONNECT_DATA=(SID=PLSExtProc)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.2)(PORT=2683)) * establish * PLSExtProc * 0
                                  08-KAS-2006 05:44:30 * (CONNECT_DATA=(SID=PLSExtProc)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.2)(PORT=2693)) * establish * PLSExtProc * 0
                                  08-KAS-2006 05:50:29 * (CONNECT_DATA=(SID=PLSExtProc)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.2)(PORT=2714)) * establish * PLSExtProc * 0
                                  • 14. Re: Oracle Maps RC1 - java.sql.SQLException: No more data to read from sock
                                    Branislav Nemec
                                    Hi,

                                    the problem was RDBMS bug. after upgrading the database to 10.2.0.2 and recreating problematic table the problem is solved

                                    thanks,

                                    Branislav