> 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/
Hi, I aready put mysql-connector-java-5.1.6.jar in lib directory. And after altering the tables xwikircs and xwikidoc the page is displayed with no error, but there is no create page button, no search, no right panel and nothing. What will be the reason? Regards, project trainees. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
