cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with JDBC adapter polling

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

ravi_raman2
Active Contributor
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

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>

justin_santhanam
Active Contributor
0 Kudos

Jaison,

Can u paste the error u are getting for the particular comm.channel.

Best regards,

raj.

Former Member
0 Kudos

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.

justin_santhanam
Active Contributor
0 Kudos

Jaison,

Can u check the database connection outside of XI whether its successful or not. Using the client tool connect to database with the same authorization as u given in the sender JDBC adapter, see whether its connecting successfully or not.

Best regards,

raj.

prateek
Active Contributor
0 Kudos

Check for the following

1. The firewall settings.

2. The tablespace is sufficient.

3. Try this commnication channel option "Disconnect From Database After Processing Each Message."

Regards,

Prateek