On 08/02/2011 05:49 PM, Dale Amon wrote: > 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='$
Can you try to use this line instead? <property name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8</property> (the same as yours, but without the sessionVariables parameter, which isn't compatible with the latest version of the connector jar (a bug in the connector). > <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 -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
