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&amp;useUnicode=true&amp;characterEncoding=UTF-8&amp;sessionVariables=sql_mode='$

Can you try to use this line instead?

<property 
name="connection.url">jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&amp;useUnicode=true&amp;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

Reply via email to