Can JNDI ds reconnect automatically after DB server restarts

[allen_lei]

Hi,all

I've had that "The JBoss server must be restarted when db server restarted" idea in my head for a long time,maybe because I used the C3P0 database connnection pooling which just like what i think formerly .But it's just wrong.

Today i try to restart the Mysql db service without restarting the JBoss server,then i find it can work however.The Oracle db server i have not tried,but i think it will work too.

Is this which i mean above right?Is this the datasource connection pooling mechanism for JBoss only?

Your reply will by most appreciated.

[jaikiran]

This question is more appropriate in the JCA forum http://www.jboss.org/index.html?module=bb&op=viewforum&f=136. Here's a wiki entry which has an explanation for your question:

http://www.jboss.org/community/wiki/WhatHappensToJBossIfIRestartTheDatabase

[allen_lei]

I see,thanks.

Next time i will post my new topic about JCA in the JCA forum.

And i hava a question that it still work when not use jdbc driver ping and <check-valid-connection-sql> statement.Just as following:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE datasources
 PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
 "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">
<datasources>
 <local-tx-datasource>
 <jndi-name>testDs</jndi-name>
 <connection-url>jdbc:mysql://localhost:3306/test</connection-url>
 <driver-class>com.mysql.jdbc.Driver</driver-class>
 <user-name>root</user-name>
 <password>mysql</password>
 <min-pool-size>20</min-pool-size>
 <max-pool-size>50</max-pool-size>
 <metadata>
 <type-mapping>mySQL</type-mapping>
 </metadata>
 </local-tx-datasource>
</datasources>

Is that right? Or is it the default mechanism of JBoss JNDI ds connection pooling?

Your replay will by most appreciated.