On 24/11/2014 15:45, Javier Calvach Regidor wrote:
Hello again,
Has anyone configured successfully a DB2 resource in Syncope? Any hint
about the JDBC driver?
Hi,
I have no experience at all with DB2, but, with reference to [1], I'd
start defining a persistence.properties like as
jpa.driverClassName=com.ibm.db2.jcc.DB2Driver
jpa.url=jdbc:db2://appdb:50000/SYNCOPE
jpa.username=syncope
jpa.password=syncope
jpa.dialect= org.apache.openjpa.jdbc.sql.DB2Dictionary
jpa.pool.validationQuery=SELECT 1
#note: other connection pool settings can also be configured here, see
persistenceContext.xml
quartz.jobstore=org.quartz.impl.jdbcjobstore.DB2v8Delegate
quartz.sql=tables_db2.sql
audit.sql=audit_db2.sql
database.schema=
where tables_db2.sql needs to be provided under
core/src/main/resoures/quartz from one of the ones available from [2]
and audit_db2.sql needs to be provided under core/src/main/audit on the
basis of others [3].
Possibly, a specific orm.xml (as for Oracle and MS SQL Server) might
need to be provided [4].
If you succeed, it would be a very nice addition, please keep us informed.
Regards.
[1]
https://cwiki.apache.org/confluence/display/SYNCOPE/Run+Syncope+in+real+environments#RunSyncopeinrealenvironments-Internalstorage
[2]
https://fisheye.terracotta.org/browse/Quartz/tags/quartz-2.2.1/distribution/src/main/assembly/root/docs/dbTables
[3]
https://git-wip-us.apache.org/repos/asf?p=syncope.git;a=tree;f=core/src/main/resources/audit;hb=1_2_X
[4]
https://git-wip-us.apache.org/repos/asf?p=syncope.git;a=tree;f=core/src/main/resources/META-INF;hb=1_2_X
--
Francesco Chicchiriccò
Tirasa - Open Source Excellence
http://www.tirasa.net/
Involved at The Apache Software Foundation:
member, Syncope PMC chair, Cocoon PMC, Olingo PMC
http://people.apache.org/~ilgrosso/
