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

java.lang.Object
  de.uplanet.lucy.server.util.db.DbQuery

All Implemented Interfaces:

IDbQuery, ICloseable

public final class DbQuery
extends java.lang.Object
implements IDbQuery

Version:

$Revision: 92937 $

Constructor Summary

DbQuery()

Method Summary

void	close() Close this database query object and all dependent DbPreparedStatement and DbResultSet objects.
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.math.BigDecimal	executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Boolean	executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Byte	executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.util.Date	executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Double	executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Float	executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Integer	executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Long	executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.Short	executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.lang.String	executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.sql.Timestamp	executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Closure).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object).
java.util.Date	executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback, groovy.lang.Closure p_closure) Typed version of IDbQuery.executeAndGetScalarValue(JdbcConnection, String, Object, Closure).
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.Object p_valueFallback) Get the value of the first column in the first row of the result set.
java.lang.Object	executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, java.lang.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, java.lang.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, java.lang.String p_strQuery) Execute an INSERT or UPDATE statement.
int	executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery, groovy.lang.Closure p_closure) Execute a prepared INSERT or UPDATE statement.
DbPreparedStatement	prepare(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Prepares a statement.
DbPreparedStatement	prepareDeprecated(de.uplanet.jdbc.JdbcConnection p_conn, java.lang.String p_strQuery) Deprecated.

Methods inherited from class java.lang.Object

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

Constructor Detail

DbQuery

public DbQuery()

Method Detail

executeAndGetScalarValueHolder

public IValueHolder<?> executeAndGetScalarValueHolder(de.uplanet.jdbc.JdbcConnection p_conn,
                                                      java.lang.String p_strQuery)
                                               throws java.sql.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:

java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 java.lang.Object p_valueFallback)
                                          throws java.sql.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.

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:

java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery)
                                          throws java.sql.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:

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:

java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 java.lang.Object p_valueFallback,
                                                 groovy.lang.Closure p_closure)
                                          throws java.sql.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.

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:

java.sql.SQLException

executeAndGetScalarValue

public java.lang.Object executeAndGetScalarValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                 java.lang.String p_strQuery,
                                                 groovy.lang.Closure p_closure)
                                          throws java.sql.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.

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:

java.sql.SQLException

executeAndGetScalarBooleanValue

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

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery)
                                                  throws java.sql.SQLException,
                                                         ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery,
                                                         java.lang.Object p_valueFallback,
                                                         groovy.lang.Closure p_closure)
                                                  throws java.sql.SQLException,
                                                         ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Boolean executeAndGetScalarBooleanValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                         java.lang.String p_strQuery,
                                                         groovy.lang.Closure p_closure)
                                                  throws java.sql.SQLException,
                                                         ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBooleanValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Byte executeAndGetScalarByteValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarByteValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Short executeAndGetScalarShortValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarShortValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Integer executeAndGetScalarIntValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarIntValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Long executeAndGetScalarLongValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarLongValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     java.lang.Object p_valueFallback,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Float executeAndGetScalarFloatValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                     java.lang.String p_strQuery,
                                                     groovy.lang.Closure p_closure)
                                              throws java.sql.SQLException,
                                                     ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarFloatValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

java.sql.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 java.lang.Double executeAndGetScalarDoubleValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDoubleValue in interface IDbQuery

Throws:

java.sql.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 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               java.lang.Object p_valueFallback)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

java.sql.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 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

java.sql.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 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               java.lang.Object p_valueFallback,
                                                               groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

java.sql.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 java.math.BigDecimal executeAndGetScalarBigDecimalValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                               java.lang.String p_strQuery,
                                                               groovy.lang.Closure p_closure)
                                                        throws java.sql.SQLException,
                                                               ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarBigDecimalValue in interface IDbQuery

Throws:

java.sql.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 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

java.sql.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 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

java.sql.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 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       java.lang.Object p_valueFallback,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

java.sql.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 java.lang.String executeAndGetScalarStringValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                       java.lang.String p_strQuery,
                                                       groovy.lang.Closure p_closure)
                                                throws java.sql.SQLException,
                                                       ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarStringValue in interface IDbQuery

Throws:

java.sql.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 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            java.lang.Object p_valueFallback)
                                                     throws java.sql.SQLException,
                                                            ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

java.sql.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 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery)
                                                     throws java.sql.SQLException,
                                                            ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

java.sql.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 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            java.lang.Object p_valueFallback,
                                                            groovy.lang.Closure p_closure)
                                                     throws java.sql.SQLException,
                                                            ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

java.sql.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 java.sql.Timestamp executeAndGetScalarTimestampValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                            java.lang.String p_strQuery,
                                                            groovy.lang.Closure p_closure)
                                                     throws java.sql.SQLException,
                                                            ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimestampValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarDateValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarDateValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   java.lang.Object p_valueFallback,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

java.sql.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 java.util.Date executeAndGetScalarTimeValue(de.uplanet.jdbc.JdbcConnection p_conn,
                                                   java.lang.String p_strQuery,
                                                   groovy.lang.Closure p_closure)
                                            throws java.sql.SQLException,
                                                   ValueCastException

Description copied from interface: IDbQuery

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

Specified by:

executeAndGetScalarTimeValue in interface IDbQuery

Throws:

java.sql.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,
                         java.lang.String p_strQuery)
                  throws java.sql.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:

java.sql.SQLException

executeUpdate

public int executeUpdate(de.uplanet.jdbc.JdbcConnection p_conn,
                         java.lang.String p_strQuery,
                         groovy.lang.Closure p_closure)
                  throws java.sql.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:

java.sql.SQLException

prepare

public DbPreparedStatement prepare(de.uplanet.jdbc.JdbcConnection p_conn,
                                   java.lang.String p_strQuery)
                            throws java.sql.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:

java.sql.SQLException - If a database error occurred.

prepareDeprecated

@Deprecated
public DbPreparedStatement prepareDeprecated(de.uplanet.jdbc.JdbcConnection p_conn,
                                                        java.lang.String p_strQuery)
                                      throws java.sql.SQLException

Deprecated.

In deprecated mode DbDisconnectedRow does not support null values for primitive numeric or boolean datatypes, but returns 0 or false values instead.

Throws:

java.sql.SQLException

close

public void close()
           throws java.sql.SQLException

Description copied from interface: IDbQuery

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

Specified by:

close in interface IDbQuery

Specified by:

close in interface ICloseable

Throws:

java.sql.SQLException - If a database error occurred.