Just placing this up here so I remember it:

To create a connection pool / jdbc resource under Sun One Web Server 6.1.

This is heavily influenced by: this link

Step 1 -- Set up the connection pool via the web admin interface

• Under Java -> JDBC Connection Pools - create your new connection pool using the proper Oracle driver (9.x in my case)
• Enter in user, password, URL (jdbc:oracle:thin:@[IP]:[port]:[name]
• IMPORTANT: set Transaction Isolation to Read-Committed or Serializable and Guarantee Isolation Level is set to "on"
• ... and you are done

Step 2 -- create your JDBC resource via the web admin interface

Step 3 -- edit your web.xml file

Example
jdbc/exampleDB
javax.sql.DataSource
Container

Step 4 -- edit your sun-web.xml file

jdbc/example
exampleJNDIName

Step 5 -- setup your test code

javax.naming.InitialContext ic = new javax.naming.InitialContext();
DataSource ds = (DataSource)ic.lookup("java:comp/env/jdbc/webdevdata");
dbConn = ds.getConnection();


And you are done!