Hi Joao,
I think con. pool is working fine.
Whenever it finds an invalid connection,
"RAR5074 : Exception while executing prepared statement"
exception will be logged and then the connection will be dropped.
Application will always get a valid connection.
To ensure that validation is working fine:
a) access the application that updates the db (add a row to a table)
b) restart db
c) again access the application (add another row to the same table)
d) check whether both the rows are persisted. If they are, validation is
working fine.
Thanks,
-Jagadish
On Wed, 2006-10-11 at 11:00 +0100, Joao Cabral wrote:
> Hi
>
>
>
> As you ask:
>
>
>
> domain.xml
>
>
>
>
>
> <jdbc-connection-pool allow-non-component-callers="false"
> connection-validat
>
> ion-method="table"
> datasource-classname="com.informix.jdbcx.IfxDataSource" fail-
>
> all-connections="false" idle-timeout-in-seconds="300"
> is-connection-validation-r
>
> equired="true" is-isolation-level-guaranteed="false"
> max-pool-size="32" max-wait
>
> -time-in-millis="60000" name="rhcpool"
> non-transactional-connections="false" poo
>
> l-resize-quantity="2" res-type="javax.sql.DataSource"
> steady-pool-size="8" valid
>
> ation-table-name="vcgpar">
>
> <description>Base de dados dos Recursos Humanos</description>
>
> <property name="IfxFET_BUF_SIZE" value="4096"/>
>
> <property name="LoginTimeout" value="0"/>
>
> <property name="IfxIFX_CODESETLOB" value="0"/>
>
> <property name="Password" value="super"/>
>
> <property name="IfxIFX_BATCHUPDATE_PER_SPEC" value="1"/>
>
> <property name="User" value="orirh"/>
>
> <property name="IfxINFORMIXCONTIME" value="0"/>
>
> <property name="IfxIFX_GET_SMFLOAT_AS_FLOAT" value="0"/>
>
> <property name="IfxTRACE" value="0"/>
>
> <property name="IfxINFORMIXSTACKSIZE" value="0"/>
>
> <property name="DatabaseName" value="ana"/>
>
> <property name="PortNumber" value="8101"/>
>
> <property name="IfxIFX_SET_FLOAT_AS_SMFLOAT" value="0"/>
>
> <property name="ServerName" value="finarh1_net"/>
>
> <property name="IfxIFXHOST" value="10.10.1.71"/>
>
> <property name="IfxINFORMIXCONRETRY" value="0"/>
>
> <property name="IfxBIG_FET_BUF_SIZE" value="4096"/>
>
> <property name="IfxIFX_LOCK_MODE_WAIT" value="0"/>
>
> <property name="IfxENABLE_HDRSWITCH" value="false"/>
>
> <property name="IfxPROTOCOLTRACE" value="0"/>
>
> </jdbc-connection-pool>
>
>
>
>
>
>
>
>
>
>
>
> Log:
>
>
>
> [#|2006-10-11T01:03:06.774+0100|SEVERE|sun-appserver-pe9.0|
> javax.enterprise.reso
>
> urce.resourceadapter|
> _ThreadID=14;_ThreadName=Timer-6;_RequestID=9f760de4-e31f-4
>
> 6ab-aae2-742a17f1509d;|RAR5074 : Exception while executing prepared
> statement|#]
>
>
>
>
>
> Cumprimentos,
>
>
>
> João Cabral
>
>
>
> ________________________________
>
>
>
> Orientação Lda.
>
>
>
> Rua José Afonso, nº.1, 2º Frt. 2810-237 Almada
>
>
>
> Tel: +351 21 258 62 80 Fax: +351 21 258 62 8
>
>
>
> mailto:jcabral_at_orientacao-lda.pt
>
>
>
>
>
> -----Mensagem original-----
> De: Jagadish.Ramu_at_Sun.COM [mailto:Jagadish.Ramu_at_Sun.COM]
> Enviada: quarta-feira, 11 de Outubro de 2006 10:37
> Para: dev_at_glassfish.dev.java.net
> Cc: Joao Cabral
> Assunto: Re: problem with connection pool
>
>
>
> Hi Joao,
>
> Can you post
>
> 1) Connection pool configuration from domain.xml.
>
> 2) Exceptions related to this issue from server.log
>
>
>
> Ping will succeed as it does not use a connection that is pooled.
>
>
>
> Thanks,
>
> -Jagadish
>
>
>
> On Wed, 2006-10-11 at 10:09 +0100, Joao Cabral wrote:
>
> >
>
> >
>
> > I am using sunapp 9 and a Informix database.
>
> >
>
> > Whenever I shutdown and restart the database, the “connection
> pool”
>
> > stop functioning - I have validation “table”. The strange is that
>
> > ping succeeds. Any ideia?
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
>
>
>
> ---------------------------------------------------------------------
>
> To unsubscribe, e-mail: dev-unsubscribe_at_glassfish.dev.java.net
>
> For additional commands, e-mail: dev-help_at_glassfish.dev.java.net
>
>