We are having some issues in the confluence set up connecting to the DB. We are at the screen for "Setup Datasource Connection" and i am entering jdbc/OraResource for the datasource name and specifying the oracle 9 dialect however all i can get is a "Could not lookup datasource successfully " message. I have included snippets of our server.xml and web.xml. Thanks for your time. Please note also that the DB is NOT on the same server as confluence.

server.xml

<RESOURCES>
<JDBCCONNECTIONPOOL name="OraclePool" datasourceclassname="oracle.jdbc.pool.OracleDataSource" steadypoolsize="16" maxpoolsize="32" poolresizequantity="2" idletimeout="300" maxwaittime="60000" connectionvalidationrequired="off" connectionvalidationmethod="auto-commit" validationtablename="" failallconnections="off" transactionisolationlevel="read-uncommitted" isolationlevelguaranteed="off">
<PROPERTY name="User" value="conf"/>
<PROPERTY name="URL" value="jdbc:oracle:thin:@10.10.208.52:1521:CONF"/>
<PROPERTY name="Password" value="password"/>
</JDBCCONNECTIONPOOL>
<JDBCRESOURCE jndiname="OraResource" poolname="OraclePool" enabled="on"/>
</RESOURCES>

web.xml

<resource-ref>
<description> Connection Pool</description>
<res-ref-name>jdbc/OraResource</res-ref-name>
<res-type>javax.sql.Datasource</res-type>
<res-auth>Container</res-auth>
</resource-ref>