JDBC Adapter

Has anyone seen / solved the following problem?

We are using the JDBC adapter to extract data from a SQL Server 2000 database. The columns we are extracting are numerical, but null in the database. When we do the extract, the select statement returns a value of 0 instead of null. The field in the document we are mapping to is an int. Our subscribing application cannot accept 0’s when the value should be null and we must use the JDBC adapter, not the SQL Server adapter.

In your integration component, go to the properties tab and check ‘Allow unset fields’.