[esb-issues] [JBoss JIRA] Commented: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy

sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy --------------------------------------------------------------------------------------------- Key: JBESB-457 URL: http://jira.jboss.com/jira/browse/JBESB-457 Project: JBoss ESB Issue Type: Bug Security Level: Public(Everyone can see) Affects Versions: 4.0 Environment: Jboss-AS-portal-2.4.1 JBossESB-4.0 WindowsXP Pentium(R) 4 CPU 3.00GHz 1GB of RAM Reporter: Rafael Codina Tormo Assigned To: Kurt Stam Fix For: 4.2 I have been trying to use the sql-provider configuration to retrieve data from a database. I have properly created the optional status column to indicate the pending rows to be treated. When trying to define the query, I have got an issue that is blocking my development, due to the fact that I am not able to configure the parameters selectFields, whereCondition and orderBy, which means that I am only capable to obtain the rows from the specified table which have the value 'P' in the status column (select * from myTable where status='P'). You can check the following example of code I have for the file jbossesb.xml: <?xml version = "1.0" encoding = "UTF-8"?> <jbossesb parameterReloadSecs="3600" xmlns="http://anonsvn.labs.jboss.com/labs/jbossesb/trunk/product/etc... <providers> <sql-provider name="SQLProvider" url="myURL" driver="myDriver" username="XXX" password="XXX"> <sql-bus busid="SQLChannel" > <sql-message-filter tablename="myTable" status-column="STATUS" message-id-column="TEST_ID" post-delete="false" error-delete="false" ></sql-message-filter> </sql-bus> </sql-provider> <jms-provider name="JBossMQ" connection-factory="ConnectionFactory" jndi-context-factory="org.jnp.interfaces.NamingContextFactory" jndi-URL="localhost"> <jms-bus busid="BusA"> <jms-message-filter dest-type="QUEUE" dest-name="queue/A"/> </jms-bus> </providers> <services> <service category="SQLCategory" name="SQLGateway" description="GatewayConnectionSQL"> <listeners> <sql-listener name="MySQLGateway" busidref="SQLChannel" maxThreads="1" is-gateway="true"> </sql-listener> <jms-listener name="JmsSQLListener" busidref="BusA" maxThreads="1" is-gateway="false"/> </listeners> <actions> <action name="SQLListenerAction" class="myClass" process="myMethod" /> </actions> </service> <services> Since this performance is very important for the project I am working in, I would like to know if there is an alternative way to achieve this goal. Thank you in advance, Rafael Codina