users@glassfish.java.net

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

From: <glassfish_at_javadesktop.org>
Date: Tue, 20 Feb 2007 20:05:43 PST

Hi,

How are you concluding that the issue is related to connection validation ? If there is a validation failure, you can find exceptions in server.log.

From your application log, I could see the exception
" javax.naming.NameNotFoundException: No object bound for java:comp/env/jdbc/oraclesccweb "

which means, there is no such "resource-ref" in your sun-web.xml

eg: Do you have a resource-ref like this in sun-web.xml,

            <resource-ref>
                <res-ref-name>jdbc/oraclesccweb</res-ref-name>
                <jndi-name>jdbc/ORACLE_RESOURCE</jndi-name>
            </resource-ref>


where jdbc/ORACLE_RESOURCE is the jdbc-resource you have created in GlassFish.

Thanks,
-Jagadish
[Message sent by forum member 'jr158900' (jr158900)]

http://forums.java.net/jive/thread.jspa?messageID=204570