Revision 1988 branches/Fmap_GisPlanet/libraries/libFMap/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGisDriver.java

View differences:

PostGisDriver.java
51 51 
import java.sql.Statement;
52 52 
import java.sql.Types;
53 53 

  		




  
  54
  
    
import org.apache.log4j.Logger;


  		




  54
  55
  
    
import org.postgis.PGbox3d;


  		




  55
  56
  
    

  		




  56
  57
  
    
import com.hardcode.gdbms.engine.values.Value;


  		




  ......




  61
  62
  
    
import com.iver.cit.gvsig.fmap.drivers.DriverAttributes;


  		




  62
  63
  
    
import com.iver.cit.gvsig.fmap.drivers.IFeatureIterator;


  		




  63
  64
  
    
import com.iver.cit.gvsig.fmap.drivers.WKBParser;


  		




  
  65
  
    
import com.iver.cit.gvsig.fmap.drivers.shp.DemoSHPDriver;


  		




  64
  66
  
    
import com.vividsolutions.jts.io.ParseException;


  		




  65
  67
  
    

  		




  66
  68
  
    
/**


  		




  ......




  70
  72
  
    
 * Window - Preferences - Java - Code Generation - Code and Comments


  		




  71
  73
  
    
 */


  		




  72
  74
  
    
public class PostGisDriver extends DefaultDBDriver {


  		




  
  75
  
    
    private static Logger logger = Logger.getLogger(PostGisDriver.class.getName());


  		




  73
  76
  
    
    private WKBParser parser = new WKBParser();


  		




  74
  77
  
    
    private int fetch_min=-1;


  		




  75
  78
  
    
    private int fetch_max=-1;


  		




  ......




  140
  143
  
    
	    try {


  		




  141
  144
  
    
	        st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);


  		




  142
  145
  
    
	        st.setFetchSize(5000);


  		




  
  146
  
    
            logger.info("Cadena SQL:" + this.sqlOrig);


  		




  143
  147
  
    
	        st.execute("declare wkb_cursor binary cursor for " + sqlOrig);


  		




  144
  148
  
    
	        rs = st.executeQuery("fetch forward all in wkb_cursor");


  		




  145
  149
  
    
	        // st.execute("begin"); 


  		




  ......




  337
  341
  
    
	 * @see com.iver.cit.gvsig.fmap.drivers.VectorialDatabaseDriver#getGeometryField(java.lang.String)


  		




  338
  342
  
    
	 */


  		




  339
  343
  
    
	public String getGeometryField(String fieldName) {


  		




  340
  
  
    
		return "ASBINARY(" + fieldName + ", XDR)";


  		




  
  344
  
    
		return "ASBINARY(" + fieldName + ", 'XDR')";


  		




  341
  345
  
    
	}


  		




  342
  346
  
    
    /**


  		




  343
  347
  
    
     * @see com.hardcode.gdbms.engine.data.driver.ObjectDriver#getPrimaryKeys()


  		












Also available in:  Unified diff