2 Aug
2011
2 Aug
'11
11:49 p.m.
On Tue, Aug 02, 2011 at 10:38:37PM +0200, Vincent Massol wrote:
On Aug 2, 2011, at 10:36 PM, Dale Amon wrote:
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
On Tue, Aug 02, 2011 at 10:22:10PM +0200,
Guillaume Fenollar wrote:
[snip]
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 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.