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 <[email protected]> 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 <[email protected]>
> *Date:* 2014-09-10 14:41
> *To:* stevegyc <[email protected]>
> *CC:* dev <[email protected]>
> *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 <[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
>
>
--
Best Regards..
Chanika Geeganage
Software Engineer
WSO2, Inc.; http://wso2.com
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev
