sqlg2.checker
Interface SqlChecker

public interface SqlChecker

Used to check validity of SQL queries during preprocess.

Method Summary

void	checkSequenceExists(java.sql.Connection conn, java.lang.String name) Checks whether sequence generator exists in database.
void	checkSql(java.sql.Connection conn, java.lang.String sql) Checks SQL statement syntax.
void	checkStatement(java.sql.PreparedStatement stmt) Checks SQL statement syntax.
java.lang.String	getCurrentSchema(java.sql.DatabaseMetaData meta) Returns current schema name (for stored proc search).
java.lang.Class<? extends java.util.Date>	getDateColumnClass(int sqlType) Determines which Java Date subclass to use for given Types type code.
int	getDateSqlType(java.lang.Class<? extends java.util.Date> cls) Determines which of SQL date types to use for given Java Date subclass - Types.DATE, Types.TIME or Types.TIMESTAMP.

Method Detail

getCurrentSchema

java.lang.String getCurrentSchema(java.sql.DatabaseMetaData meta)
                                  throws java.sql.SQLException

Returns current schema name (for stored proc search).

Returns:

current schema

Throws:

java.sql.SQLException

checkSequenceExists

void checkSequenceExists(java.sql.Connection conn,
                         java.lang.String name)
                         throws java.sql.SQLException

Checks whether sequence generator exists in database.

Parameters:

name - sequence name

Throws:

java.sql.SQLException - when no such sequence

checkSql

void checkSql(java.sql.Connection conn,
              java.lang.String sql)
              throws java.sql.SQLException

Checks SQL statement syntax.

Throws:

java.sql.SQLException - when SQL is invalid

checkStatement

void checkStatement(java.sql.PreparedStatement stmt)
                    throws java.sql.SQLException

Checks SQL statement syntax.

Throws:

java.sql.SQLException - when SQL is invalid

getDateSqlType

int getDateSqlType(java.lang.Class<? extends java.util.Date> cls)

Determines which of SQL date types to use for given Java Date subclass - Types.DATE, Types.TIME or Types.TIMESTAMP.

getDateColumnClass

java.lang.Class<? extends java.util.Date> getDateColumnClass(int sqlType)

Determines which Java Date subclass to use for given Types type code.

Parameters:

sqlType - one of Types.DATE, Types.TIME or Types.TIMESTAMP