Blog Archives

Matthias_Richter · August 24, 2012, 1:29pm

Hi there,

I’ve found a bug, if I use the function "findPublishedEntriesByDate) in EntryService.cfc.
All parameters of these function will be set correctly. Following dump is shown:

Oops! Exception Encountered### Application Execution ExceptionError Type: org.hibernate.exception.GenericJDBCException : 8127

Error Messages: could not execute query

Tag Context:
ID: ??
LINE: 190
Template: D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\BaseORMService.cfc
ID: ??
LINE: 88
Template: D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\VirtualEntityService.cfc
ID: ??
LINE: 142
Template: D:\inetpub\www_akibase\strandperle\modules\contentbox\model\content\EntryService.cfc
ID: ??
LINE: 147
Template: D:\inetpub\www_akibase\strandperle\modules\akibase\handlers\blog.cfc
ID: ??
LINE: 739
Template: D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc
ID: ??
LINE: 623
Template: D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc
ID: ??
LINE: 236
Template: D:\inetpub\www_akibase\strandperle\coldbox\system\Coldbox.cfc
ID: ??
LINE: 101
Template: D:\inetpub\www_akibase\strandperle\Application.cfc
Framework Snapshot
Current Event: akibase:blog.archives
Current Layout: N/A (Module: )
Current View: N/A
Bug Date: 08/24/2012 03:29:07 PM
Coldfusion ID: CFID=bbd1b9c8-d88a-4c1f-aa0e-6eb5b5f4a0bd ; CFToken=0 ; JSessionID=ContentBox-Shell-F5C2D05D4DE1639EA6B1EA4C65633F3F_bbd1b9c8-d88a-4c1f-aa0e-6eb5b5f4a0bd_0
Template Path : D:\inetpub\www_akibase\strandperle\index.cfm
Path Info : /en/blog/archives/2011/6/11
Host & Server: strandperle Akimatze-PC
Query String:
Browser: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.83 Safari/537.1
Remote Address: 127.0.0.1
Form variables:
Session Storage:
Cookies:
userhash:
railo_admin_pw_server: (:PZKO^_;X@
originalurltoken: CC538C36-2993-442C-BF1CD56ADC711630
railo_admin_lastpage: services.datasource
cftoken: 0
railo_admin_lang: de
coldbox_debugmode_DA7398A05DAF81DBEBB06F04F78FD23F: true
userid:
cfid: bbd1b9c8-d88a-4c1f-aa0e-6eb5b5f4a0bd
rb: de
Stack Trace:

could not execute query
	at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368):368
	at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816):2816
	at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254):2254
	at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:631):631
	at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477):477
	at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:777):777
	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208):208
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1869):1869
	at org.hibernate.loader.Loader.doQuery(Loader.java:718):718
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270):270
	at org.hibernate.loader.Loader.doList(Loader.java:2449):2449
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192):2192
	at org.hibernate.loader.Loader.list(Loader.java:2187):2187
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452):452
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363):363
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196):196
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1258):1258
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102):102
	at railo.runtime.orm.hibernate.HibernateORMSession.__executeQuery(HibernateORMSession.java:429):429
	at railo.runtime.orm.hibernate.HibernateORMSession._executeQuery(HibernateORMSession.java:291):291
	at railo.runtime.orm.hibernate.HibernateORMSession.executeQuery(HibernateORMSession.java:286):286
	at railo.runtime.functions.orm.ORMExecuteQuery._call(ORMExecuteQuery.java:44):44
	at railo.runtime.functions.orm.ORMExecuteQuery.call(ORMExecuteQuery.java:36):36
	at system.orm.hibernate.baseormservice_cfc$cf._1(D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\BaseORMService.cfc:190):190
	at system.orm.hibernate.baseormservice_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\BaseORMService.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:616):616
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:510):510
	at railo.runtime.SuperComponent.callWithNamedValues(SuperComponent.java:83):83
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:769):769
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495
	at system.orm.hibernate.virtualentityservice_cfc$cf._1(D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\VirtualEntityService.cfc:88):88
	at system.orm.hibernate.virtualentityservice_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\coldbox\system\orm\hibernate\VirtualEntityService.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495
	at model.content.entryservice_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\modules\contentbox\model\content\EntryService.cfc:142):142
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:616):616
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1834):1834
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:769):769
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495
	at modules.akibase.handlers.blog_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\modules\akibase\handlers\blog.cfc:147):147
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:616):616
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1830):1830
	at railo.runtime.tag.Invoke.doComponent(Invoke.java:210):210
	at railo.runtime.tag.Invoke.doEndTag(Invoke.java:183):183
	at system.web.controller_cfc$cf._6(D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc:739):739
	at system.web.controller_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738
	at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1480):1480
	at system.web.controller_cfc$cf._5(D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc:623):623
	at system.web.controller_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\coldbox\system\web\Controller.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:377):377
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:616):616
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
	at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1834):1834
	at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:769):769
	at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1495):1495
	at coldbox.system.coldbox_cfc$cf._1(D:\inetpub\www_akibase\strandperle\coldbox\system\Coldbox.cfc:236):236
	at coldbox.system.coldbox_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\coldbox\system\Coldbox.cfc):-1
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
	at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815
	at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:733):733
	at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1480):1480
	at application_cfc$cf.udfCall(D:\inetpub\www_akibase\strandperle\Application.cfc:101):101
	at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:215):215
	at railo.runtime.type.UDFImpl._call(UDFImpl.java:434):434
	at railo.runtime.type.UDFImpl.call(UDFImpl.java:384):384
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:615):615
	at railo.runtime.ComponentImpl._call(ComponentImpl.java:502):502
	at railo.runtime.ComponentImpl.call(ComponentImpl.java:1815):1815
	at railo.runtime.listener.ModernAppListener.call(ModernAppListener.java:349):349
	at railo.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:106):106
	at railo.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:23):23
	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2035):2035
	at railo.runtime.PageContextImpl.execute(PageContextImpl.java:2002):2002
	at railo.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:297):297
	at railo.loader.servlet.CFMLServlet.service(CFMLServlet.java:32):32
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:722):722
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304):304
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210):210
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224):224
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169):169
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472):472
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168):168
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100):100
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118):118
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:405):405
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200):200
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:515):515
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:302):302
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown Source):-1
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source):-1
	at java.lang.Thread.run(Unknown Source):-1

