Upgrade SQLprovider ------------------- Key: JBESB-3189 URL: https://jira.jboss.org/jira/browse/JBESB-3189 Project: JBoss ESB Issue Type: Feature Request Security Level: Public (Everyone can see) Components: Rosetta Affects Versions: 4.7 Environment: JBoss AS jboss-5.1.0.GA, OpenMQ 4.4, Postgres 8.4, CentOS 64 Bit, Jdk 1.6 Reporter: Quinton Anderson 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. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira