VariableInstanceDbTest testDate failure MSSQL jtds

[andrewbruno]

The testDate method of VariableInstanceDbTest fails when using MSSQL2000 with the jtds driver.

expected:<Thu Aug 25 11:48:11 EST 2005> but was:<2005-08-25 11:48:11.327>

junit.framework.AssertionFailedError: expected:<Thu Aug 25 11:48:11 EST 2005> but was:<2005-08-25 11:48:11.327> at org.jbpm.context.exe.VariableInstanceDbTest.testDate(VariableInstanceDbTest.java:143)

The code snip is:

public void testDate() {
Date now = new Date();
contextInstance.setVariable("a", now);
processInstance = saveAndReload(processInstance);
contextInstance = processInstance.getContextInstance();
assertEquals(now, contextInstance.getVariable("a"));
}

Any ideas? Is there something I can do in terms of configuration?

Thanks, Andrew

[aguizar]

Andrew,

In topic http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3891717#3891717 you reference the jbpm.db project. Did the configuration from jbpm.db solve this problem?

If it didn't, note that your datetimes differ only by milliseconds. Take a look at https://sourceforge.net/forum/forum.php?thread_id=1292904&forum_id=240086. It discusses the issue of datetime accuracy in databases, particularly MSSQL.