You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Cary Clark <ca...@etechsolutions.net> on 2006/01/06 18:02:08 UTC

Connection Pool setup from console fails

Running XP Pro, JDK1.4.2, MySQL 5.0, MySQL connector 3.1.12
If I use the wizard through the console to include my MySQL jar and then 
create a pool, I get a failure.  It gets through the Test Connection 
phase fine, but fails when I click the Deploy button with this stack trace:

10:48:15,700 ERROR [DatabasePoolPortlet] Unable to save connection pool
java.lang.NullPointerException
    at sun.misc.URLClassPath$3.run(URLClassPath.java:312)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.misc.URLClassPath.getLoader(URLClassPath.java:309)
    at sun.misc.URLClassPath.getLoader(URLClassPath.java:286)
    at sun.misc.URLClassPath.findResource(URLClassPath.java:137)
    at java.net.URLClassLoader$2.run(URLClassLoader.java:352)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findResource(URLClassLoader.java:349)
    at java.lang.ClassLoader.getResource(ClassLoader.java:787)
    at 
org.apache.geronimo.deployment.tools.loader.AbstractDeployable.<init>(AbstractDeployable.java:57)
    at 
org.apache.geronimo.deployment.tools.loader.ConnectorDeployable.<init>(ConnectorDeployable.java:37)
    at 
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:813)
    at 
org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:337)
    at 
org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
    at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
    at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at 
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
    at 
org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
    at 
org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
    at 
org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
    at 
org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
    at 
org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
    at 
org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
    at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
    at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
    at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
    at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
    at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
    at 
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
    at 
org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:272)
    at 
org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46)
    at 
org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyContextValve.java:50)
    at 
org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(TransactionContextValve.java:53)
    at 
org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentContextValve.java:47)
    at 
org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceContextValve.java:60)
    at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
    at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
    at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
    at 
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
    at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
    at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
    at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
    at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:534)

The generated URL at the top of the page with the Test Connection button is:
jdbc:mysql://localhost:3306/cpdb

After the failure, the page is forwarded back to the list of pools and 
doesn't list the one I just configured.

Suggestions?  Do I need to open up a JIRA issue?

Thanks,
Cary

Re: Connection Pool setup from console fails

Posted by Cary Clark <ca...@etechsolutions.net>.
*GERONIMO-1426 <http://issues.apache.org/jira/browse/GERONIMO-1426> opened*

Aaron Mulder said the following on 1/6/2006 3:58 PM:

