[JBoss JIRA] Created: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
by Rafael Codina Tormo (JIRA)
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: Mark Little
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/schemas/xml...">
<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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira