Application: gvSIG desktop

      String dbuser = "postgres";

      String dbpass = "aquilina";

     java.sql.Connection conn; 

        try 

          /* 

          * Create a statement and execute a select query. 

          */

            // strSQL = "select ASTEXT(the_geom), nom_provin as geom from " + dbtable;

            /* String strSQL = "SELECT gid, rd_3, rd_5, rd_6, rd_10, rd_11, rd_12, rd_13, rd_14,"; 

            strSQL = strSQL + " rd_15, rd_16, kilometers, cost, metros, AsText(force_2d(the_geom)) FROM vias"; 

            // Statement s = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

            // s.setFetchSize(5);

			s.execute("declare wkb_cursor binary cursor for " + strSQL);

            // ResultSet r = s.executeQuery(strSQL);

			long t2 = System.currentTimeMillis();

              // Object obj = r.getObject(2);

              byte[] arrayByte = r.getBytes(1);

              IGeometry gp = parser.parse(arrayByte);

              // int id = r.getInt(2);

              // System.out.println("Fila " + id + ":" + obj.toString());

              id++;

              // Geometry regeom = PGgeometry.geomFromString(obj.toString());

            // PGgeometry geom = (PGgeometry)obj; 

              // System.out.println("provin=" + r.getString(2));

              if ((id % fetchSize) == 0)

              {