Sun Web Server 7 - Problem setting up database connection pools
In SWS 6.x, I set up a database connection pool like so:
1. Add a connection pool in the admin tool
2. Add a resource and match it to that connection pool in the admin tool
3. Add a line in sun-web.xml which matches the name I use for the resource within my Web app to the JNDI name
4. Add entries into web.xml to add JNDI names to the resources I created.
Under SWS7.x, I used the admin tool to create resources - it asked me for the database, and I gave it the jndi name. I left sun-web.xml and web.xml the way they were (i.e. the way I had them in 6.x). But, now, when I redeploy the Web application, I get the following error:
[05/Sep/2006:08:22:52] info (26791): WEB0100: Loading web module in virtual server [myserver.com] at [/sccweb]
[05/Sep/2006:08:22:53] warning (26791): WEB7020: Web application [/sccweb] is expecting a resource named [jdbc/maize] which is not configured in server.xml
[05/Sep/2006:08:22:53] warning (26791): WEB7020: Web application [/sccweb] is expecting a resource named [jdbc/oraclesccweb] which is not configured in server.xml
[05/Sep/2006:08:22:53] warning (26791): WEB7020: Web application [/sccweb] is expecting a resource named [jdbc/handbook] which is not configured in server.xml
[05/Sep/2006:08:22:53] info (26791): CORE3280: Anew configuration was successfully installed
What am I doing wrong?
Here is an example entry in sun-web.xml:
<resource-ref>
<res-ref-name>jdbc/oraclesccweb</res-ref-name>
<jndi-name>jdbc/oraclesccweb</jndi-name>
</resource-ref>
And here is an example from an entry in web.xml:
<resource-ref>
<description>SCCWeb Oracle Database</description>
<res-ref-name>jdbc/oraclesccweb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
And here is what is currently in server.xml:
<jdbc-resource>
<jndi-name>jdbc/oraclesccweb</jndi-name>
<datasource-class>oracle.jdbc.pool.OracleDataSource</datasource-class>
<isolation-level>read-committed</isolation-level>
<connection-validation>auto-commit</connection-validation>
<fail-all-connections>true</fail-all-connections>
<property>
<name>password</name>
<value>mypass</value>
</property>
<property>
<name>user</name>
<value>myuser</value>
</property>
<property>
<name>url</name>
<value>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.com) (PORT=1521))(CONNECT_DA
TA=(SERVICE_NAME=myservice_name.com)))</value>
</property>
<description>Main Database</description>
</jdbc-resource>
Any suggestions?
