users@glassfish.java.net

Re: Connection Pooling - Validation and Recreating Connection does not work

From: <glassfish_at_javadesktop.org>
Date: Tue, 20 Feb 2007 08:50:41 PST

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