[xwiki-users] configuration problem
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.
Did you put the mysql-connectorlibrary in the lib folder? Download http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.5/mysql-connect... 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/
Did you put the mysql-connectorlibrary in the lib folder?
Download http://repo1.maven.org/maven2/mysql/mysql-connector-java/5.1.5/mysql-connect... 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.
participants (2)
-
project_trainees＠amritatech.com -
Sergiu Dumitriu