Logged Field Data Types in JDBC
When the value for a logged field is written to the database, it is saved as one of the JDBC data types: VARCHAR, FLOAT or DATE. Integration Server converts the data type for each logged field as follows:
Data Type in Input or Output Document | JDBC Type in Database |
String, String List or Table | VARCHAR |
Object or Object List, Java wrapper type: | |
java.lang.Boolean | VARCHAR |
java.lang.Byte | VARCHAR |
java.lang.Character | VARCHAR |
java.lang.Double | FLOAT |
java.lang.Float | FLOAT |
java.lang.Integer | FLOAT |
java.lang.Long | FLOAT |
java.lang.Short | FLOAT |
java.util.Date | DATE |
byte[] | VARCHAR |
UNKNOWN | VARCHAR |
Integration Server calls the toString() method on objects that do not have a defined Java wrapper type. If you are logging one of your own types and you implement the toString() method, the server saves the value returned by your implementation to the audit log. If you do not supply a toString implementation, the server saves the output of java.lang.Object.toString() to the database.