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.
