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
Date: 2014-09-10 10:25
To: stevegyc
CC: dev
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
