[Using Sakai] Samigo: saving files answers to database not working
Mame-Awa Diop
mame-awa.diop at hec.ca
Mon Dec 12 13:31:51 PST 2011
Thanks Karen. Your answer really helped.
Awa for the OpenSyllabus team,
-------- Message original --------
Sujet : Re: [Using Sakai] Samigo: saving files answers to database not
working
De : Karen Tsao <ktsao at stanford.edu>
Pour : mame-awa.diop at hec.ca
Copie à : sakai-dev <sakai-dev at collab.sakaiproject.org>,
sakai-user at collab.sakaiproject.org
Date : 2011-12-08 18:58
> Hi Mame,
>
> The "/tmp" was meant as an example, not a 'default' value. We have
> aware of this confusion and changed the sakai.properties path in 2.8
> to avoid it (https://jira.sakaiproject.org/browse/SAM-662). However,
> if you change the path now, you will need to change the existing file
> paths to the new one in order to retrieve them (from /tmp/filename to
> /new path/filename).
>
> I cannot reproduce your error when saving files in db (I use trunk
> code). The error message doesn't give me enough information either.
> But we do recommend saving data to filesystem. Maybe you should still
> save your data in filesystem?
>
> Thanks,
> Karen
>
> On Thu, Dec 8, 2011 at 1:06 PM, Mame-Awa Diop <mame-awa.diop at hec.ca
> <mailto:mame-awa.diop at hec.ca>> wrote:
>
> Hello,
>
> We have realized recently (after a major loss of files) that by
> default, Samigo saves the answer files of the student to the temp
> folder. I changed the property to now save in the database but I
> am getting an error that confuses me a bit:
>
> 2011-12-08 15:26:09,546 INFO http-8080-Processor24
> org.sakaiproject.tool.assessment.ui.listener.delivery.BeginDeliveryActionListener
> - ****DeliveryBean=
> org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean at ff8aa9
> 2011-12-08 15:28:16,625 WARN http-8080-Processor23
> org.sakaiproject.tool.assessment.facade.AssessmentGradingFacadeQueries
> - problem saving media: [B cannot be cast to java.sql.Blob
> 2011-12-08 15:28:16,640 WARN http-8080-Processor23
> org.sakaiproject.tool.assessment.services.PersistenceService -
> Error saving to db...retry again....
> 2011-12-08 15:28:16,671 WARN http-8080-Processor23
> org.sakaiproject.tool.assessment.services.PersistenceService -
> [B cannot be cast to java.sql.Blob
> 2011-12-08 15:28:16,718 ERROR http-8080-Processor23
> org.hibernate.AssertionFailure - an assertion failure occured
> (this may indicate a bug in Hibernate, but is more likely due
> to unsafe use of the session)
> org.hibernate.AssertionFailure: null id in
> org.sakaiproject.tool.assessment.data.dao.grading.MediaData
> entry (don't flush the Session after an exception occurs)
> at
> org.hibernate.event.def.DefaultFlushEntityEventListener.checkId(DefaultFlushEntityEventListener.java:55)
> at
> org.hibernate.event.def.DefaultFlushEntityEventListener.getValues(DefaultFlushEntityEventListener.java:164)
> at
> org.hibernate.event.def.DefaultFlushEntityEventListener.onFlushEntity(DefaultFlushEntityEventListener.java:120)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.flushEntities(AbstractFlushingEventListener.java:196)
> at
> org.hibernate.event.def.AbstractFlushingEventListener.flushEverythingToExecutions(AbstractFlushingEventListener.java:76)
> at
> org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:26)
> at
> org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1001)
> at
> org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:339)
> at
> org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)
> at
> org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
> at
> org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
> at
> org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)
> at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)
> at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
> at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
> at $Proxy57.saveMedia(Unknown Source)
> at
> org.sakaiproject.tool.assessment.services.GradingService.saveMedia(GradingService.java:418)
> at
> org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.saveMedia(DeliveryBean.java:1982)
> at
> org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.addMediaToItemGrading(DeliveryBean.java:1921)
> at
> org.sakaiproject.tool.assessment.ui.bean.delivery.DeliveryBean.addMediaToItemGrading(DeliveryBean.java:1842)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
> Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at
> com.sun.faces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:126)
> at
> javax.faces.component.UIInput.broadcast(UIInput.java:492)
> at javax.faces.component.UIData.broadcast(UIData.java:657)
> at javax.faces.component.UIData.broadcast(UIData.java:657)
> at
> javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:249)
> at
> javax.faces.component.UIViewRoot.processValidators(UIViewRoot.java:343)
> at
> com.sun.faces.lifecycle.ProcessValidationsPhase.execute(ProcessValidationsPhase.java:78)
> at
> com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:200)
> at
> com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:90)
>
> I tested it locally with MySql and on our test instance with
> Oracle and I am getting the same error.
>
> I would really appreciate it if you could held. We are running
> Sakai 2.7.1 with Samio 2.7.1.
>
> Thank you,
>
> --
>
> Mame Awa Diop
> Analyste en Informatique - Java
> Service de gestion des technologies et de l'information
> HEC Montréal
> 3000, chemin de la côte-Sainte-Catherine
> Montréal (Québec) H3T 2A7
>
> GTI: 514.340.6000 #12029 <tel:514.340.6000%20%2312029> - Bureau RJ-221e
> Projet OpenSyllabus: 514.340.6000 #12888 <tel:514.340.6000%20%2312888> - Bureau RJ-221
> Télécopieur: (514)340-5637 <tel:%28514%29340-5637>
>
>
>
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> <mailto:sakai-user at collab.sakaiproject.org>
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>
> TO UNSUBSCRIBE: send email to
> sakai-user-unsubscribe at collab.sakaiproject.org
> <mailto:sakai-user-unsubscribe at collab.sakaiproject.org> with a
> subject of "unsubscribe"
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20111212/045d538b/attachment.html
More information about the sakai-user
mailing list