Extra Information Dump
[N/A]

ColdBox Tracer Messages

lmajano · August 24, 2012, 1:30pm

Can you post the calling source.

Matthias_Richter · August 24, 2012, 1:51pm

Hi Luis,

modules/ownModule/handler/blog.cfc:

entryService.findPublishedEntriesByDate(year=rc.year,month=rc.month,day=rc.day, offset=0, max=10);

Best
Matze

andrews · August 24, 2012, 1:55pm

What version of ColdFusion or Railo are you running on?

Matthias_Richter · August 24, 2012, 1:59pm

Hi Andrew,

My Railo-Version: Railo 3.3.5.002 final

Best
Matze

andrews · August 24, 2012, 2:03pm

Ok, then I think Luis will tell you that Railo is not fully supported for ContentBox at the moment. This looks like another reason why, as it will be a Railo bug more than a ContentBox bug.

lmajano · August 24, 2012, 2:26pm

Matze, can you document what exactly is failing as I need to give this to the railo folks

Luis F. Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com

ColdBox Platform: http://www.coldbox.org
Linked In: http://www.linkedin.com/pub/3/731/483
Blog: http://www.luismajano.com
IECFUG Manager: http://www.iecfug.com

Social: twitter.com/lmajano facebook.com/lmajano

Matthias_Richter · August 27, 2012, 8:01am

Hi Luis,

I’ve added a new module (mymodule), this module uses the CBRequest interceptor. This interceptor has the settingService and CBHelper as property.
In Config/Routes.cfm there is following line to route the requests:

`
addRoute(pattern="/:language/", moduleRouting=“mymodule”, constraints={language="(de|en)"});

`

In ModuleConfig.cfc of mymodule there is following routes added:

`

{pattern="/blog/archives/:year-numeric{4}?/:month-numeric{1,2}?/:day-numeric{1,2}?", handler=“blog”, action=“archives”},
{pattern="/blog/category/:category/:page-numeric?", handler=“blog”, action=“index”},
{pattern="/blog", handler=“blog”, action=“index”}

`

Both routes to blog.index works fine. In function blog.index calles the function “findPublishedEntries(…)” of the entryService, the response of this function is correctly.
In the function blog.archives the function findPublishedEntriesByDate(…) of the entryService will called, but this function throws an error as described.

The parameter in the function “findPublishedEntriesByDate” in EntryService.cfc looks correctly, the hql variable (query?!) looks also fine. This function calls the method “executeQuery” of VirtualEntitryService.cfc. In this function the incoming parameters looks fine.

Last, the build-in function ORMExecuteQuery will be called, this function throws an error.
I’ve tried to execute this function in my blog.cfc with the same parameter like in BaseORMService.cfc… there was no error…

Best
Matze

lmajano · August 27, 2012, 4:41pm

Matze, this is Railo right?

Luis Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com

ColdBox Platform: http://www.coldbox.org
Linked In: http://www.linkedin.com/pub/3/731/483
Social: twitter.com/ortussolutions | twitter.com/coldbox | twitter.com/lmajano

Matthias_Richter · August 28, 2012, 5:59am

Yes

Blog Archives

Oops! Exception Encountered### Application Execution ExceptionError Type: org.hibernate.exception.GenericJDBCException : 8127

Latest Ortus News

GIVING BACK

HARVESTING IN SPANISH

WOODSEDGE