[Amazon][JDBC](10220) Driver not capable
<p>I am trying to update the table is redshift through Pentaho. Getting the below error message:</p>

<pre><code>2016/11/24 18:15:37 - Dimension lookup/update.0 - Dimension Lookup setting preparedStatement to [SELECT cnsmr_id_KEY, Version, crm_cnsmr_id, trvs_core_cnsmr_id, cnsmr_first_name, cnsmr_last_name, cnsmr_email, contact_no, cnsmr_pswd, bus_id, primary_geo_id, cnsmr_loc_id, cnsmr_cc_handle, cnsmr_cc_desc, cnsmr_cc_expiry_date, bill_cycle_start_date, bill_cycle_end_date, registration_date, active_flag, deactivation_date, created_at, updated_at, created_by, updated_by, null, null FROM staging.trvs_consumer WHERE cnsmr_id = ?  AND ? &gt;= null
2016/11/24 18:15:37 - Dimension lookup/update.0 -  AND ? &lt; null
2016/11/24 18:15:37 - Dimension lookup/update.0 - ]
2016/11/24 18:15:38 - Dimension lookup/update.0 - Finished preparing dimension lookup statement.

2016/11/24 18:15:39 - Dimension lookup/update.0 - SQL w/ return keys=[INSERT INTO staging.trvs_consumer( Version, null, null, cnsmr_id, crm_cnsmr_id, trvs_core_cnsmr_id, cnsmr_first_name, cnsmr_last_name, cnsmr_email, contact_no, cnsmr_pswd, bus_id, primary_geo_id, cnsmr_loc_id, cnsmr_cc_handle, cnsmr_cc_desc, cnsmr_cc_expiry_date, bill_cycle_start_date, bill_cycle_end_date, registration_date, active_flag, deactivation_date, created_at, updated_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )]

2016/11/24 18:15:39 - Dimension lookup/update.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : Because of an error this step can't continue: 
2016/11/24 18:15:39 - Dimension lookup/update.0 - Unable to prepare dimension insert :
2016/11/24 18:15:39 - Dimension lookup/update.0 - INSERT INTO staging.trvs_consumer( Version, null, null, cnsmr_id, crm_cnsmr_id, trvs_core_cnsmr_id, cnsmr_first_name, cnsmr_last_name, cnsmr_email, contact_no, cnsmr_pswd, bus_id, primary_geo_id, cnsmr_loc_id, cnsmr_cc_handle, cnsmr_cc_desc, cnsmr_cc_expiry_date, bill_cycle_start_date, bill_cycle_end_date, registration_date, active_flag, deactivation_date, created_at, updated_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

2016/11/24 18:15:39 - Dimension lookup/update.0 - [Amazon][JDBC](10220) Driver not capable.
</code></pre>

<p>From the pentaho forum, I came to know that its a kind of bug to generate NULL column (<a href="http://jira.pentaho.com/browse/PDI-2292" rel="nofollow noreferrer">http://jira.pentaho.com/browse/PDI-2292</a>)</p>

<p>For which I generated one empty row with surrogate key 0 and all other values NULL.</p>

<p>After this when I try and run the transformation, I get the below error.</p>

<p><code>2016/11/24 21:00:32 - Dimension lookup/update.0 - INSERT INTO staging.trvs_consumer( null, created_at, updated_at, cnsmr_id, crm_cnsmr_id, trvs_core_cnsmr_id, cnsmr_first_name, cnsmr_last_name, cnsmr_email, contact_no, cnsmr_pswd, bus_id, primary_geo_id, cnsmr_loc_id, cnsmr_cc_handle, cnsmr_cc_desc, cnsmr_cc_expiry_date, bill_cycle_start_date, bill_cycle_end_date, registration_date, active_flag, deactivation_date, created_at, updated_at, created_by, updated_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
2016/11/24 21:00:32 - Dimension lookup/update.0 - [Amazon][JDBC](10220) Driver not capable.</code></p>

<p>How shall I proceed ?</p>