[jira] Created: (OFBIZ-1624) Dates used in ManufacturingExampleData.xml incompatible with mysql

[Nicolas Malin (Jira)]

Dates used in ManufacturingExampleData.xml incompatible with mysql
------------------------------------------------------------------

                 Key: OFBIZ-1624
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1624
             Project: OFBiz
          Issue Type: Bug
          Components: manufacturing
    Affects Versions: SVN trunk
            Reporter: Chris Lombardi
            Priority: Minor


I'll look into this tomorrow.

When I run "ant run-install" I get the following errors:

     [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:217:INFO ] Beginning import from URL: file:/home/clombard/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
     [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:255:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
     [java] 2008-02-07 21:24:56,642 (main) [    EntitySaxReader.java:556:WARN ]
     [java] ---- runtime exception report --------------------------------------------------
     [java] Could not set field FixedAsset.dateAcquired to the value 2005-1-1 00:01:00.0
     [java] Exception: java.lang.IllegalArgumentException
     [java] Message: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
     [java] ---- stack trace ---------------------------------------------------------------
     [java] java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
     [java] java.sql.Timestamp.valueOf(Timestamp.java:194)
     [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:469)
     [java] org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
     [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
     [java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
     [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
     [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
     [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
     [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
     [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
     [java] org.ofbiz.base.start.Start.startServer(Start.java:310)
     [java] org.ofbiz.base.start.Start.start(Start.java:314)
     [java] org.ofbiz.base.start.Start.main(Start.java:397)


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chris Lombardi updated OFBIZ-1624:
----------------------------------

    Attachment: ofbiz-1624.patch

This fixes the issue.

> Dates used in ManufacturingExampleData.xml incompatible with mysql
> ------------------------------------------------------------------
>
>                 Key: OFBIZ-1624
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1624
>             Project: OFBiz
>          Issue Type: Bug
>          Components: manufacturing
>    Affects Versions: SVN trunk
>            Reporter: Chris Lombardi
>            Priority: Minor
>         Attachments: ofbiz-1624.patch
>
>
> I'll look into this tomorrow.
> When I run "ant run-install" I get the following errors:
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:217:INFO ] Beginning import from URL: file:/home/clombard/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:255:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
>      [java] 2008-02-07 21:24:56,642 (main) [    EntitySaxReader.java:556:WARN ]
>      [java] ---- runtime exception report --------------------------------------------------
>      [java] Could not set field FixedAsset.dateAcquired to the value 2005-1-1 00:01:00.0
>      [java] Exception: java.lang.IllegalArgumentException
>      [java] Message: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] ---- stack trace ---------------------------------------------------------------
>      [java] java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] java.sql.Timestamp.valueOf(Timestamp.java:194)
>      [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:469)
>      [java] org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
>      [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
>      [java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
>      [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
>      [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
>      [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
>      [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
>      [java] org.ofbiz.base.start.Start.startServer(Start.java:310)
>      [java] org.ofbiz.base.start.Start.start(Start.java:314)
>      [java] org.ofbiz.base.start.Start.main(Start.java:397)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bilgin Ibryam reassigned OFBIZ-1624:
------------------------------------

    Assignee: Bilgin Ibryam

> Dates used in ManufacturingExampleData.xml incompatible with mysql
> ------------------------------------------------------------------
>
>                 Key: OFBIZ-1624
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1624
>             Project: OFBiz
>          Issue Type: Bug
>          Components: manufacturing
>    Affects Versions: SVN trunk
>            Reporter: Chris Lombardi
>            Assignee: Bilgin Ibryam
>            Priority: Minor
>         Attachments: ofbiz-1624.patch
>
>
> I'll look into this tomorrow.
> When I run "ant run-install" I get the following errors:
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:217:INFO ] Beginning import from URL: file:/home/clombard/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:255:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
>      [java] 2008-02-07 21:24:56,642 (main) [    EntitySaxReader.java:556:WARN ]
>      [java] ---- runtime exception report --------------------------------------------------
>      [java] Could not set field FixedAsset.dateAcquired to the value 2005-1-1 00:01:00.0
>      [java] Exception: java.lang.IllegalArgumentException
>      [java] Message: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] ---- stack trace ---------------------------------------------------------------
>      [java] java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] java.sql.Timestamp.valueOf(Timestamp.java:194)
>      [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:469)
>      [java] org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
>      [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
>      [java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
>      [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
>      [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
>      [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
>      [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
>      [java] org.ofbiz.base.start.Start.startServer(Start.java:310)
>      [java] org.ofbiz.base.start.Start.start(Start.java:314)
>      [java] org.ofbiz.base.start.Start.main(Start.java:397)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

     [ https://issues.apache.org/jira/browse/OFBIZ-1624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bilgin Ibryam closed OFBIZ-1624.
--------------------------------

       Resolution: Fixed
    Fix Version/s: SVN trunk

Thanks Chris
Your patch is in trunk rev 629016.

> Dates used in ManufacturingExampleData.xml incompatible with mysql
> ------------------------------------------------------------------
>
>                 Key: OFBIZ-1624
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1624
>             Project: OFBiz
>          Issue Type: Bug
>          Components: manufacturing
>    Affects Versions: SVN trunk
>            Reporter: Chris Lombardi
>            Assignee: Bilgin Ibryam
>            Priority: Minor
>             Fix For: SVN trunk
>
>         Attachments: ofbiz-1624.patch
>
>
> I'll look into this tomorrow.
> When I run "ant run-install" I get the following errors:
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:217:INFO ] Beginning import from URL: file:/home/clombard/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>      [java] 2008-02-07 21:24:56,633 (main) [    EntitySaxReader.java:255:INFO ] Transaction Timeout set to 2 hours (7200 seconds)
>      [java] 2008-02-07 21:24:56,642 (main) [    EntitySaxReader.java:556:WARN ]
>      [java] ---- runtime exception report --------------------------------------------------
>      [java] Could not set field FixedAsset.dateAcquired to the value 2005-1-1 00:01:00.0
>      [java] Exception: java.lang.IllegalArgumentException
>      [java] Message: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] ---- stack trace ---------------------------------------------------------------
>      [java] java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
>      [java] java.sql.Timestamp.valueOf(Timestamp.java:194)
>      [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:469)
>      [java] org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:550)
>      [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source)
>      [java] javolution.xml.sax.XMLReaderImpl.parse(Unknown Source)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:258)
>      [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:218)
>      [java] org.ofbiz.entity.util.EntityDataLoader.loadData(EntityDataLoader.java:211)
>      [java] org.ofbiz.entityext.data.EntityDataLoadContainer.start(EntityDataLoadContainer.java:267)
>      [java] org.ofbiz.base.container.ContainerLoader.start(ContainerLoader.java:79)
>      [java] org.ofbiz.base.start.Start.startStartLoaders(Start.java:261)
>      [java] org.ofbiz.base.start.Start.startServer(Start.java:310)
>      [java] org.ofbiz.base.start.Start.start(Start.java:314)
>      [java] org.ofbiz.base.start.Start.main(Start.java:397)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.