>OK.  Can you post a JIRA with the exact values you entered and buttons
>you clicked in each screen you got through and I'll try to replicate
>it and see where I get from there?
>
>Thanks,
>    Aaron
>
>On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
>  
>
>>Regardless if I click the Test Connection or Skip Test and Show Plan, it
>>gets the same error in the log and puts up a Show Deployment Plan page
>>with no Deployment Plan.
>>
>>Any other suggestions?
>>
>>Cary
>>
>>
>>Aaron Mulder said the following on 1/6/2006 3:10 PM:
>>
>>    
>>
>>>Could you click the button to show the plan it generated and post that
>>>here?  That might help figure out what's going on.
>>>
>>>Thanks,
>>>   Aaron
>>>
>>>On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
>>>
>>>
>>>      
>>>
>>>>Running XP Pro, JDK1.4.2, MySQL 5.0, MySQL connector 3.1.12
>>>>If I use the wizard through the console to include my MySQL jar and then
>>>>create a pool, I get a failure.  It gets through the Test Connection
>>>>phase fine, but fails when I click the Deploy button with this stack trace:
>>>>
>>>>10:48:15,700 ERROR [DatabasePoolPortlet] Unable to save connection pool
>>>>java.lang.NullPointerException
>>>>   at sun.misc.URLClassPath$3.run(URLClassPath.java:312)
>>>>   at java.security.AccessController.doPrivileged(Native Method)
>>>>   at sun.misc.URLClassPath.getLoader(URLClassPath.java:309)
>>>>   at sun.misc.URLClassPath.getLoader(URLClassPath.java:286)
>>>>   at sun.misc.URLClassPath.findResource(URLClassPath.java:137)
>>>>   at java.net.URLClassLoader$2.run(URLClassLoader.java:352)
>>>>   at java.security.AccessController.doPrivileged(Native Method)
>>>>   at java.net.URLClassLoader.findResource(URLClassLoader.java:349)
>>>>   at java.lang.ClassLoader.getResource(ClassLoader.java:787)
>>>>   at
>>>>org.apache.geronimo.deployment.tools.loader.AbstractDeployable.<init>(AbstractDeployable.java:57)
>>>>   at
>>>>org.apache.geronimo.deployment.tools.loader.ConnectorDeployable.<init>(ConnectorDeployable.java:37)
>>>>   at
>>>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:813)
>>>>   at
>>>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:337)
>>>>   at
>>>>org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
>>>>   at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>>>>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>>>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>>   at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>>>   at
>>>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>>>>   at
>>>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>>>>   at
>>>>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
>>>>   at
>>>>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
>>>>   at
>>>>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
>>>>   at
>>>>org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
>>>>   at
>>>>org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
>>>>   at
>>>>org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
>>>>   at
>>>>org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
>>>>   at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
>>>>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>>>   at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>>>   at
>>>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>>>>   at
>>>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>>>>   at
>>>>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>>>>   at
>>>>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>>>>   at
>>>>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
>>>>   at
>>>>org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:272)
>>>>   at
>>>>org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46)
>>>>   at
>>>>org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyContextValve.java:50)
>>>>   at
>>>>org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(TransactionContextValve.java:53)
>>>>   at
>>>>org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentContextValve.java:47)
>>>>   at
>>>>org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceContextValve.java:60)
>>>>   at
>>>>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>>>>   at
>>>>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>>>>   at
>>>>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>>>>   at
>>>>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
>>>>   at
>>>>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>>>>   at
>>>>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
>>>>   at
>>>>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>>>   at
>>>>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>>>>   at
>>>>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>>>>   at
>>>>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>>>>   at java.lang.Thread.run(Thread.java:534)
>>>>
>>>>The generated URL at the top of the page with the Test Connection button is:
>>>>jdbc:mysql://localhost:3306/cpdb
>>>>
>>>>After the failure, the page is forwarded back to the list of pools and
>>>>doesn't list the one I just configured.
>>>>
>>>>Suggestions?  Do I need to open up a JIRA issue?
>>>>
>>>>Thanks,
>>>>Cary
>>>>
>>>>
>>>>
>>>>        
>>>>

Re: Connection Pool setup from console fails

Posted by Aaron Mulder <am...@alumni.princeton.edu>.
OK.  Can you post a JIRA with the exact values you entered and buttons
you clicked in each screen you got through and I'll try to replicate
it and see where I get from there?

Thanks,
    Aaron

On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
> Regardless if I click the Test Connection or Skip Test and Show Plan, it
> gets the same error in the log and puts up a Show Deployment Plan page
> with no Deployment Plan.
>
> Any other suggestions?
>
> Cary
>
>
> Aaron Mulder said the following on 1/6/2006 3:10 PM:
>
> >Could you click the button to show the plan it generated and post that
> >here?  That might help figure out what's going on.
> >
> >Thanks,
> >    Aaron
> >
> >On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
> >
> >
> >>Running XP Pro, JDK1.4.2, MySQL 5.0, MySQL connector 3.1.12
> >>If I use the wizard through the console to include my MySQL jar and then
> >>create a pool, I get a failure.  It gets through the Test Connection
> >>phase fine, but fails when I click the Deploy button with this stack trace:
> >>
> >>10:48:15,700 ERROR [DatabasePoolPortlet] Unable to save connection pool
> >>java.lang.NullPointerException
> >>    at sun.misc.URLClassPath$3.run(URLClassPath.java:312)
> >>    at java.security.AccessController.doPrivileged(Native Method)
> >>    at sun.misc.URLClassPath.getLoader(URLClassPath.java:309)
> >>    at sun.misc.URLClassPath.getLoader(URLClassPath.java:286)
> >>    at sun.misc.URLClassPath.findResource(URLClassPath.java:137)
> >>    at java.net.URLClassLoader$2.run(URLClassLoader.java:352)
> >>    at java.security.AccessController.doPrivileged(Native Method)
> >>    at java.net.URLClassLoader.findResource(URLClassLoader.java:349)
> >>    at java.lang.ClassLoader.getResource(ClassLoader.java:787)
> >>    at
> >>org.apache.geronimo.deployment.tools.loader.AbstractDeployable.<init>(AbstractDeployable.java:57)
> >>    at
> >>org.apache.geronimo.deployment.tools.loader.ConnectorDeployable.<init>(ConnectorDeployable.java:37)
> >>    at
> >>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:813)
> >>    at
> >>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:337)
> >>    at
> >>org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
> >>    at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
> >>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> >>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> >>    at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
> >>    at
> >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> >>    at
> >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> >>    at
> >>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
> >>    at
> >>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
> >>    at
> >>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
> >>    at
> >>org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
> >>    at
> >>org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
> >>    at
> >>org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
> >>    at
> >>org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
> >>    at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
> >>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
> >>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
> >>    at
> >>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
> >>    at
> >>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
> >>    at
> >>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
> >>    at
> >>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
> >>    at
> >>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
> >>    at
> >>org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:272)
> >>    at
> >>org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46)
> >>    at
> >>org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyContextValve.java:50)
> >>    at
> >>org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(TransactionContextValve.java:53)
> >>    at
> >>org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentContextValve.java:47)
> >>    at
> >>org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceContextValve.java:60)
> >>    at
> >>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
> >>    at
> >>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
> >>    at
> >>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
> >>    at
> >>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
> >>    at
> >>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
> >>    at
> >>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
> >>    at
> >>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
> >>    at
> >>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
> >>    at
> >>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
> >>    at
> >>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
> >>    at java.lang.Thread.run(Thread.java:534)
> >>
> >>The generated URL at the top of the page with the Test Connection button is:
> >>jdbc:mysql://localhost:3306/cpdb
> >>
> >>After the failure, the page is forwarded back to the list of pools and
> >>doesn't list the one I just configured.
> >>
> >>Suggestions?  Do I need to open up a JIRA issue?
> >>
> >>Thanks,
> >>Cary
> >>
> >>
> >>
>

