[Building Sakai] Turnitin integration with sakai2.8

[Stoufer,R M]

Hello Jehan,

We had the same issue.  The solution is to add the ERRORCODE column to the CONTENTREVIEW_ITEM table.  The SQL we used was:

ALTER TABLE CONTENTREVIEW_ITEM
   ADD (ERRORCODE number (10,0));

Mike


R. Michael Stoufer
Academic Technology - ICS
University of Florida



From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Jehan
Sent: Friday, November 25, 2011 2:41 PM
To: sakai-dev at collab. org
Subject: [Building Sakai] Turnitin integration with sakai2.8

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/20111129/d355e239/attachment.html