| gvSIG desktop 1

//          String dburl = "jdbc:postgresql://localhost/latin1";

//          String dbuser = "postgres";

//          String dbpass = "aquilina";

        String dburl = "jdbc:postgresql://192.168.0.217/postgis";

        String dbuser = "gvsig";

        String dbpass = "";

          String dbtable = "carreteras_lin_5k_t10";

              // String strSQL = "select ASBINARY(geometria) as geom, fecha_inicio_evento, fecha_fin_evento, date1, time1 from " + dbtable;

        	  String strSQL = "select ASBINARY(the_geom) as geom from " + dbtable;

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

                IGeometry gp2 = parser2.parse(arrayByte);

//                String strAux = r.getString(5);

//                System.out.println("Straux = " + strAux);

//                byte[] data1 = r.getBytes(2);

//                byte[] data2 = r.getBytes(3);

//                byte[] bdate1 = r.getBytes(4);

//                byte[] btime1 = r.getBytes(5);

//                ByteBuffer buf = ByteBuffer.wrap(data1);

//                ByteBuffer bufDate1 = ByteBuffer.wrap(bdate1);

//                ByteBuffer bufTime1 = ByteBuffer.wrap(btime1);

//                

//                long daysAfter2000 = bufDate1.getInt() + 1;

//                long msecs = daysAfter2000*24*60*60*1000;

//                long real_msecs_date1 = (long) (num_msSecs2000 + msecs);

//                Date realDate1 = new Date(real_msecs_date1);

//                System.err.println("Date1 = " + realDate1 + " diff = " + (real_msecs_date1 - num_msSecs2000));

//                

//                Calendar cal = new GregorianCalendar();

//                cal.setTimeInMillis(0);

//                // bufTime1.order(ByteOrder.LITTLE_ENDIAN);

//                long microsecs = bufTime1.getLong();

//                long real_msecs = microsecs - 3600000; // le quitamos una hora.

//                cal.setTimeInMillis(real_msecs);

//                long milis = cal.getTimeInMillis();

//                Time mytime1 = new Time(real_msecs);

//                Date mytime1asdate = new Date(real_msecs);

//                System.err.println("microsecs = " + microsecs + " TIME1 = " + mytime1);

//                System.err.println("microsecs = " + (long)num_msSecs2000 + " TIME1ASDATE = " + mytime1asdate);

//

//				

//				double n1 = buf.getDouble(0); // num segs after 2000

////				Timestamp ts2000 = new Timestamp(2000-1900, 0, 1, 0, 0 , 0, 0);

////				int offset = ts2000.getTimezoneOffset() * 60 * 1000;

//				

////				double num_msSecs2000 = ts2000.getTime() + offset;

//				long real_msecs2 = (long) (num_msSecs2000 + n1*1000);

//				Timestamp real = new Timestamp(real_msecs2);

//

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

//                System.out.println("Fila " + id + ": fecha:" + real);

//                id++;

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

//                

//              // PGgeometry geom = (PGgeometry)obj; 

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

//              // System.out.println("Row " + id + ":" + strAux); 

//              // System.out.println(geom.toString()); 

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

//                /* if ((id % fetchSize) == 0)

//                {

//                    r =   s.executeQuery("fetch forward " + fetchSize + " in wkb_cursor");

//                } */