Note | ||
---|---|---|
| ||
The content below is for Apache Syncope <= 1.2 - for later versions check the "System Administration" chapter of the Reference Guide. |
Table of Contents | ||
---|---|---|
|
...
Code Block |
---|
quartz.sql=tables_mysql.sql |
MariaDB
Code Block |
---|
jpa.driverClassName=org.mariadb.jdbc.Driver jpa.url=jdbc:mariadb://localhost:3306/syncope?characterEncoding=UTF-8 jpa.username=syncope jpa.password=syncope jpa.dialect=org.apache.openjpa.jdbc.sql.MariaDBDictionary jpa.pool.validationQuery=SELECT 1 #note: other connection pool settings can also be configured here, see persistenceContext.xml quartz.jobstore=org.quartz.impl.jdbcjobstore.StdJDBCDelegate quartz.sql=tables_mariadb.sql audit.sql=audit.sql database.schema= |
This assumes that you have a MariaDB instance running on localhost, listening on its default port 3306 with a database syncope
fully accessible by user syncope
with password syncope
.
Oracle
Code Block |
---|
jpa.driverClassName=oracle.jdbc.OracleDriver
jpa.url=jdbc:oracle:thin:@localhost:1521:orcl
jpa.username=syncope
jpa.password=syncope
jpa.dialect=org.apache.openjpa.jdbc.sql.OracleDictionary
jpa.pool.validationQuery=SELECT 1 FROM DUAL
#note: other connection pool settings can also be configured here, see persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.oracle.OracleDelegate
quartz.sql=tables_oracle.sql
audit.sql=audit_oracle.sql
database.schema=SYNCOPE
|
...
create directory
Code Block core/src/main/resources/META-INF
- download Oracle mapping file for the version you are building (1_2_X, 1.1.X, 1.0.X)
rename it to
Code Block orm.xml
and copy it under the directory created above
...
create directory
Code Block core/src/main/resources/META-INF
- download MS SQL Server mapping file for the version you are building (1_2_X, 1.1.X, 1.0.X)
rename it to
Code Block orm.xml
and copy it under the directory created above
...
Optionally, define a datasource for internal storage (following example is for MySQL): please check that the connection parameters are same as configured above.
Code Block | ||
---|---|---|
| ||
<Resource name="jdbc/syncopeDataSource" auth="Container" type="javax.sql.DataSource" factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" testWhileIdle="true" testOnBorrow="true" testOnReturn="true" validationQuery="SELECT 1" validationInterval="30000" maxActive="100" minIdle="2" maxWait="10000" initialSize="2" removeAbandonedTimeout="2000020" removeAbandoned="true" logAbandoned="true" suspectTimeout="2000020" timeBetweenEvictionRunsMillis="5000" minEvictableIdleTimeMillis="5000" jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" username="syncope" password="syncope" driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/syncope?characterEncoding=UTF-8"/> |
...
When using a datasource for internal storage, be sure to add
Code Block | ||
---|---|---|
| ||
<resource-ref> <res-ref-name>jdbc/syncopeDataSource</res-ref-name> <jndi-name>jdbc/syncopeDataSource</jndi-name> </resource-ref> |
...
right after </context-root>
in core/src/main/webapp/WEB-INF/glassfish-web.xml
.
JBoss AS 7.1
Note | ||
---|---|---|
| ||
Content of this paragraph applies to Apache Syncope < 1.2.0 |
Download this file, copy it under core/src/main/resources/
and replace
Code Block | ||
---|---|---|
| ||
<entry key="openjpa.MetaDataFactory" value="org.apache.syncope.core.persistence.openjpa.JBossPersistenceMappingFactory(URLs=vfs:${project.build.directory}/cargo/configurations/jboss71x/deployments/${project.build.finalName}.war/WEB-INF/classes/, Resources=META-INF/orm.xml)"/> |
with
Code Block | ||
---|---|---|
| ||
<entry key="openjpa.MetaDataFactory" value="org.apache.syncope.core.persistence.openjpa.JBossPersistenceMappingFactory(URLs=vfs:/content/${project.build.finalName}.war/WEB-INF/classes/, Resources=META-INF/orm.xml)"/> |
Fixing error messages at core startup
When core application starts up you will see many yet harmless error messages and stacktraces: this is due to an internal mechanism that looks for custom implementations of standard Apache Syncope interfaces.
If you want to remove such messages you can provide an override of the org.apache.syncope.core.init.ImplementationClassNamesLoader
class: see an example here.
Wildfly 8.1
...
Note | ||
---|---|---|
| ||
Content of this paragraph applies to Apache Syncope >= 1.2.X |
...
Download this file, copy it under
...
core/src/main/resources/
...
and replace
Code Block | ||
---|---|---|
| ||
<entry key="openjpa.MetaDataFactory" value="jpa(URLs=vfs:${project.build.directory}/cargo/configurations/jboss71x/deployments/${project.build.finalName}.war/WEB-INF/classes/, Resources=META-INF/orm.xml)"/> |
with
Code Block | ||
---|---|---|
| ||
<entry key="openjpa.MetaDataFactory" value="jpa(URLs=vfs:/content/${project.build.finalName}.war/WEB-INF/classes/, Resources=META-INF/orm.xml)"/> |
Fixing error messages at core startup
When core application starts up you will see many yet harmless error messages and stacktraces: this is due to an internal mechanism that looks for custom implementations of standard Apache Syncope interfaces.
If you want to remove such messages you can provide an override of the org.apache.syncope.core.init.ImplementationClassNamesLoader
class: see an example here.
Use DataSource
When using a DataSource, a few additional adjustments are needed.
...