[xwiki-users] configuration problem - xwiki-users@xwiki.org

11 May 2008

Hi,

   I am using XE 1.3.2(stand alone) and i have to use Mysql 5.0. For that
I configured the hibernate.cfg and web.cfg but it shows error. Where is my
fault? can any one help? Why No one responding? i am trying to do this as
my curriculam project.

Hibernate configuration
........................
[config]

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate
Configuration DTD//EN"

"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<!-- Template for hibernate configuration. processing by maven using
profiles.
     Replace original src/main/webapp/WEB-INF/hibernate.cfg.xml -->
<hibernate-configuration>
  <session-factory>

    <property name="show_sql">false</property>
    <property name="use_outer_join">true</property>

    <property name="dbcp.defaultAutoCommit">false</property>
    <property name="dbcp.maxActive">50</property>
    <property name="dbcp.maxIdle">5</property>
    <property name="dbcp.maxWait">30000</property>
    <property name="dbcp.whenExhaustedAction">1</property>
    <property name="dbcp.ps.whenExhaustedAction">1</property>
    <property name="dbcp.ps.maxActive">20</property>
    <property name="dbcp.ps.maxWait">120000</property>
    <property name="dbcp.ps.maxIdle">20</property>

    <!-- MySQL configuration.
         Uncomment if you want to use MySQL and comment out other database
configurations.
         Note that the database will be created automatically if it
doesn't already exist.
         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;sessionVariables=sql_mode=''</property>
    <property name="connection.username">root</property>
    <property name="connection.password">amma</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"/>

</session-factory>
</hibernate-configuration>

[/config]

Web configuration
...................

<!-- Uncomment if you wish to use a DataSource to define the Database
connection  -->
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/XWikiDS</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>

HTTP ERROR: 500

Error number 3 in 0: Could not initialize main XWiki context
Wrapped Exception: Error number 3201 in 3: Exception while saving document
XWiki.XWikiPreferences
Wrapped Exception: Could not execute JDBC batch update

RequestURI=/xwiki/bin/view/main/webhome

Regards,
Project trainees.