[Building Sakai] Evaluation Tool

[Miller, Jeffrey]

Thanks, both columns were in fact varchar2.  So after HIERARCHY_NODE table
conversion, the evaluation tool was built, deployed, and seems to be
working fine!


On Thu, Jul 3, 2014 at 7:45 AM, Matthew Jones <matthew at longsight.com> wrote:

> 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"
>>
>
>


-- 
Jeb Miller
Programmer Analyst - Sakai, HJF
USUHS/ATD
4301 Jones Bridge Road
Bethesda, MD 20814-4799
301-319-0442
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140703/8808a47e/attachment.html