You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@roller.apache.org by æon <ae...@gmail.com> on 2010/09/21 21:06:28 UTC

roller-weblogger-5.0.0-RC2 Cannot connect to database

    *  SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES
    * -- Using JDBC driver class: com.mysql.jdbc.Driver
    * -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb
    * -- Using JDBC username: scott
    * -- Using JDBC password: [hidden]
    * ERROR: cannot load JDBC driver class [com.mysql.jdbc.Driver].
Likely problem: JDBC driver jar missing from server classpath.


In case the clues above are not enough to help you figure out what is
going wrong, here are some more details. The root cause of the problem
is an exception of type [java.lang.ClassNotFoundException]

To help you debug the problem, here is the stack trace for that exception:

    [java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1666)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1511)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Unknown Source)
	at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabaseProvider.java:106)
	at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:169)
	at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:140)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4323)
	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4780)
	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:139)
	at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3493)
	at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:915)
	at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:654)
	at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:196)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:185)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:242)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:163)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:108)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:401)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:242)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:267)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:245)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:260)
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)]


Windows XP, Tomcat 7.0, MySQL 5.1

"mysql-connector-java-3.1.14-bin.jar", "mail.jar", "activation.jar"
and "roller-custom.properties" into .../Tomcat 7.0/lib/

"roller-custom.properties" file content:
installation.type=auto
database.configurationType=jdbc
database.jdbc.driverClass=com.mysql.jdbc.Driver
database.jdbc.connectionURL=jdbc:mysql://localhost:3306/rollerdb
database.jdbc.username=scott
database.jdbc.password=tiger
mail.configurationType=properties
mail.hostname=smtp-server.example.com
mail.username=scott
mail.password=tiger


What's wrong???
Help please.

:D

Thanks in advance.

Enrique Fuenzalida M.
http://www.individual.cl/

Re: roller-weblogger-5.0.0-RC2 Cannot connect to database

Posted by æon <ae...@gmail.com>.
SOLVED!

I restart Tomcat and it works. It ask me to create tables

:D

And all seems to work good


Enrique Fuenzalida M.
http://www.individual.cl/

On Tue, Sep 21, 2010 at 3:06 PM, æon <ae...@gmail.com> wrote:
>    *  SUCCESS: Got parameters. Using configuration type JDBC_PROPERTIES
>    * -- Using JDBC driver class: com.mysql.jdbc.Driver
>    * -- Using JDBC connection URL: jdbc:mysql://localhost:3306/rollerdb
>    * -- Using JDBC username: scott
>    * -- Using JDBC password: [hidden]
>    * ERROR: cannot load JDBC driver class [com.mysql.jdbc.Driver].
> Likely problem: JDBC driver jar missing from server classpath.
>
>
> In case the clues above are not enough to help you figure out what is
> going wrong, here are some more details. The root cause of the problem
> is an exception of type [java.lang.ClassNotFoundException]
>
> To help you debug the problem, here is the stack trace for that exception:
>
>    [java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
>        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1666)
>        at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1511)
>        at java.lang.Class.forName0(Native Method)
>        at java.lang.Class.forName(Unknown Source)
>        at org.apache.roller.weblogger.business.DatabaseProvider.<init>(DatabaseProvider.java:106)
>        at org.apache.roller.weblogger.business.startup.WebloggerStartup.prepare(WebloggerStartup.java:169)
>        at org.apache.roller.weblogger.ui.core.RollerContext.contextInitialized(RollerContext.java:140)
>        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4323)
>        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:4780)
>        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:139)
>        at org.apache.catalina.core.StandardContext.reload(StandardContext.java:3493)
>        at org.apache.catalina.manager.ManagerServlet.reload(ManagerServlet.java:915)
>        at org.apache.catalina.manager.HTMLManagerServlet.reload(HTMLManagerServlet.java:654)
>        at org.apache.catalina.manager.HTMLManagerServlet.doPost(HTMLManagerServlet.java:196)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
>        at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
>        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
>        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>        at org.apache.catalina.filters.CsrfPreventionFilter.doFilter(CsrfPreventionFilter.java:185)
>        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:242)
>        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
>        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
>        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201)
>        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:563)
>        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:163)
>        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:108)
>        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
>        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:401)
>        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:242)
>        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:267)
>        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:245)
>        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:260)
>        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source)
>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
>        at java.lang.Thread.run(Unknown Source)]
>
>
> Windows XP, Tomcat 7.0, MySQL 5.1
>
> "mysql-connector-java-3.1.14-bin.jar", "mail.jar", "activation.jar"
> and "roller-custom.properties" into .../Tomcat 7.0/lib/
>
> "roller-custom.properties" file content:
> installation.type=auto
> database.configurationType=jdbc
> database.jdbc.driverClass=com.mysql.jdbc.Driver
> database.jdbc.connectionURL=jdbc:mysql://localhost:3306/rollerdb
> database.jdbc.username=scott
> database.jdbc.password=tiger
> mail.configurationType=properties
> mail.hostname=smtp-server.example.com
> mail.username=scott
> mail.password=tiger
>
>
> What's wrong???
> Help please.
>
> :D
>
> Thanks in advance.
>
> Enrique Fuenzalida M.
> http://www.individual.cl/
>