[Carbon-dev] BAM rlease - can we code freeze today?

[Samisa Abeysinghe]

Dumindu,
   Are you done with your commits?

Samisa...


On Wed, Dec 2, 2009 at 4:56 PM, ratha <rathav at wso2.com> wrote:

> ratha wrote:
> > Samisa Abeysinghe wrote:
> >>
> >> On Wed, Dec 2, 2009 at 2:53 PM, Krishantha Samaraweera
> >> <krishantha at wso2.com <mailto:krishantha at wso2.com>> wrote:
> >>
> >>     Now I see more oracle SQL exceptions after adding a new monitored
> >>     server.
> >>
> >>
> >> That is becuase now you get more queries executed.
> >> Looks like we are having trouble with timestamps in DS
> > Table has columns of datatype TIMESTAMP. Dates are implicitly
> > convertible to timestamps But we are passing strings not dates.
> >
> > eg:- From, BAMSummaryGeneratot.ds,
> >
> > <query id="addQuaterDimQ" useConfig="bamDataSource">
> >        <sql>INSERT INTO BAM_QTR_DIM (BAM_START_TIMESTAMP, BAM_NAME,
> > BAM_NO, BAM_YEAR) VALUES (?, ?, ?, ?)</sql>
> >        <param name="startTimestamp" sqlType="/*STRING*/" type=""/>
> >        <param name="name" sqlType="STRING" type=""/>
> >        <param name="quarterNo" sqlType="INTEGER" type=""/>
> >        <param name="yearId" sqlType="INTEGER" type=""/>
> >    </query>
> >
> sorry, wrong view...
>
> > Thanks.
> > -Ratha.
> >> Samisa...
> >>
> >>
> >>
> >>     [2009-12-02 14:39:31,579] ERROR -  DS Fault Message: Error in
> >>     'SQLQuery.processNormalQuery'
> >>     Source Data Service:-
> >>     Name: BAMSummaryGenerationDS
> >>     Location:
> >>
> >>
> /home/krishantha/Desktop/BAM/samisa-latest/12-02/wso2bam-1.0.0-beta001/repository/dataservices/BAMSummaryGenerationDS.dbs
> >>
> >>     Description: N/A
> >>     Default Namespace: http://ws.wso2.org/dataservice
> >>     Current Request Name: getOperationYearlySummary
> >>     Current Params: {startTimestamp=2008-01-01 00:00:00,
> >>     endTimestamp=2009-01-01 00:00:00, operationId=15}
> >>     Nested Exception:-
> >>     java.sql.SQLException: ORA-01843: not a valid month
> >>
> >>
> >>     Thanks,
> >>     Krishantha.
> >>
> >
> >
>
>
> _______________________________________________
> Carbon-dev mailing list
> Carbon-dev at wso2.org
> https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
>



-- 
Samisa Abeysinghe
Director, Engineering - WSO2 Inc.

http://www.wso2.com/ - "The Open Source SOA Company"
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.wso2.org/pipermail/carbon-dev/attachments/20091206/4a113161/attachment.htm