com.caucho.jdbc

Class MysqlMetaData

java.lang.Object

com.caucho.jdbc.JdbcMetaData

com.caucho.jdbc.GenericMetaData

com.caucho.jdbc.MysqlMetaData

public class MysqlMetaData
extends GenericMetaData

Metadata for the MySQL database.

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	MysqlMetaData(javax.sql.DataSource ds)

Method Summary

Modifier and Type	Method and Description
java.lang.String	createIdentitySQL(java.lang.String sqlType) Returns the identity property
java.lang.String	getFalseLiteral() Returns the literal for FALSE.
boolean	isLimit() Returns true if the metadata can handle limit
boolean	isLimitOffset() Returns true if the metadata can handle limit and offset
java.lang.String	limit(java.lang.String sql, int offset, int limit) Returns a limit.
boolean	supportsIdentity() Returns true if identity is supported.
boolean	supportsPositionFunction() Returns true if the POSITION function is supported.
boolean	supportsUpdateTableList() Returns true if table list with UPDATE is supported: UPDATE table1 a, table2 b SET ...

Methods inherited from class com.caucho.jdbc.GenericMetaData

createSequenceSQL, getBlobType, getCreateColumnSQL, getCreateColumnSQLImpl, getDefaultCreateTableSQL, getLongType, selectSequenceSQL, supportsGetGeneratedKeys, supportsSequences, supportsUpdateTableAlias

Methods inherited from class com.caucho.jdbc.JdbcMetaData

create, generateBoolean, getConnection, getDatabaseName, isForeignKeyViolationSQLState, isTruncateBlobBeforeDelete, isUniqueConstraintSQLState, testSequenceSQL

Methods inherited from class java.lang.Object

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

Constructor Detail

MysqlMetaData

protected MysqlMetaData(javax.sql.DataSource ds)

Method Detail

getFalseLiteral

public java.lang.String getFalseLiteral()

Returns the literal for FALSE.

Overrides:

getFalseLiteral in class GenericMetaData

supportsIdentity

public boolean supportsIdentity()

Returns true if identity is supported.

Overrides:

supportsIdentity in class GenericMetaData

supportsPositionFunction

public boolean supportsPositionFunction()

Returns true if the POSITION function is supported.

Overrides:

supportsPositionFunction in class GenericMetaData

supportsUpdateTableList

public boolean supportsUpdateTableList()

Returns true if table list with UPDATE is supported: UPDATE table1 a, table2 b SET ...

Overrides:

supportsUpdateTableList in class GenericMetaData

createIdentitySQL

public java.lang.String createIdentitySQL(java.lang.String sqlType)

Returns the identity property

Overrides:

createIdentitySQL in class GenericMetaData

isLimit

public boolean isLimit()

Description copied from class: JdbcMetaData

Returns true if the metadata can handle limit

Overrides:

isLimit in class JdbcMetaData

isLimitOffset

public boolean isLimitOffset()

Description copied from class: JdbcMetaData

Returns true if the metadata can handle limit and offset

Overrides:

isLimitOffset in class JdbcMetaData

limit

public java.lang.String limit(java.lang.String sql,
                              int offset,
                              int limit)

Returns a limit.

Overrides:

limit in class JdbcMetaData