sqlg2.db
Interface DBSpecific

All Known Implementing Classes:

NoDBSpecific, OracleDBSpecific

public interface DBSpecific

Database-specific operations interface.

Method Summary

void	freeBlob(java.sql.Connection conn, java.sql.Blob blob) Frees BLOB data after return from stored procedure.
void	freeClob(java.sql.Connection conn, java.sql.Clob clob) Frees CLOB data after return from stored procedure.
java.io.OutputStream	getBlobOutputStream(java.sql.Blob blob) Retrieves stream to write BLOB contents
java.lang.Class<? extends SqlChecker>	getCheckerClass() Returns checker of SQL statements for this DB.
java.io.Writer	getClobWriter(java.sql.Clob clob) Retrieves stream to write CLOB contents
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.
long	getNextId(java.sql.Connection conn, java.lang.String sequence) Gets next number from sequence
int	getResultSetType() Returns type code to use for CallableStatement.registerOutParameter(int, int) for cursor OUT parameters.
java.util.Date	getServerDate(java.sql.Connection conn) Returns DB server local time.

Method Detail

getNextId

long getNextId(java.sql.Connection conn,
               java.lang.String sequence)
               throws java.sql.SQLException

Gets next number from sequence

Parameters:

sequence - sequence name

Throws:

java.sql.SQLException

freeClob

void freeClob(java.sql.Connection conn,
              java.sql.Clob clob)
              throws java.sql.SQLException

Frees CLOB data after return from stored procedure.

Throws:

java.sql.SQLException

freeBlob

void freeBlob(java.sql.Connection conn,
              java.sql.Blob blob)
              throws java.sql.SQLException

Frees BLOB data after return from stored procedure.

Throws:

java.sql.SQLException

getServerDate

java.util.Date getServerDate(java.sql.Connection conn)
                             throws java.sql.SQLException

Returns DB server local time.

Returns:

DB server local time

Throws:

java.sql.SQLException

getBlobOutputStream

java.io.OutputStream getBlobOutputStream(java.sql.Blob blob)
                                         throws java.sql.SQLException

Retrieves stream to write BLOB contents

Throws:

java.sql.SQLException

getClobWriter

java.io.Writer getClobWriter(java.sql.Clob clob)
                             throws java.sql.SQLException

Retrieves stream to write CLOB contents

Throws:

java.sql.SQLException

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.

getCheckerClass

java.lang.Class<? extends SqlChecker> getCheckerClass()

Returns checker of SQL statements for this DB. Invoked only at preprocess phase, so this class is not required at run time. Class shoud have default constructor to instantiate.

getResultSetType

int getResultSetType()

Returns type code to use for CallableStatement.registerOutParameter(int, int) for cursor OUT parameters.