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-e3
1f-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