Railo 4.2.1.008 Error (database)
Message
Detail Wrong data type: java.lang.NumberFormatException: For input string: ""
SQL
select
year,
count(*) as total
from arguments_q
where year <> ''
group by year
order by year desc
DatabaseName HSQL Database Engine
DatabaseVersion 1.8.0
DriverName HSQL Database Engine Driver
DriverVersion 1.8.0
Datasource _queryofquerydb
Stacktrace The Error Occurred in
C:\Inetpub\wwwroot\Powerlinks\com\webmalls\Vehicles.cfc: line 149
147: count(*) as total
148: from arguments.q
149: where year <> ''
150: group by year
151: order by year desc

called from C:\Inetpub\wwwroot\Powerlinks\com\webmalls\DealerList.cfc: line 24
called from C:\Inetpub\wwwroot\Powerlinks\webmallListing.cfm: line 36
called from C:\Inetpub\wwwroot\Powerlinks\application.cfc: line 33
Java Stacktrace
  at org.hsqldb.jdbc.Util.sqlException(Unknown Source):-1
  at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source):-1
  at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source):-1
  at railo.runtime.db.driver.state.StateUtil.execute(StateUtil.java:19):19
  at railo.runtime.db.driver.state.StateStatement.execute(StateStatement.java:25):25
  at railo.runtime.type.util.QueryUtil.execute(QueryUtil.java:214):214
  at railo.runtime.type.QueryImpl.(QueryImpl.java:224):224
  at railo.runtime.db.HSQLDBHandler.__execute(HSQLDBHandler.java:349):349
  at railo.runtime.db.HSQLDBHandler._execute(HSQLDBHandler.java:313):313
  at railo.runtime.db.HSQLDBHandler.execute(HSQLDBHandler.java:302):302
  at railo.runtime.tag.Query.executeQoQ(Query.java:671):671
  at railo.runtime.tag.Query.doEndTag(Query.java:500):500
  at com.webmalls.vehicles_cfc$cf.udfCall1(C:\Inetpub\wwwroot\Powerlinks\com\webmalls\Vehicles.cfc:149):149
  at com.webmalls.vehicles_cfc$cf.udfCall(C:\Inetpub\wwwroot\Powerlinks\com\webmalls\Vehicles.cfc):-1
  at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
  at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
  at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
  at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738
  at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:724):724
  at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1547):1547
  at com.webmalls.dealerlist_cfc$cf.udfCall(C:\Inetpub\wwwroot\Powerlinks\com\webmalls\DealerList.cfc:24):24
  at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
  at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
  at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
  at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738
  at railo.runtime.functions.other._CreateComponent.call(_CreateComponent.java:59):59
  at webmalllisting_cfm$cf.call(C:\Inetpub\wwwroot\Powerlinks\webmallListing.cfm:36):36
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:909):909
  at railo.runtime.PageContextImpl.doInclude(PageContextImpl.java:813):813
  at application_cfc$cf.udfCall(C:\Inetpub\wwwroot\Powerlinks\application.cfc:33):33
  at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:93):93
  at railo.runtime.type.UDFImpl._call(UDFImpl.java:307):307
  at railo.runtime.type.UDFImpl.call(UDFImpl.java:208):208
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:623):623
  at railo.runtime.ComponentImpl._call(ComponentImpl.java:506):506
  at railo.runtime.ComponentImpl.call(ComponentImpl.java:1738):1738
  at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:388):388
  at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:114):114
  at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:18):18
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2212):2212
  at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2179):2179
  at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:331):331
  at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:29):29
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:727):727
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
  at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220):220
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503):503
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170):170
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103):103
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116
  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421):421
  at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070):1070
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611):611
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:314):314
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145):1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615):615
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61
  at java.lang.Thread.run(Thread.java:745):745
 
Timestamp 8/30/15 11:53:20 AM EDT