Hello Great to hear that!
have a nice weekend Grzegorz Grzybek pt., 18 wrz 2020 o 17:52 Luigi Caligiuri <[email protected]> napisał(a): > Hi, > I've solved the problem. > In my installation were present 2 version of pax-jdbc. > I've removed the one not used and now all is ok. > > Thanks for your help. > Luigi > > Il giorno mercoledì 16 settembre 2020 alle 16:36:53 UTC+2 > [email protected] ha scritto: > >> Hello >> >> For this "strange behavior", I'd need to see some logs, or some kind of >> reproducer project ;) >> >> regards >> Grzegorz Grzybek >> >> śr., 16 wrz 2020 o 16:31 Luigi Caligiuri <[email protected]> >> napisał(a): >> >>> Hi Grzegorz, >>> thanks for your reply, I'll try narayana, but I,m curious to know why >>> the system has this strange behaviour. >>> >>> Luigi >>> >>> Il giorno mer 16 set 2020 alle ore 16:23 Grzegorz Grzybek < >>> [email protected]> ha scritto: >>> >>>> Hello >>>> >>>> InitialSize was introduced in >>>> https://ops4j1.jira.com/browse/PAXJDBC-146, but only for >>>> pax-jdbc-pool-narayana. Looks like plain dbcp2 pool doesn't have this >>>> support... >>>> >>>> regards >>>> Grzegorz Grzybek >>>> >>>> śr., 16 wrz 2020 o 16:14 Luigi Caligiuri <[email protected]> >>>> napisał(a): >>>> >>>>> I'm workin on an application deployed on karaf 4.2.9 and I'm >>>>> using org.ops4j.pax.jdbc-1.4.4. >>>>> >>>>> I've installed >>>>> pax-jdbc-mariadb >>>>> pax-jdbc-pool-dbcp2 >>>>> pax-jdbc-spec >>>>> pax-jdbc-config >>>>> >>>>> >>>>> I have a xa datasource for mariadb with this configuration: >>>>> >>>>> osgi.jdbc.driver.name=mariadb >>>>> url=jdbc:mariadb://dbprimary:3306/gg_caibizdata?autoReconnect=true >>>>> user= xxxxxx >>>>> password=xxxxxx >>>>> dataSourceName=caibizdata >>>>> pool=dbcp2 >>>>> jdbc.pool.maxTotal=100 >>>>> jdbc.pool.maxIdle=7 >>>>> jdbc.pool.maxWaitMillis=10000 >>>>> xa=true >>>>> jdbc.factory.validationQuery="/* ping */ SELECT 1" >>>>> >>>>> When karaf starts it doesn't create the connection, only when used for >>>>> the first time using ds-list or by some bundle the connection is >>>>> instantiated. >>>>> After some time, when every connection goes idle no other connection >>>>> is created and if a bundle try to get a connection it receives a >>>>> connection >>>>> timeout, then if it tries another time everything goes well. >>>>> I've tried to set a minimum number of connections, bat i'ven't found >>>>> the right property. >>>>> I've also tried to change the configuration using something like this >>>>> >>>>> osgi.jdbc.driver.name=mariadb >>>>> url=jdbc:mariadb://dbprimary:3306/gg_caibizdata?autoReconnect=true >>>>> user=xxxxxxx >>>>> password=xxxxxx >>>>> dataSourceName=caibizdata >>>>> pool=dbcp2 >>>>> pool.maxTotal=100 >>>>> pool.minIdle=10 >>>>> pool.maxWaitMillis=2000 >>>>> pool.blockWhenExhausted = true >>>>> pool.testOnBorrow = true >>>>> pool.testWhileIdle = false >>>>> pool.timeBetweenEvictionRunsMillis = 120000 >>>>> pool.evictionPolicyClassName = >>>>> org.apache.commons.pool2.impl.DefaultEvictionPolicy >>>>> xa=true >>>>> jdbc.factory.validationQuery="/* ping */ SELECT 1" >>>>> jdbc.factory.maxConnLifetimeMillis = 30000 >>>>> jdbc.factory.validationQueryTimeout = 2000 >>>>> >>>>> but nothing changes , and if I set both validationQUery and >>>>> testOnBorrow the system could not create the connection. >>>>> >>>>> What I'm doing wrong, can anyone help me? >>>>> >>>>> -- >>>>> -- >>>>> ------------------ >>>>> OPS4J - http://www.ops4j.org - [email protected] >>>>> >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "OPS4J" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/ops4j/d0e5451b-ee8c-4642-be82-ff3210ec766cn%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/ops4j/d0e5451b-ee8c-4642-be82-ff3210ec766cn%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- >>>> -- >>>> ------------------ >>>> OPS4J - http://www.ops4j.org - [email protected] >>>> >>>> --- >>>> You received this message because you are subscribed to a topic in the >>>> Google Groups "OPS4J" group. >>>> To unsubscribe from this topic, visit >>>> https://groups.google.com/d/topic/ops4j/PQxwctv8PYg/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> [email protected]. >>>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/ops4j/CAAdXmhrsO3W1JCX05o%2BEwg7-NhFicurDXaYtgQoBoAUHTjtv-A%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/ops4j/CAAdXmhrsO3W1JCX05o%2BEwg7-NhFicurDXaYtgQoBoAUHTjtv-A%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> -- >>> ------------------ >>> OPS4J - http://www.ops4j.org - [email protected] >>> >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "OPS4J" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> >> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/ops4j/CAM4qgtpFVzoBTwOBaePSFweJFd2iUVJyTqn_4zdaXZhp4rdWCw%40mail.gmail.com >>> <https://groups.google.com/d/msgid/ops4j/CAM4qgtpFVzoBTwOBaePSFweJFd2iUVJyTqn_4zdaXZhp4rdWCw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > -- > ------------------ > OPS4J - http://www.ops4j.org - [email protected] > > --- > You received this message because you are subscribed to the Google Groups > "OPS4J" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/ops4j/d6ec66df-a27a-4fd1-9972-9fb97e768c08n%40googlegroups.com > <https://groups.google.com/d/msgid/ops4j/d6ec66df-a27a-4fd1-9972-9fb97e768c08n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -- ------------------ OPS4J - http://www.ops4j.org - [email protected] --- You received this message because you are subscribed to the Google Groups "OPS4J" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ops4j/CAAdXmhoOFrEFdgJ-FbUM_pdkK0YquFGpXXisKfHp96DrJ%2BNBvg%40mail.gmail.com.
