[Building Sakai] Evaluation Tool

[Matthew Jones]

I'd check to make sure you have an up-to-date ojdbc6.jar from Oracle and
that the hierarchy_node table has the correct column types. If you came
from an existing database which was converted up to 10. It sounds like some
columns are varchar that it's expecting to be clob. The conversion script
for 10 expects you were never running hierarchy previously, and I think
there might be a note in the release notes about this.

>From this thread last month
http://collab.sakaiproject.org/pipermail/sakai-dev/2014-June/027541.html

That sounds like an error with hibernate and Oracle trying to figure out
the auto ddl for clob.  You can manually check to make sure that these
columns are set as CLOBS:

   - HIERARCHY_NODE.directChildIds
   - HIERARCHY_NODE.childIds


It sounds like those 2 were the most common problems for this error. I
haven't specially tested evaluation with Sakai under Oracle 10, but have
tested the latest hierarchy in 10.

http://ibatis.10938.n7.nabble.com/Beta-6-Oracle-Invalid-column-type-getCLOB-not-implemented-td16396.html


On Thu, Jul 3, 2014 at 7:11 AM, Miller, Jeffrey <
jeffrey.miller.ctr at usuhs.edu> wrote:

> Has anyone tried the evaluation tool with Sakai 10 and Oracle?  I tried
> https://source.sakaiproject.org/contrib/evaluation/branches/sakai-10.x/
> as well as a few other versions and nothing seems to work.  They all seem
> to exhibit the same failed behavior.  Here's an excerpt from the log:
>
> INFO Registered entity provider
> (org.sakaiproject.evaluation.logic.entity.EvaluationEntityProviderImpl)
> prefix (eval-evaluation) with 4 capabilities
>
> Jul 02, 2014 9:47:36 PM oracle.jdbc.driver.Accessor unimpl
>
> SEVERE: Throwing SQLException: 4getCLOB not implemented for class
> oracle.jdbc.driver.T4CVarcharAccessor
>
> 2014-07-02 21:47:36,163  WARN org.hibernate.util.JDBCExceptionReporter -
> SQL Error: 17004, SQLState: 99999
>
> 2014-07-02 21:47:36,163  ERROR org.hibernate.util.JDBCExceptionReporter -
> Invalid column type: getCLOB not implemented for class
> oracle.jdbc.driver.T4CVarcharAccessor
>
> 2014-07-02 21:47:36,207  ERROR
> org.sakaiproject.util.NoisierDefaultListableBeanFactory - Failed to
> preinstantiate the singleton named
> org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderAutoRegistrar.
> Destroying all Spring beans.
>
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name
> 'org.sakaiproject.entitybroker.impl.entityprovider.EntityProviderAutoRegistrar'
> defined in file
> [/home/jmiller/apache-tomcat-7.0.54/components/entitybroker-pack/WEB-INF/components.xml]:
> Initialization of bean failed; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name
> 'org.sakaiproject.evaluation.logic.entity.AssignGroupEntityProvider'
> defined in file
> [/home/jmiller/apache-tomcat-7.0.54/components/sakai-evaluation-pack/WEB-INF/entity-providers.xml]:
> Cannot resolve reference to bean
> 'org.sakaiproject.evaluation.logic.EvalEvaluationSetupService' while
> setting bean property 'evaluationSetupService'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name
> 'org.sakaiproject.evaluation.logic.EvalEvaluationSetupService' defined in
> file
> [/home/jmiller/apache-tomcat-7.0.54/components/sakai-evaluation-pack/WEB-INF/components.xml]:
> Cannot resolve reference to bean
> 'org.sakaiproject.evaluation.logic.externals.ExternalHierarchyLogic' while
> setting bean property 'hierarchyLogic'; nested exception is
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name
> 'org.sakaiproject.evaluation.logic.externals.ExternalHierarchyLogic'
> defined in file
> [/home/jmiller/apache-tomcat-7.0.54/components/sakai-evaluation-pack/WEB-INF/external-logic.xml]:
> Invocation of init method failed; nested exception is
> org.springframework.jdbc.UncategorizedSQLException: Hibernate operation:
> could not execute query; uncategorized SQLException for SQL [select
> this_.ID as ID67_1_, this_.hierarchyId as hierarch2_67_1_, this_.isRootNode
> as isRootNode67_1_, this_.ownerId as ownerId67_1_, this_.title as
> title67_1_, this_.description as descript6_67_1_, this_.permToken as
> permToken67_1_, this_.isDisabled as isDisabled67_1_, hierarchyp2_.ID as
> ID66_0_, hierarchyp2_.directParentIds as directPa2_66_0_,
> hierarchyp2_.parentIds as parentIds66_0_, hierarchyp2_.directChildIds as
> directCh4_66_0_, hierarchyp2_.childIds as childIds66_0_ from
> HIERARCHY_NODE_META this_ left outer join HIERARCHY_NODE hierarchyp2_ on
> this_.ID=hierarchyp2_.ID where (this_.hierarchyId=? and
> this_.isRootNode=?)]; SQL state [99999]; error code [17004]; Invalid column
> type: getCLOB not implemented for class
> oracle.jdbc.driver.T4CVarcharAccessor; nested exception is
> java.sql.SQLException: Invalid column type: getCLOB not implemented for
> class oracle.jdbc.driver.T4CVarcharAccessor
>
> Any insight would be greatly appreciated!
>
> Thanks,
>
> -jeb
>
> --
> Jeb Miller
> Programmer Analyst - Sakai, HJF
> USUHS/ATD
> 4301 Jones Bridge Road
> Bethesda, MD 20814-4799
> 301-319-0442
>
> _______________________________________________
> 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/20140703/7555c6d7/attachment.html