[GEODE-4833] JdbcWriter and JdbcAsyncWriter may fail to write null fields to database

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 1.4.0
• Fix Version/s: 1.9.0
• Component/s: extensions, regions
• Labels: pull-request-available
• Assignee: Darrel Schneider
• Reporter: Darrel Schneider
• Created: 13/Mar/18 21:17
• Updated: 24/Apr/19 22:23
• Resolved: 18/Dec/18 01:04

Description

Both JdbcWriter and JdbcAsyncWriter end up calling the JDBC method PreparedStatement.setObject with a value of "null" if the pdx field contains "null".

This will work with jdbc drivers that support sending "non-typed Null" to the backend database.

But some drivers do not support this and these puts will fail with a SQLException.

For portability the jdbc connector should be changed to not pass "null" to setObject without a type.

 

Issue Links

• links to: GitHub Pull Request #1636