Did you put the mysql-connectorlibrary in the lib folder? Download http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.5/mysql-connector-java-5.1.5.jar and put it in WEB-INF/lib
[EMAIL PROTECTED] wrote: > 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&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. > -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
