on 06-18-2007 7:36 PM
Hi All,
I have come across a problem with JDBC adapter. Polling got stopped due to connection failure. But currently the there is no connection problem exists. Still the JDBC adapter is not polling for the records. I tried to stop the adapter and started it again. Adapter status is "started but has errors" . How will I solve this?
Thanks in advance
Jaison
Looks like some cached value still exists, try clearing cache, or restart server, as a common problems with Databases are shared memory segments, alternatively you might have a connection but it might be stale that could also show the "adaptor has started but has errors". restart would be a good starting point here.
Regards
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
if its a sender JDBC adapter and your poll interval is not very high frequency then consider the option
<b>Disconnect from Database After Processing Each Message</b>
this will overcome the problem of stale connections from the connection pool and afresh connections will be made to the db for every transfer.<b>Again...to be used only if your polling frequency is not very high</b>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Jaison,
Can u paste the error u are getting for the particular comm.channel.
Best regards,
raj.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is the exact error message.
Database-level error reported by JDBC driver while executing statement <here is the querry in adapter> The JDBC driver returned the following error message: 'java.sql.SQLException: Communication link failure. (Connection was dropped unexpectedly.)'. For details, contact your database server vendor
Thanks.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.