public abstract class SQLPalioConnector extends SQLConnector implements PalioConnectable, Constants
SQLConnector.Chars
SQLConnectable.QueryReader
Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
increaseSequenceSQL |
protected boolean |
utf8DB |
actionStart, columnLabelingOverride, driver, enableScroll, initSQL, localResultSet, localResultSetMetaData, preparedStatementCacheSize, refreshSQL, unscaledAsLong
allConnections, askingBusy, askingDedicated, debug, freeList, maxConnections, maxInactivity, maxLifeTime, maxUseCount
cluster, connectorClass, instance, name, properties, refreshInterval, scheduler, sharedConfiguration, url
ACCESS, DB2, GENERIC, HIBERNATE, HSQL, JTDS, MSSQL, MYSQL, ORACLE, PALIO, POSTGRESQL, SYBASE
DECIMAL_ZERO, INTEGER_ONE, LONG_MINUS_ONE, LONG_ONE, LONG_THREE, LONG_TWO, LONG_ZERO, STRING_EMPTY
Constructor and Description |
---|
SQLPalioConnector(java.lang.String url,
java.util.Properties properties,
AbstractSQLGenerator generator) |
Modifier and Type | Method and Description |
---|---|
void |
activateSession(PSession s,
java.lang.Long pageID,
java.lang.String params) |
void |
addAccessPrivToPage(java.lang.Long privID,
java.lang.Long pageID) |
void |
addPrivToRole(java.lang.Long roleID,
java.lang.Long privID) |
void |
addRoleToUser(java.lang.Long userID,
java.lang.Long roleID,
java.lang.Long regionID,
java.util.Date expireDate) |
void |
addSessionParam(PSession s,
java.lang.String name,
java.lang.Object value) |
void |
addUser(java.lang.Long ID,
java.lang.String name,
byte[] password,
java.util.Date createdDate,
java.util.Date expireDate,
java.lang.Long expireSessions,
java.lang.Long sessionTimeout) |
void |
closeSession(PSession s) |
void |
createOrUpdateDatabaseForModule(boolean pretend,
java.lang.String moduleName,
java.lang.String targetVersion,
AutomaticScriptFactory scriptFactory)
This method is intended to be called by installers of external modules like CMS, Newsletter, etc.
|
void |
createPriv(java.lang.Long ID,
java.lang.Long typeID,
java.lang.String name,
java.lang.String code,
java.lang.String description) |
void |
createRegion(java.lang.Long ID,
java.lang.String name,
java.lang.String displayName,
java.lang.Long parent) |
void |
createRole(java.lang.Long ID,
java.lang.String name,
java.lang.String displayName,
java.lang.String description) |
void |
createRole(java.lang.Long ID,
java.lang.String name,
java.lang.String displayName,
java.lang.String description,
java.lang.Long parentID) |
void |
delAccessPrivFromPage(java.lang.Long privID,
java.lang.Long pageID) |
void |
deletePriv(java.lang.Long ID) |
void |
deleteRegion(java.lang.Long ID) |
void |
deleteRole(java.lang.Long ID) |
java.util.Collection |
getAllMedia()
Returns set of
PMedia . |
java.util.Collection |
getAllObjects()
Returns set of
PObject . |
java.util.Collection |
getAllPages()
Returns set of
PPage . |
java.util.Collection |
getAllPrivs()
Returns set of
PPriv . |
java.util.Collection |
getAllRoles(Connector connector)
Returns set of
PRole . |
java.lang.Long |
getFreePrivID() |
java.lang.Long |
getFreeRegionID() |
java.lang.Long |
getFreeRoleID() |
java.lang.Long |
getFreeSessionID() |
java.lang.Long |
getFreeUserID() |
AbstractSQLGenerator |
getGenerator() |
PMedia |
getMedia(java.lang.Long ID) |
PMimeType |
getMimeType(java.lang.Long ID) |
PObject |
getObject(java.lang.Long ID) |
PPage |
getPage(java.lang.Long ID) |
PPriv |
getPriv(java.lang.Long ID) |
PPriv |
getPriv(java.lang.String name) |
java.util.LinkedList |
getPrivsList() |
PRegion |
getRegion(java.lang.Long ID,
Connector connector) |
PRegion |
getRegion(java.lang.String name,
Connector connector) |
PRole |
getRole(java.lang.Long ID,
Connector connector) |
PRole |
getRole(java.lang.String name,
Connector connector) |
java.util.LinkedList |
getRolePrivs(java.lang.Long roleID) |
java.util.LinkedList |
getRolesList() |
java.util.LinkedList |
getRolesRegionsForUser(java.lang.Long userID) |
java.lang.Long |
getSequence(java.lang.String sequenceName) |
PSession |
getSession(java.lang.Long ID,
Connector palioConn) |
PTreeType |
getTreeType(java.lang.Long ID) |
PUser |
getUser(java.lang.Long ID,
Connector palioConn) |
PUser |
getUser(java.lang.String name,
Connector connector) |
java.util.Collection<PUser> |
getUsers(Connector connector) |
java.lang.Long |
getVirtualSequence(java.lang.String sequenceName,
boolean create) |
java.util.Properties |
loadConfig() |
void |
loadConnectors(java.util.Map<java.lang.String,Connector> connectors,
java.util.Map<java.lang.String,Connector> schedulerConnectors) |
void |
lockUser(java.lang.Long userID) |
void |
putMedia(PMedia media) |
void |
putObject(PObject object) |
void |
putSession(PSession s) |
void |
removeRoleFromUser(java.lang.Long userID,
java.lang.Long roleID) |
void |
removeRoleFromUser(java.lang.Long userID,
java.lang.Long roleID,
java.lang.Long regionID) |
void |
removeUser(java.lang.Long userID) |
void |
remPrivFromRole(java.lang.Long roleID,
java.lang.Long privID) |
void |
setConfig(java.lang.String name,
java.lang.String value) |
protected void |
setGenerator(AbstractSQLGenerator generator) |
void |
setSessionRegion(PSession s) |
void |
setUserSession(PSession s) |
void |
unlockUser(java.lang.Long userID) |
void |
updateDatabase(java.util.Properties configProperties) |
void |
updateRole(java.lang.Long ID,
java.lang.String name,
java.lang.String displayName,
java.lang.String description,
java.lang.Long parentID) |
void |
updateSessionParam(PSession s,
java.lang.String name,
java.lang.Object value) |
void |
updateUser(java.lang.Long ID,
java.lang.String field,
java.lang.Object value) |
void |
visitingPage(java.lang.Long pageID,
java.lang.Long visitedCount,
java.util.Date lastVisited) |
commit, debugInit, debugSave, dedicatedCommit, dedicatedRollback, dedicatedStart, dedicatedStop, executeFunction, executePL_SQL, executeProcedure, executeSql, fastRead, getConnectorTypes, getInfo, getMetaData, getOutTypeParamForClass, getResultSet, getResultSetMetaData, info, info, init, isNoTransaction, isTransaction, needWriteLob, newConnection, newConnectionInit, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readLine, readLine, readLine, readLine, readLineAsMap, readLineAsMap, readLineAsMap, refreshConnection, resolveDataValue, resolveJavaType, rollback, setFetchSize, transactionStart, transactionStop, write, write, write, write, writeBlob, writeBlob, writeClob, writeLob, writeLob
BusyChecker, clearThreadResources, close, connect, DedicateChecker, FreeChecker, getConnection, getDedicatedConnection, getFreeConnection, getIntParam, putConnection, reconnect, refresh, setDedicated, unsetDedicated
delete, getAsPalioConnector, getConnector, getConnector, getInstance, getLogConfiguration, getName, getUrl, init, log, logDebug, logError, logError, logWarning, save, scheduler, setDedicatedLogConfiguration, setInstance
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
commit, executeFunction, executePL_SQL, executeProcedure, fastRead, getMetaData, getName, getResultSet, getResultSetMetaData, getType, getUrl, init, isNoTransaction, isTransaction, needWriteLob, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, read, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readAsMaps, readLine, readLine, readLine, readLineAsMap, readLineAsMap, readLineAsMap, rollback, setInstance, transactionStart, transactionStop, write, write, write, writeLob, writeLob
protected boolean utf8DB
protected static java.lang.String increaseSequenceSQL
public SQLPalioConnector(java.lang.String url, java.util.Properties properties, AbstractSQLGenerator generator)
public AbstractSQLGenerator getGenerator()
protected void setGenerator(AbstractSQLGenerator generator)
public PTreeType getTreeType(java.lang.Long ID) throws PalioException
getTreeType
in interface PalioConnectable
PalioException
public java.util.Collection getAllPages() throws PalioException
PalioConnectable
PPage
.getAllPages
in interface PalioConnectable
PalioException
public PPage getPage(java.lang.Long ID) throws PalioException
getPage
in interface PalioConnectable
PalioException
public java.util.Collection getAllObjects() throws PalioException
PalioConnectable
PObject
.getAllObjects
in interface PalioConnectable
PalioException
public PObject getObject(java.lang.Long ID) throws PalioException
getObject
in interface PalioConnectable
PalioException
public java.util.Collection getAllMedia() throws PalioException
PalioConnectable
PMedia
.getAllMedia
in interface PalioConnectable
PalioException
public PMedia getMedia(java.lang.Long ID) throws PalioException
getMedia
in interface PalioConnectable
PalioException
public PMimeType getMimeType(java.lang.Long ID) throws PalioException
getMimeType
in interface PalioConnectable
PalioException
public java.util.Collection getAllPrivs() throws PalioException
PalioConnectable
PPriv
.getAllPrivs
in interface PalioConnectable
PalioException
public PPriv getPriv(java.lang.Long ID) throws PalioException
getPriv
in interface PalioConnectable
PalioException
public PPriv getPriv(java.lang.String name) throws PalioException
getPriv
in interface PalioConnectable
PalioException
public java.util.Collection getAllRoles(Connector connector) throws PalioException
PalioConnectable
PRole
.getAllRoles
in interface PalioConnectable
PalioException
public PRole getRole(java.lang.Long ID, Connector connector) throws PalioException
getRole
in interface PalioConnectable
PalioException
public PRole getRole(java.lang.String name, Connector connector) throws PalioException
getRole
in interface PalioConnectable
PalioException
public PRegion getRegion(java.lang.Long ID, Connector connector) throws PalioException
getRegion
in interface PalioConnectable
PalioException
public PRegion getRegion(java.lang.String name, Connector connector) throws PalioException
getRegion
in interface PalioConnectable
PalioException
public PUser getUser(java.lang.Long ID, Connector palioConn) throws PalioException
getUser
in interface PalioConnectable
PalioException
public PUser getUser(java.lang.String name, Connector connector) throws PalioException
getUser
in interface PalioConnectable
PalioException
public java.util.Collection<PUser> getUsers(Connector connector) throws PalioException
getUsers
in interface PalioConnectable
PalioException
public java.util.LinkedList getRolesRegionsForUser(java.lang.Long userID) throws PalioException
getRolesRegionsForUser
in interface PalioConnectable
PalioException
public void addUser(java.lang.Long ID, java.lang.String name, byte[] password, java.util.Date createdDate, java.util.Date expireDate, java.lang.Long expireSessions, java.lang.Long sessionTimeout) throws PalioException
addUser
in interface PalioConnectable
PalioException
public void updateUser(java.lang.Long ID, java.lang.String field, java.lang.Object value) throws PalioException
updateUser
in interface PalioConnectable
PalioException
public void addRoleToUser(java.lang.Long userID, java.lang.Long roleID, java.lang.Long regionID, java.util.Date expireDate) throws PalioException
addRoleToUser
in interface PalioConnectable
PalioException
public void removeRoleFromUser(java.lang.Long userID, java.lang.Long roleID, java.lang.Long regionID) throws PalioException
removeRoleFromUser
in interface PalioConnectable
PalioException
public void removeRoleFromUser(java.lang.Long userID, java.lang.Long roleID) throws PalioException
PalioException
public void removeUser(java.lang.Long userID) throws PalioException
removeUser
in interface PalioConnectable
PalioException
public void lockUser(java.lang.Long userID) throws PalioException
lockUser
in interface PalioConnectable
PalioException
public void unlockUser(java.lang.Long userID) throws PalioException
unlockUser
in interface PalioConnectable
PalioException
public PSession getSession(java.lang.Long ID, Connector palioConn) throws PalioException
getSession
in interface PalioConnectable
PalioException
public void putSession(PSession s) throws PalioException
putSession
in interface PalioConnectable
PalioException
public void activateSession(PSession s, java.lang.Long pageID, java.lang.String params) throws PalioException
activateSession
in interface PalioConnectable
PalioException
public void setUserSession(PSession s) throws PalioException
setUserSession
in interface PalioConnectable
PalioException
public void setSessionRegion(PSession s) throws PalioException
setSessionRegion
in interface PalioConnectable
PalioException
public void closeSession(PSession s) throws PalioException
closeSession
in interface PalioConnectable
PalioException
public void addSessionParam(PSession s, java.lang.String name, java.lang.Object value) throws PalioException
addSessionParam
in interface PalioConnectable
PalioException
public void updateSessionParam(PSession s, java.lang.String name, java.lang.Object value) throws PalioException
updateSessionParam
in interface PalioConnectable
PalioException
public java.lang.Long getSequence(java.lang.String sequenceName) throws PalioException
getSequence
in interface SQLConnectable
getSequence
in class SQLConnector
PalioException
public java.lang.Long getVirtualSequence(java.lang.String sequenceName, boolean create) throws PalioException
PalioException
public java.lang.Long getFreeSessionID() throws PalioException
getFreeSessionID
in interface PalioConnectable
PalioException
public java.lang.Long getFreeUserID() throws PalioException
getFreeUserID
in interface PalioConnectable
PalioException
public void visitingPage(java.lang.Long pageID, java.lang.Long visitedCount, java.util.Date lastVisited) throws PalioException
visitingPage
in interface PalioConnectable
PalioException
public java.util.LinkedList getRolesList() throws PalioException
getRolesList
in interface PalioConnectable
PalioException
public java.lang.Long getFreeRoleID() throws PalioException
getFreeRoleID
in interface PalioConnectable
PalioException
public void createRole(java.lang.Long ID, java.lang.String name, java.lang.String displayName, java.lang.String description) throws PalioException
createRole
in interface PalioConnectable
PalioException
public void createRole(java.lang.Long ID, java.lang.String name, java.lang.String displayName, java.lang.String description, java.lang.Long parentID) throws PalioException
createRole
in interface PalioConnectable
PalioException
public void updateRole(java.lang.Long ID, java.lang.String name, java.lang.String displayName, java.lang.String description, java.lang.Long parentID) throws PalioException
updateRole
in interface PalioConnectable
PalioException
public void deleteRole(java.lang.Long ID) throws PalioException
deleteRole
in interface PalioConnectable
PalioException
public java.util.LinkedList getPrivsList() throws PalioException
getPrivsList
in interface PalioConnectable
PalioException
public java.util.LinkedList getRolePrivs(java.lang.Long roleID) throws PalioException
getRolePrivs
in interface PalioConnectable
PalioException
public java.lang.Long getFreePrivID() throws PalioException
getFreePrivID
in interface PalioConnectable
PalioException
public void createPriv(java.lang.Long ID, java.lang.Long typeID, java.lang.String name, java.lang.String code, java.lang.String description) throws PalioException
createPriv
in interface PalioConnectable
PalioException
public void deletePriv(java.lang.Long ID) throws PalioException
deletePriv
in interface PalioConnectable
PalioException
public void addPrivToRole(java.lang.Long roleID, java.lang.Long privID) throws PalioException
addPrivToRole
in interface PalioConnectable
PalioException
public void remPrivFromRole(java.lang.Long roleID, java.lang.Long privID) throws PalioException
remPrivFromRole
in interface PalioConnectable
PalioException
public void createRegion(java.lang.Long ID, java.lang.String name, java.lang.String displayName, java.lang.Long parent) throws PalioException
createRegion
in interface PalioConnectable
PalioException
public void deleteRegion(java.lang.Long ID) throws PalioException
deleteRegion
in interface PalioConnectable
PalioException
public java.lang.Long getFreeRegionID() throws PalioException
getFreeRegionID
in interface PalioConnectable
PalioException
public void addAccessPrivToPage(java.lang.Long privID, java.lang.Long pageID) throws PalioException
addAccessPrivToPage
in interface PalioConnectable
PalioException
public void delAccessPrivFromPage(java.lang.Long privID, java.lang.Long pageID) throws PalioException
delAccessPrivFromPage
in interface PalioConnectable
PalioException
public void putMedia(PMedia media) throws PalioException
putMedia
in interface PalioConnectable
PalioException
public void putObject(PObject object) throws PalioException
putObject
in interface PalioConnectable
PalioException
public void loadConnectors(java.util.Map<java.lang.String,Connector> connectors, java.util.Map<java.lang.String,Connector> schedulerConnectors) throws PalioException
loadConnectors
in interface PalioConnectable
PalioException
public java.util.Properties loadConfig() throws PalioException
loadConfig
in interface PalioConnectable
PalioException
public void setConfig(java.lang.String name, java.lang.String value) throws PalioException
setConfig
in interface PalioConnectable
PalioException
public void updateDatabase(java.util.Properties configProperties)
updateDatabase
in interface PalioConnectable
public void createOrUpdateDatabaseForModule(boolean pretend, java.lang.String moduleName, java.lang.String targetVersion, AutomaticScriptFactory scriptFactory)
createOrUpdateDatabaseForModule
in interface PalioConnectable
PalioException
- if database create/update for module failed