[JBoss JIRA] Created: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
6:50 p.m.
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...
<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
7:06 p.m.
New subject: [JBoss JIRA] Assigned: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little reassigned JBESB-457:
---------------------------------
Assignee: Kurt Stam (was: Mark Little)
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
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
--
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
9:05 p.m.
New subject: [JBoss JIRA] Updated: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little updated JBESB-457:
------------------------------
Fix Version/s: 4.0 Maintenance Pack 1
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.0 Maintenance Pack 1
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
--
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
4:16 p.m.
New subject: [JBoss JIRA] Commented: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=comments#action_12355624 ]
Mark Little commented on JBESB-457:
-----------------------------------
How critical is this for you? We're in the middle of a MP release, so need to
determine priorities.
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
--
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
4:16 p.m.
New subject: [JBoss JIRA] Updated: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little updated JBESB-457:
------------------------------
Fix Version/s: 4.2
(was: 4.0 Maintenance Pack 1)
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
--
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
8:14 p.m.
New subject: [JBoss JIRA] Commented: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=comments#action_12355846 ]
Rafael Codina Tormo commented on JBESB-457:
-------------------------------------------
It is actually blocking the performance I need to develop, so I would say it is critical,
and I would really appreciate if you could fix this bug for the MP release you are working
in. Thank you,
Rafael Codina
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
--
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
10 a.m.
New subject: [JBoss JIRA] Updated: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little updated JBESB-457:
------------------------------
Fix Version/s: 4.2 Milestone Release 2
(was: 4.2)
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 Milestone Release 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
--
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
10 a.m.
New subject: [JBoss JIRA] Assigned: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little reassigned JBESB-457:
---------------------------------
Assignee: Esteban Schifman (was: Kurt Stam)
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: Esteban Schifman
Fix For: 4.2 Milestone Release 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
--
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
2:47 p.m.
New subject: [JBoss JIRA] Commented: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=comments#action_12359874 ]
Mark Little commented on JBESB-457:
-----------------------------------
Esteban has replied to you directly concerning this issue. Please respond to that email so
we can determine whether or not this is a bug. If you don't reply, we'll close
this as No Action and you can always schedule another issue later.
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: Esteban Schifman
Fix For: 4.2 Milestone Release 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
--
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
12:08 p.m.
New subject: [JBoss JIRA] Closed: (JBESB-457) sql-message-filter does not allow to specify the fields whereCondition, selectFields, orderBy
[ http://jira.jboss.com/jira/browse/JBESB-457?page=all ]
Mark Little closed JBESB-457.
-----------------------------
Resolution: Incomplete Description
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: Esteban Schifman
Fix For: 4.2 Milestone Release 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
--
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
6276
days inactive
6324
days old
9 comments
2 participants
participants (2)
-
Mark Little (JIRA) -
Rafael Codina Tormo (JIRA)