Error while executing Select Query

[Former Member]

Hi All,

I am getting following error in Sender JDBC Channel.

u201CDatabase-level error reported by JDBC driver while

retrieving the result set metadata for the select Query. Error message returned by the

JDBC driver: 'java.sql.SQLException: Closed Statement: getMetaDatau201D.

What might be the actual cause of this problem? please reply.

[Former Member]

Hi Sudeep,

The error seems to be with retrieving the results with the select query, Please provide the SQL statement and check with your Database developer.

Thanks,

[Former Member]

Hi Sudeep,

Please check the SQL query that you are trying to execute on the DB. Also, check if it gives a correct result. The problem seems to be with the SQL query or the result of this SQL query.

I would suggest you to run the same query on the DB & see the result first and then try executing the same query via the JDBC adapter.

Regards, Gaurav.

[Former Member]

The statement is wrong and is not returning the correct results. Contact your databse developer or mention the query here:

Regards

Monika