You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@geronimo.apache.org by Boris von Alten Blaskowitz <bo...@gmx.de> on 2006/05/10 23:34:20 UTC

MySQL - Cannot setup a new Database Pool

Hi,

maybe some one can help me I could not figureout the problem. I am using:
Geronimo v1.0
MySQL v5.0
MySQL Connector v3.0.17 or v3.1.12
Java 1.4.2 or 1.5.0

After I configured all Data for the new Pool I made a test and 
everything doing well. Then I tried to deploy it and god the following 
log message:

22:53:35,281 ERROR [DatabasePoolPortlet] Unable to save connection pool
java.lang.NullPointerException
at sun.misc.URLClassPath$3.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.getLoader(Unknown Source)
at sun.misc.URLClassPath.findResource(Unknown Source)
at java.net.URLClassLoader$2.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findResource(Unknown Source)
at java.lang.ClassLoader.getResource(Unknown Source)
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(Unknown Source)

Does someone know why it dosen´t work? I also tried the deployer Tool 
and it dosen´t work as well.

Thanks ahead for your help.

Boris

Re: MySQL - Cannot setup a new Database Pool

Posted by Paul McMahan <pa...@gmail.com>.
Thanks for following up with how you worked around the problem.  FYI
it sounds like you were seeing an issue that is fixed in Geronimo 1.1:
http://issues.apache.org/jira/browse/GERONIMO-1426

Best wishes,
Paul

On 5/11/06, Boris von Alten Blaskowitz <bo...@gmx.de> wrote:
> Hi,
>
> I solved the problem. I don´t know why but after I copied the geronimo-1.0
> folder to c:\ everything is doing well.
>
> Cheers
> Boris
>
> > --- Ursprüngliche Nachricht ---
> > Von: "Boris von Alten Blaskowitz" <bo...@gmx.de>
> > An: user@geronimo.apache.org
> > Betreff: Re: MySQL - Cannot setup a new Database Pool
> > Datum: Thu, 11 May 2006 09:39:51 +0200 (MEST)
> >
> > Hi Aaron,
> >
> > this is also strange I tried to see the deploy plan in the wizard but the
> > field was empty. So I made my own plan and used the commandline:
> >
> > <?xml version="1.0">
> >
> > <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector"
> >   version="1.5"
> >   configId="MysqlDatabase"
> >   parentId="org/apache/geronimo/Server">
> >
> > <dependency>
> >   <uri>
> >     mysql/jars/mysql-connector-java-3.1.12-bin.jar
> >   </uri>
> > </dependency>
> >
> > <resourceadapter>
> >   <outbound-resourceadapter>
> >     <connection-definition>
> >       <connectionfactory-interface>
> >         javax.sql.DataSource
> >       </connectionfactory-interface>
> >       <connectiondefinition-instance>
> >         <name>MysqlDataSource</name>
> >         <config-property-setting name="UserName">
> >           root
> >         </config-property-setting>
> >         <config-property-setting name="Password">
> >           manager
> >         </config-property-setting>
> >         <config-property-setting name="Driver">
> >           com.mysql.jdbc.Driver
> >         </config-property-setting>
> >         <config-property-setting name="ConnectionURL">
> >           jdbc:mysql://localhost/mytest
> >         </config-property-setting>
> >         <config-property-setting name="CommitBeforeAutocommit">
> >            false
> >         </config-property-setting>
> >         <config-property-setting name="ExceptionSorterClass">
> >            org.tranql.connector.NoExceptionsAreFatalSorter
> >         </config-property-setting>
> >
> >         <connectionmanager>
> >           <local-transaction/>
> >           <single-pool>
> >              <max-size>10</max-size>
> >              <min-size>0</min-size>
> >              <blocking-timeout-milliseconds>
> >                 5000
> >               </blocking-timeout-milliseconds>
> >               <idle-timeout-minutes>
> >                 30
> >               </idle-timeout-minutes>
> >               <match-one/>
> >           </single-pool>
> >         </connectionmanager>
> >
> >         <global-jndi-name>
> >           jdbc/MysqlDatabase
> >         </global-jndi-name>
> >
> >       </connectiondefinition-instance>
> >     </connection-definition>
> >   </outbound-resourceadapter>
> > </resourceadapter>
> > </connector>
> >
> > The install folder of geronimo is ...\Eigene Dateien\geronimo-1.0\. I also
> > using vmware. Do you think this could cause trouble?
> >
> > Cheers
> > Boris
> >
> > > --- Ursprüngliche Nachricht ---
> > > Von: "Aaron Mulder" <am...@alumni.princeton.edu>
> > > An: user@geronimo.apache.org
> > > Betreff: Re: MySQL - Cannot setup a new Database Pool
> > > Datum: Wed, 10 May 2006 18:39:36 -0400
> > >
> > > Can you post the plan that the console generates for the database pool?
> > >
> > > Thanks,
> > >      Aaron
> > >
> > > On 5/10/06, Boris von Alten Blaskowitz <bo...@gmx.de> wrote:
> > > > Hi,
> > > >
> > > > maybe some one can help me I could not figureout the problem. I am
> > > using:
> > > > Geronimo v1.0
> > > > MySQL v5.0
> > > > MySQL Connector v3.0.17 or v3.1.12
> > > > Java 1.4.2 or 1.5.0
> > > >
> > > > After I configured all Data for the new Pool I made a test and
> > > > everything doing well. Then I tried to deploy it and god the following
> > > > log message:
> > > >
> > > > 22:53:35,281 ERROR [DatabasePoolPortlet] Unable to save connection
> > pool
> > > > java.lang.NullPointerException
> > > > at sun.misc.URLClassPath$3.run(Unknown Source)
> > > > at java.security.AccessController.doPrivileged(Native Method)
> > > > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > > > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > > > at sun.misc.URLClassPath.findResource(Unknown Source)
> > > > at java.net.URLClassLoader$2.run(Unknown Source)
> > > > at java.security.AccessController.doPrivileged(Native Method)
> > > > at java.net.URLClassLoader.findResource(Unknown Source)
> > > > at java.lang.ClassLoader.getResource(Unknown Source)
> > > > 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(Unknown Source)
> > > >
> > > > Does someone know why it dosen´t work? I also tried the deployer Tool
> > > > and it dosen´t work as well.
> > > >
> > > > Thanks ahead for your help.
> > > >
> > > > Boris
> > > >
> > >
> >
> > --
> > Boris von Alten Blaskowitz
> >
> > E-Mail: borisvab@gmx.de
> >
> > GMX Produkte empfehlen und ganz einfach Geld verdienen!
> > Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
> >
>
> --
> Boris von Alten Blaskowitz
>
> E-Mail: borisvab@gmx.de
>
> Analog-/ISDN-Nutzer sparen mit GMX SmartSurfer bis zu 70%!
> Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer
>

