oracle.clex.persistence.jdbc
Class OracleJDBCPoolProvider

java.lang.Object
  |
  +--oracle.cle.persistence.ConnectionProvider
        |
        +--oracle.clex.persistence.jdbc.JDBCPoolProvider
              |
              +--oracle.clex.persistence.jdbc.OracleJDBCPoolProvider

All Implemented Interfaces:

Connectable, java.io.Serializable

public class OracleJDBCPoolProvider

extends JDBCPoolProvider

Creates a JDBC connection pool.

Callers of this class will get a java.sql.Connection instance. The instance is a logical connection from the pool. When this method loads, it creates a connection to the database.

Attributes can automatically be set and loaded by specifying properties in the "cle-providers.xml" file at the root of the classpath (ie. WEB-INF/classes/cle-providers.xml). See the http://xmlns.oracle.com/ias/mvc/cle-providers.dtd for more on structure of the file.

Example Oracle JDBC Pool Provider in cle-providers.xml:

 <?xml version="1.0" standalone="yes"?>
 <!DOCTYPE cle-providers SYSTEM "http://xmlns.oracle.com/ias/mvc/cle-providers.dtd">
 <cle-providers>
 	<provider name="personnel_jdbc" class="oracle.clex.persistence.jdbc.OracleJDBCPoolProvider">
  	<property name="user" value="scott"/>
		<property name="password" value="dGlnZXI="/>
		<property name="connectionstring" value="jdbc:oracle:thin:scott/dGlnZXI=@localhost:1521:orcl"/>
		<property name="host" value="localhost"/>
		<property name="port" value="1521"/> 
		<property name="sid" value="orcl"/>  
		<property name="encryptiontype" value="BASE64"/> 
		<property name="drivertype" value="oracle.jdbc.driver.OracleDriver"/>
		<property name="persistencebase" value="oracle.demo.personnel.persistence.jdbc"/>
		<property name="failover" value=""/>
 	</provider>
 </cle-providers>
 

Typical Usage in a Handler:

 
  public Vector aHandlerMethod(Object sessionId, <ArgumentType> aArgument)
    throws Exception
  {
    Connection connection = (Connection)getConnection(sessionId);
    .... use the connection here ...
    releaseConnection(connection);

    return theResult;
  } // end aHandlerMethod
 
 

See Also:

Serialized Form

Fields inherited from class oracle.cle.persistence.ConnectionProvider

BASE64, connection, connectionString, CONNECTIONSTRING, defaultProperties, deploymentKey, driverType, DRIVERTYPE, encryptionType, ENCRYPTIONTYPE, failover, FAILOVER, host, HOST, NO_SCOPE, NONE, password, PASSWORD, persistenceBase, PERSISTENCEBASE, port, PORT, releasedConnectionIds, REQUEST_SCOPE, scope, SCOPE, SESSION_SCOPE, sessionConnectionIds, sid, SID, USER, userName

Constructor Summary

OracleJDBCPoolProvider(java.util.Properties properties)

Method Summary

javax.sql.PooledConnection

getPoolConnection() Create and get a vendor specific PooledConnection instance The username and password keys must be specified in the keys properties file

Methods inherited from class oracle.clex.persistence.jdbc.JDBCPoolProvider

connect, disconnect, getConnection, getConnection, getPoolKey, hashCode, isConnected, isSame, releaseConnection

Methods inherited from class oracle.cle.persistence.ConnectionProvider

addPropertyKey, addPropertyKeys, applyDynamicProperties, clone, compareDynamicProperties, compareProperty, equals, getConnection, getConnection, getConnection, getConnection, getConnection, getConnection, getConnectionString, getDefaultProperties, getDeploymentKey, getDriverType, getEncryptionType, getFailOver, getHost, getPassword, getPassword, getPersistenceBase, getPort, getProperty, getPropertyKeys, getScope, getSid, getUnspecifiedKeys, getUserName, issueWarnings, releaseAllConnections, releaseAllConnections, releaseConnection, releaseConnection, releaseConnection, releaseRequestScopedConnections, releaseRequestScopedConnections, removePropertyKey, setConnectionString, setDefaultProperties, setDeploymentKey, setEncryptionType, setHost, setPassword, setPersistenceBase, setPort, setScope, setSid, setUserName, warn

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleJDBCPoolProvider

public OracleJDBCPoolProvider(java.util.Properties properties)

Method Detail

getPoolConnection

public javax.sql.PooledConnection getPoolConnection()

Create and get a vendor specific PooledConnection instance The username and password keys must be specified in the keys properties file

Overrides:

getPoolConnection in class JDBCPoolProvider