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
