|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Types.ARRAY
constant.
Types.BIGINT
constant.
Types.BINARY
constant.
Types.BIT
constant.
Types.BLOB
constant.
Types.BOOLEAN
constant.
Types.CHAR
constant.
Types.CLOB
constant.
SqlTypeConverter
implementations.Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.Database.createDynaBeanFor(Table)
and
Database.findTable(String, boolean)
.
SqlBuilder.createTable(Database, Table, Map)
.
Types.DATALINK
constant.
Types.DATE
constant.
Types.DECIMAL
constant.
Types.DISTINCT
constant.
Types.DOUBLE
constant.
DataReader
.DataSink
implementations.DataWriter
.Date
and String
using the standard
representation "yyyy", or "yyyy-mm", or "yyyy-mm-dd".ResultSetMetaData.isAutoIncrement(int)
method.
Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.
Platform.setDataSource(DataSource)
because it is not possible to
retrieve the connection information from it without establishing a connection.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Database, Table)
if you want that.
SqlBuilder.dropTable(Table)
.
PlatformInfo.getSqlCommandDelimiter()
of the info object
of this platform.
PlatformInfo.getSqlCommandDelimiter()
of the info object
of this platform.
PlatformInfo.getSqlCommandDelimiter()
of the info object
of this platform.
PlatformInfo.getSqlCommandDelimiter()
of the info object
of this platform.
TODO: consider outputting a collection of String or some kind of statement
object from the SqlBuilder instead of having to parse strings here
Types.FLOAT
constant.
Platform.query(Database, String)
method all beans will be
materialized and the connection will be closed before returning the beans.
Platform.query(Database, String)
method all beans will be
materialized and the connection will be closed before returning the beans.
Platform.query(Database, String)
method all beans will be
materialized and the connection will be closed before returning the beans.
Also, the two int parameters specify which rows of the result set to use.
If there are more rows than desired, they will be ignored (and not read
from the database).
Platform.query(Database, String, Table[])
method all
beans will be materialized and the connection will be closed before
returning the beans. Also, the two int parameters specify which rows of
the result set to use. If there are more rows than desired, they will be
ignored (and not read from the database).
Platform.query(Database, String, Collection)
method
all beans will be materialized and the connection will be closed before
returning the beans.
Platform.query(Database, String, Collection)
method all
beans will be materialized and the connection will be closed before returning
the beans. Also, the two int parameters specify which rows of the result set
to use. If there are more rows than desired, they will be ignored (and not
read from the database).
Platform.query(Database, String, Collection)
method
all beans will be materialized and the connection will be closed before
returning the beans.
Platform.query(Database, String, Collection, Table[])
method all beans will be materialized and the connection will be closed
before returning the beans. Also, the two int parameters specify which
rows of the result set to use. If there are more rows than desired, they
will be ignored (and not read from the database).
Platform.query(Database, String, Collection, Table[])
method all beans will be materialized and the connection will be closed
before returning the beans. Also, the two int parameters specify which
rows of the result set to use. If there are more rows than desired, they
will be ignored (and not read from the database).
Platform.query(Database, String, Table[])
method all
beans will be materialized and the connection will be closed before
returning the beans. Also, the two int parameters specify which rows of
the result set to use. If there are more rows than desired, they will be
ignored (and not read from the database).
InputSource
object.
SqlDynaClass
for the given table.
SqlDynaClass
for the given bean.
SqlDynaClass
for the given table name.
SqlDynaClass
for the given dyna bean.
Types
constants) that
corresponds to the given JDBC type name.
Types
constants).
null
.
null
.
null
.
null
.
null
.
null
.
null
.
null
.
Normally mysql will return the LAST_INSERT_ID as the column name for the inserted id.
null
.
null
.
null
.
null
.
Types
) of the
JDBC type of the column.
Types
constants) has a null default value on this platform.
Types
constants) has precision and scale specifications on
this platform.
Types
constants) has a size specification on this platform.
Types.INTEGER
constant.
Types
constants)
is a binary type.
Types
constants)
is a date/time type.
PlatformInfo.isIdentityOverrideAllowed()
). If this is off, then the
insert
methods will ignore values for identity columns.
Types
constants)
is a numeric type.
Command.execute(DatabaseTaskBase, Database)
cannot be null
.
Command.execute(DatabaseTaskBase, Database)
cannot be null
.
Command.execute(DatabaseTaskBase, Database)
cannot be null
.
Command.execute(DatabaseTaskBase, Database)
cannot be null
.
Command.execute(DatabaseTaskBase, Database)
cannot be null
.
Types
constants)
is a special type.
Types
constants)
is a text type.
Types.JAVA_OBJECT
constant.
Types.LONGVARBINARY
constant.
Types.LONGVARCHAR
constant.
Types.NULL
constant.
Types.NUMERIC
constant.
String
.Types.OTHER
constant.
Platform
and the factory to create instances for individual platforms,
PlatformFactory
.DynaClass
and DynaBean
that directly map to tables in the database
model.org.apache.ddlutils.io
package contains a classes for input
and output of both the database schemas and data files.Types
.org.apache.ddlutils.task
package contains the Ant
tasks provided by DdlUtils.org.apache.ddlutils.util
package contains utility classes of DdlUtils.Platform
instances based on a case
insensitive database name.RemoveForeignKeyChange
and
RemoveIndexChange
come first
to allow for e.g. subsequent primary key changes or column removal.RemoveTableChange
comes after the removal of foreign keys and indices.RemovePrimaryKeyChange
AddPrimaryKeyChange
PrimaryKeyChange
RemoveColumnChange
AddColumnChange
ColumnAutoIncrementChange
ColumnDefaultValueChange
ColumnRequiredChange
ColumnDataTypeChange
ColumnSizeChange
AddTableChange
AddForeignKeyChange
and
AddIndexChange
come last
after table/column/primary key additions or changes.RemoveForeignKeyChange
and
RemoveIndexChange
come first
to allow for e.g. subsequent primary key changes or column removal.RemoveTableChange
comes after the removal of foreign keys and indices.RemovePrimaryKeyChange
AddPrimaryKeyChange
PrimaryKeyChange
RemoveColumnChange
AddColumnChange
ColumnAutoIncrementChange
ColumnDefaultValueChange
ColumnRequiredChange
ColumnDataTypeChange
ColumnSizeChange
AddTableChange
AddForeignKeyChange
and
AddIndexChange
come last
after table/column/primary key additions or changes.AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
AddPrimaryKeyChange
changes are
applied via an ALTER TABLE ADD CONSTRAINT
statement.
Types.REAL
constant.
Types.REF
constant.
Types.SMALLINT
constant.
Types.STRUCT
constant.
haltOnErrors
to false as this might
result in beans not inserted at all.
haltOnErrors
to false as this might
result in beans not inserted at all.
Types
constants) has a null default value on this platform.
Types
constants) has precision and scale specifications on
this platform.
Types
constants) has a size specification on this platform.
PlatformInfo.isIdentityOverrideAllowed()
). If this is off, then the
insert
methods will ignore values for identity columns.
databaseType
attribute of the tasks for possible values).
Types
) of the
JDBC type of the column.
http://db.apache.org/torque/dtd/database.dtd
).
Types.TIME
constant.
Types.TIMESTAMP
constant.
Types.TINYINT
constant.
Time
and String
using the standard
representation "hh:mm:ss".Timestamp
and String
using the standard
representation "yyyy-mm-dd hh:mm:ss.fffffffff".Types
and vice versa.Types.VARBINARY
constant.
Types.VARCHAR
constant.
WaitingObject
instance for the given object.
dataSource
sub element of the enclosing task can be omitted.SqlBuilder.writeCastExpression(Column, Column)
method.
SqlBuilder.writeCastExpression(Column, Column)
method.
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |