net.sf.appstatus.batch.jdbc

Class BatchDaoOracle

java.lang.Object

net.sf.appstatus.batch.jdbc.BatchDao

net.sf.appstatus.batch.jdbc.BatchDaoOracle

public class BatchDaoOracle
extends BatchDao

Oracle-Compatible implementation.

 <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"
 scope="singleton">
     <constructor-arg ref="dataSource" />
 </bean>

 <bean id="batchDao" class="net.sf.appstatus.batch.jdbc.BatchDao"
 scope="singleton"> <property name="jdbcTemplate" ref="jdbcTemplate" />
 </bean>



 <bean id="jdbcBatchManager"
 class="net.sf.appstatus.batch.jdbc.JdbcBatchManager" scope="singleton">
                <property name="batchDao" ref="batchDao" />
 </bean>

 

Create table: BATCH

UUID_BATCH	varchar (256)
GROUP_BATCH	varchar (256)
NAME_BATCH	varchar (256)
START_DATE	DATETIME
END_DATE	DATETIME
UPDATED	DATETIME
STATUS	varchar (64)
SUCCESS	BOOLEAN
ITEMCOUNT	LONG
ITEM	varchar (256)
CURRENT_TASK	varchar (256)
PROGRESS	Float
REJECT	CLOB
LAST_MSG	varchar (1024)

Field Summary

Fields inherited from class net.sf.appstatus.batch.jdbc.BatchDao

BATCH_CREATE_TABLE, BATCH_DELETE, BATCH_DELETE_OLD, BATCH_DELETE_SUCCESS, BATCH_FETCH, BATCH_FETCH_BY_NAME, BATCH_INSERT, BATCH_UPDATE, tableName

Constructor Summary

Constructors

Constructor and Description
BatchDaoOracle()

Method Summary

Methods

Modifier and Type	Method and Description
protected String	getSql(int query) Get SQL query for the requested action.

Methods inherited from class net.sf.appstatus.batch.jdbc.BatchDao

createDbIfNecessary, deleteBatch, deleteOldBatches, deleteSuccessBatches, fetch, fetchError, fetchFinished, fetchRunning, save, setJdbcTemplate, setTableName, update

Methods inherited from class java.lang.Object

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

Constructor Detail

BatchDaoOracle

public BatchDaoOracle()

Method Detail

getSql

protected String getSql(int query)

Description copied from class: BatchDao

Get SQL query for the requested action.

Override this method to adapt to a new SQL Dialect.

Overrides:

getSql in class BatchDao

Parameters:

query - BatchDao.BATCH_FETCH BatchDao.BATCH_CREATE_TABLE

Returns:

the SQL query