[ 
https://issues.apache.org/jira/browse/OFBIZ-925?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492128
 ] 

Krzysztof Podejma commented on OFBIZ-925:
-----------------------------------------

on Derby two login timestamps look like this
2007-04-26 23:48:15.75
2007-04-26 23:48:15.828
date               time        ms?

but on MySQL the same timestamps:
2007-04-26 23:48:15
2007-04-26 23:48:15

this timestamp field is part of primary key(<prim-key field="fromDate"/>) so 
with MySQL it is possible to get login error if you try to login twice with the 
the same username in less than one second.

Krzysztof Podejma


> Duplicate entry for key 1) on login
> -----------------------------------
>
>                 Key: OFBIZ-925
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-925
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: SVN trunk
>         Environment: all i think 
>            Reporter: Krzysztof Podejma
>            Priority: Trivial
>
> in framework/security/entitydef/entitymodel.xml/UserLoginHistory are pkfields 
> <prim-key field="userLoginId"/> and <prim-key field="fromDate"/> so if you'r 
> fast in logout/login action, you can get nasty error ;]
> the best workaround i found is to add  <prim-key field="visitId"/> because 
> visitId seems to be unique for this entity.
> Regards
> Krzysztof Podejma

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

Reply via email to