[Building Sakai] Turnitin integration with sakai2.8

[Jehan]

Dear All

I have integrated Turnitin with Sakai.

I am specifying quartz jobs trigger expression as 0 0/5 * * * ?

and  getting following error on command prompt

2011-11-26 00:30:50,378 ERROR QuartzScheduler_Worker-5
org.quartz.core.ErrorLogger - Job (DEFAULT.*Process Content Review
Reports*threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.*
SQLGrammarException*: could not execute query]
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)



2011-11-26 00:31:01,531  INFO QuartzScheduler_Worker-2
org.sakaiproject.contentreview.impl.turnitin.TurnitinReviewServiceImpl -
Processing submission queue
2011-11-26 00:31:01,533  WARN QuartzScheduler_Worker-2
org.hibernate.util.JDBCExceptionReporter - SQL Error: 1054, SQLState: 42S22
2011-11-26 00:31:01,533 ERROR QuartzScheduler_Worker-2
org.hibernate.util.JDBCExceptionReporter -* Unknown column
'this_.errorCode' in 'field list'*
2011-11-26 00:31:01,533 ERROR QuartzScheduler_Worker-2
org.quartz.core.JobRunShell - Job DEFAULT.*Process Content Review
Queue*threw an unhandled Exception:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.*
SQLGrammarException*: could not execute query
at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
at
org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:424)
at
org.springframework.orm.hibernate3.HibernateTemplate.executeWithNativeSession(HibernateTemplate.java:374)
at
org.springframework.orm.hibernate3.HibernateTemplate.findByCriteria(HibernateTemplate.java:1055)
at
org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.baseFindBySearch(HibernateBasicGenericDao.java:154)
at
org.sakaiproject.genericdao.hibernate.HibernateBasicGenericDao.findBySearch(HibernateBasicGenericDao.java:237)


2011-11-26 00:31:01,534 ERROR QuartzScheduler_Worker-2
org.quartz.core.ErrorLogger - Job (DEFAULT*.Process Content Review
Queue*threw an exception.
org.quartz.SchedulerException: Job threw an unhandled exception. [See
nested exception:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.*
SQLGrammarException*: could not execute query]
at org.quartz.core.JobRunShell.run(JobRunShell.java:213)
at
org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:534)
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException:
could not execute query; nested exception is
org.hibernate.exception.SQLGrammarException: could not execute query
at
org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:630)
at
org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20111126/ae91369e/attachment.html