org.apache.agila.util
Class JDBCUtil

java.lang.Object
  extended by org.apache.agila.util.JDBCUtil
All Implemented Interfaces:
AgilaDAO

public class JDBCUtil
extends java.lang.Object
implements AgilaDAO

An intermediary between the database and the system. Creates a persistence session using JDBC. All JDBC calls pass through this class TODO maybe creating a session factory is a cool todo so that system will be abstracted how the persistence layer is done (JDO, O/R, JDBC) $Id: JDBCUtil.java 232597 2005-08-14 11:33:39Z clim $


Method Summary
 BusinessProcessID addGraph(BusinessProcess businessProcess)
           
 UserID addUser(UserInfo newUser)
           
 int generateKey()
          Generates a unique key TODO needs some improvement
 java.util.List getActiveTokensForInstance(InstanceID instanceID)
           
 java.util.List getAllProcessGraphs()
           
 java.sql.Connection getConnection()
           
 BusinessProcess getGraphByID(BusinessProcessID businessProcessID)
           
 BusinessProcessID getGraphIDByName(java.lang.String name)
           
static JDBCUtil getInstance()
           
 Instance getInstanceByID(InstanceID instanceID)
           
 java.util.List getInstanceInfos()
           
 InstanceServiceInfo getInstanceServiceInfo()
          Retrieve the instance service info.
 Task getTaskByID(TaskID taskID)
           
 java.util.List getTasksForGroups(GroupID[] groupIDs, int status)
           
 java.util.List getTasksForInstance(InstanceID instanceID, int status)
           
 java.util.List getTasksForUser(UserID userID, int status)
           
 Token getTokenByID(TokenID tokenID)
           
 UserInfo getUserFromPrincipal(java.lang.String principalName)
           
 UserInfo getUserInfo(UserID id)
           
 TaskID insertTask(Task task)
           
 java.util.List listAllUserInfo()
           
 boolean lockTaskForUser(TaskID taskID, UserID userID)
           
 Instance newInstance(BusinessProcessID businessProcessID, java.util.Map params)
          Inserts a new instance in the database
 Token newToken(InstanceID instanceID, NodeID nodeID, int state)
          Create a token with only the InstanceID given
 void saveInstance(Instance instance)
           
 boolean saveToken(Token token)
           
 void saveUser(UserInfo existingUser)
           
 int setTaskStatusForInstance(InstanceID instanceID, int oldStatus, int newStatus)
           
 void unlockTaskForUser(TaskID taskID, UserID userID)
           
 TaskID updateTask(Task task)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getInstance

public static JDBCUtil getInstance()

getConnection

public java.sql.Connection getConnection()

addGraph

public BusinessProcessID addGraph(BusinessProcess businessProcess)
Specified by:
addGraph in interface AgilaDAO

getGraphIDByName

public BusinessProcessID getGraphIDByName(java.lang.String name)
Specified by:
getGraphIDByName in interface AgilaDAO

getGraphByID

public BusinessProcess getGraphByID(BusinessProcessID businessProcessID)
Specified by:
getGraphByID in interface AgilaDAO

getAllProcessGraphs

public java.util.List getAllProcessGraphs()
Specified by:
getAllProcessGraphs in interface AgilaDAO

newInstance

public Instance newInstance(BusinessProcessID businessProcessID,
                            java.util.Map params)
Inserts a new instance in the database

Specified by:
newInstance in interface AgilaDAO

getInstanceServiceInfo

public InstanceServiceInfo getInstanceServiceInfo()
Retrieve the instance service info.

Specified by:
getInstanceServiceInfo in interface AgilaDAO

saveInstance

public void saveInstance(Instance instance)
Specified by:
saveInstance in interface AgilaDAO

getInstanceByID

public Instance getInstanceByID(InstanceID instanceID)
Specified by:
getInstanceByID in interface AgilaDAO

getInstanceInfos

public java.util.List getInstanceInfos()
Specified by:
getInstanceInfos in interface AgilaDAO

insertTask

public TaskID insertTask(Task task)
Specified by:
insertTask in interface AgilaDAO

updateTask

public TaskID updateTask(Task task)
Specified by:
updateTask in interface AgilaDAO

getTaskByID

public Task getTaskByID(TaskID taskID)
Specified by:
getTaskByID in interface AgilaDAO

getTasksForUser

public java.util.List getTasksForUser(UserID userID,
                                      int status)
Specified by:
getTasksForUser in interface AgilaDAO

getTasksForInstance

public java.util.List getTasksForInstance(InstanceID instanceID,
                                          int status)
Specified by:
getTasksForInstance in interface AgilaDAO

setTaskStatusForInstance

public int setTaskStatusForInstance(InstanceID instanceID,
                                    int oldStatus,
                                    int newStatus)
Specified by:
setTaskStatusForInstance in interface AgilaDAO

getTasksForGroups

public java.util.List getTasksForGroups(GroupID[] groupIDs,
                                        int status)
Specified by:
getTasksForGroups in interface AgilaDAO

lockTaskForUser

public boolean lockTaskForUser(TaskID taskID,
                               UserID userID)
Specified by:
lockTaskForUser in interface AgilaDAO

unlockTaskForUser

public void unlockTaskForUser(TaskID taskID,
                              UserID userID)
Specified by:
unlockTaskForUser in interface AgilaDAO

newToken

public Token newToken(InstanceID instanceID,
                      NodeID nodeID,
                      int state)
Create a token with only the InstanceID given

Specified by:
newToken in interface AgilaDAO

saveToken

public boolean saveToken(Token token)
Specified by:
saveToken in interface AgilaDAO

getTokenByID

public Token getTokenByID(TokenID tokenID)
Specified by:
getTokenByID in interface AgilaDAO

getActiveTokensForInstance

public java.util.List getActiveTokensForInstance(InstanceID instanceID)
Specified by:
getActiveTokensForInstance in interface AgilaDAO

getUserFromPrincipal

public UserInfo getUserFromPrincipal(java.lang.String principalName)
Specified by:
getUserFromPrincipal in interface AgilaDAO

getUserInfo

public UserInfo getUserInfo(UserID id)
Specified by:
getUserInfo in interface AgilaDAO

addUser

public UserID addUser(UserInfo newUser)
Specified by:
addUser in interface AgilaDAO

listAllUserInfo

public java.util.List listAllUserInfo()
Specified by:
listAllUserInfo in interface AgilaDAO

saveUser

public void saveUser(UserInfo existingUser)
Specified by:
saveUser in interface AgilaDAO

generateKey

public int generateKey()
Generates a unique key TODO needs some improvement



Copyright © 2004-2005 The Apache Software Foundation. All Rights Reserved.