Yes, most likely. If your CFC location paths are not found, ColdFusion will just scan the entire web root by default. There is no error message so it’s difficult for you to detect when this happens. You should consult the docs on CF ORM confirm how to specify your CFC paths.
I am now using apache web sever with coldfusion 2016 and Oracle 12c DB. I got rid of the websphere web server because of the fact that you had to rebuild the .ear file for every change.
the current challenge we are facing is the fact that the framework keeps adding the keyword “as” to table alias’s in the hibernate queries the workaround to get past the install was to remove all createalias function calls from the code base however the folowing query is still being generated on the home page and is using key word “as” in table alias so I am looking for a more permanent solution. Would you happen to know where the keyword as is being added to the query? should I modify the create alias query to have it strip out the “as”? Is that even possible? I also change my dialect variable in my application.cfc to Oracle11g and its still happening. I search all the hard coded queries and change those to not use the as keyword as well.
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_.LAYOUT as LAYOUT2_17_2_,
this_1_.MOBILELAYOUT as MOBILELAYOUT3_17_2_,
this_1_.“order” as order4_17_2_,
this_1_.SHOWINMENU as SHOWINMENU5_17_2_,
this_1_.EXCERPT as EXCERPT6_17_2_,
this_1_.SSLONLY as SSLONLY7_17_2_,
(select
cs.hits
from
cb_stats cs
where
cs.FK_contentID=this_.contentID) as formula22_2_,
(select
count(*)
from
cb_contentVersion cv
where
cv.FK_contentID=this_.contentID) as formula23_2_,
(select
count(*)
from
cb_contentVersion cv
where
cv.FK_contentID=this_.contentID
AND cv.isActive = 1) as formula24_2_,
(select
count(*)
from
cb_comment comment
where
comment.FK_contentID=this_.contentID) as formula25_2_,
(select
count(*)
from
cb_comment comment
where
comment.FK_contentID=this_.contentID
and comment.isApproved = 1) as formula26_2_,
(select
count(*)
from
cb_content content
where
content.FK_parentID=this_.contentID) as formula27_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 formula30_0_,
(select
count(*)
from
cb_content content
where
content.FK_authorID=cbauthor2_.authorID
and content.contentType = ‘Page’) as formula31_0_,
(select
count(*)
from
cb_content content
where
content.FK_authorID=cbauthor2_.authorID
and content.contentType = ‘ContentStore’) as formula32_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_
inner join
cb_page this_1_
on this_.CONTENTID=this_1_.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_.contentType=‘Page’
and this_.ISPUBLISHED=?
and this_.PUBLISHEDDATE<?
and (
this_.EXPIREDATE is null
or this_.EXPIREDATE>?
)
and this_.PASSWORDPROTECTION=?
and this_1_.SHOWINMENU=?
and this_.FK_parentID is null
order by
this_1_.“order” asc
discovered that this line was the problem
cb_comment comment
its trying to alias cb_comment as comment but in Oracle its a reserved word