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&useUnicode=true&characterEncoding=UTF-8&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
