Skip to Content
0
Former Member
Dec 01, 2006 at 07:59 PM

JDBC: How to select only those records which contains col1 is NULL

285 Views

Hi All,

In JDBC SELECT scenario.

I wants to select only those records which contains col1 is NULL.

I am trying as follows:

<key>

<col1 isNull="TRUE" />

</key>

but in moni/monitoring i am getting Following Error

006-12-01 19:35:20 Error Unable to execute statement for table or stored procedure. 'BG_SALARY_SEND_SAP_D' (Structure 'SELECT') due to java.sql.SQLException: FATAL ERROR document format: structure 'SELECT', key element 'key' contains no values

2006-12-01 19:35:20 Error Exception caught by adapter framework: Error processing request in sax parser: Error when executing statement for table/stored proc. 'BG_SALARY_SEND_SAP_D' (structure 'SELECT'): java.sql.SQLException: FATAL ERROR document format: structure 'SELECT', key element 'key' contains no values

Please suggest how to do select rows with col1 is null.

Regards