Web service - time zone

[former_member190457]

Hi all,

I have my db table where dates are stored. I correctly retrieve the time from the field on server side: 09.30.00

Now I have exposed this service as WebService. When I call this WS from WDJ I get: 10.30.00

When I call this webservice from webservice navigator I get: 08.30.00

I think that something like a locale should be specified for webservice.

Can anyone please help?

Thanks, regards

Vincenzo

[Former Member]

Hi,

Datatype "time" should have timezone associated with it. If it is not associated then calling application will assume time as GMT/UTC and covert them automatically as per timezone of calling server.

If your service is custom created then add "timezone" as attribute which can be hardcoded in code or filled dynamically as per servier time.

WDJ may be treating this time as GMT time.

Locale in webservice is not automatically assigned, you need to define parameters and assign them in service implementation.

Regards,

Gourav

[former_member190457]

Hi thanks for your reply,

Actually what is output from the webservice is:

1970-01-01T09:30:47.000+01:00

So GMT+1 is the timezone (correct).

WS Navigator shows 8.30 because it converts time in GMT (still consistent)

What do you exactly mean add a timezone attribute?

Timezone is already in WS output as far as I can see from WS Navigator, could you elaborate?

Thanks, regards

Vincenzo

[Former Member]

Hi,

This means webservice giving you correct output as per timezone and problem occuring in WDJ only.

Check following:

-> timezone of your DB server.

-> timezone of Java engine where WDJ is executing.

-> timezone of your wsnavigator.

I am not expert in WDJ but I belive you can assign timezone or locale to controls in WDJ.

addition of attribute is not necessary as it is taking timezone by default (this could be also source of problem if your DB server is not maintaining timezone).

post above details and we will see how to resolve this issue.

Regards,

Gourav