Well, I know this is not a typical ServiceMix query but the SQL queries and
standards I am pondering over are used extensively in ServiceMix on which I
am currently working. So I thought some one can help me out. Sorry if I have
put it in the wrong Forum. Any helpful pointer from any member will be very
helpful for me.
-Dev
gnodet wrote:
>
> How is that related to servicemix ? ;-)
>
> On 10/4/07, DEBANJAN <[EMAIL PROTECTED]> wrote:
>>
>> I am using a schema ADM containing a table MESSAGE. In the sql.properties
>> file i have a statement like-
>>
>> ROLLUPSELECT=SELECT DOCUMENTELEMENT\, TRUNC(RECEIVEDDATE)\,
>> RECEIVINGSERVER\, ORIGINATIONIP\, ORIGINATIONUSER\, COUNT(*) FROM
>> ADM.MESSAGE WHERE RECEIVEDDATE > TRUNC(SYSDATE)-1 AND RECEIVEDDATE <
>> TRUNC(SYSDATE) GROUP BY TRUNC(RECEIVEDDATE)\, DOCUMENTELEMENT\,
>> RECEIVINGSERVER\, ORIGINATIONIP\, ORIGINATIONUSER
>>
>> Then I have a statement like-
>>
>> ROLLUPINSERT=INSERT INTO ADM.ESB_ACTIVITY_ROLLUP (DOCUMENTELEMENT\,
>> EVENTDATE\, RECEIVINGSERVER\, ORIGINATIONIP\, ORIGINATIONUSER\,
>> MESSAGECOUNT) VALUES('{XPATH://COLUMN1}'\, TO_DATE ('{XPATH://COLUMN2}'\,
>> 'YYYY-MM-DD')\, '{XPATH://COLUMN3}'\, '{XPATH://COLUMN4}'\,
>> '{XPATH://COLUMN5}'\, {XPATH://COLUMN6})
>>
>> My queries are-
>>
>> 1. What are ROLLUPSELECT and ROLLUPINSERT? Are they created functions
>> which
>> are called by the java code?
>>
>> 2. Does date does this part of the SQL statement considers valid?
>> ".....WHERE RECEIVEDDATE > TRUNC(SYSDATE)-1 AND RECEIVEDDATE <
>> TRUNC(SYSDATE)......"
>>
>> 3. Is this a XPath query? can someone let me know how this XPath query
>> works?
>> "...VALUES('{XPATH://COLUMN1}'\, TO_DATE ('{XPATH://COLUMN2}'\,
>> 'YYYY-MM-DD')\, ....."
>>
>> Thanks in advance.
>>
>> -Dev
>> --
>> View this message in context:
>> http://www.nabble.com/SQL-and-XPath-Query%28Urgent%29-tf4570958s12049.html#a13046959
>> Sent from the ServiceMix - User mailing list archive at Nabble.com.
>>
>>
>
>
> --
> Cheers,
> Guillaume Nodet
> ------------------------
> Blog: http://gnodet.blogspot.com/
>
>
--
View this message in context:
http://www.nabble.com/SQL-and-XPath-Query%28Urgent%29-tf4570958s12049.html#a13047296
Sent from the ServiceMix - User mailing list archive at Nabble.com.
