ratha wrote: > 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> > 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 [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/carbon-dev