Re: Connection Pool setup from console fails

Posted by Cary Clark <ca...@etechsolutions.net>.
Regardless if I click the Test Connection or Skip Test and Show Plan, it 
gets the same error in the log and puts up a Show Deployment Plan page 
with no Deployment Plan.

Any other suggestions?

Cary


Aaron Mulder said the following on 1/6/2006 3:10 PM:

>Could you click the button to show the plan it generated and post that
>here?  That might help figure out what's going on.
>
>Thanks,
>    Aaron
>
>On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
>  
>
>>Running XP Pro, JDK1.4.2, MySQL 5.0, MySQL connector 3.1.12
>>If I use the wizard through the console to include my MySQL jar and then
>>create a pool, I get a failure.  It gets through the Test Connection
>>phase fine, but fails when I click the Deploy button with this stack trace:
>>
>>10:48:15,700 ERROR [DatabasePoolPortlet] Unable to save connection pool
>>java.lang.NullPointerException
>>    at sun.misc.URLClassPath$3.run(URLClassPath.java:312)
>>    at java.security.AccessController.doPrivileged(Native Method)
>>    at sun.misc.URLClassPath.getLoader(URLClassPath.java:309)
>>    at sun.misc.URLClassPath.getLoader(URLClassPath.java:286)
>>    at sun.misc.URLClassPath.findResource(URLClassPath.java:137)
>>    at java.net.URLClassLoader$2.run(URLClassLoader.java:352)
>>    at java.security.AccessController.doPrivileged(Native Method)
>>    at java.net.URLClassLoader.findResource(URLClassLoader.java:349)
>>    at java.lang.ClassLoader.getResource(ClassLoader.java:787)
>>    at
>>org.apache.geronimo.deployment.tools.loader.AbstractDeployable.<init>(AbstractDeployable.java:57)
>>    at
>>org.apache.geronimo.deployment.tools.loader.ConnectorDeployable.<init>(ConnectorDeployable.java:37)
>>    at
>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:813)
>>    at
>>org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:337)
>>    at
>>org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
>>    at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>    at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>>    at
>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>>    at
>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>>    at
>>org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
>>    at
>>org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
>>    at
>>org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
>>    at
>>org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
>>    at
>>org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
>>    at
>>org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
>>    at
>>org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
>>    at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>>    at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>>    at
>>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>>    at
>>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>>    at
>>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>>    at
>>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>>    at
>>org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
>>    at
>>org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:272)
>>    at
>>org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46)
>>    at
>>org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyContextValve.java:50)
>>    at
>>org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(TransactionContextValve.java:53)
>>    at
>>org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentContextValve.java:47)
>>    at
>>org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceContextValve.java:60)
>>    at
>>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>>    at
>>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>>    at
>>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>>    at
>>org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
>>    at
>>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>>    at
>>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
>>    at
>>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>>    at
>>org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>>    at
>>org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>>    at
>>org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>>    at java.lang.Thread.run(Thread.java:534)
>>
>>The generated URL at the top of the page with the Test Connection button is:
>>jdbc:mysql://localhost:3306/cpdb
>>
>>After the failure, the page is forwarded back to the list of pools and
>>doesn't list the one I just configured.
>>
>>Suggestions?  Do I need to open up a JIRA issue?
>>
>>Thanks,
>>Cary
>>
>>    
>>

