Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="UTF-8"?>
- <!--
- * See the NOTICE file distributed with this work for additional
- * information regarding copyright ownership.
- *
- * This is free software; you can redistribute it and/or modify it
- * under the terms of the GNU Lesser General Public License as
- * published by the Free Software Foundation; either version 2.1 of
- * the License, or (at your option) any later version.
- *
- * This software is distributed in the hope that it will be useful,
- * but WITHOUT ANY WARRANTY; without even the implied warranty of
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
- * Lesser General Public License for more details.
- *
- * You should have received a copy of the GNU Lesser General Public
- * License along with this software; if not, write to the Free
- * Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
- * 02110-1301 USA, or see the FSF site: http://www.fsf.org.
- -->
- <!DOCTYPE hibernate-configuration PUBLIC
- "-//Hibernate/Hibernate Configuration DTD//EN"
- "http://www.hibernate.org/dtd/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>
- <!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -->
- <property name="jdbc.use_scrollable_resultset">false</property>
- <!-- DBCP Connection Pooling configuration. Only some properties are shown. All available properties can be found
- at http://commons.apache.org/proper/commons-dbcp/configuration.html
- -->
- <property name="dbcp.defaultAutoCommit">false</property>
- <property name="dbcp.maxTotal">50</property>
- <property name="dbcp.maxIdle">5</property>
- <property name="dbcp.maxWaitMillis">30000</property>
- <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
- <!-- Setting "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" will tell DBCP to cache
- Prepared Statements (it's off by default). Note that for backward compatibility the "dbcp.ps.maxActive" is also
- supported and when set it'll set "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" to
- value of "dbcp.ps.maxActive".
- Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB
- Prepared Statements (PS) contain the schema on which they were initially created and thus when switching
- schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache
- prepared statement there's no performance loss by not caching Prepared Statements at the DBCP level.
- See https://jira.xwiki.org/browse/XWIKI-1740.
- Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :)
- Note 2: The same applies to PostGreSQL.
- -->
- <!-- BoneCP Connection Pooling configuration.
- <property name="bonecp.idleMaxAgeInMinutes">240</property>
- <property name="bonecp.idleConnectionTestPeriodInMinutes">60</property>
- <property name="bonecp.partitionCount">3</property>
- <property name="bonecp.acquireIncrement">10</property>
- <property name="bonecp.maxConnectionsPerPartition">60</property>
- <property name="bonecp.minConnectionsPerPartition">20</property>
- <property name="bonecp.statementsCacheSize">50</property>
- <property name="bonecp.releaseHelperThreads">3</property>
- <property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</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.
- If you want the main wiki database to be different than "xwiki" (or the default schema for schema based engines)
- you will also have to set the property xwiki.db in xwiki.cfg file
- -->
- <!-- property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property-->
- <property name="connection.url">jdbc:mysql://localhost/xwiki</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.MySQL5InnoDBDialect</property>
- <property name="connection.useUnicode">true</property>
- <property name="connection.characterEncoding">UTF-8</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="hibernate.connection.charSet">UTF-8</property>
- <property name="hibernate.connection.useUnicode">true</property>
- <property name="hibernate.connection.characterEncoding">utf8</property>
- -->
- <mapping resource="xwiki.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- <!-- MySQL configuration.
- Uncomment if you want to use MySQL and comment out other database configurations.
- Notes:
- - if you want the main wiki database to be different than "xwiki"
- you will also have to set the property xwiki.db in xwiki.cfg file
- <property name="connection.url">jdbc:mysql://localhost/xwiki?useSSL=false</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.MySQL5InnoDBDialect</property>
- <property name="dbcp.poolPreparedStatements">true</property>
- <property name="dbcp.maxOpenPreparedStatements">20</property>
- <mapping resource="xwiki.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- -->
- <!-- HSQLDB configuration.
- Uncomment if you want to use HSQLDB and comment out other database configurations.
- Notes:
- - if you want the main wiki schema to be different than "PUBLIC" (the default HSQLDB schema)
- you will also have to set the property xwiki.db in xwiki.cfg file
- <property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/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>
- <mapping resource="xwiki.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- -->
- <!-- PostgreSQL configuration.
- Uncomment if you want to use PostgreSQL and comment out other database configurations.
- Notes:
- - "jdbc.use_streams_for_binary" needs to be set to "false",
- see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
- - "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode
- doesn't support database creation (see https://jira.xwiki.org/browse/XWIKI-8753)
- - if you want the main wiki database to be different than "xwiki" (or "public" in schema mode)
- you will also have to set the property xwiki.db in xwiki.cfg file
- <property name="connection.url">jdbc:postgresql://localhost:5432/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="jdbc.use_streams_for_binary">false</property>
- <property name="xwiki.virtual_mode">schema</property>
- <mapping resource="xwiki.postgresql.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- -->
- <!-- Oracle configuration.
- Uncomment if you want to use Oracle and comment out other database configurations.
- Notes:
- - the 2 properties named "connection.SetBigStringTryClob" and
- "jdbc.batch_size" are required to tell Oracle to allow CLOBs larger than 32K.
- - "jdbc.use_streams_for_binary" needs to be set to "false",
- see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
- - if you want the main wiki schema to be different than "xwiki"
- you will also have to set the property xwiki.db in xwiki.cfg file
- <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.SetBigStringTryClob">true</property>
- <property name="jdbc.batch_size">0</property>
- <property name="jdbc.use_streams_for_binary">false</property>
- <property name="dbcp.poolPreparedStatements">true</property>
- <property name="dbcp.maxOpenPreparedStatements">20</property>
- <mapping resource="xwiki.oracle.hbm.xml"/>
- <mapping resource="feeds.oracle.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.oracle.hbm.xml"/>
- -->
- <!-- Derby configuration.
- Uncomment if you want to use Derby and comment out other database configurations.
- Notes:
- - if you want the main wiki schema to be different than "APP" (the default Derby schema)
- you will also have to set the property xwiki.db in xwiki.cfg file
- <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="dbcp.poolPreparedStatements">true</property>
- <property name="dbcp.maxOpenPreparedStatements">20</property>
- <mapping resource="xwiki.derby.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- -->
- <!-- H2 configuration.
- Uncomment if you want to use H2 and comment out other database configurations.
- Notes:
- - if you want the main wiki schema to be different than "PUBLIC" (the default H2 schema)
- you will also have to set the property xwiki.db in xwiki.cfg file
- <property name="connection.url">jdbc:h2:${environment.permanentDirectory}/database/xwiki</property>
- <property name="connection.username">sa</property>
- <property name="connection.password"></property>
- <property name="connection.driver_class">org.h2.Driver</property>
- <property name="dialect">org.hibernate.dialect.H2Dialect</property>
- <mapping resource="xwiki.hbm.xml"/>
- <mapping resource="feeds.hbm.xml"/>
- <mapping resource="activitystream.hbm.xml"/>
- <mapping resource="instance.hbm.xml"/>
- <mapping resource="mailsender.hbm.xml"/>
- -->
- </session-factory>
- </hibernate-configuration>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement