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?
It looks to me like it's just a SQL statement that is assigned to the
property name ROLLUPSELECT and ROLLUPINSERT. I'm guessing that the
properties file is read in by a Java class and the queries are each
accessed via a call to the properties.getProperty(String) method.
> 2. Does date does this part of the SQL statement considers valid?
> ".....WHERE RECEIVEDDATE > TRUNC(SYSDATE)-1 AND RECEIVEDDATE <
> TRUNC(SYSDATE)......"
Sure, this WHERE clause is comparing some dates against the Oracle
SYSDATE but it is using the Oracle TRUNC function to truncate the
SYSDATE to some precision before the comparison.
> 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')\, ....."
I've not used the XPath functions in Oracle so I'll have to guess
here, but it seems that the COLUMN1 and COLUMN2 variables are columns
in the database that are stored as XML and I think the XPath function
probably supports XPath query syntax.
Hope that helps ;-).
Bruce
--
perl -e 'print unpack("u30","D0G)[EMAIL
PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*"
);'
Apache ActiveMQ - http://activemq.org/
Apache ServiceMix - http://servicemix.org/
Apache Geronimo - http://geronimo.apache.org/
Castor - http://castor.org/
