Re: [Sequoiadb-discuss] Sequoia DataSource

[Toni M. L. <ton...@gm...>]

Sorry, I have follwoing configuration :

We are working with jboss-4.0.3SP1, sequoia-2.10.10 and mysql 4.1.20 in a
RHEL environment !

2009/6/3 Toni Menendez Lopez <ton...@gm...>

> Hello everyone,
>
> I am studying the parameters that we can set in the DATASOURCE of JBoss to
> access the Sequoia Driver..
>
> I have following parameters :
>
> <?xml version="1.0" encoding="UTF-8"?>
> <!--============================================================= -->
> <!--                                                              -->
> <!-- JBoss Server Configuration                                   -->
> <!--                                                              -->
> <!--============================================================= -->
> <!--============================================================= -->
> <!-- Datasource config for Sequoia                              -->
> ============================================================= -->
> <datasources>
>  <local-tx-datasource>
>   <jndi-name>cdpdbDS</jndi-name>
>
> <connection-url>jdbc:sequoia://mibeas01_data,mibeas02_data/cdpdb?preferredController=mibeas02_data</connection-url>
>   <driver-class>org.continuent.sequoia.driver.Driver</driver-class>
>   <user-name>cdpdb</user-name>
>   <password>cdpdb</password>
>   <max-pool-size>150</max-pool-size>
>   <min-pool-size>5</min-pool-size>
>  <blocking-timeout-millis>8000</blocking-timeout-millis>
>   <set-tx-query-timeout/>
>    <query-timeout>60</query-timeout> <!-- maximum of 1 minutes for queries
> -->
>   <idle-timeout-minutes>3</idle-timeout-minutes>
>  </local-tx-datasource>
> </datasources>
> But, the Conection pool is never close.
>
> Do you know if parameter
>
>   <idle-timeout-minutes>3</idle-timeout-minutes>
> works fine with sequoia ?
>
>
>
> Thanks,
>
> Toni.
>