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.

Version:

$Id$

Author:

Rich Stepanski

Constructor Summary

DerbyDialect()
Creates a new DerbyDialect.

Method Summary

protected java.lang.String	constantToSql(java.lang.String valueType, java.lang.Object value) Helper for controlling how constant values of where clauses are writing in Sql.
java.lang.String	createTable(CogSchema schema, CogStructureType tableType) Returns complete Sql create table statement.
java.lang.String	selectSql(DataRecordQuery query, CogStructureType tableType) Returns complete Sql select statement.

Methods inherited from class com.partnersoft.sql.GenericSqlDialect

addColumn, alterColumn, cogTypeToSqlType, dropColumn, handleSorts, listFields, parseFilter

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

constantToSql

protected java.lang.String constantToSql(java.lang.String valueType,
                                         java.lang.Object value)

Description copied from class: GenericSqlDialect

Helper for controlling how constant values of where clauses are writing in Sql. By default, returns SqlLib.convertToStringAndQuote()

Overrides:

constantToSql in class GenericSqlDialect

Parameters:

valueType - - CogStructureField's value type for this field.

value - - Value to covert to String for Sql.

Returns:

String value of passed Object value to embed in Sql.

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.