Hi Vesco,
Ok, as per Syncope JPA configuration this is not possible, take a look
at [1]. There are two datasources definitions, but the application
managed (HikariCP) is taken as fallback if jndi is not found.
BTW well done. This means that your persistence conf is good now.
Best regards,
Andrea
[1]
https://github.com/apache/syncope/blob/2_1_X/fit/core-reference/src/main/resources/jboss/domains/MasterDomain.xml#L46-L49
Il 17/10/19 19:16, vesco ha scritto:
I think i was using BOTH pool connections....:
- Application-managed (default); based on HikariCP, the related parameters
can be tuned in the related domain configuration file, e.g.
domains/Master.properties, for the Master domain.
- JavaEE Container-managed, via the JNDI resource matching the name
specified for a given domain, e.g.
java:comp/env/jdbc/syncopeMasterDataSource for the Master domain.
After deleting the quartz tables were finally created
<Resource name="jdbc/syncopeMasterDataSource" 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="20" removeAbandoned="true"
logAbandoned="true"
suspectTimeout="20" timeBetweenEvictionRunsMillis="5000"
minEvictableIdleTimeMillis="5000" defaultAutoCommit="false"
jdbcInterceptors="org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;
org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"
username="syncope" password="syncope"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/syncope?characterEncoding=UTF-8"/>
--
Sent from: http://syncope-user.1051894.n5.nabble.com/
--
Dott. Andrea Patricelli
Tel. +39 3204524292
Engineer @ Tirasa S.r.l.
Viale Vittoria Colonna 97 - 65127 Pescara
Tel +39 0859116307 / FAX +39 0859111173
http://www.tirasa.net
Apache Syncope PMC Member
