Samisa Abeysinghe wrote:
>
> On Wed, Dec 2, 2009 at 2:53 PM, Krishantha Samaraweera
> <[email protected] <mailto:[email protected]>> 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>
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
[email protected]
https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