Re: MySQL - Cannot setup a new Database Pool

Posted by Boris von Alten Blaskowitz <bo...@gmx.de>.
Hi,

I solved the problem. I don´t know why but after I copied the geronimo-1.0
folder to c:\ everything is doing well.

Cheers
Boris

> --- Ursprüngliche Nachricht ---
> Von: "Boris von Alten Blaskowitz" <bo...@gmx.de>
> An: user@geronimo.apache.org
> Betreff: Re: MySQL - Cannot setup a new Database Pool
> Datum: Thu, 11 May 2006 09:39:51 +0200 (MEST)
> 
> Hi Aaron,
> 
> this is also strange I tried to see the deploy plan in the wizard but the
> field was empty. So I made my own plan and used the commandline:
> 
> <?xml version="1.0">
> 
> <connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector" 
>   version="1.5" 
>   configId="MysqlDatabase"  
>   parentId="org/apache/geronimo/Server">
> 
> <dependency>
>   <uri>
>     mysql/jars/mysql-connector-java-3.1.12-bin.jar
>   </uri>
> </dependency>
> 
> <resourceadapter>
>   <outbound-resourceadapter>
>     <connection-definition>
>       <connectionfactory-interface> 
>         javax.sql.DataSource 
>       </connectionfactory-interface>
>       <connectiondefinition-instance>
>         <name>MysqlDataSource</name>
>         <config-property-setting name="UserName"> 
>           root 
>         </config-property-setting>
>         <config-property-setting name="Password"> 
>           manager 
>         </config-property-setting>
>         <config-property-setting name="Driver"> 
>           com.mysql.jdbc.Driver 
>         </config-property-setting>
>         <config-property-setting name="ConnectionURL">
>           jdbc:mysql://localhost/mytest 
>         </config-property-setting>
>         <config-property-setting name="CommitBeforeAutocommit"> 
>            false 
>         </config-property-setting>
>         <config-property-setting name="ExceptionSorterClass"> 
>            org.tranql.connector.NoExceptionsAreFatalSorter
>         </config-property-setting>
> 
>         <connectionmanager>
>           <local-transaction/>
>           <single-pool>
>              <max-size>10</max-size>
>              <min-size>0</min-size>
>              <blocking-timeout-milliseconds> 
>                 5000 
>               </blocking-timeout-milliseconds>
>               <idle-timeout-minutes>
>                 30
>               </idle-timeout-minutes>
>               <match-one/>
>           </single-pool>
>         </connectionmanager>
> 
>         <global-jndi-name> 
>           jdbc/MysqlDatabase 
>         </global-jndi-name>
> 
>       </connectiondefinition-instance>
>     </connection-definition>
>   </outbound-resourceadapter>
> </resourceadapter>
> </connector>
> 
> The install folder of geronimo is ...\Eigene Dateien\geronimo-1.0\. I also
> using vmware. Do you think this could cause trouble?
> 
> Cheers
> Boris
> 
> > --- Ursprüngliche Nachricht ---
> > Von: "Aaron Mulder" <am...@alumni.princeton.edu>
> > An: user@geronimo.apache.org
> > Betreff: Re: MySQL - Cannot setup a new Database Pool
> > Datum: Wed, 10 May 2006 18:39:36 -0400
> > 
> > Can you post the plan that the console generates for the database pool?
> > 
> > Thanks,
> >      Aaron
> > 
> > On 5/10/06, Boris von Alten Blaskowitz <bo...@gmx.de> wrote:
> > > Hi,
> > >
> > > maybe some one can help me I could not figureout the problem. I am
> > using:
> > > Geronimo v1.0
> > > MySQL v5.0
> > > MySQL Connector v3.0.17 or v3.1.12
> > > Java 1.4.2 or 1.5.0
> > >
> > > After I configured all Data for the new Pool I made a test and
> > > everything doing well. Then I tried to deploy it and god the following
> > > log message:
> > >
> > > 22:53:35,281 ERROR [DatabasePoolPortlet] Unable to save connection
> pool
> > > java.lang.NullPointerException
> > > at sun.misc.URLClassPath$3.run(Unknown Source)
> > > at java.security.AccessController.doPrivileged(Native Method)
> > > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > > at sun.misc.URLClassPath.findResource(Unknown Source)
> > > at java.net.URLClassLoader$2.run(Unknown Source)
> > > at java.security.AccessController.doPrivileged(Native Method)
> > > at java.net.URLClassLoader.findResource(Unknown Source)
> > > at java.lang.ClassLoader.getResource(Unknown Source)
> > > 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(Unknown Source)
> > >
> > > Does someone know why it dosen´t work? I also tried the deployer Tool
> > > and it dosen´t work as well.
> > >
> > > Thanks ahead for your help.
> > >
> > > Boris
> > >
> > 
> 
> -- 
> Boris von Alten Blaskowitz
> 
> E-Mail: borisvab@gmx.de
> 
> GMX Produkte empfehlen und ganz einfach Geld verdienen!
> Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
> 

