Oracle Notes

This is a place for random notes about Oracle and uPortal:

Oracle JDBC thin driver and Oracle Clusters

The Oracle JDBC thin driver now supports RAC. You can connect with the thin driver and RAC by setting up your uPortal.xml like this. (This has been tested with ojdbc.jar version 10.1.0.4.)

...

 <ResourceParams name="jdbc/PortalDb">
            <parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>

<parameter><name>maxActive</name><value>10</value></parameter>
<parameter><name>maxIdle</name><value>3</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>driverClassName</name><value>oracle.jdbc.driver.OracleDriver</value></parameter>

<parameter><name>username</name><value>portal</value></parameter>
<parameter><name>password</name><value>foobar</value></parameter>
<parameter><name>url</name><value>jdbc:oracle:thin:@
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-node1.foo.edu)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = oracle-node2.foo.edu)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracle.foo.edu)
      (FAILOVER_MODE =(TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
</value></parameter>
            
<parameter><name>removeAbandoned</name><value>true</value></parameter>
<parameter><name>logAbandoned</name><value>true</value></parameter>
<parameter><name>validationQuery</name><value>select 1 from dual</value></parameter>
</ResourceParams>
...

Is TAF supported by the thin driver? Would TAF give you any thing over just RAC without modifying uPortal?

Other Notes

Oracle Connection Pooling