Package de.uplanet.lucy.server.util.db

Class DbQuery

java.lang.Object

de.uplanet.lucy.server.util.db.DbQuery

All Implemented Interfaces:

IDbQuery, ICloseable, AutoCloseable

public final class DbQuery
extends Object
implements IDbQuery

This class provides a database API that is intended to be used in scripting environments.

Constructor Summary

Constructors

Constructor	Description
DbQuery()

Method Summary

Modifier and Type	Method	Description
void	close()	Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback)	Get the value of the first column in the first row of the result set.
Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, Object p_valueFallback, groovy.lang.Closure<?> p_closure)	Get the value of the first column in the first row of the result set.
IValueHolder<?>	executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Get the value of the first column in the first row of the result set.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Execute an INSERT or UPDATE statement.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery, groovy.lang.Closure<?> p_closure)	Execute a prepared INSERT or UPDATE statement.
int	getDefaultFetchSize()	Get the default fetch size.
DbPreparedStatement	prepare(de.uplanet.jdbc.JdbcConnection p_conn, String p_strQuery)	Prepares a statement.
void	setDefaultFetchSize(int p_iDefaultFetchSize)	Set the default fetch size for prepared statements created by this class.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbQuery

public DbQuery()

Method Detail

getDefaultFetchSize

public int getDefaultFetchSize()

Get the default fetch size. The default value is 100.

Specified by:

getDefaultFetchSize in interface IDbQuery

Returns:

The default fetch size.

setDefaultFetchSize

public void setDefaultFetchSize(int p_iDefaultFetchSize)

Set the default fetch size for prepared statements created by this class.

Specified by:

setDefaultFetchSize in interface IDbQuery

Parameters:

p_iDefaultFetchSize - The default fetch size.

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
                                                      String p_strQuery)
                                               throws SQLException

Description copied from interface: IDbQuery

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Specified by:

executeAndGetScalarValueHolder in interface IDbQuery

Returns:

A value holder that contains the value of the first column in the first row of the result set, or null if the result set is empty.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       Object p_valueFallback)
                                throws SQLException

Description copied from interface: IDbQuery

Get the value of the first column in the first row of the result set.

If the result set is empty, or the value is null, p_valueIfNull is returned.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Specified by:

executeAndGetScalarValue in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The query.

p_valueFallback - The return value if the query returns an empty result set, or null.

Returns:

The value of the first column in the first row of the result set, or p_valueIfNull if the result set is empty, or the value is null.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery)
                                throws SQLException

Description copied from interface: IDbQuery

Get the value of the first column in the first row of the result set.

If the result set is empty, null is returned.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Specified by:

executeAndGetScalarValue in interface IDbQuery

Returns:

The value of the first column in the first row of the result set, or null if the result set is empty.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       Object p_valueFallback,
                                       groovy.lang.Closure<?> p_closure)
                                throws SQLException

Description copied from interface: IDbQuery

Get the value of the first column in the first row of the result set.

If the result set is empty or the value is null, p_valueIfNull is returned.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Specified by:

executeAndGetScalarValue in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The query.

p_valueFallback - The return value if the query returns an empty result set, or null.

p_closure - The closure that prepares the statement.

Returns:

The value of the first column in the first row of the result set, or p_valueIfNull if the result set is empty or the value is null.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarValue

public Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                       String p_strQuery,
                                       groovy.lang.Closure<?> p_closure)
                                throws SQLException

Description copied from interface: IDbQuery

Get the value of the first column in the first row of the result set.

If the result set is empty or the value is null, p_valueIfNull is returned.

Note: The type of the result depends on the database column's datatype. To coerce the result to a specific type use the respective executeAndGetScalarValueXxx methods.

Specified by:

executeAndGetScalarValue in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The query.

p_closure - The closure that prepares the statement.

Returns:

The value of the first column in the first row of the result set, or p_valueIfNull if the result set is empty or the value is null.

Throws:

SQLException - If a database error occurred.

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               Object p_valueFallback)
                                        throws SQLException,
                                               ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery)
                                        throws SQLException,
                                               ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               Object p_valueFallback,
                                               groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
                                               ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBooleanValue

public Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                               String p_strQuery,
                                               groovy.lang.Closure<?> p_closure)
                                        throws SQLException,
                                               ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarByteValue

public Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarShortValue

public Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarIntValue

public Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarLongValue

public Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           Object p_valueFallback,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarFloatValue

public Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                           String p_strQuery,
                                           groovy.lang.Closure<?> p_closure)
                                    throws SQLException,
                                           ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDoubleValue

public Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     Object p_valueFallback)
                                              throws SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery)
                                              throws SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     Object p_valueFallback,
                                                     groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarBigDecimalValue

public BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     String p_strQuery,
                                                     groovy.lang.Closure<?> p_closure)
                                              throws SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             Object p_valueFallback,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarStringValue

public String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                             String p_strQuery,
                                             groovy.lang.Closure<?> p_closure)
                                      throws SQLException,
                                             ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   Object p_valueFallback)
                                            throws SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery)
                                            throws SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   Object p_valueFallback,
                                                   groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimestampValue

public Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   String p_strQuery,
                                                   groovy.lang.Closure<?> p_closure)
                                            throws SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarDateValue

public Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         Object p_valueFallback,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure)

executeAndGetScalarTimeValue

public Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                         String p_strQuery,
                                         groovy.lang.Closure<?> p_closure)
                                  throws SQLException,
                                         ValueCastException

Description copied from interface: IDbQuery

Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

SQLException - If a database error occurred.

ValueCastException - If the database value could not be cast to the specific type.

See Also:

IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure)

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         String p_strQuery)
                  throws SQLException

Description copied from interface: IDbQuery

Execute an INSERT or UPDATE statement.

Specified by:

executeUpdate in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The SQL statement to be executed.

Returns:

The number of affected rows in the database, or 0.

Throws:

SQLException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         String p_strQuery,
                         groovy.lang.Closure<?> p_closure)
                  throws SQLException

Description copied from interface: IDbQuery

Execute a prepared INSERT or UPDATE statement.

Specified by:

executeUpdate in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The (prepared) SQL statement to be executed.

p_closure - The closure that prepares the statement.

Returns:

The number of affected rows in the database, or 0.

Throws:

SQLException

prepare

public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
                                   String p_strQuery)
                            throws SQLException

Description copied from interface: IDbQuery

Prepares a statement.

Specified by:

prepare in interface IDbQuery

Parameters:

p_conn - The database connection to be used.

p_strQuery - The (parameterized) SQL query.

Returns:

A prepared statement object.

Throws:

SQLException - If a database error occurred.

close

public void close()
           throws SQLException

Description copied from interface: IDbQuery

Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.

Specified by:

close in interface AutoCloseable

Specified by:

close in interface IDbQuery

Throws:

SQLException - If a database error occurred.