Trading Networks 10.3 | Administering and Monitoring B2B Transactions | Service Development Help | Building Services | About Service Auditing | Logging Input and Output Fields | Logged Field Data Types in JDBC
 
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.