public class PostgreSQLConnector extends SQLPalioConnector
SQLConnector.Chars
SQLConnectable.QueryReader
increaseSequenceSQL, 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 |
---|
PostgreSQLConnector(java.lang.String url,
java.util.Properties properties) |
Modifier and Type | Method and Description |
---|---|
static boolean |
acceptsURL(java.lang.String URL) |
java.lang.Long |
getSequence(java.lang.String sequenceName) |
int |
getType() |
void |
init() |
boolean |
isPostgresVersionHigherOrEqual91() |
protected void |
setFetchSize(palio.connectors.SQLConnection conn,
java.sql.Statement stat,
int count) |
activateSession, addAccessPrivToPage, addPrivToRole, addRoleToUser, addSessionParam, addUser, closeSession, createOrUpdateDatabaseForModule, createPriv, createRegion, createRole, createRole, delAccessPrivFromPage, deletePriv, deleteRegion, deleteRole, getAllMedia, getAllObjects, getAllPages, getAllPrivs, getAllRoles, getFreePrivID, getFreeRegionID, getFreeRoleID, getFreeSessionID, getFreeUserID, getGenerator, getMedia, getMimeType, getObject, getPage, getPriv, getPriv, getPrivsList, getRegion, getRegion, getRole, getRole, getRolePrivs, getRolesList, getRolesRegionsForUser, getSession, getTreeType, getUser, getUser, getUsers, getVirtualSequence, loadConfig, loadConnectors, lockUser, putMedia, putObject, putSession, removeRoleFromUser, removeRoleFromUser, removeUser, remPrivFromRole, setConfig, setGenerator, setSessionRegion, setUserSession, unlockUser, updateDatabase, updateRole, updateSessionParam, updateUser, visitingPage
commit, debugInit, debugSave, dedicatedCommit, dedicatedRollback, dedicatedStart, dedicatedStop, executeFunction, executePL_SQL, executeProcedure, executeSql, fastRead, getConnectorTypes, getInfo, getMetaData, getOutTypeParamForClass, getResultSet, getResultSetMetaData, info, info, 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, 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, getUrl, 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
public PostgreSQLConnector(java.lang.String url, java.util.Properties properties)
public static final boolean acceptsURL(java.lang.String URL) throws PalioException
PalioException
public void init() throws PalioException
init
in interface SQLConnectable
init
in class SQLConnector
PalioException
protected void setFetchSize(palio.connectors.SQLConnection conn, java.sql.Statement stat, int count) throws java.sql.SQLException
setFetchSize
in class SQLConnector
java.sql.SQLException
public int getType()
public java.lang.Long getSequence(java.lang.String sequenceName) throws PalioException
getSequence
in interface SQLConnectable
getSequence
in class SQLPalioConnector
PalioException
public boolean isPostgresVersionHigherOrEqual91()