Hi Chanika:
Thank you very much!
By the way, do you know when DSS 3.2.2 will be released?
stevegyc
From: Chanika Geeganage
Date: 2014-09-10 17:24
To: stevegyc
CC: Dakshika Jayathilaka; dev
Subject: Re: [Dev] [DSS]Generating Using a Given Database Structure failed
Hi,
I was able to reproduce this error. From the corresponding resultSet (for
TIMESTAMP type), when we try to get the SQL Type using
resultSet.getInt("DATA_TYPE") it gives 1111 which is mapped to SQL Type 'OTHER'
[1]. It is an issue in the Oracle ResultSet Implementation, anyway we will
handle this in the DSS 3.2.2 by converting that to a STRING value. I have
created a JIRA to track this issue.
[1]
http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Types.DATE
[2] https://wso2.org/jira/browse/DS-959
Thanks
On Wed, Sep 10, 2014 at 1:17 PM, stevegyc <steve...@163.com> wrote:
Hi Dakshika:
Thank you for your reply.
But it is difficult for me to change the format of "TIMESTAMP".
Can you tell me the location of the related code approximately?
stevegyc
From: Dakshika Jayathilaka
Date: 2014-09-10 14:41
To: stevegyc
CC: dev
Subject: Re: Re: [Dev] [DSS]Generating Using a Given Database Structure failed
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 <steve...@163.com> 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
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 <steve...@163.com> 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
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
--
Best Regards..
Chanika Geeganage
Software Engineer
WSO2, Inc.; http://wso2.com_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev
