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
>