You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Adil BEN EL KHATTAB (JIRA)" <ji...@apache.org> on 2009/01/25 20:31:02 UTC
[jira] Created: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
---------------------------------------------------------------------------
Key: OFBIZ-2139
URL: https://issues.apache.org/jira/browse/OFBIZ-2139
Project: OFBiz
Issue Type: Bug
Components: framework
Affects Versions: SVN trunk
Environment: WinXP / JDK1.6 / Postgre8.3
Reporter: Adil BEN EL KHATTAB
When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
Error is:
2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
Expected behavior > 2 options:
1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12677718#action_12677718 ]
Jacques Le Roux commented on OFBIZ-2139:
----------------------------------------
Hi Adil,
Could you please provide a patch for this ?
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Adil BEN EL KHATTAB (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Adil BEN EL KHATTAB updated OFBIZ-2139:
---------------------------------------
Yes. I created a service with export='true'.
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Adrian Crum (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667129#action_12667129 ]
Adrian Crum commented on OFBIZ-2139:
------------------------------------
Since the Timestamp string format is beyond our control - http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Timestamp.html#valueOf(java.lang.String) - we should find out why the SOAP service is returning another format and see if it can be changed.
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Adil BEN EL KHATTAB (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12667135#action_12667135 ]
Adil BEN EL KHATTAB commented on OFBIZ-2139:
--------------------------------------------
So this excludes option 2 above. Option 1, however, is still a valid solution to this problem.
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Mike Fanning (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12783261#action_12783261 ]
Mike Fanning commented on OFBIZ-2139:
-------------------------------------
I ran into this issue while exporting services. It's not just a matter of one timestamp format or another, the SOAP handler passes all the parameters to the service as strings, which then causes the exception. I have a patch for this issue, but it doesn't directly address Adil's options. Should I attach it to this issue?
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12783266#action_12783266 ]
Jacques Le Roux commented on OFBIZ-2139:
----------------------------------------
Hi Mike,
yes please do, we will review for sure.
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2139) Service validation doesnt accept
timestamp format 2009-01-15T00:00:00.000Z
Posted by "Jacques Le Roux (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12674053#action_12674053 ]
Jacques Le Roux commented on OFBIZ-2139:
----------------------------------------
Adil,
When you say
{quote}
When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'.
{quote}
Do you mean using an OFBiz service with export="true" ?
> Service validation doesnt accept timestamp format 2009-01-15T00:00:00.000Z
> ---------------------------------------------------------------------------
>
> Key: OFBIZ-2139
> URL: https://issues.apache.org/jira/browse/OFBIZ-2139
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: SVN trunk
> Environment: WinXP / JDK1.6 / Postgre8.3
> Reporter: Adil BEN EL KHATTAB
>
> When I request a value of type timestamp through a SOAP service call, the value returned has the format '2009-01-15T00:00:00.000Z'. When I return the same value as IN parameter to another service for updating the same field the value is not accepted as a valid timestamp.
> Error is:
> 2009-01-25 18:54:44,919 (TP-Processor3) [ RequestHandler.java:326:ERROR] Request SOAPService caused an error with the following message: Error calling event: org.ofbiz.webapp.event.EventHandlerException: Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String] (Type check failed for field [updateRelative.thruDate]; expected type is [java.sql.Timestamp]; actual type is [java.lang.String])
> Expected behavior > 2 options:
> 1. format 2009-01-15T00:00:00.000Z should be accepted as a valid timestamp
> 2. timestamp should be returned by SOAP service as '2009-01-15 00:00:00.000'
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.