Examples of org.geotools.jdbc.SQLDialect

org.geotools.jdbc.SQLDialect

The driver used by JDBCDataStore to directly communicate with the database.

This class encapsulates all the database specific operations that JDBCDataStore needs to function. It is implemented on a per-database basis.

Type Mapping

One of the jobs of a dialect is to map sql types to java types and vice versa. This abstract implementation provides default mappings for "primitive" java types. The following mappings are provided. A '*' denotes that the mapping is the default java to sql mapping as well.

VARCHAR -> String
CHAR -> String
LONGVARCHAR -> String
BIT -> Boolean
BOOLEAN -> Boolean
SMALLINT -> Short
TINYINT -> Short
INTEGER -> Integer
BIGINT -> Long
REAL -> Float
DOUBLE -> Double
FLOAT -> Double
NUMERIC -> BigDecimal
DECIMAL -> BigDecimal
DATE -> java.sql.Date
TIME -> java.sql.Time
TIMESTAMP -> java.sql.Timestmap

Subclasses should extend (not override) the following methods to configure the mappings:

{@link #registerSqlTypeToClassMappings(Map)}
{@link #registerSqlTypeNameToClassMappings(Map)}
{@link #registerClassToSqlMappings(Map)}

This class is intended to be stateless, therefore subclasses should not maintain any internal state. If for some reason a subclass must keep some state around (not recommended), it must ensure that the state is accessed in a thread safe manner.

@author Justin Deoliveira, The Open Planning Project @source $URL$

            // this allows PostGIS to page the results and respect the fetch size
            if(getState().getTransaction() == Transaction.AUTO_COMMIT) {
                cx.setAutoCommit(false);
            }
            
            SQLDialect dialect = getDataStore().getSQLDialect();
            if ( dialect instanceof PreparedStatementSQLDialect ) {
                PreparedStatement ps = selectSQLPS(querySchema, preQuery, cx);
                reader = new JDBCFeatureReader( ps, cx, this, fullSchema, query.getHints() );
            } else {
                //build up a statement for the content

    
    protected void setUpDataStore(JDBCDataStore dataStore) {
        super.setUpDataStore(dataStore);
        
        // the unit tests needs function encoding enabled to actually test that
        SQLDialect dialect = dataStore.getSQLDialect();
        if (dialect instanceof DB2SQLDialectBasic)
            ((DB2SQLDialectBasic) dialect).setFunctionEncodingEnabled(true);
        if (dialect instanceof DB2SQLDialectPrepared)
            ((DB2SQLDialectPrepared) dialect).setFunctionEncodingEnabled(true);
    }

            throws IOException {
        String storageEngine = (String) STORAGE_ENGINE.lookUp( params );
        if (storageEngine == null) {
            storageEngine = (String) STORAGE_ENGINE.sample;
        }
        SQLDialect dialect = dataStore.getSQLDialect();
        if (dialect instanceof MySQLDialectBasic) {
            ((MySQLDialectBasic)dialect).setStorageEngine(storageEngine);
        }
        else {
            ((MySQLDialectPrepared)dialect).setStorageEngine(storageEngine);

Examples of org.geotools.jdbc.SQLDialect

Type Mapping

Related Classes of org.geotools.jdbc.SQLDialect