I think the error is due to mysql-java connector jar file.
Please make sure that a recent version of this connector is in WEB-INF/lib
directory of XWiki, and restart tomcat . You don't talk about this .jar file
in previous mails but it's a crucial element.

Guillaume

2011/8/2 Dale Amon <a...@vnl.com>

> On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
> >
> > On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
> >
> > > On Tue, Aug 02, 2011 at 10:22:10PM +0200, Guillaume Fenollar wrote:
> > >> If you are talking about the default database, then it's HSQLDB. You
> can
> > >> compare the two methods (hsqldb vs mysql) to make your own opinion,
> but I
> > >> advise you to use mysql for production environment.
> > >> If you choose to use mysql, don't forget to download the mysql-java
> > >> connector and to move it into WEB-INF/lib directory in xwiki.
> > >
> > > type Exception report
> >
> > [snip]
> >
> > > Wrapped Exception: Could not create a DBCP pool. There is an error in
> the hibernate configuration file, please review it.
> >
> > This means your hibernate.cfg.xml file is not correctly configured.
>
> I've got the default file with minor changes:
>
>        * I commented out the default db set up
>        * I enabled the mysql section
>        * I played with various user names and at the
>          moment am using mysql root.
>
>    <!-- Configuration for the default database.
>         Comment out this section and uncomment other sections below if you
> want to use another database.
>         Note that the database tables will be created automatically if they
> don't already exist.
>    <property
> name="connection.url">jdbc:hsqldb:file:database/xwiki_db;shutdown=true</property>
>    <property name="connection.username">sa</property>
>    <property name="connection.password"></property>
>    <property
> name="connection.driver_class">org.hsqldb.jdbcDriver</property>
>    <property name="dialect">org.hibernate.dialect.HSQLDialect</property>
>    <property
> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
>    <property name="connection.pool_size">2</property>
>    <property name="statement_cache.size">2</property>
>    <mapping resource="xwiki.hbm.xml"/>
>    <mapping resource="feeds.hbm.xml"/>
>    <mapping resource="activitystream.hbm.xml"/>
>    -->
>
>    <!-- MySQL configuration.
>         Uncomment if you want to use MySQL and comment out other database
> configurations.
>         We need to set the sql_mode to a less strict value, see XWIKI-1945
>    -->
>    <property
> name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode='$
>    <property name="connection.username">root</property>
>    <property name="connection.password">XXXXXXX</property>
>    <property
> name="connection.driver_class">com.mysql.jdbc.Driver</property>
>    <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
>    <property
> name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
>    <property name="connection.pool_size">2</property>
>    <property name="statement_cache.size">2</property>
>    <mapping resource="xwiki.hbm.xml"/>
>    <mapping resource="feeds.hbm.xml"/>
>    <mapping resource="activitystream.hbm.xml"/>
>
> Is this tomcat log line telling me there is a bad path somewhere in
> the default set up?
>
>        Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
>
> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>



-- 
Guillaume Fenollar
XWiki SysAdmin
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Reply via email to