Normal or Deviant disconnection of DB Connection??

[brian_luo]

Hello Experts,

While I stop the JDBC Sender / Receiver Channel them are running in the RWB ,then if the DB Connection will be disconnected ???

Is the disconnection way normal or deviant ??

Thx in advance,

Brian

Edited by: brian Luo on Nov 16, 2009 6:05 PM

[Shabarish_Nair]

When ever you stop the CC for JDBC, the underlying connection to the DB will also be cut off.

Only when you start the CC, the connection will be re-established.

[brian_luo]

Hi Shabarish,

thx for ur answer.

If there are 7000 records ought to insert DB via JDBC Receiver Channel, now there are 4000 records have be inserted DB (I know here the 4000 records arent committed. it will be commited when all 7000 records be inserted, I m right ??? ), but suddenly I interrupt the Receiver Channel when it is running, then what will occur ??

a rollback? or commit?or hung? or other circs?

Waitting for ur answer.

Thx.

[Former Member]

if you are firing insert action - 4000 records get commited in database, rest you have to check in queue/failed messages and send those across.