Package org.sqlproc.engine.jdbc.type

Class JdbcOracleCursorType

java.lang.Object

org.sqlproc.engine.jdbc.type.JdbcOracleCursorType

All Implemented Interfaces:

SqlMetaType, SqlTaggedMetaType

public class JdbcOracleCursorType
extends Object
implements SqlTaggedMetaType

The JDBC META type ORACLE_CURSOR (from Oracle jdbc driver).

Author:

Vladimir Hudec

Field Summary

Fields

Modifier and Type	Field	Description
private static Integer	JDBC_TYPE	The value of ORACLE_CURSOR.
protected org.slf4j.Logger	logger	The internal slf4j logger.

Constructor Summary

Constructors

Constructor	Description
JdbcOracleCursorType()

Method Summary

Modifier and Type	Method	Description
void	addScalar(SqlTypeFactory typeFactory, SqlQuery query, String dbName, Class<?>... attributeTypes)	Declares a scalar query result, which is an SQL query execution output value.
Class<?>[]	getClassTypes()	Returns the list of Java class types related to this META type.
String[]	getMetaTypes()	Returns the list of names of this META type.
Object	getProviderSqlType()	Returns the type provided by the stack on top of which the SQL Processor works.
void	setParameter(SqlRuntimeContext runtimeCtx, SqlQuery query, String paramName, Object inputValue, boolean ingoreError, Class<?>... inputTypes)	Binds an input value to a named query parameter.
void	setResult(SqlRuntimeContext runtimeCtx, Object resultInstance, String attributeName, Object resultValue, boolean ingoreError)	Initializes the attribute of the result class with output value from the SQL query execution.

Methods inherited from class java.lang.Object

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

Methods inherited from interface org.sqlproc.engine.type.SqlMetaType

addScalarEntryLog, error, getResult, setParameterEntryLog, setResultEntryLog

Field Detail

logger

protected final org.slf4j.Logger logger

The internal slf4j logger.

JDBC_TYPE

private static final Integer JDBC_TYPE

The value of ORACLE_CURSOR.

Constructor Detail

JdbcOracleCursorType

public JdbcOracleCursorType()

Method Detail

getProviderSqlType

public Object getProviderSqlType()

Returns the type provided by the stack on top of which the SQL Processor works.

Specified by:

getProviderSqlType in interface SqlMetaType

Returns:

the provided type

getClassTypes

public Class<?>[] getClassTypes()

Returns the list of Java class types related to this META type.

Specified by:

getClassTypes in interface SqlTaggedMetaType

Returns:

the list of Java class types related to this META type

getMetaTypes

public String[] getMetaTypes()

Returns the list of names of this META type. These names can be used in the META SQL statements.

Specified by:

getMetaTypes in interface SqlTaggedMetaType

Returns:

list of names of this META type. These names can be used in the META SQL statements

addScalar

public void addScalar(SqlTypeFactory typeFactory,
                      SqlQuery query,
                      String dbName,
                      Class<?>... attributeTypes)

Declares a scalar query result, which is an SQL query execution output value.

Specified by:

addScalar in interface SqlMetaType

Parameters:

typeFactory - the SQL Type factory

query - the SQL Engine query, an adapter or proxy to the internal JDBC or ORM staff

dbName - the name of a database query output, it can be the column name or the alias name

attributeTypes - the Java types of of the attribute in the result class

setResult

public void setResult(SqlRuntimeContext runtimeCtx,
                      Object resultInstance,
                      String attributeName,
                      Object resultValue,
                      boolean ingoreError)
               throws SqlRuntimeException

Initializes the attribute of the result class with output value from the SQL query execution.

Specified by:

setResult in interface SqlMetaType

Parameters:

runtimeCtx - the runtimeCtx context

resultInstance - the instance of the result class

attributeName - the name of the attribute in the result class

resultValue - the query execution output value

ingoreError - ignore improper output value handling

Throws:

SqlRuntimeException - in the case of any problem with the output values handling

setParameter

public void setParameter(SqlRuntimeContext runtimeCtx,
                         SqlQuery query,
                         String paramName,
                         Object inputValue,
                         boolean ingoreError,
                         Class<?>... inputTypes)
                  throws SqlRuntimeException

Binds an input value to a named query parameter.

Specified by:

setParameter in interface SqlMetaType

Parameters:

runtimeCtx - the runtimeCtx context

query - the SQL Engine query, an adapter or proxy to the internal JDBC or ORM staff

paramName - the name of the parameter

ingoreError - ignore improper input value handling

inputTypes - the Java types of the attribute in the input POJO

Throws:

SqlRuntimeException - in the case of any problem with the input values handling