/*
* GeoTools - The Open Source Java GIS Toolkit
* http://geotools.org
*
* (C) 2002-2008, Open Source Geospatial Foundation (OSGeo)
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation;
* version 2.1 of the License.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*/
package org.geotools.data.db2;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.Driver;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.Map;
import org.geotools.data.DataAccessFactory.Param;
import org.geotools.jdbc.JDBCDataStore;
import org.geotools.jdbc.JDBCDataStoreFactory;
import org.geotools.jdbc.SQLDialect;
import com.vividsolutions.jts.io.ByteArrayInStream;
import com.vividsolutions.jts.io.ByteOrderDataInStream;
import com.vividsolutions.jts.io.ByteOrderValues;
import com.vividsolutions.jts.io.WKBConstants;
/**
* DataStoreFactory for DB2 database.
*
* @author Christian Mueller
*
*
*
*
* @source $URL$
*/
public class DB2NGDataStoreFactory extends JDBCDataStoreFactory {
public static String GetCurrentSchema = "select current sqlid from sysibm.sysdummy1";
public static String GetWKBZTypes = "select db2gse.st_asbinary(db2gse.st_point(1,2,3,0)) from sysibm.sysdummy1";
public static String SelectGeometryColumns="select * from db2gse.st_geometry_columns where 0 = 1";
/** parameter for database type */
public static final Param DBTYPE = new Param("dbtype", String.class, "Type", true, "db2");
/** enables using EnvelopesIntersect in bbox queries */
public static final Param LOOSEBBOX = new Param("Loose bbox", Boolean.class, "Perform only primary filter on bbox", false, Boolean.TRUE);
public final static String DriverClassName = "com.ibm.db2.jcc.DB2Driver";
protected SQLDialect createSQLDialect(JDBCDataStore dataStore) {
return new DB2SQLDialectPrepared(dataStore, new DB2DialectInfo());
}
public String getDisplayName() {
return "DB2 NG";
}
protected String getDriverClassName() {
return DriverClassName;
}
protected String getDatabaseID() {
return (String) DBTYPE.sample;
}
public String getDescription() {
return "DB2 Database";
}
@Override
protected String getValidationQuery() {
return "select current date from sysibm.sysdummy1";
}
@Override
protected boolean checkDBType(Map params) {
if (super.checkDBType(params)) {
return true;
}
//check also for "DB2" which is iold db type, but only when the old
// factory is not on the classpath
if (checkDBType(params, "DB2")) {
try {
Class.forName("org.geotools.data.db2.DB2DataStoreFactory");
//old factory is around, let it handle the connection
return false;
}
catch (ClassNotFoundException e) {
return true;
}
}
return false;
}
@Override
protected String getJDBCUrl(Map params) throws IOException {
// jdbc url
String host=null;
Integer port = null;
try {
host = (String) HOST.lookUp(params);
port = (Integer) PORT.lookUp(params);
} catch (IOException ex) {
// do nothing
}
String db = (String) DATABASE.lookUp(params);
if (host==null && port== null && db !=null)
return "jdbc:"+getDatabaseID()+":"+db;
return super.getJDBCUrl(params);
}
protected void setupParameters(Map parameters) {
super.setupParameters(parameters);
parameters.put(DBTYPE.key, DBTYPE);
parameters.put(LOOSEBBOX.key, LOOSEBBOX);
}
@Override
protected JDBCDataStore createDataStoreInternal(JDBCDataStore dataStore, Map params)
throws IOException {
Connection con = null;
try {
con = dataStore.getDataSource().getConnection();
DB2DialectInfo di = ((DB2SQLDialectPrepared) dataStore.getSQLDialect()).getDb2DialectInfo();
DB2SQLDialectPrepared dialect = (DB2SQLDialectPrepared) dataStore.getSQLDialect();
Boolean loose = (Boolean) LOOSEBBOX.lookUp(params);
dialect.setLooseBBOXEnabled(loose == null || Boolean.TRUE.equals(loose));
DatabaseMetaData md = con.getMetaData();
di.setMajorVersion(md.getDatabaseMajorVersion());
di.setMinorVersion(md.getDatabaseMinorVersion());
di.setProductName(md.getDatabaseProductName());
di.setProductVersion(md.getDatabaseProductVersion());
PreparedStatement ps = con.prepareStatement(SelectGeometryColumns);
ResultSet rs=ps.executeQuery();
ResultSetMetaData rsmd=ps.getMetaData();
for (int i = 0; i < rsmd.getColumnCount();i++) {
if ("MIN_X".equals(rsmd.getColumnName(i+1))) {
di.setSupportingPrecalculatedExtents(true);
break;
}
}
rs.close();
ps.close();
if (dataStore.getDatabaseSchema()==null) {
ps = con.prepareStatement(GetCurrentSchema);
rs = ps.executeQuery();
rs.next();
dataStore.setDatabaseSchema(rs.getString(1));
rs.close();
ps.close();
}
ps = con.prepareStatement(GetWKBZTypes);
rs = ps.executeQuery();
rs.next();
byte[] bytes = rs.getBytes(1);
ByteOrderDataInStream dis = new ByteOrderDataInStream();
dis.setInStream(new ByteArrayInStream(bytes));
byte byteOrder = dis.readByte();
// default is big endian
if (byteOrder == WKBConstants.wkbNDR)
dis.setOrder(ByteOrderValues.LITTLE_ENDIAN);
int geometryType = dis.readInt();
if (geometryType==1001)
di.setHasOGCWkbZTyps(true);
rs.close();
ps.close();
} catch (SQLException e) {
throw new IOException(e.getMessage());
}
dataStore.closeSafe(con);
return dataStore;
}
}