Package org.copperengine.core.persistent

Class DerbyDbDialect

java.lang.Object

org.copperengine.core.persistent.AbstractSqlDialect

org.copperengine.core.persistent.DerbyDbDialect

All Implemented Interfaces:

DatabaseDialect, org.copperengine.management.DatabaseDialectMXBean

public class DerbyDbDialect
extends AbstractSqlDialect

Apache Derby implementation of the DatabaseDialect interface.

Field Summary

Fields inherited from class org.copperengine.core.persistent.AbstractSqlDialect

ACQUIRE_BLOCKING_WAIT_SEC, dbBatchingLatencyMSec, defaultStaleResponseRemovalTimeout, multiEngineMode, queryUpdateQueueState, selectQueueSizeStmtStatistic, serializer, supportsClob, supportsMultipleEngines

Constructor Summary

Constructors

Constructor	Description
DerbyDbDialect()

Method Summary

Modifier and Type	Method	Description
protected void	addLimitation(java.lang.StringBuilder sql, int max)
protected void	addLimitationAndOffset(java.lang.StringBuilder sql, int max, int offset)
static void	checkAndCreateSchema(javax.sql.DataSource ds)
BatchCommand	createBatchCommand4error(Workflow<?> w, java.lang.Throwable t, DBProcessingState dbProcessingState, Acknowledge ack)
BatchCommand	createBatchCommand4NotifyNoEarlyResponseHandling(Response<?> response, Acknowledge ack)
protected java.sql.PreparedStatement	createDeleteStaleResponsesStmt(java.sql.Connection c, int maxRows)
protected java.sql.PreparedStatement	createDequeueStmt(java.sql.Connection c, java.lang.String ppoolId, int maxRows)
protected java.sql.PreparedStatement	createQueryAllActiveStmt(java.sql.Connection c, java.lang.String className, int max)
protected java.sql.PreparedStatement	createUpdateStateStmt(java.sql.Connection c, int max)
java.lang.String	getDialectDescription()
void	insert(java.util.List<Workflow<?>> wfs, java.sql.Connection con)
void	setDataSource(javax.sql.DataSource dataSource)
static void	shutdownDerby()
void	startup()

Methods inherited from class org.copperengine.core.persistent.AbstractSqlDialect

checkDbConsistency, computeLockId, countAuditTrailInstances, countWorkflowInstances, createBatchCommand4Finish, createBatchCommand4Notify, createBatchCommand4registerCallback, createReadStmt, decode, deleteBroken, deleteFiltered, deleteStaleResponse, deleteWaiting, dequeue, doLock, doReleaseLock, getDbBatchingLatencyMSec, getDefaultStaleResponseRemovalTimeout, getResourceAsString, getResourceAsString, getWorkflowPersistencePlugin, insert, isBlank, isRemoveWhenFinished, lock, notify, queryAllActive, queryAuditTrailInstances, queryAuditTrailMessage, queryObjectState, queryQueueSize, queryWorkflowInstances, read, readDatabaseClock, releaseLock, restart, restartAll, restartFiltered, resumeBrokenBusinessProcesses, setDbBatchingLatencyMSec, setDefaultStaleResponseRemovalTimeout, setEngineId, setEngineIdProvider, setMultiEngineMode, setRemoveWhenFinished, setRuntimeStatisticsCollector, setSerializer, setWfRepository, setWorkflowPersistencePlugin, shutdown, splitt, updateQueueState

Methods inherited from class java.lang.Object

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

Constructor Detail

DerbyDbDialect

public DerbyDbDialect()

Method Detail

setDataSource

public void setDataSource(javax.sql.DataSource dataSource)

startup

public void startup()

Specified by:

startup in interface DatabaseDialect

Overrides:

startup in class AbstractSqlDialect

createUpdateStateStmt

protected java.sql.PreparedStatement createUpdateStateStmt(java.sql.Connection c,
                                                           int max)
                                                    throws java.sql.SQLException

Specified by:

createUpdateStateStmt in class AbstractSqlDialect

Throws:

java.sql.SQLException

createDequeueStmt

protected java.sql.PreparedStatement createDequeueStmt(java.sql.Connection c,
                                                       java.lang.String ppoolId,
                                                       int maxRows)
                                                throws java.sql.SQLException

Specified by:

createDequeueStmt in class AbstractSqlDialect

Throws:

java.sql.SQLException

createDeleteStaleResponsesStmt

protected java.sql.PreparedStatement createDeleteStaleResponsesStmt(java.sql.Connection c,
                                                                    int maxRows)
                                                             throws java.sql.SQLException

Specified by:

createDeleteStaleResponsesStmt in class AbstractSqlDialect

Throws:

java.sql.SQLException

createBatchCommand4error

public BatchCommand createBatchCommand4error(Workflow<?> w,
                                             java.lang.Throwable t,
                                             DBProcessingState dbProcessingState,
                                             Acknowledge ack)

Specified by:

createBatchCommand4error in interface DatabaseDialect

Specified by:

createBatchCommand4error in class AbstractSqlDialect

createBatchCommand4NotifyNoEarlyResponseHandling

public BatchCommand createBatchCommand4NotifyNoEarlyResponseHandling(Response<?> response,
                                                                     Acknowledge ack)
                                                              throws java.lang.Exception

Specified by:

createBatchCommand4NotifyNoEarlyResponseHandling in class AbstractSqlDialect

Throws:

java.lang.Exception

insert

public void insert(java.util.List<Workflow<?>> wfs,
                   java.sql.Connection con)
            throws DuplicateIdException,
                   java.lang.Exception

Specified by:

insert in interface DatabaseDialect

Overrides:

insert in class AbstractSqlDialect

Throws:

DuplicateIdException

java.lang.Exception

getDialectDescription

public java.lang.String getDialectDescription()

checkAndCreateSchema

public static void checkAndCreateSchema(javax.sql.DataSource ds)
                                 throws java.sql.SQLException,
                                        java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

shutdownDerby

public static void shutdownDerby()

createQueryAllActiveStmt

protected java.sql.PreparedStatement createQueryAllActiveStmt(java.sql.Connection c,
                                                              java.lang.String className,
                                                              int max)
                                                       throws java.sql.SQLException

Specified by:

createQueryAllActiveStmt in class AbstractSqlDialect

Throws:

java.sql.SQLException

addLimitation

protected void addLimitation(java.lang.StringBuilder sql,
                             int max)

Specified by:

addLimitation in class AbstractSqlDialect

addLimitationAndOffset

protected void addLimitationAndOffset(java.lang.StringBuilder sql,
                                      int max,
                                      int offset)

Specified by:

addLimitationAndOffset in class AbstractSqlDialect