AFAIK it should YYYY-MM-DD HH24:MI:SS.FF --> 1997-01-31 09:26:50.12 *Dakshika Jayathilaka* Software Engineer WSO2, Inc. lean.enterprise.middleware 0771100911
On Wed, Sep 10, 2014 at 3:06 AM, stevegyc <[email protected]> wrote: > Hi Dakshika > > The format of TIMESTAMP value is like "05-2ζ -12 11.17.41.000 δΈε ", > what is the format that DSS support? > > ------------------------------ > stevegyc > > *From:* Dakshika Jayathilaka <[email protected]> > *Date:* 2014-09-10 10:25 > *To:* stevegyc <[email protected]> > *CC:* dev <[email protected]> > *Subject:* Re: [Dev] [DSS]Generating Using a Given Database Structure > failed > Hi, > > What is the format of TIMESTAMP value ? If your sending incorrect format > that will cause some issues. > > > > *Dakshika Jayathilaka* > Software Engineer > WSO2, Inc. > lean.enterprise.middleware > 0771100911 > > On Wed, Sep 10, 2014 at 2:16 AM, stevegyc <[email protected]> wrote: > >> Hi: >> >> >> When I generated dss server by using a given database structure, it failed >> and following error log displayed. >> >> >> TID: [0] [DSS] [2014-09-09 14:50:42,957] WARN >> {org.wso2.carbon.dataservices.core.script.DSGenerator} - Insert operation >> not created {org.wso2.carbon.dataservices.core.script.DSGenerator} >> DS Code: UNKNOWN_ERROR >> Nested Exception:- >> DS Fault Message: Invalid query param sqlType: 'null'. >> DS Code: UNKNOWN_ERROR >> >> at >> org.wso2.carbon.dataservices.core.engine.QueryParam.validateQueryParam(QueryParam.java:123) >> >> at >> org.wso2.carbon.dataservices.core.engine.QueryParam.<init>(QueryParam.java:76) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.getQueryParamList(DSGenerator.java:754) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.getInsertQuery(DSGenerator.java:687) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.addInsertOperation(DSGenerator.java:472) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.addOperations(DSGenerator.java:236) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.makeService(DSGenerator.java:197) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.generateService(DSGenerator.java:160) >> >> at >> org.wso2.carbon.dataservices.core.script.DSGenerator.<init>(DSGenerator.java:108) >> >> at >> org.wso2.carbon.dataservices.core.admin.DataServiceAdmin.getDSService(DataServiceAdmin.java:447) >> >> >> My DB is oracle and my table only include 4 datatypes NUMBER, VARCHAR2, DATE >> and TIMESTAMP, such as following: >> create table INFO >> ( >> object_id NUMBER(18) not null, >> oc_name VARCHAR2(50), >> last_time DATE, >> insert_time TIMESTAMP(3) default SYSDATE, >> ) >> >> >> It seems DSS does not support the datatype of "TIMESTAMP", When I delete the >> datatype of "TIMESTAMP", it can generate dss server successfully. >> >> I do not know why DSS do not support datatype of "TIMESTAMP" and how to >> solve it. >> >> ------------------------------ >> stevegyc >> >> _______________________________________________ >> Dev mailing list >> [email protected] >> http://wso2.org/cgi-bin/mailman/listinfo/dev >> >> >
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
