[JBoss JIRA] Created: (JBESB-1900) Current system date in sql-provider where-condition
by Raghavan TV (JIRA)
Current system date in sql-provider where-condition
---------------------------------------------------
Key: JBESB-1900
URL: https://jira.jboss.org/jira/browse/JBESB-1900
Project: JBoss ESB
Issue Type: Feature Request
Security Level: Public (Everyone can see)
Environment: JBoss ESB 4.3GA + JBoss 4.2.2 or JBOss 4.0.0 + Oracle 10g + Windows Xp or HP-UX 11.0
Reporter: Raghavan TV
I have a simple table where I store my Orders.
e.g.
DB - Oracle 10g
Table
ORDER_QUEUE
----------------------------------------
ORDER_ID NUMBER(5)
FIELD1 VARCHAR2(10)
FIELD2 VARCHAR2(10)
ORDER_DATE DATE
ESB_STATUS VARCHAR2(1)
TIMESTAMP_COL DATE
-----------------------------------------
My requirement is to process only those records where ORDER_DATE = Current System Date that hosts my AppServer
Am trying to work with the sample provided. I updated the where condition as follows and it works fine.
<sql-bus busid="helloSQLChannel" >
<sql-message-filter
tablename="ORDER_QUEUE"
status-column="ESB_STATUS"
where-condition="TO_DATE(ORDER_DATE,'DD-MON-YYYY') = (SELECT TO_DATE(SYSDATE,'DD-MON-YYYY') FROM DUAL)"
message-column="message"
message-id-column="ORDER_ID"
insert-timestamp-column="TIMESTAMP_COL"
/>
</sql-bus>
[where-condition="TO_CHAR(ORDER_DATE,'DD-MON-YYYY') = (SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY') FROM DUAL)"]
But the query is more specific to a Oracle DB. If I decide to change the provider in the future, then this filter will fail!
Also if the DB and AppServer are in different TZ, we have a problem
Is there some other workaround to use the AppServer Date in the where-condition ?
--
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
13 years, 9 months
[JBoss JIRA] Created: (JBESB-3468) Propagate http-client-property configuration to SOAPProxyWsdlLoader.newLoader
by Kevin Conner (JIRA)
Propagate http-client-property configuration to SOAPProxyWsdlLoader.newLoader
-----------------------------------------------------------------------------
Key: JBESB-3468
URL: https://jira.jboss.org/browse/JBESB-3468
Project: JBoss ESB
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Web Services
Affects Versions: 4.7 CP2
Reporter: Kevin Conner
Assignee: Kevin Conner
Fix For: 4.7 CP3
SOAPProxyWsdlLoader.newLoader does not use the correct configuration when invoked from SOAPProxy or SOAPProxyWsdlContractPublisher.. As a consequence it has no visibility of any http-client-property elements that are configured on the action.
This should retain current functionality as much as possible, only allowing changes to the WSDL configuration if configured.
There will be two mechanisms that can be used to configure the WSDL access through the SOAPProxy use case
- introduce wsdl-http-client-property elements for explicit configuration of the WSDL http client
- introduce a "wsdlUseHttpClientProperties" property so that the http-client-property elements can also be used
wsdl-http-client-property will override http-client-property.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months
[JBoss JIRA] Created: (JBESB-3378) http-client-properties not propagated to HttpMethodParams
by David Ward (JIRA)
http-client-properties not propagated to HttpMethodParams
---------------------------------------------------------
Key: JBESB-3378
URL: https://jira.jboss.org/browse/JBESB-3378
Project: JBoss ESB
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Configuration, Rosetta, Transports
Affects Versions: 4.8
Reporter: David Ward
If you set your config like this:
<action ... class="org.jboss.soa.esb.actions.soap.proxy.SOAPProxy">
...
<property name="http-client-properties">
<http-client-property name="http.method.retry-handler" value="com.foobar.MyRetryHandler"/>
</property>
or like this:
<action ... class="org.jboss.soa.esb.actions.soap.proxy.SOAPProxy">
...
<property name="file" value="http-client.properties"/>
http-client.properties:
http.method.retry-handler=com.foobar.MyRetryHandler
, your custom retry handler is not picked up. This is NOT a bug in SOAPProxy.
The bug is in both POSTHttpMethodFactory and GETHttpMethodFactory, where in the setConfiguration(ConfigTree):void method, the http-client-properties that are available in the passed-in ConfigTree are not set into the HttpMethod's HttpMethodParams.
What should happen is that ANY property that starts with "http.method." should be set into the HttpMethodParams.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
13 years, 9 months