|
uPortal 2.4.1 API Documentation |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.jasig.portal.RDBMServices
Provides relational database access and helper methods. A static routine determins if the database/driver supports prepared statements and/or outer joins.
Nested Class Summary | |
static interface |
RDBMServices.IJoinQueryString
|
static class |
RDBMServices.JdbcDb
|
static class |
RDBMServices.JoinQueryString
|
static class |
RDBMServices.OracleDb
|
static class |
RDBMServices.PostgreSQLDb
|
static class |
RDBMServices.PreparedStatement
Wrapper for/Emulator of PreparedStatement class |
Field Summary | |
static RDBMServices.IJoinQueryString |
joinQuery
|
static java.lang.String |
PERSON_DB
|
static java.lang.String |
PORTAL_DB
|
static int |
RETRY_COUNT
|
static boolean |
supportsOuterJoins
|
static boolean |
supportsTransactions
|
Constructor Summary | |
RDBMServices()
|
Method Summary | |
static void |
closePreparedStatement(java.sql.PreparedStatement ps)
Close a PreparedStatement |
static void |
closePreparedStatement(RDBMServices.PreparedStatement ps)
Close a PreparedStatement |
static void |
closeResultSet(java.sql.ResultSet rs)
Close a ResultSet |
static void |
closeStatement(java.sql.Statement st)
Close a Statement |
static void |
commit(java.sql.Connection connection)
Commit pending transactions |
static java.lang.String |
dbFlag(boolean flag)
Return DB format of a boolean. |
static boolean |
dbFlag(java.lang.String flag)
Return boolean value of DB flag, "Y" or "N". |
static java.sql.Connection |
getConnection()
Gets a database connection to the portal database. |
static java.sql.Connection |
getConnection(java.lang.String dbName)
Returns a connection produced by a DataSource found in the JNDI context. |
static java.lang.String |
getJdbcDriver()
Get the JDBC driver |
static java.lang.String |
getJdbcUrl()
Get the JDBC connection URL |
static java.lang.String |
getJdbcUser()
Get the JDBC user |
static void |
releaseConnection(java.sql.Connection con)
Releases database connection |
static void |
rollback(java.sql.Connection connection)
rollback unwanted changes to the database |
static void |
setAutoCommit(java.sql.Connection connection,
boolean autocommit)
Set auto commit state for the connection |
static java.lang.String |
sqlEscape(java.lang.String sql)
Make a string SQL safe |
static java.lang.String |
sqlTimeStamp()
SQL format of current time |
static java.lang.String |
sqlTimeStamp(java.util.Date date)
SQL format a Date |
static java.lang.String |
sqlTimeStamp(long date)
SQL format a long timestamp |
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
public static int RETRY_COUNT
public static boolean supportsOuterJoins
public static boolean supportsTransactions
public static RDBMServices.IJoinQueryString joinQuery
public static final java.lang.String PORTAL_DB
public static final java.lang.String PERSON_DB
Constructor Detail |
public RDBMServices()
Method Detail |
public static java.sql.Connection getConnection(java.lang.String dbName)
dbName
- the database name which will be retrieved from
the JNDI context relative to "jdbc/"
null
if no Connectionpublic static java.sql.Connection getConnection()
public static void releaseConnection(java.sql.Connection con)
con
- a database Connection objectpublic static void closePreparedStatement(java.sql.PreparedStatement ps)
ps
- a database PreparedStatement objectpublic static void closePreparedStatement(RDBMServices.PreparedStatement ps)
ps
- a database PreparedStatement objectpublic static void closeResultSet(java.sql.ResultSet rs)
rs
- a database ResultSet objectpublic static void closeStatement(java.sql.Statement st)
st
- a database Statement objectpublic static java.lang.String getJdbcDriver()
public static java.lang.String getJdbcUrl()
public static java.lang.String getJdbcUser()
public static final void commit(java.sql.Connection connection) throws java.sql.SQLException
connection
-
java.sql.SQLException
public static final void setAutoCommit(java.sql.Connection connection, boolean autocommit) throws java.sql.SQLException
connection
- autocommit
-
java.sql.SQLException
public static final void rollback(java.sql.Connection connection) throws java.sql.SQLException
connection
-
java.sql.SQLException
public static final java.lang.String dbFlag(boolean flag)
flag
- true or false
public static final boolean dbFlag(java.lang.String flag)
flag
- either "Y" or "N"
public static final java.lang.String sqlTimeStamp()
public static final java.lang.String sqlTimeStamp(long date)
date
-
public static final java.lang.String sqlTimeStamp(java.util.Date date)
date
-
public static final java.lang.String sqlEscape(java.lang.String sql)
sql
-
|
uPortal 2.4.1 API Documentation |
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |