[Building Sakai] Samigo question

[Matthew Jones]

Yeah, looking at the code that is an issue introduced there. This is fixed
in hibernate (finally) but not until 4.1.7 which we haven't been able to
upgrade to yet mostly because of getHibernateTemplate, but also other
things that would come up.

In any case I can create a new related jira for this.

On Mon, Sep 8, 2014 at 12:11 PM, Omer A Piperdi <omer at rice.edu> wrote:

> We are seeing the following Oracle error with Samigo when a user click
> Published Assessments | Scores | Questions.
>
> 2014-09-04 13:29:36,533  WARN http-bio-8443-exec-246
> org.hibernate.util.JDBCExceptionReporter - SQL Error: 1795, SQLState: 42000
> 2014-09-04 13:29:36,534 ERROR http-bio-8443-exec-246
> org.hibernate.util.JDBCExceptionReporter - ORA-01795: maximum number of
> expressions in a list is 1000
>
> org.springframework.dao.InvalidDataAccessResourceUsageException: could
> not execute query; SQL [select publishedi0_.ITEMID as ITEMID218_,
> publishedi0_.SECTIONID as SECTIONID218_, publishedi0_.ITEMIDSTRING as
> ITEMIDST3_218_, publishedi0_.SEQUENCE as SEQUENCE218_,
> publishedi0_.DURATION as DURATION218_, publishedi0_.TRIESALLOWED as
> TRIESALL6_218_, publishedi0_.INSTRUCTION as INSTRUCT7_218_,
> publishedi0_.DESCRIPTION as DESCRIPT8_218_, publishedi0_.TYPEID as
> TYPEID218_, publishedi0_.GRADE as GRADE218_, publishedi0_.SCORE as
> SCORE218_, publishedi0_.DISCOUNT as DISCOUNT218_,
> publishedi0_.ANSWER_OPTIONS_RICH_COUNT as ANSWER13_218_,
> publishedi0_.ANSWER_OPTIONS_SIMPLE_OR_RICH as ANSWER14_218_,
> publishedi0_.HINT as HINT218_, publishedi0_.HASRATIONALE as
> HASRATI16_218_, publishedi0_.PARTIAL_CREDIT_FLAG as PARTIAL17_218_,
> publishedi0_.STATUS as STATUS218_, publishedi0_.CREATEDBY as
> CREATEDBY218_, publishedi0_.CREATEDDATE as CREATED20_218_,
> publishedi0_.LASTMODIFIEDBY as LASTMOD21_218_,
> publishedi0_.LASTMODIFIEDDATE as LASTMOD22_218_ from SAM_PUBLISHEDITEM_T
> publishedi0_ where publishedi0_.ITEMID in (? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?
> , ? , ? , ? , ? , ? ,...
>
> Basically Oracle won't allow more than 1000 in 'in' of select
> statement.. It works when I reverts (
> https://jira.sakaiproject.org/browse/SAM-2192 ) which was using sub
> select in query.
>
> I am wondering if anyone see this problem or any other issue by
> reverting the above JIRA.
>
> Thanks
> Omer
>
>
>
>
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> sakai-dev-unsubscribe at collab.sakaiproject.org with a subject of
> "unsubscribe"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140908/f2a2c59c/attachment.html