[opencms-dev] OAMP Comments module & Firebird
Georgi Naplatanov
gosho at oles.biz
Thu Aug 5 12:09:28 CEST 2010
Hello Yves.
The problem with OAMP Comments module is in OAMP Webform module.
Look at
http://cvs.opencms.org/viewvc.cgi/alkacon/com.alkacon.opencms.formgenerator/src/com/alkacon/opencms/formgenerator/database/
There is database specific part.
HTH
Best regards
Georgi
Georgi Naplatanov wrote:
> Hello Yves.
>
> > How is the status of the jpa-build? Will it be part of the next official
> > release of OpenCms? :-)
>
> I don't know. This information should come from Alkacon, but it will be
> good JPA support to be included at least for modules.
>
> > Do you have a solution for this issue of mine:
> > http://permalink.gmane.org/gmane.comp.cms.opencms.devel/34179 ? :-)
>
> The comments module use SQL. You should rewrite some queries which
> contains "LIMIT" keyword. Look at this article
> (http://scott.yang.id.au/2004/01/limit-in-select-statements-in-firebird/).
>
> Best regards
> Georgi
>
> Yves Glodt wrote:
>> Hi Georgi,
>>
>> thanks for the info, that's how I worked around in fact :-)
>>
>> How is the status of the jpa-build? Will it be part of the next official
>> release of OpenCms? :-)
>>
>> And my last question would be:
>>
>> Do you have a solution for this issue of mine:
>> http://permalink.gmane.org/gmane.comp.cms.opencms.devel/34179 ? :-)
>>
>>
>> Best regards,
>> Yves
>>
>> On 4 August 2010 12:13, Georgi Naplatanov <gosho at oles.biz
>> <mailto:gosho at oles.biz>> wrote:
>>
>> Hello Yves.
>>
>> Thank you for this bug report.
>>
>> There is workaround. You can use "Context Menu/History" dialog to
>> restore online version of resource.
>>
>> Best regards
>> Georgi
>>
>> Yves Glodt wrote:
>> > Hi Gerogi,
>> >
>> > I found a small bug with the jpa-version. I get an exception
>> everytime I
>> > do "Undo changes", as follows:
>> >
>> > 26 Jul 2010 23:01:25,128 ERROR
>> [rg.opencms.workplace.CmsDialog:1452] The
>> > workplace dialog caused an error.
>> > org.opencms.file.CmsVfsException: Error undoing changes of resource
>> > "/demo_en/intro.html".
>> > at
>> org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:264)
>> > at
>> org.opencms.db.jpa.CmsDbContext.report(CmsDbContext.java:107)
>> > at
>> >
>> org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4876)
>> > at
>> >
>> org.opencms.file.types.A_CmsResourceType.undoChanges(A_CmsResourceType.java:804)
>> > at
>> org.opencms.file.CmsObject.undoChanges(CmsObject.java:4189)
>> > at
>> >
>> org.opencms.workplace.commons.CmsUndoChanges.performDialogOperation(CmsUndoChanges.java:489)
>> > at
>> >
>> org.opencms.workplace.commons.CmsUndoChanges.actionUndoChanges(CmsUndoChanges.java:217)
>> > at
>> >
>> org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.undochanges_jsp._jspService(undochanges_jsp.java:137)
>> > at
>> > org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> > at
>> >
>> org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
>> > at
>> >
>> org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
>> > at
>> org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
>> > at
>> >
>> org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:551)
>> > at
>> >
>> org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:488)
>> > at
>> >
>> org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)
>> > at
>> >
>> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
>> > at
>> org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:555)
>> > at
>> >
>> org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)
>> > at
>> >
>> org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
>> > at
>> > org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:829)
>> > at
>> org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:512)
>> > at
>> >
>> org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:1052)
>> > at
>> org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1504)
>> > at
>> org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:153)
>> > at
>> org.opencms.main.OpenCmsServlet.doPost(OpenCmsServlet.java:166)
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
>> > at
>> javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>> > at
>> >
>> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>> > at
>> >
>> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>> > at
>> >
>> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>> > at
>> >
>> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>> > at
>> >
>> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>> > at
>> >
>> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>> > at
>> >
>> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
>> > at
>> >
>> org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)
>> > at
>> >
>> org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
>> > at
>> >
>> org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)
>> > at java.lang.Thread.run(Thread.java:619)
>> > Caused by: java.lang.NullPointerException
>> > at
>> >
>> org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:149)
>> > at
>> >
>> org.opencms.db.CmsPublishedResource.<init>(CmsPublishedResource.java:138)
>> > at
>> >
>> org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.reIndexResources(CmsSearchManager.java:262)
>> > at
>> >
>> org.opencms.search.CmsSearchManager$CmsSearchOfflineHandler.cmsEvent(CmsSearchManager.java:173)
>> > at
>> >
>> org.opencms.main.CmsEventManager.fireEventHandler(CmsEventManager.java:203)
>> > at
>> > org.opencms.main.CmsEventManager.fireEvent(CmsEventManager.java:126)
>> > at org.opencms.main.OpenCms.fireCmsEvent(OpenCms.java:156)
>> > at
>> > org.opencms.db.jpa.CmsVfsDriver.createResource(CmsVfsDriver.java:757)
>> > at
>> >
>> org.opencms.db.CmsDriverManager.createResource(CmsDriverManager.java:1747)
>> > at
>> >
>> org.opencms.db.CmsDriverManager.undoContentChanges(CmsDriverManager.java:9544)
>> > at
>> >
>> org.opencms.db.CmsDriverManager.undoChanges(CmsDriverManager.java:7679)
>> > at
>> >
>> org.opencms.db.CmsSecurityManager.undoChanges(CmsSecurityManager.java:4874)
>> >
>> >
>> > On 26 May 2010 09:45, Yves Glodt <yg at mind.lu <mailto:yg at mind.lu>
>> <mailto:yg at mind.lu <mailto:yg at mind.lu>>> wrote:
>> >
>> > 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
>> <mailto:yg at mind.lu> <mailto:yg at mind.lu <mailto: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
>> <mailto:gosho at oles.biz>
>> > <mailto:gosho at oles.biz <mailto: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>
>> > <mailto:gosho at oles.biz <mailto:gosho at oles.biz>>
>> > > <mailto:gosho at oles.biz <mailto:gosho at oles.biz>
>> <mailto: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>>
>> > <mailto:achim.westermann at questico.de
>> <mailto:achim.westermann at questico.de>
>> > <mailto:achim.westermann at questico.de
>> <mailto:achim.westermann at questico.de>>>
>> > > > <mailto:achim.westermann at questico.de
>> <mailto:achim.westermann at questico.de>
>> > <mailto:achim.westermann at questico.de
>> <mailto:achim.westermann at questico.de>>
>> > > <mailto: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
More information about the opencms-dev
mailing list