Good evening and sorry for my bad english…this is my firtst post. I’m a newbie to CFML and i’m trying to migrate a little program i’ve made from Coldfusion to Lucee.
I’ve a page that take some data from input forms and invoke a CFTRANSACTION for update a MySql table named “elencoCapitoli” calling a CFC file for the column type.
May someone help me?
(UPDATE: the EntityNew function works regularly…the problem is EntityLoadByPK)
Thank you…
CFTRANSACTION
<cfcase value="inserisci_impegno">
<cfset id=0 >
<cfset CODcapitoli= "#FORM['inserisci']#" &'-'& ("#ListGetAt("#FORM['IdProgElem']#",1)#") &'-'& ("#ListGetAt("#FORM['IdProgElem']#",2)#") &'-'& "#FORM['idTipoUffGest']#"/>
<cftransaction>
<cfset elencoCapitoliLoadPK = EntityLoadByPK("elencoCapitoli",CODcapitoli) />
<cfset situazioneCapitoliNew = EntityNew("situazioneCapitoli") />
<cfquery name="sommaCapitoliQuery">
SELECT *
FROM elencoCapitoli
WHERE (elencoCapitoli.IdCap = '#form.IdCap#' AND elencoCapitoli.annoEsercizio=#session._anno# AND elencoCapitoli.idTipoUffGest=#session._idTipoUffGest#)
</cfquery>
.....................................
CFC FILE
<cfcomponent persistent="true" table="elencoCapitoli" output="false">
<!---- properties ---->
<cfproperty name="CODcapitoli" column="CODcapitoli" type="string" ormtype="string" fieldtype="id"/>
<cfproperty name="annoEsercizio" column="annoEsercizio" type="numeric" ormtype="int"/>
<cfproperty name="IdCap" column="IdCap" type="numeric" ormtype="int"/>
<cfproperty name="IdProg" column="IdProg" type="numeric" ormtype="int"/>
<cfproperty name="IdElem" column="IdElem" type="numeric" ormtype="int"/>
<cfproperty name="numCapitolo" column="numCapitolo" type="string" ormtype="string"/>
<cfproperty name="numProgramma" column="numProgramma" type="string" ormtype="string"/>
<cfproperty name="numElemento" column="numElemento" type="string" ormtype="string"/>
<cfproperty name="denominazioneCapitolo" column="denominazioneCapitolo" type="string" ormtype="string"/>
<cfproperty name="assegnazioni" column="assegnazioni" type="double" ormtype="double"/>
<cfproperty name="impegni" column="impegni" type="double" ormtype="double"/>
<cfproperty name="rimanenza" column="rimanenza" type="double" ormtype="double"/>
<cfproperty name="impegniSA" column="impegniSA" type="double" ormtype="double"/>
<cfproperty name="rimanenzaSA" column="rimanenzaSA" type="double" ormtype="double"/>
<cfproperty name="uffGestore" column="uffGestore" type="numeric" ormtype="int"/>
<cfproperty name="idTipoUffGest" column="idTipoUffGest" type="numeric" ormtype="int"/>
</cfcomponent>
ERROR RETURNED
Lucee 5.3.3.62 Error (java.sql.SQLSyntaxErrorException)
Message Unknown column 'elencocapi0_.uffGestore' in 'field list'
Error Code 1054
hibernate exception org.hibernate.exception.SQLGrammarException: could not load an entity: [elencoCapitoli#2019-1-1-1-1]
sql select elencocapi0_.CODcapitoli as CODcapit1_0_0_, elencocapi0_.annoEsercizio as annoEser2_0_0_, elencocapi0_.IdCap as IdCap0_0_, elencocapi0_.IdProg as IdProg0_0_, elencocapi0_.IdElem as IdElem0_0_, elencocapi0_.numCapitolo as numCapit6_0_0_, elencocapi0_.numProgramma as numProgr7_0_0_, elencocapi0_.numElemento as numEleme8_0_0_, elencocapi0_.denominazioneCapitolo as denomina9_0_0_, elencocapi0_.assegnazioni as assegna10_0_0_, elencocapi0_.impegni as impegni0_0_, elencocapi0_.rimanenza as rimanenza0_0_, elencocapi0_.impegniSA as impegniSA0_0_, elencocapi0_.rimanenzaSA as rimanen14_0_0_, elencocapi0_.uffGestore as uffGestore0_0_, elencocapi0_.idTipoUffGest as idTipoU16_0_0_ from elencoCapitoli elencocapi0_ where elencocapi0_.CODcapitoli=?
Stacktrace The Error Occurred in
D:\lucee\tomcat\webapps\ROOT\capitoli\logistico\pre_processing.cfm: line 93
91: <cfset CODcapitoli= "#FORM['inserisci']#" &'-'& ("#ListGetAt("#FORM['IdProgElem']#",1)#") &'-'& ("#ListGetAt("#FORM['IdProgElem']#",2)#") &'-'& "#FORM['idTipoUffGest']#"/>
92: <cftransaction>
93: <cfset elencoCapitoliLoadPK = EntityLoadByPK("elencoCapitoli",CODcapitoli) />
94: <cfset situazioneCapitoliNew = EntityNew("situazioneCapitoli") />
called from D:\lucee\tomcat\webapps\ROOT\capitoli\logistico\amministrazione.cfm: line 10
Java Stacktrace lucee.runtime.exp.NativeException: Unknown column 'elencocapi0_.uffGestore' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:970)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1020)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)
at org.hibernate.loader.Loader.doQuery(Loader.java:718)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1953)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:86)
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:76)
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3270)
at org.hibernate.event.def.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:496)
at org.hibernate.event.def.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:477)
at org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:227)
at org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:285)
at org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:152)
at org.hibernate.impl.SessionImpl.fireLoad(SessionImpl.java:1080)
at org.hibernate.impl.SessionImpl.get(SessionImpl.java:997)
at org.lucee.extension.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:619)
at org.lucee.extension.orm.hibernate.HibernateORMSession.load(HibernateORMSession.java:604)
at lucee.runtime.functions.orm.EntityLoadByPK.call(EntityLoadByPK.java:16)
at capitoli.logistico.pre_processing_cfm$cf.call(/capitoli/logistico/pre_processing.cfm:93)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:816)
at capitoli.logistico.amministrazione_cfm$cf.call(/capitoli/logistico/amministrazione.cfm:10)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:942)
at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:834)
at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:216)
at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:42)
at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2409)
at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2399)
at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2374)
at lucee.runtime.engine.Request.exe(Request.java:43)
at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1109)
at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1055)
at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97)
at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
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:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at mod_cfml.core.invoke(core.java:180)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'elencocapi0_.uffGestore' in 'field list'
... 64 more