I will deal with that. Sorry about that.

Regards
JB


On 09/19/2017 12:07 PM, Maurice Betzel wrote:

    Due to increased SPAM and fake accounts, the self-registration has been
    disabled. Sorry for the inconvenience. Contact the OPS4J General list to
    have an account created.


Who can help here?

Am Dienstag, 19. September 2017 11:13:18 UTC+2 schrieb Jean-Baptiste Onofré:

    Hi

    it sounds like a bug, can you create a Jira about that ?

    Thanks,
    Regards

    JB


    On 09/19/2017 11:03 AM, Maurice Betzel wrote:
    Dear community,

    i am trying to setup a database connection pool for Oracle using the
    ojdbc8 12.2.0.1 Driver, but if i add:

    |
    jdbc.pool.maxTotal=16
    |

    i get a SQLException:

    |
    Causedby:java.sql.SQLException:cannot setproperties [pool.maxTotal]
        at
    
org.ops4j.pax.jdbc.oracle.impl.OracleDataSourceFactory.setProperties(OracleDataSourceFactory.java:97)~[?:?]
        at
    
org.ops4j.pax.jdbc.oracle.impl.OracleDataSourceFactory.createDataSource(OracleDataSourceFactory.java:53)~[?:?]
    |

    I have tested this with PAX-JDBC 0.9.0 where all was up and running
    perfectly. It seems the pool parameters are not forwarded to the pool and
    filtered out before the data-source creation.

    Config details for PAX-JDBC 1.2.0:

    |
    osgi.jdbc.driver.name=oracle
    pool=dbcp2
    xa=true
    dataSourceName=oramult
    .user=testUser
    .password=testPassword
    url=jdbc:oracle:thin:@//test-01:1521/oramult
    jdbc.pool.maxTotal=16
    |

    Karaf details:

    |
    karaf@root()>jdbc:ds-list
    Name│Product│Version│URL │Status
    
────────┼─────────┼───────────────────────────────────────────────────────────┼─────────────────────────────────────────────┼───────
    oramult
    
│Oracle│OracleDatabase11gRelease11.2.0.4.0-64bitProduction│jdbc:oracle:thin:@//test-01:1521/oramult
    │ OK
    karaf@root()>service:list javax.sql.DataSource
    [javax.sql.DataSource]
    ----------------------
     dataSourceName =oramult
     felix.fileinstall.filename
    
=file:/C:/Users/betzm/Development/intellij/eu.abeel.platform/assemblies/platform/target/platform-1.0.0/etc/org.ops4j.datasource-oracle.test.persistence.cfg
     osgi.jdbc.driver.name =oracle
     osgi.jndi.service.name =oramult
     service.bundleid =74
     service.factoryPid =org.ops4j.datasource
     service.id =160
     service.pid =org.ops4j.datasource.f33bc71b-6efd-4759-b102-0a9889f2a2fd
     service.scope =singleton
     url =jdbc:oracle:thin:@//vlo-ora-02:1521/oramult
    Providedby:
     OPS4J PaxJDBC Config(74)

    karaf@root()>service:list PooledDataSourceFactory
    [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory]
    --------------------------------------------------------
     pool =dbcp2
     service.bundleid =77
     service.id =146
     service.scope =singleton
     xa =false
    Providedby:
     OPS4J PaxJDBC PoolingDBCP2 (77)
    Usedby:
     OPS4J PaxJDBC Config(74)

    [org.ops4j.pax.jdbc.pool.common.PooledDataSourceFactory]
    --------------------------------------------------------
     pool =dbcp2
     service.bundleid =77
     service.id =147
     service.scope =singleton
     xa =true
    Providedby:
     OPS4J PaxJDBC PoolingDBCP2 (77)
    |

    Any idea how to configure the connection pool?

-- -- ------------------
    OPS4J - http://www.ops4j.org - [email protected] <javascript:>

    ---
    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] <javascript:>.
    For more options, visit https://groups.google.com/d/optout
    <https://groups.google.com/d/optout>.

--
--
------------------
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] <mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.

--
--
------------------
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].
For more options, visit https://groups.google.com/d/optout.

Reply via email to