[Macromedia][Oracle JDBC Driver][Oracle]ORA-00918: column ambiguously defined

[clockwo...@gmail.com]

Problem:

this is happening when ever you need to list out content for display  the problem seems to be with 

this_.CONTENTTYPE as CONTENTTYPE2_6_2_

and 

this_.contentType as contentType2_6_2_

not sure how to fix this 

Query is :

select

        * 

    from

        ( select

            this_.CONTENTID as CONTENTID1_6_2_,

            this_.CREATEDDATE as CREATEDDATE3_6_2_,

            this_.MODIFIEDDATE as MODIFIEDDATE4_6_2_,

            this_.ISDELETED as ISDELETED5_6_2_,

            this_.CONTENTTYPE as CONTENTTYPE2_6_2_,

            this_.TITLE as TITLE6_6_2_,

            this_.SLUG as SLUG7_6_2_,

            this_.PUBLISHEDDATE as PUBLISHEDDATE8_6_2_,

            this_.EXPIREDATE as EXPIREDATE9_6_2_,

            this_.ISPUBLISHED as ISPUBLISHED10_6_2_,

            this_.ALLOWCOMMENTS as ALLOWCOMMENTS11_6_2_,

            this_.PASSWORDPROTECTION as PASSWORDPROTECTIO12_6_2_,

            this_.HTMLKEYWORDS as HTMLKEYWORDS13_6_2_,

            this_.HTMLDESCRIPTION as HTMLDESCRIPTION14_6_2_,

            this_.HTMLTITLE as HTMLTITLE15_6_2_,

            this_.CACHE as CACHE16_6_2_,

            this_.CACHELAYOUT as CACHELAYOUT17_6_2_,

            this_.CACHETIMEOUT as CACHETIMEOUT18_6_2_,

            this_.CACHELASTACCESSTIMEOUT as CACHELASTACCESSTI19_6_2_,

            this_.MARKUP as MARKUP20_6_2_,

            this_.SHOWINSEARCH as SHOWINSEARCH21_6_2_,

            this_.FEATUREDIMAGE as FEATUREDIMAGE22_6_2_,

            this_.FEATUREDIMAGEURL as FEATUREDIMAGEURL23_6_2_,

            this_.FK_authorID as FK_authorID24_6_2_,

            this_.FK_parentID as FK_parentID25_6_2_,

            this_1_.EXCERPT as EXCERPT2_11_2_,

            this_2_.LAYOUT as LAYOUT2_17_2_,

            this_2_.MOBILELAYOUT as MOBILELAYOUT3_17_2_,

            this_2_."order" as order4_17_2_,

            this_2_.SHOWINMENU as SHOWINMENU5_17_2_,

            this_2_.EXCERPT as EXCERPT6_17_2_,

            this_2_.SSLONLY as SSLONLY7_17_2_,

            this_3_.DESCRIPTION as DESCRIPTION2_8_2_,

            this_3_."order" as order3_8_2_,

            (select

                cs.hits 

            from

                cb_stats cs 

            where

                cs.FK_contentID=this_.contentID) as formula364_2_,

            (select

                count(*) 

            from

                cb_contentVersion cv 

            where

                cv.FK_contentID=this_.contentID) as formula365_2_,

            (select

                count(*) 

            from

                cb_contentVersion cv 

            where

                cv.FK_contentID=this_.contentID 

                AND cv.isActive = 1) as formula366_2_,

            (select

                count(*) 

            from

                cb_comments comments 

            where

                comments.FK_contentID=this_.contentID) as formula367_2_,

            (select

                count(*) 

            from

                cb_comments comments 

            where

                comments.FK_contentID=this_.contentID 

                and comments.isApproved = 1) as formula368_2_,

            (select

                count(*) 

            from

                cb_content content 

            where

                content.FK_parentID=this_.contentID) as formula369_2_,

            this_.contentType as contentType2_6_2_,

            cbauthor2_.AUTHORID as AUTHORID1_0_0_,

            cbauthor2_.CREATEDDATE as CREATEDDATE2_0_0_,

            cbauthor2_.MODIFIEDDATE as MODIFIEDDATE3_0_0_,

            cbauthor2_.ISDELETED as ISDELETED4_0_0_,

            cbauthor2_.FIRSTNAME as FIRSTNAME5_0_0_,

            cbauthor2_.LASTNAME as LASTNAME6_0_0_,

            cbauthor2_.EMAIL as EMAIL7_0_0_,

            cbauthor2_.USERNAME as USERNAME8_0_0_,

            cbauthor2_.PASSWORD as PASSWORD9_0_0_,

            cbauthor2_.ISACTIVE as ISACTIVE10_0_0_,

            cbauthor2_.LASTLOGIN as LASTLOGIN11_0_0_,

            cbauthor2_.BIOGRAPHY as BIOGRAPHY12_0_0_,

            cbauthor2_.PREFERENCES as PREFERENCES13_0_0_,

            cbauthor2_.ISPASSWORDRESET as ISPASSWORDRESET14_0_0_,

            cbauthor2_.IS2FACTORAUTH as IS15_0_0_,

            cbauthor2_.APITOKEN as APITOKEN16_0_0_,

            cbauthor2_.FK_roleID as FK_roleID17_0_0_,

            (select

                count(*) 

            from

                cb_content content       

            where

                content.FK_authorID=cbauthor2_.authorID 

                and content.contentType = 'Entry') as formula372_0_,

            (select

                count(*) 

            from

                cb_content content       

            where

                content.FK_authorID=cbauthor2_.authorID 

                and content.contentType = 'Page') as formula373_0_,

            (select

                count(*) 

            from

                cb_content  content       

            where

                content.FK_authorID=cbauthor2_.authorID 

                and content.contentType = 'ContentStore') as formula374_0_,

            cbstats3_.STATSID as STATSID1_25_1_,

            cbstats3_.CREATEDDATE as CREATEDDATE2_25_1_,

            cbstats3_.MODIFIEDDATE as MODIFIEDDATE3_25_1_,

            cbstats3_.ISDELETED as ISDELETED4_25_1_,

            cbstats3_.HITS as HITS5_25_1_,

            cbstats3_.FK_contentID as FK_contentID6_25_1_ 

        from

            cb_content this_ 

        left outer join

            cb_entry this_1_ 

                on this_.CONTENTID=this_1_.contentID 

        left outer join

            cb_page this_2_ 

                on this_.CONTENTID=this_2_.contentID 

        left outer join

            cb_contentStore this_3_ 

                on this_.CONTENTID=this_3_.contentID 

        inner join

            cb_author cbauthor2_ 

                on this_.FK_authorID=cbauthor2_.AUTHORID 

        left outer join

            cb_stats cbstats3_ 

                on this_.CONTENTID=cbstats3_.FK_contentID 

        where

            this_.ISPUBLISHED=? 

            and this_.PUBLISHEDDATE<? 

            and (

                this_.EXPIREDATE is null 

                or this_.EXPIREDATE>?

            ) 

            and this_.PASSWORDPROTECTION=? 

        order by

            this_.SLUG asc ) 

        where

            rownum <= ?

