[opencms-dev] JPA driver for 7.5.2

[Yves Glodt]

I think I found an issue in my code.

I have a jsp which logs in a user (CmsObject.loginUser()), gets a list of
image resources, and displays 3 by random.
Now I can imagine the deadlock comes when several people hit the site
concurrently.

I should find a better way to dislpay random resources I guess.

best regards,
yves

On 21 May 2010 09:58, Yves Glodt <yg at mind.lu> wrote:

> Hi!
>
> I think there should be no simultaneous logins... But I can not be sure if
> some people left a browser somewhere open with a logged session...
>
> Good news about jpa 2.0, I will wait for that. Hopefully I can upgrade
> 7.5.2 by just replacing the relevant jars... :-)
>
> yves
>
>
> On 21 May 2010 09:50, Georgi Naplatanov <gosho at oles.biz> wrote:
>
>> Hello Yves.
>>
>> In your case if there are not simultaneous logins with the same user
>> name, it sounds like a bug.
>>
>> These days OpenJPA 2.0 is available and I will build OpenCms with this
>> version of OpenJPA which contains a lot of bug fixes.
>>
>> Best regards
>> Georgi
>>
>> Yves Glodt wrote:
>> > Hi Georgi,
>> >
>> > I use only the workplace here.
>> >
>> > On 20 May 2010 14:40, Georgi Naplatanov <gosho at oles.biz
>> > <mailto:gosho at oles.biz>> wrote:
>> >
>> >     Hello Yves.
>> >
>> >     OpenCms updates user last login when user login on.
>> >
>> >     Do you use cms shell or this exception occurs when you use workplace
>> ?
>> >
>> >     Best regards
>> >     Georgi
>> >
>> >     Yves Glodt wrote:
>> >      > Hi Georgii,
>> >      >
>> >      > I am using the jpa-builds with Firebird 2.1 quite intensively,
>> and
>> >      > frequently see this in the logs:
>> >      >
>> >      > SEVERE: Servlet.service() for servlet jsp threw exception
>> >      > org.apache.openjpa.lib.jdbc.ReportingSQLException: GDS Exception.
>> >      > 335544336. deadlock
>> >      > update conflicts with concurrent update
>> >      > No message for code 335544878 found.
>> >      > null {prepstmnt 1344045115 UPDATE CMS_USERS SET USER_LASTLOGIN =
>> >     ? WHERE
>> >      > USER_ID = ? [params=(long) 1274353716094, (String)
>> >      > ea551c31-xxxx-yyyy-zzzz-1234567890]} [code=335544336,
>> state=HY000]
>> >      >
>> >      > Do you have an idea where these deadlocks come from?
>> >      > If you need more details, let me know!
>> >      >
>> >      > best regards,
>> >      > Yves
>> >      >
>> >      > On 21 January 2010 16:17, Achim Westermann
>> >     <achim.westermann at questico.de <mailto:achim.westermann at questico.de>
>> >      > <mailto:achim.westermann at questico.de
>> >     <mailto:achim.westermann at questico.de>>> wrote:
>> >      >
>> >      >     Hi Georgi,
>> >      >
>> >      >     that was quick!
>> >      >
>> >      >     thx for sharing your work.
>> >      >
>> >      >     Achim
>> >      >
>> >      >     Georgi Naplatanov wrote:
>> >      >      > binary -
>> >      >      >
>> >      >
>> >
>> http://os.oles.biz/opencms/jpa-driver/opencms_7.5.2-jpa-2010-01-21.zip
>> >      >      >
>> >      >      > source code -
>> >     https://opencms-jpa.oles.biz/opencmsjpa/branches/7.5.2/
>> >      >      >
>> >      >      > Best regards
>> >      >      > Georgi
>> >      >      >
>> >      >      > _______________________________________________
>> >      >      > This mail is sent to you from the opencms-dev mailing list
>> >      >      > To change your list options, or to unsubscribe from the
>> list,
>> >      >     please visit
>> >      >      > http://lists.opencms.org/mailman/listinfo/opencms-dev
>> >      >      >
>> >      >
>> >      >
>> >      >     _______________________________________________
>> >      >     This mail is sent to you from the opencms-dev mailing list
>> >      >     To change your list options, or to unsubscribe from the list,
>> >     please
>> >      >     visit
>> >      >     http://lists.opencms.org/mailman/listinfo/opencms-dev
>> >      >
>> >      >
>> >      >
>> >      >
>> >
>> ------------------------------------------------------------------------
>> >      >
>> >      >
>> >      > _______________________________________________
>> >      > This mail is sent to you from the opencms-dev mailing list
>> >      > To change your list options, or to unsubscribe from the list,
>> >     please visit
>> >      > http://lists.opencms.org/mailman/listinfo/opencms-dev
>> >
>> >
>> >     _______________________________________________
>> >     This mail is sent to you from the opencms-dev mailing list
>> >     To change your list options, or to unsubscribe from the list, please
>> >     visit
>> >     http://lists.opencms.org/mailman/listinfo/opencms-dev
>> >
>> >
>> >
>> > ------------------------------------------------------------------------
>> >
>> >
>> > _______________________________________________
>> > This mail is sent to you from the opencms-dev mailing list
>> > To change your list options, or to unsubscribe from the list, please
>> visit
>> > http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100526/2798bdb3/attachment.htm>