I need to use the the SQLprovider with against a postgres database, with a table structure that doesn't exactly match what the provider expects. I would therefore like to the add the following features to this provider:
-Message ID can be of any type
-Status column can be of any type
-I can specify the different state values for the status column in the esb provider definition in the jboss-esb.xml file
-The timestamp is optional and can be either bigint or an actual datetime stamp field
-The message data column can be of any type.
As part of this I need to ensure that this provider works with Postgres, as currently postgres does not support implicit type casts, which this component seems to use.