Since the solution given works, guess I should confirm it:
1) I'm using the Oracle thin JDBC client (ojdbc14.jar) provided by Oracle
2) The connection string looks like this:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=CM-db01)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=CM-db02)(PORT=1521))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CMREP)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))))
3) Go to SJSAS/GF Admin Console
4) Browse to Resources -> JDBC -> Connection Pools
5) Create a new connection pool
6) Under "Additional Properties", you need just 3 properties:
i. URL - give above
ii. Username - DB username
iii. Password - password
Have not tried using the OCI driver yet. No time to.
[Message sent by forum member 'lilwong' (lilwong)]
http://forums.java.net/jive/thread.jspa?messageID=251610