Re: Connection Pool setup from console fails

Posted by Aaron Mulder <am...@alumni.princeton.edu>.
Could you click the button to show the plan it generated and post that
here?  That might help figure out what's going on.

Thanks,
    Aaron

On 1/6/06, Cary Clark <ca...@etechsolutions.net> wrote:
> Running XP Pro, JDK1.4.2, MySQL 5.0, MySQL connector 3.1.12
> If I use the wizard through the console to include my MySQL jar and then
> create a pool, I get a failure.  It gets through the Test Connection
> phase fine, but fails when I click the Deploy button with this stack trace:
>
> 10:48:15,700 ERROR [DatabasePoolPortlet] Unable to save connection pool
> java.lang.NullPointerException
>     at sun.misc.URLClassPath$3.run(URLClassPath.java:312)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at sun.misc.URLClassPath.getLoader(URLClassPath.java:309)
>     at sun.misc.URLClassPath.getLoader(URLClassPath.java:286)
>     at sun.misc.URLClassPath.findResource(URLClassPath.java:137)
>     at java.net.URLClassLoader$2.run(URLClassLoader.java:352)
>     at java.security.AccessController.doPrivileged(Native Method)
>     at java.net.URLClassLoader.findResource(URLClassLoader.java:349)
>     at java.lang.ClassLoader.getResource(ClassLoader.java:787)
>     at
> org.apache.geronimo.deployment.tools.loader.AbstractDeployable.<init>(AbstractDeployable.java:57)
>     at
> org.apache.geronimo.deployment.tools.loader.ConnectorDeployable.<init>(ConnectorDeployable.java:37)
>     at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.save(DatabasePoolPortlet.java:813)
>     at
> org.apache.geronimo.console.databasemanager.wizard.DatabasePoolPortlet.processAction(DatabasePoolPortlet.java:337)
>     at
> org.apache.pluto.core.PortletServlet.dispatch(PortletServlet.java:229)
>     at org.apache.pluto.core.PortletServlet.doGet(PortletServlet.java:158)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>     at org.apache.pluto.core.PortletServlet.service(PortletServlet.java:153)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>     at
> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
>     at
> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
>     at
> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
>     at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.invoke(PortletInvokerImpl.java:120)
>     at
> org.apache.pluto.invoker.impl.PortletInvokerImpl.action(PortletInvokerImpl.java:68)
>     at
> org.apache.pluto.PortletContainerImpl.processPortletAction(PortletContainerImpl.java:164)
>     at
> org.apache.pluto.portalImpl.core.PortletContainerWrapperImpl.processPortletAction(PortletContainerWrapperImpl.java:82)
>     at org.apache.pluto.portalImpl.Servlet.doGet(Servlet.java:227)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:595)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
>     at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>     at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>     at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>     at
> org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
>     at
> org.apache.geronimo.tomcat.GeronimoStandardContext$SystemMethodValve.invoke(GeronimoStandardContext.java:272)
>     at
> org.apache.geronimo.tomcat.valve.DefaultSubjectValve.invoke(DefaultSubjectValve.java:46)
>     at
> org.apache.geronimo.tomcat.valve.PolicyContextValve.invoke(PolicyContextValve.java:50)
>     at
> org.apache.geronimo.tomcat.valve.TransactionContextValve.invoke(TransactionContextValve.java:53)
>     at
> org.apache.geronimo.tomcat.valve.ComponentContextValve.invoke(ComponentContextValve.java:47)
>     at
> org.apache.geronimo.tomcat.valve.InstanceContextValve.invoke(InstanceContextValve.java:60)
>     at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>     at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>     at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>     at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:526)
>     at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>     at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
>     at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
>     at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
>     at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
>     at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>     at java.lang.Thread.run(Thread.java:534)
>
> The generated URL at the top of the page with the Test Connection button is:
> jdbc:mysql://localhost:3306/cpdb
>
> After the failure, the page is forwarded back to the list of pools and
> doesn't list the one I just configured.
>
> Suggestions?  Do I need to open up a JIRA issue?
>
> Thanks,
> Cary
>