lucee.runtime.util

Interface DBUtil

public interface DBUtil

Method Summary

Modifier and Type	Method and Description
void	closeSilent(Connection conn) close silently a SQL Connection
void	closeSilent(ResultSet rs) close silently a SQL ResultSet
void	closeSilent(Statement stat) close silently a SQL Statement
String	getColumnName(ResultSetMetaData meta, int column)
Collection.Key[]	getColumnNames(Query qry)
String	getDatabaseName(DatasourceConnection dc)
DatasourceConnection	getDatasourceConnection(PageContext pc, DataSource datasource, String user, String pass)
DatasourceConnection	getDatasourceConnection(PageContext pc, String datasourceName, String user, String pass)
Object	getObject(ResultSet rs, int columnIndex, Class type)
Object	getObject(ResultSet rs, String columnLabel, Class type)
boolean	isOracle(Connection conn) checks if this is a oracle connection
void	releaseDatasourceConnection(Config config, DatasourceConnection dc, boolean async)
void	setValue(PageContext pc, TimeZone tz, PreparedStatement stat, int parameterIndex, SQLItem item) fill a SQLItem to into a PreparedStatement
void	setValue(TimeZone tz, PreparedStatement stat, int parameterIndex, SQLItem item) Deprecated.
Blob	toBlob(Connection conn, Object value) create a blog Object
Clob	toClob(Connection conn, Object value) create a clob Object
SQL	toSQL(String sql, SQLItem[] items)
SQLItem	toSQLItem(Object value, int type)
Object	toSqlType(SQLItem item) converts the value defined inside a SQLItem to the type defined in stat item
int	toSQLType(String strType) cast a String SQL Type to type defined in java.sql.Types
String	toString(SQLItem item) Cast a SQL Item to a String (Display) Value
String	toStringType(int type) cast a type defined in java.sql.Types to String SQL Type

Method Detail

toSqlType

Object toSqlType(SQLItem item)
          throws PageException

converts the value defined inside a SQLItem to the type defined in stat item

Throws:

PageException

setValue

@Deprecated
void setValue(TimeZone tz,
                          PreparedStatement stat,
                          int parameterIndex,
                          SQLItem item)
                   throws PageException,
                          SQLException

Deprecated.

Throws:

PageException

SQLException

setValue

void setValue(PageContext pc,
              TimeZone tz,
              PreparedStatement stat,
              int parameterIndex,
              SQLItem item)
       throws PageException,
              SQLException

fill a SQLItem to into a PreparedStatement

Parameters:

tz -

stat -

parameterIndex -

item -

Throws:

PageException

SQLException

toString

String toString(SQLItem item)

Cast a SQL Item to a String (Display) Value

Parameters:

item -

Returns:

String Value

toStringType

String toStringType(int type)
             throws PageException

cast a type defined in java.sql.Types to String SQL Type

Parameters:

type -

Returns:

SQL Type as String

Throws:

PageException

toSQLType

int toSQLType(String strType)
       throws PageException

cast a String SQL Type to type defined in java.sql.Types

Parameters:

strType -

Returns:

SQL Type as int

Throws:

PageException

toBlob

Blob toBlob(Connection conn,
            Object value)
     throws PageException,
            SQLException

create a blog Object

Parameters:

conn -

value -

Returns:

Throws:

PageException

SQLException

toClob

Clob toClob(Connection conn,
            Object value)
     throws PageException,
            SQLException

create a clob Object

Parameters:

conn -

value -

Returns:

Throws:

PageException

SQLException

isOracle

boolean isOracle(Connection conn)

checks if this is a oracle connection

Parameters:

conn -

Returns:

getDatabaseName

String getDatabaseName(DatasourceConnection dc)
                throws SQLException

Throws:

SQLException

closeSilent

void closeSilent(Statement stat)

close silently a SQL Statement

Parameters:

stat -

closeSilent

void closeSilent(Connection conn)

close silently a SQL Connection

Parameters:

conn -

closeSilent

void closeSilent(ResultSet rs)

close silently a SQL ResultSet

Parameters:

rs -

toSQLItem

SQLItem toSQLItem(Object value,
                  int type)

toSQL

SQL toSQL(String sql,
          SQLItem[] items)

releaseDatasourceConnection

void releaseDatasourceConnection(Config config,
                                 DatasourceConnection dc,
                                 boolean async)

getDatasourceConnection

DatasourceConnection getDatasourceConnection(PageContext pc,
                                             DataSource datasource,
                                             String user,
                                             String pass)
                                      throws PageException

Throws:

PageException

getDatasourceConnection

DatasourceConnection getDatasourceConnection(PageContext pc,
                                             String datasourceName,
                                             String user,
                                             String pass)
                                      throws PageException

Throws:

PageException

getColumnNames

Collection.Key[] getColumnNames(Query qry)

getColumnName

String getColumnName(ResultSetMetaData meta,
                     int column)
              throws SQLException

Throws:

SQLException

getObject

Object getObject(ResultSet rs,
                 int columnIndex,
                 Class type)
          throws SQLException

Throws:

SQLException

getObject

Object getObject(ResultSet rs,
                 String columnLabel,
                 Class type)
          throws SQLException

Throws:

SQLException