-- 
Boris von Alten Blaskowitz

E-Mail: borisvab@gmx.de

Analog-/ISDN-Nutzer sparen mit GMX SmartSurfer bis zu 70%!
Kostenlos downloaden: http://www.gmx.net/de/go/smartsurfer

Re: MySQL - Cannot setup a new Database Pool

Posted by Boris von Alten Blaskowitz <bo...@gmx.de>.
Hi Aaron,

this is also strange I tried to see the deploy plan in the wizard but the
field was empty. So I made my own plan and used the commandline:

<?xml version="1.0">

<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector" 
  version="1.5" 
  configId="MysqlDatabase"  
  parentId="org/apache/geronimo/Server">

<dependency>
  <uri>
    mysql/jars/mysql-connector-java-3.1.12-bin.jar
  </uri>
</dependency>

<resourceadapter>
  <outbound-resourceadapter>
    <connection-definition>
      <connectionfactory-interface> 
        javax.sql.DataSource 
      </connectionfactory-interface>
      <connectiondefinition-instance>
        <name>MysqlDataSource</name>
        <config-property-setting name="UserName"> 
          root 
        </config-property-setting>
        <config-property-setting name="Password"> 
          manager 
        </config-property-setting>
        <config-property-setting name="Driver"> 
          com.mysql.jdbc.Driver 
        </config-property-setting>
        <config-property-setting name="ConnectionURL">
          jdbc:mysql://localhost/mytest 
        </config-property-setting>
        <config-property-setting name="CommitBeforeAutocommit"> 
           false 
        </config-property-setting>
        <config-property-setting name="ExceptionSorterClass"> 
           org.tranql.connector.NoExceptionsAreFatalSorter
        </config-property-setting>

        <connectionmanager>
          <local-transaction/>
          <single-pool>
             <max-size>10</max-size>
             <min-size>0</min-size>
             <blocking-timeout-milliseconds> 
                5000 
              </blocking-timeout-milliseconds>
              <idle-timeout-minutes>
                30
              </idle-timeout-minutes>
              <match-one/>
          </single-pool>
        </connectionmanager>

        <global-jndi-name> 
          jdbc/MysqlDatabase 
        </global-jndi-name>

      </connectiondefinition-instance>
    </connection-definition>
  </outbound-resourceadapter>
