So this is what I have set up:
(1) In web.xml I have this entry:
[code]
<resource-ref>
<description>My database</description>
<res-ref-name>jdbc/oraclesccweb</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
[/code]
(2) In sun-web.xml I have this corresponding entry:
[code]
<resource-ref>
<res-ref-name>jdbc/oraclesccweb</res-ref-name>
<jndi-name>jdbc/oraclesccweb</jndi-name>
</resource-ref>
[/code]
(3) In domain.xml / GUI admin on Sun App Server 9, I have this connection pool set up:
[code]ATR My Database oracle.jdbc.pool.OracleDataSource[/code]
with Connection validation enabled using a database table and with on failure close all connections.
(4) In domain.xml / GUI admin, I have this JDBC resource set up:
[code]jdbc/oraclesccweb true My database[/code]
This resource links with the ATR connection pool in (3).
The connection to the database works. However, when I redeploy a Web application, i.e. using Netbeans, the connection dies. I don't see error messages in server.log other than those already listed in my posts above. Am I setting up the connections incorrectly?
dailysun
[Message sent by forum member 'dailysun' (dailysun)]
http://forums.java.net/jive/thread.jspa?messageID=204850