Here are step-by-step actions I take to recreate the problem.
First, I redeploy the Web application. Here are the logs:
[code]
[#|2007-02-20T08:42:58.765-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.admin|_ThreadID=16;_ThreadName=httpWorkerThread-4848-2;/var/tmp/s1astempdomain1server1615478316/actionplans.war;|ADM1064:The upload file at [/var/tmp/s1astempdomain1server1615478316/actionplans.war] exists and will be overwritten.|#]
[#|2007-02-20T08:42:58.766-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.admin|_ThreadID=16;_ThreadName=httpWorkerThread-4848-2;/var/tmp/s1astempdomain1server1615478316/actionplans.war;|ADM1006:Uploading the file to:[/var/tmp/s1astempdomain1server1615478316/actionplans.war]|#]
[#|2007-02-20T08:43:46.902-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.deployment|_ThreadID=27;_ThreadName=Thread-469;8080;|mbean.use_default_port|#]
[#|2007-02-20T08:43:47.562-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.deployment|_ThreadID=27;_ThreadName=Thread-469;|deployed with moduleid = actionplans|#]
[#|2007-02-20T08:43:48.758-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.container.web|_ThreadID=28;_ThreadName=httpWorkerThread-4848-3;actionplans;server;/actionplans;|WEB0100: Loading web module [actionplans] in virtual server [server] at [/actionplans]|#]
[/code]
Now, I try to load a page that accesses the database. I notice that the page does not load with the connection. I check the logs and see no entries. I think, hmm, maybe I should "poke" app server to reload by changing a value of the database resource in the GUI. So, for instance, I uncheck the "fail all connections" option. The server log now shows:
[code]
[#|2007-02-20T08:46:47.451-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.tools.admin|_ThreadID=16;_ThreadName=httpWorkerThread-4848-2;ResourceDeployEvent -- redeploy jcp/ATR-HANDBOOK;|ADM1041:Sent the event to instance:[ResourceDeployEvent -- redeploy jcp/ATR-HANDBOOK]|#]
[#|2007-02-20T08:46:47.546-0800|INFO|sun-appserver-pe9.0|javax.enterprise.system.core|_ThreadID=16;_ThreadName=httpWorkerThread-4848-2;jcp:ATR-HANDBOOK;|CORE5008: Resource Redeployed: [jcp:ATR-HANDBOOK].|#]
[/code]
That's good. I'd expect the database to be available now. But it's not! With connection validation - isn't the app server supposed to find out when a connection is bad? The only way for me to solve this is by restarting the entire domain. Am I doing something incorrectly? The database I'm using is Oracle 9.
dailysun.
[Message sent by forum member 'dailysun' (dailysun)]
http://forums.java.net/jive/thread.jspa?messageID=204446