The tentative date for the DSS 3.2.2 release is Sep 26th. You can find DSS
release dates from [1]

[1]
https://wso2.org/jira/browse/DS#selectedTab=com.atlassian.jira.plugin.system.project%3Aversions-panel

On Wed, Sep 10, 2014 at 2:59 PM, stevegyc <[email protected]> wrote:

>   Hi Chanika:
>
>     Thank you very much!
>     By the way, do you know when DSS 3.2.2 will be released?
>
> ------------------------------
> stevegyc
>
>  *From:* Chanika Geeganage <[email protected]>
> *Date:* 2014-09-10 17:24
> *To:* stevegyc <[email protected]>
> *CC:* Dakshika Jayathilaka <[email protected]>; dev <[email protected]>
> *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 <[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
>
>


-- 
Best Regards..

Chanika Geeganage
Software Engineer
WSO2, Inc.; http://wso2.com
_______________________________________________
Dev mailing list
[email protected]
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to