[jboss-jira] [JBoss JIRA] Updated: (JBAS-6745) org.jboss.test.cmp2.audit.test.AuditUnitTestCase failing with MySQL - miliseconds not supported

[Shelly McGowan (JIRA)]

     [ https://jira.jboss.org/jira/browse/JBAS-6745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shelly McGowan updated JBAS-6745:
---------------------------------

    Fix Version/s: JBossAS-5.1.0.GA


> org.jboss.test.cmp2.audit.test.AuditUnitTestCase failing with MySQL - miliseconds not supported
> -----------------------------------------------------------------------------------------------
>
>                 Key: JBAS-6745
>                 URL: https://jira.jboss.org/jira/browse/JBAS-6745
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Test Suite
>    Affects Versions: JBossAS-5.1.0.Beta1
>         Environment: MySQL as DefaultDS
>            Reporter: Martin Malina
>            Assignee: Shelly McGowan
>             Fix For: JBossAS-5.1.0.GA
>
>
> Tests in org.jboss.test.cmp2.audit.test.AuditUnitTestCase are failing because MySQL does not support storage of miliseconds when storing DATETIME (or any other).
> (This is part of the effort of trying to run the jboss-all-config-tests target of the AS testsuite against different databases.)
> testUpdateAudit	Failure	Expected created time to be set between 1238076991121-1238076991136 during the test but got 1238076991000
> junit.framework.AssertionFailedError: Expected created time to be set between 1238076991121-1238076991136 during the test but got 1238076991000
> 	at org.jboss.test.cmp2.audit.test.AuditUnitTestCase.testUpdateAudit(AuditUnitTestCase.java:77)
> 	at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
> 	at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
> 	at junit.extensions.TestSetup.run(TestSetup.java:25)
> The problem is that the created time is saved in the DB, then retrieved and compared to the values taken before and after the audit was created.
> This is similar to JBPAPP-1063 where Emmanuel noted: "Actually I would expect the test to fail. We ened to tell our customer that MySQL will not be able to support millisecond timestamp."

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira