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/
