Syncope & DB2

[Javier Calvach Regidor <jc...@rocketmail.com>]

Hello again,
Has anyone configured successfully a DB2 resource in Syncope? Any hint about the JDBC driver?
Thank you in advance,
Best regards.

Re: Syncope & DB2

[Francesco Chicchiriccò <il...@apache.org>]

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/