I created tables containing all the different datatypes for the databases we support and then attempted to insert and select data into them.

attaching a list of the datatypes and if they should be editable or not.

There where a few issues:

DB2 z/OS XML, is always passed null.  AFResultValueUtil.java  method : prepareXML -> creates for apache or mssql else null.  the datatype is editable but if we pass it a value via aqtablewriter, it will only send null to the database no matter the value passed.

Informix - CLOB - editable = true, the datatype comes back as a clob but the _columnInfo is saying its a java.sql.string and those the code tries to insert the value and fails.

Oracle - PLS_INTEGER, STRING editable = true, I would think they need to be false.

Postgres - SERIAL -  I create this datatype but database returns int(4) with default value: nextval('datatype.test_b_seq'::regclass).  The issue is that the datatype editable is false, but since it returns int(4) we send it the value as editable been true.

Sybase Anywhere - SYSNAME - editable = false  -- datatype returned is sysname but _columnInfo._columnClass = java.lang.String and those editable becomes true and we send it the value

Sybase IQ - I couldn't test the following datatypes -- TEXT, IMAGE, LONG VARCHAR, LONG BINARY, BLOB, CLOB, XML -- Don't have a server licensed to Manage large objects

TeraData - GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC -- datatypes say editable but when value sent for insertion errors out.  they should be editable = false.  The other thing is that there _columnInfo._columnClass = java.sql.char and java.sql.varchar

let me know when you have a moment to go over this with me.