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
