Looks like you have specifications for 2 databases uncommented. try putting "-->" before "<!-- MySQL configuration." and remove the "-->" from the end of "<!-- Configuration for the default database......."
Caleb Vivian Richard wrote: > Hello Devs, > > I am getting this strange xml formet error in the hibernate.cfg.xml file. > I am attaching my xml and as you can see all I did was uncommented > the mysql part of the file. I tried validate the xml format at this site: > > http://validator.w3.org/#validate_by_input > > and got these error messages- > > Line 51, Column 36: document type does not allow element "property" here > Line 52, Column 36: document type does not allow element "property" here > Line 53, Column 36: document type does not allow element "property" here > Line 54, Column 36: document type does not allow element "property" here > Line 55, Column 36: document type does not allow element "property" here > Line 56, Column 36: document type does not allow element "property" here > Line 57, Column 36: document type does not allow element "property" here > Line 58, Column 36: document type does not allow element "property" here > > Can some one please point out what is wrong with it? By the way this xml > file came with xwiki-enterprise-manager-web-2.1.1.war file > > > Regards > > > > > > > ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// > > <?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";> > <hibernate-configuration> > <session-factory> > > <!-- Please refer to the installation guide on > http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation > for configuring your > database. You'll need to do 2 things: > 1) Copy your database driver JAR in WEB-INF/lib or in some > shared lib directory > 2) Uncomment the properties below for your specific DB (and > comment the default > database configuration if it doesn't match your DB) > --> > > <!-- Generic parameters common to all Databases --> > > <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> > <!-- Without it, some queries fail in MS SQL. XWiki doesn't need > scrollable result sets, anyway. --> > <property name="jdbc.use_scrollable_resultset">false</property> > > <!-- 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&useUnicode=true&characterEncoding=UTF-8&sessionVariables=sql_mode=''</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</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"/> > > > <!-- HSQLDB configuration. > Uncomment if you want to use HSQLDB and comment out other > database configurations. > <property > name="connection.url">jdbc:hsqldb:file:/some/path/xwikidb;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"/> > --> > > <!-- PostgreSQL configuration. > Uncomment if you want to use PostgreSQL and comment out other > database configurations. > <property name="connection.url">jdbc:postgresql:xwiki</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property name="connection.driver_class">org.postgresql.Driver</property> > <property > name="dialect">org.hibernate.dialect.PostgreSQLDialect</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"/> > --> > > <!-- Oracle configuration. > Uncomment if you want to use Oracle and comment out other > database configurations. > Note: the 2 properties named > "hibernate.connection.SetBigStringTryClob" and > "hibernate.jdbc.batch_size". They are required to tell Oracle > to allow CLOBs larger than > 32K. > <property > name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property> > <property name="connection.username">xwiki</property> > <property name="connection.password">xwiki</property> > <property > name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property> > <property name="dialect">org.hibernate.dialect.Oracle10gDialect</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> > <property name="hibernate.connection.SetBigStringTryClob">true</property> > <property name="hibernate.jdbc.batch_size">0</property> > <mapping resource="xwiki.oracle.hbm.xml"/> > <mapping resource="feeds.oracle.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > <!-- Derby configuration. > Uncomment if you want to use Derby and comment out other > database configurations. > <property > name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property> > <property > name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property> > <property name="dialect">org.hibernate.dialect.DerbyDialect</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.derby.hbm.xml"/> > <mapping resource="feeds.hbm.xml"/> > <mapping resource="activitystream.hbm.xml"/> > --> > > </session-factory> > </hibernate-configuration> > > /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
