[opencms-dev] CmsScheduledJob and writeExportPoint

[Roman Uhlig]

Writing export points and therefore the exception happens while publishing
resources. As stated in the bug report posted earlier in this thread, this
did not happen until OpenCms 6.2.2. In 6.2.1 everything was working fine.

Using createResource is usually working fine. Especially when creating
(custom) XMLContent resources, it does the whole work like creating the
default XML structure inside the resource. We use it i.e. for our intranet
knowledge management, it has some advantages over classic wiki solutions.

Roman


Andy Bicksbo wrote:
> 
> Hi
> Is the method "createResource you use that one, which causes OpenCms to
> write the export points, or publishResource?
> I'm asking cause i had some problems with the publishResource, but i never
> used it with craeteResource. I write the files instead in xmlFiles and
> import them afterwords than i use:
> *publishProject*<http://www.opencms.org/export/javadoc/core/org/opencms/file/CmsObject.html#publishProject(org.opencms.report.I_CmsReport,
> org.opencms.file.CmsResource,
> boolean)>(I_CmsReport<http://www.opencms.org/export/javadoc/core/org/opencms/report/I_CmsReport.html>
> report,
> CmsResource<http://www.opencms.org/export/javadoc/core/org/opencms/file/CmsResource.html>
> directPublishResource,
> boolean directPublishSiblings)
> this one works fine...
> So please give me feedback aubout that, cause i'm very interested in that
> Thanks
> Andy
> 
> 
> 2006/10/13, Roman Uhlig <roman.uhlig at knve.de>:
>>
>>
>> Note: Looks like this is caused by the 6.2.2 bug addressed here:
>>
>> http://www.opencms.org/bugzilla/show_bug.cgi?id=1201
>>
>>
>>
>> Roman Uhlig wrote:
>> >
>> > Hi,
>> >
>> > I'm currently trying on my first CmsScheduledJob class to be executed
>> > within the OpenCms job schedule. Basically everything is quite
>> > straightforward and easy to use.
>> > Now I have to change and publish a resource within the launch() method
>> of
>> > my CmsScheduledJob class, which is working very well when executed
>> > manually within a jsp page. When getting executed inside the class at
>> it's
>> > scheduled execution time, the following exception is noted inside the
>> log
>> > file:
>> >
>> > 11 Oct 2006 14:58:22,091 ERROR [rg.opencms.db.CmsDriverManager:7243]
>> Error
>> > writing export points.
>> > org.opencms.db.CmsDbSqlException: An SQL error occurred when executing
>> the
>> > following query: .
>> >         at
>> > org.opencms.db.generic.CmsProjectDriver.readPublishedResources(
>> CmsProjectDriver.java:2174)
>> >         at
>> > org.opencms.db.CmsDriverManager.writeExportPoints(CmsDriverManager.java
>> :7146)
>> >         at
>> > org.opencms.db.CmsDriverManager.cmsEvent(CmsDriverManager.java:999)
>> >         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:152)
>> >         at
>> > org.opencms.db.CmsDriverManager.publishProject(CmsDriverManager.java
>> :4535)
>> >         at
>> >
>> org.opencms.db.CmsSecurityManager.publishProject(CmsSecurityManager.java
>> :2893)
>> >         at org.opencms.file.CmsObject.publishProject(CmsObject.java
>> :1975)
>> >         at org.opencms.file.CmsObject.publishProject(CmsObject.java
>> :1998)
>> >         at org.opencms.file.CmsObject.publishResource(CmsObject.java
>> :2033)
>> >         at org.opencms.file.CmsObject.publishResource(CmsObject.java
>> :2016)
>> >         at
>> > com.idaba.common.IdabaGoogleSitemap.launch(IdabaGoogleSitemap.java:75)
>> >         at
>> >
>> org.opencms.scheduler.CmsScheduleManager.execute(CmsScheduleManager.java
>> :171)
>> >         at org.quartz.core.JobRunShell.run(JobRunShell.java:191)
>> >         at
>> > org.opencms.scheduler.CmsSchedulerThread.run(CmsSchedulerThread.java
>> :123)
>> > Caused by: java.sql.SQLException: Unsupported project ID "-1" to return
>> a
>> > JDBC connection.
>> >         at
>> > org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java
>> :502)
>> >         at
>> > org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java
>> :247)
>> >         at
>> > org.opencms.db.generic.CmsProjectDriver.readPublishedResources(
>> CmsProjectDriver.java:2149)
>> >         ... 15 more
>> >
>> > Note: com.idaba.common.IdabaGoogleSitemap is the custom class mentioned
>> > above.
>> >
>> > I can't really see a conection to my code inside the launch method,
>> thats
>> > why I'm asking this here. Anything is working well, the resource gets
>> > published. Just writing export points seems to fail. Any ideas or
>> > experience on this?
>> >
>> > Here's the relevant code of my implementation of
>> > I_CmsScheduledJob.launch():
>> >
>> > public class IdabaGoogleSitemap implements I_CmsScheduledJob {
>> >     ...
>> >     public String launch(CmsObject arg0, Map arg1) throws Exception {
>> >         ....
>> >         cmso.createResource(portal_prefix + "/" + sitemap_filename,
>> > i_restype_plain_id, s_content.getBytes(), list_props);
>> >         cmso.unlockResource(portal_prefix + "/" + sitemap_filename);
>> >         cmso.publishResource(portal_prefix + "/" + sitemap_filename);
>> >         ...
>> >     }
>> > }
>> >
>> > Thanks in advance,
>> > Roman
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/CmsScheduledJob-and-writeExportPoint-tf2424139.html#a6792396
>> Sent from the OpenCMS - Dev mailing list archive at Nabble.com.
>>
>>
>> _______________________________________________
>> 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
> 

-- 
View this message in context: http://www.nabble.com/CmsScheduledJob-and-writeExportPoint-tf2424139.html#a6794018
Sent from the OpenCMS - Dev mailing list archive at Nabble.com.