<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Sql-provider validation seems invalid
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/simontp">Simon Toftegård Petersen</a> in <i>JBoss ESB Development</i> - <a href="http://community.jboss.org/message/557912#557912">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Im using jboss-soa-p.4.3.0-cp02 and discovered something strange about sql-provider. Looking through the source code i found that it validates input through soa-work\esb\checkout\product\rosetta\src\org\jboss\soa\esb\listeners\config\XmlValidatorImpl.java with this schema: soa-work\esb\checkout\product\etc\schemas\xml\jbossesb-1.0.1.xsd</p><p>Where <xsd:element name="sql-message-filter"> is defined but only a fraction of the parameters that is actually available are there. Cause if you look in soa-work\esb\checkout\product\rosetta\src\org\jboss\soa\esb\listeners\gateway\SqlTableGatewayListener.java it has alot more parameters that it looks for:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    /** SQL related  */</p><p>Compiled list of possible configvalues(compiled from ListenerTagNames.java and JDBCEpr.java)</p><p> public static final String SQL_TABLE_NAME_TAG<span> </span>= "tableName";  </p><p> public static final String MESSAGE_ID_COLUMN_TAG <span> </span>= "message_id_column";</p><p> public static final String DATA_COLUMN_TAG <span> </span>= "message_column";   </p><p> public static final String STATUS_COLUMN_TAG <span> </span>= "status_column";</p><p> public static final String SQL_WHERE_CONDITION_TAG<span> </span>= "whereCondition";</p><p> public static final String ORDER_BY_TAG<span> </span>= "orderBy";</p><p> public static final String TIMESTAMP_COLUMN_TAG <span> </span>= "insert_timestamp_column";</p><p><p> public static final String POST_DEL_TAG<span> </span>= "postDelete";</p><p><span> </span> public static final String ERROR_DEL_TAG<span> </span>= "errorDelete";</p></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p> public static final String SQL_SELECT_FIELDS_TAG<span> </span>= "selectFields";</p><p> public static final String SQL_KEY_FIELDS_TAG<span> </span>= "keyFields";</p><p> public static final String SQL_IN_PROCESS_FIELD_TAG<span> </span>= "inProcessField";</p><p> public static final String SQL_IN_PROCESS_VALUES_TAG<span> </span>= "inProcessValues";</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>jbossesb-1.0.1.xsd(validation): </p><p><xsd:attribute name="tablename" type="xsd:string"</p><p><xsd:attribute name="message-id-column"</p><p><xsd:attribute name="message-column"</p><p><xsd:attribute name="status-column"</p><p><xsd:attribute name="where-condition" use="optional"</p><p><xsd:attribute name="order-by" use="optional"</p><p><xsd:attribute name="insert-timestamp-column" use="optional"</p><p><xsd:attribute default="true" name="post-delete"</p><p><xsd:attribute default="true" name="error-delete"</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>As you can see 4 option are missing in the validation. So these can't be used at all. Is this a bug or is it working as intended?</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Here is my jboss-esb.xml sql-provider just for reference:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><div id="_mcePaste"><sql-provider name="GatewaySQLprovider"</div><div id="_mcePaste">url="jdbc:oracle:thin:@jdbc:oracle:thin:@url"</div><div id="_mcePaste">datasource="java:/HelloworldTxSqlDB"></div><div id="_mcePaste"><sql-bus busid="helloSQLChannel"></div><div id="_mcePaste"><sql-message-filter tablename="gateway_table"</div><div id="_mcePaste">status-column="STATUS_COL" order-by="DATA_COLUMN" where-condition="DATA_COLUMN like 'data%'"</div><div id="_mcePaste">message-column="DATA_COLUMN" post-delete="false" message-id-column="UNIQUE_ID"</div><div id="_mcePaste">insert-timestamp-column="TIMESTAMP_COL" error-delete="false" select-fields="DATA_COLUMN" /></div><div id="_mcePaste"></sql-bus></div><div id="_mcePaste"></sql-provider></div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/557912#557912">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss ESB Development at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2032">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>