</resourceadapter>
</connector>

The install folder of geronimo is ...\Eigene Dateien\geronimo-1.0\. I also
using vmware. Do you think this could cause trouble?

Cheers
Boris

> --- Ursprüngliche Nachricht ---
> Von: "Aaron Mulder" <am...@alumni.princeton.edu>
> An: user@geronimo.apache.org
> Betreff: Re: MySQL - Cannot setup a new Database Pool
> Datum: Wed, 10 May 2006 18:39:36 -0400
> 
> Can you post the plan that the console generates for the database pool?
> 
> Thanks,
>      Aaron
> 
> On 5/10/06, Boris von Alten Blaskowitz <bo...@gmx.de> wrote:
> > Hi,
> >
> > maybe some one can help me I could not figureout the problem. I am
> using:
> > Geronimo v1.0
> > MySQL v5.0
> > MySQL Connector v3.0.17 or v3.1.12
> > Java 1.4.2 or 1.5.0
> >
> > After I configured all Data for the new Pool I made a test and
> > everything doing well. Then I tried to deploy it and god the following
> > log message:
> >
> > 22:53:35,281 ERROR [DatabasePoolPortlet] Unable to save connection pool
> > java.lang.NullPointerException
> > at sun.misc.URLClassPath$3.run(Unknown Source)
> > at java.security.AccessController.doPrivileged(Native Method)
> > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > at sun.misc.URLClassPath.getLoader(Unknown Source)
> > at sun.misc.URLClassPath.findResource(Unknown Source)
> > at java.net.URLClassLoader$2.run(Unknown Source)
> > at java.security.AccessController.doPrivileged(Native Method)
> > at java.net.URLClassLoader.findResource(Unknown Source)
> > at java.lang.ClassLoader.getResource(Unknown Source)
> > 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(Unknown Source)
> >
> > Does someone know why it dosen´t work? I also tried the deployer Tool
> > and it dosen´t work as well.
> >
> > Thanks ahead for your help.
> >
> > Boris
> >
> 

-- 
Boris von Alten Blaskowitz

E-Mail: borisvab@gmx.de

GMX Produkte empfehlen und ganz einfach Geld verdienen!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner

Re: MySQL - Cannot setup a new Database Pool

Posted by Aaron Mulder <am...@alumni.princeton.edu>.
Can you post the plan that the console generates for the database pool?

Thanks,
     Aaron

On 5/10/06, Boris von Alten Blaskowitz <bo...@gmx.de> wrote:
> Hi,
>
> maybe some one can help me I could not figureout the problem. I am using:
> Geronimo v1.0
> MySQL v5.0
> MySQL Connector v3.0.17 or v3.1.12
> Java 1.4.2 or 1.5.0
>
> After I configured all Data for the new Pool I made a test and
> everything doing well. Then I tried to deploy it and god the following
> log message:
>
> 22:53:35,281 ERROR [DatabasePoolPortlet] Unable to save connection pool
> java.lang.NullPointerException
> at sun.misc.URLClassPath$3.run(Unknown Source)
> at java.security.AccessController.doPrivileged(Native Method)
> at sun.misc.URLClassPath.getLoader(Unknown Source)
> at sun.misc.URLClassPath.getLoader(Unknown Source)
> at sun.misc.URLClassPath.findResource(Unknown Source)
> at java.net.URLClassLoader$2.run(Unknown Source)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findResource(Unknown Source)
> at java.lang.ClassLoader.getResource(Unknown Source)
> 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(Unknown Source)
>
> Does someone know why it dosen´t work? I also tried the deployer Tool
> and it dosen´t work as well.
>
> Thanks ahead for your help.
>
> Boris
>