01/02 10:27:50 [http-nio-8500-exec-5] HIBERNATE ERROR - [Macromedia][Oracle JDBC Driver][Oracle]ORA-00918: column ambiguously defined

call stack is: 

org.hibernate.exception.GenericJDBCException: could not extract ResultSet
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:54)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
    at org.hibernate.loader.Loader.doQuery(Loader.java:910)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
    at org.hibernate.loader.Loader.doList(Loader.java:2554)
    at org.hibernate.loader.Loader.doList(Loader.java:2540)
    at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
    at org.hibernate.loader.Loader.list(Loader.java:2365)
    at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1718)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at coldfusion.runtime.StructBean.invoke(StructBean.java:508)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3166)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074)
    at cfCriteriaBuilder2ecfc1921740904$funcLIST.runFunction(D:\ColdFusion2016\cfusion\wwwroot\modules\contentbox\modules\contentbox-deps\modules\cborm\models\CriteriaBuilder.cfc:121)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3019)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2994)
    at cfContentService2ecfc1093102847$funcSEARCHCONTENT.runFunction(D:\ColdFusion2016\cfusion\wwwroot\modules\contentbox\models\content\ContentService.cfc:179)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3019)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2994)
    at cfcontent2ecfc1500367159$funcRELATEDCONTENTSELECTOR.runFunction(D:\ColdFusion2016\cfusion\wwwroot\modules\contentbox\modules\contentbox-admin\handlers\content.cfc:157)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3027)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2994)
    at cfbaseHandler2ecfc228466344$funcAROUNDHANDLER.runFunction(D:\ColdFusion2016\cfusion\wwwroot\modules\contentbox\modules\contentbox-admin\handlers\baseHandler.cfc:85)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3019)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2994)
    at cfController2ecfc1782542106$func_RUNEVENT.runFunction(D:\ColdFusion2016\cfusion\wwwroot\coldbox\system\web\Controller.cfc:727)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3483)
    at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3464)
    at cfController2ecfc1782542106$funcRUNEVENT.runFunction(D:\ColdFusion2016\cfusion\wwwroot\coldbox\system\web\Controller.cfc:467)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3019)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2994)
    at cfBootstrap2ecfc2021340250$funcPROCESSCOLDBOXREQUEST.runFunction(D:\ColdFusion2016\cfusion\wwwroot\coldbox\system\Bootstrap.cfc:253)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
    at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542)
    at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522)
    at cfBootstrap2ecfc2021340250$funcONREQUESTSTART.runFunction(D:\ColdFusion2016\cfusion\wwwroot\coldbox\system\Bootstrap.cfc:469)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3097)
    at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074)
    at cfApplication2ecfc630757326$funcONREQUESTSTART.runFunction(D:\ColdFusion2016\cfusion\wwwroot\Application.cfc:113)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492)
    at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425)
    at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388)
    at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
    at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339)
    at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439)
    at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409)
    at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114)
    at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285)
    at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473)
    at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
    at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
    at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
    at coldfusion.filter.LicenseFilter.invoke(LicenseFilter.java:30)
    at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
    at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
    at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
    at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
    at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
    at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
    at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
    at coldfusion.CfmServlet.service(CfmServlet.java:219)
    at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
    at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at coldfusion.inspect.weinre.MobileDeviceDomInspectionFilter.doFilter(MobileDeviceDomInspectionFilter.java:121)
    at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:493)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:800)
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:800)
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1471)
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: [Macromedia][Oracle JDBC Driver][Oracle]ORA-00918: column ambiguously defined

    at macromedia.jdbcspyoracle.SpyLogger.sqlException(Unknown Source)
    at macromedia.jdbcspyoracle.SpyPreparedStatement.executeQuery(Unknown Source)
    at coldfusion.server.j2ee.sql.JRunPreparedStatement.executeQuery(JRunPreparedStatement.java:86)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
    ... 151 more