com.partnersoft.sql

Class DerbyDialect

java.lang.Object

com.partnersoft.sql.GenericSqlDialect

com.partnersoft.sql.DerbyDialect

All Implemented Interfaces:

Lib, SqlDialect

public class DerbyDialect
extends GenericSqlDialect

SqlDialect for Derby databases.

Copyright 2009 Partner Software, Inc.

Author:

Rich Stepanski

Constructor Summary

Constructors

Constructor and Description
DerbyDialect() Creates a new DerbyDialect.

Method Summary

Methods

Modifier and Type	Method and Description
java.lang.String	createTable(CogSchema schema, CogStructureType tableType) Returns complete Sql create table statement.
java.lang.Object	objectToDb(java.lang.String valueType, java.lang.Object value) Converts the passed Object of passed value type into database specific equivalent.
java.lang.String	selectSql(DataRecordQuery query, CogStructureType tableType) Returns complete Sql select statement.

Methods inherited from class com.partnersoft.sql.GenericSqlDialect

addColumn, alterColumn, cogTypeToSqlType, createTableFromSelect, dbToObject, describeTable, describleTableColumnKey, describleTableTypeKey, dropColumn, handleSorts, isAlterColumnSupported, isDescribeTableSupported, isListDatabasesSupported, isListTablesSupported, listDatabases, listFields, listTables, objectToDbSql, parseFilter, renameTable, sqlTypeToCogType

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DerbyDialect

public DerbyDialect()

Creates a new DerbyDialect.

Method Detail

objectToDb

public java.lang.Object objectToDb(java.lang.String valueType,
                          java.lang.Object value)

Description copied from interface: SqlDialect

Converts the passed Object of passed value type into database specific equivalent.

Ex. Dates may be stored as Numbers or Strings.

Specified by:

objectToDb in interface SqlDialect

Overrides:

objectToDb in class GenericSqlDialect

Parameters:

valueType - - CogStructureField value type for this field.

value - - Value to covert database Object

Returns:

database storage type equivalent

selectSql

public java.lang.String selectSql(DataRecordQuery query,
                         CogStructureType tableType)

Description copied from interface: SqlDialect

Returns complete Sql select statement.

Specified by:

selectSql in interface SqlDialect

Overrides:

selectSql in class GenericSqlDialect

Parameters:

query - - Query describing select statement.

tableType - - CogStructureType defining table. Type name is assumed to be table name.

Returns:

Sql select statement for passed query.

createTable

public java.lang.String createTable(CogSchema schema,
                           CogStructureType tableType)

Description copied from interface: SqlDialect

Returns complete Sql create table statement.

Specified by:

createTable in interface SqlDialect

Overrides:

createTable in class GenericSqlDialect

Parameters:

schema - - Schema defining column types.

tableType - - CogStructureType defining table. Type name is assumed to be table name.

Returns:

Sql create table statement for passed schema and cog type.