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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Sergiu Dumitriu http://purl.org/net/sergiu/