Bed-and-breakfast.it
500
Leider ist ein Fehler aufgetreten.
Der Administrator der Website mitgeteilt worden. Dank
Klicken Sie hier, um zur Startseite zurückzukehren Torna alla Home
struct
Cause
struct
ErrorCode 0
Message ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured.
StackTrace java.sql.SQLException: ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured. at coldfusion.server.j2ee.pool.PoolManager.getPool(PoolManager.java:47) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:115) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:137) at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:56) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:110) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:377) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58) at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 3776
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 1315
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6658
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 58
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 54
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_LISTA_STRUTTURE_UR
LINE 1
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
DataSource studioscivoletto
Detail ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured.
ErrorCode n/a
Exceptions
array
1
struct
class java.sql.SQLException
message ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured.
Message Error Executing Database Query.
NativeErrorCode 0
RootCause
struct
ErrorCode 0
Message ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured.
StackTrace java.sql.SQLException: ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured. at coldfusion.server.j2ee.pool.PoolManager.getPool(PoolManager.java:47) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:115) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:137) at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:56) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:110) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:377) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58) at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842)
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 3776
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 1315
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6658
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 58
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 54
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_LISTA_STRUTTURE_UR
LINE 1
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type java.sql.SQLException
SQLState n/a
Sql DECLARE @numeroOspiti INT = (param 1) ; DECLARE @numeroGiorni INT = (param 2) ; DECLARE @filtroCancellazioneGratuita BIT = (param 3) ; DECLARE @checkInDate DATE = (param 4) ; DECLARE @checkOutDate DATE = (param 5) ; DECLARE @checkOutDateMin DATE = (param 6) ; DECLARE @diffChecInNow INT = DATEDIFF(day, (param 7) , @checkInDate); DECLARE @tmpHotelId TABLE (hotelId INT, ghostRoom BIT); INSERT INTO @tmpHotelId(hotelId, ghostRoom) SELECT hotelId, ghostRoom FROM (VALUES (0, 0) , (9630, 0) , (26937, 0) , (37920, 0) , (38191, 0) ) T(hotelId, ghostRoom); WITH calendario AS ( SELECT h.hotelID , r.roomID , ( ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS singlePrice_discount , ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS basePrice_discount , ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_discount , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_infants_discount , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) AS extraBedPrice_children_discount , ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END ) AS singlePrice_total , ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END ) AS basePrice_total , ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END ) AS extraBedPrice_total , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale1, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) ) AS extraBedPrice_infants_total , ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.extraBedPrice ELSE r.extraBedPrice END * ISNULL(h.bambinoPercentuale2, 0) * .01 ) * ISNULL(sc.percentuale, 0) * .01 ) ) AS extraBedPrice_children_total , ( CASE WHEN r.maximumGuests = 1 THEN ( ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) - ( CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END - CASE WHEN ISNULL(rpd.singlePrice, 0) > 0 THEN rpd.singlePrice ELSE r.singlePrice END * ISNULL(sc.percentuale, 0) * .01 ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) WHEN r.maximumGuests >= 2 THEN ( ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) ) - ( ( CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END - CASE WHEN ISNULL(rpd.basePrice, 0) > 0 THEN rpd.basePrice ELSE r.basePrice END * ISNULL(sc.percentuale, 0) * .01 ) ) * (ISNULL(h.scontipaypal, 0) * .01) * ( CASE WHEN @diffChecInNow < (ISNULL(h.pagamento_anticipato_giorni, 0) - 1) OR (@filtroCancellazioneGratuita = 1 AND (h.pagamento_banca = 1 OR h.pagamento_cc = 1 OR h.pagamento_paypal = 1 OR h.pagamento_fiducia = 1 OR h.pagamento_caparra_satispay = 1 OR h.pagamento_caparra_cc = 1)) THEN 0 ELSE CASE WHEN h.pagamento_anticipato_paypal = 1 THEN 1 WHEN h.pagamento_anticipato_banca = 1 THEN 1 WHEN h.pagamento_anticipato_cc = 1 THEN 1 WHEN h.pagamento_anticipato_satispay = 1 THEN 1 ELSE 0 END END ) ) END ) AS fullPrice_discount FROM stay_dates sd CROSS JOIN @tmpHotelId tmp_h INNER JOIN hotels (NOLOCK) h ON h.hotelID = tmp_h.hotelId INNER JOIN rooms (NOLOCK) r ON r.hotelID = h.hotelID AND r.hotelID = tmp_h.hotelId AND r.ghostRoom = tmp_h.ghostRoom AND r.isDeleted = 0 OUTER APPLY ( SELECT rpd_sub.basePrice, rpd_sub.singlePrice, rpd_sub.extraBedPrice, rpd_sub.minimumStay, rpd_sub.maximumStay FROM price (NOLOCK) rpd_sub WHERE rpd_sub.roomID = r.roomID AND rpd_sub.roomRateDate = sd.date ) rpd OUTER APPLY ( SELECT TOP 1 sc_sub.hotelID, sc_sub.percentuale, sc_sub.giorni FROM sconti (NOLOCK) sc_sub WHERE sc_sub.hotelID = tmp_h.hotelID AND sc_sub.datainizio <= sd.date AND sc_sub.datafine >= sd.date AND sc_sub.giorni < @numeroGiorni AND sc_sub.bbcard = 0 ORDER BY CASE WHEN sc_sub.giorni = 0 THEN 999 ELSE sc_sub.giorni END DESC ) sc WHERE sd.date >= (param 8) AND sd.date < (param 9) ) SELECT c.hotelId , h.idstruttura , h.tipostruttura , cast(h.tipo as nvarchar) as tipo , r.roomID , r.roomIdentifier , r.bathroomInRoom , r.bathroomPrivate , r.bathroomShared , r.maximumGuests , CASE WHEN MAX(r.maximumGuests) OVER (PARTITION BY c.hotelID) <= @numeroOspiti AND cast(h.tipo as nvarchar) IN ('CV', 'AP') THEN 1000 - r.maximumGuests ELSE r.maximumGuests END AS orderMaximumGuests , r.guestsIncludedWithBasePrice , r.breakfastIncluded , r.ghostRoom , r.numberBedRooms , r.roomCount as n_camere , ISNULL(h.pagamento_cc, 0) as pagamento_cc , ISNULL(h.pagamento_fiducia, 0) as pagamento_fiducia , ISNULL(h.pagamento_paypal, 0) as pagamento_paypal , ISNULL(h.pagamento_caparra_cc, 0) as pagamento_caparra_cc , ISNULL(h.pagamento_caparra_satispay, 0) as pagamento_caparra_satispay , ISNULL(h.pagamento_banca, 0) as pagamento_banca , ISNULL(h.pagamento_anticipato_paypal, 0) as pagamento_anticipato_paypal , ISNULL(h.pagamento_anticipato_banca, 0) as pagamento_anticipato_banca , ISNULL(h.pagamento_anticipato_cc, 0) as pagamento_anticipato_cc , ISNULL(h.pagamento_anticipato_satispay, 0) as pagamento_anticipato_satispay , ISNULL(h.pagamento_anticipato_giorni, 0) as pagamento_anticipato_giorni , 1 AS flagTariffaNonRimborsabileGiorni , 0 AS limitazionigiorni , 0 AS limitazionigiornifuturi , ISNULL(h.bambinoMassima1, 0) as bambinoMassima1 , ISNULL(h.bambinoPercentuale1, 0) as bambinoPercentuale1 , ISNULL(h.bambinoMassima2, 0) as bambinoMassima2 , ISNULL(h.bambinoPercentuale2, 0) as bambinoPercentuale2 , 1 AS available , r.roomCount AS n_camere_libere , 0 AS sospeso , 1 AS soggiornominimo , 30 AS soggiornomassimo , 0 AS closedonarrival , 0 AS closedondeparture , 0 AS closedOnArrivalDeparture , 0 AS bloccato , SUM(c.singlePrice_discount) AS singlePrice_discount , SUM(c.basePrice_discount) AS basePrice_discount , SUM(c.extraBedPrice_discount) AS extraBedPrice_discount , SUM(c.extraBedPrice_infants_discount) AS extraBedPrice_infants_discount , SUM(c.extraBedPrice_children_discount) AS extraBedPrice_children_discount , SUM(c.singlePrice_total) AS singlePrice_total , SUM(c.basePrice_total) AS basePrice_total , SUM(c.extraBedPrice_total) AS extraBedPrice_total , SUM(c.extraBedPrice_infants_total) AS extraBedPrice_infants_total , SUM(c.extraBedPrice_children_total) AS extraBedPrice_children_total , SUM(c.fullPrice_discount) AS fullPrice_discount FROM calendario c INNER JOIN studioscivoletto.dbo.hotels (NOLOCK) h ON h.hotelID = c.hotelID INNER JOIN studioscivoletto.dbo.rooms (NOLOCK) r ON r.hotelID = c.hotelID AND r.roomID = c.roomID GROUP BY c.hotelId , h.idstruttura , h.tipostruttura , h.tipo , r.roomID , r.roomIdentifier , r.bathroomInRoom , r.bathroomPrivate , r.bathroomShared , r.maximumGuests , r.guestsIncludedWithBasePrice , r.breakfastIncluded , r.ghostRoom , r.numberBedRooms , r.roomCount , h.pagamento_cc , h.pagamento_fiducia , h.pagamento_paypal , h.pagamento_caparra_cc , h.pagamento_caparra_satispay , h.pagamento_banca , h.pagamento_anticipato_paypal , h.pagamento_anticipato_banca , h.pagamento_anticipato_cc , h.pagamento_anticipato_satispay , h.pagamento_anticipato_giorni , h.bambinoMassima1 , h.bambinoPercentuale1 , h.bambinoMassima2 , h.bambinoPercentuale2 ORDER BY c.hotelid ASC, available DESC, orderMaximumGuests ASC, fullPrice_discount ASC;
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:930) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822) at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4792) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4773) at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:660) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:590) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:553) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:476) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:449) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:718) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:980) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:762) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4048) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4012) at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58) at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54) at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5083) at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2) at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:573) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:162) at coldfusion.filter.IpFilter.invoke(IpFilter.java:45) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97) 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:231) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:197) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:166) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:142) at jdk.internal.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at jdk.internal.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:166) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:88) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:452) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:935) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1831) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:973) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:491) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:842) Caused by: java.sql.SQLException: ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured. at coldfusion.server.j2ee.pool.PoolManager.getPool(PoolManager.java:47) at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:115) at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:137) at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:56) at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156) at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:110) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:377) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250) at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1168) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:869) ... 101 more
Suppressed
array[empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 3776
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETQUERYRESULTPREZZIBYOCCUPANCY.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:3776)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 1315
RAW_TRACE at cfListaStrutture2ecfc60855799$func_GETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:1315)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 6658
RAW_TRACE at cfListaStrutture2ecfc60855799$funcGETSTRUTTUREBYCITTA.runFunction(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc:6658)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\cfc\class\ListaStrutture.cfc
TYPE CFML
4
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 58
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor1(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:58)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
5
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 54
RAW_TRACE at cflista_struttura_query2ecfm411963857._factor12(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:54)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
6
struct
COLUMN 0
ID CF_LISTA_STRUTTURA_QUERY
LINE 1
RAW_TRACE at cflista_struttura_query2ecfm411963857.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\include\lista_struttura_query.cfm
TYPE CFML
7
struct
COLUMN 0
ID CFINCLUDE
LINE 2
RAW_TRACE at cflista_strutture_ur2ecfm1384284247._factor6(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:2)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
8
struct
COLUMN 0
ID CF_LISTA_STRUTTURE_UR
LINE 1
RAW_TRACE at cflista_strutture_ur2ecfm1384284247.runPage(\\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm:1)
TEMPLATE \\fs-0b55830922e9e0aa1.shared.studioscivoletto.it\share\websites\bed-and-breakfast\lista_strutture_ur.cfm
TYPE CFML
Type Database
queryError ERROR: Could not locate studioscivoletto. This usually means that the configuration data for this database or pool has not been configured.
where (param 1) = [type='IN', class='java.lang.Double', value='2.0', sqltype='cf_sql_smallint'] , (param 2) = [type='IN', class='java.lang.String', value='1', sqltype='cf_sql_tinyint'] , (param 3) = [type='IN', class='java.lang.Integer', value='0', sqltype='cf_sql_bit'] , (param 4) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-17 14:59:51'}', sqltype='cf_sql_date'] , (param 5) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-18 14:59:51'}', sqltype='cf_sql_date'] , (param 6) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-17 14:59:51'}', sqltype='cf_sql_date'] , (param 7) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-17 00:00:00'}', sqltype='cf_sql_date'] , (param 8) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-17 14:59:51'}', sqltype='cf_sql_date'] , (param 9) = [type='IN', class='coldfusion.runtime.OleDateTime', value='{ts '2026-03-18 14:59:51'}', sqltype='cf_sql_date']