wso2-extensions / esb-inbound-dbevent

Apache License 2.0
0 stars 26 forks source link

Fix error - cannot connect an Oracle database #10

Closed menuka94 closed 5 years ago

menuka94 commented 5 years ago

Purpose

The following error prevented the use of an Oracle database with the extension.

ERROR

{org.wso2.carbon.inbound.poll.dbeventlistener.DBEventPollingConsumer}
- Error while checking the 
database connection.
java.sql.SQLException: Invalid operation for forward only resultset : first
at oracle.jdbc.driver.BaseResultSet.first(BaseResultSet.java:87)
at 
org.wso2.carbon.inbound.poll.dbeventlistener.DBEventPollingConsumer.isConnectionAlive(DBEventP
ollingConsumer.java:383)
at 
org.wso2.carbon.inbound.poll.dbeventlistener.DBEventPollingConsumer.poll(DBEventPollingConsume
r.java:343)

This PR resolves the issue (Resolves #12).