Got it. I remember seeing that on the list before now that you mention it. My bad.
Thanks again! On Fri, Feb 13, 2009 at 4:50 PM, Paul Bonfanti <[email protected]> wrote: > By using the admin console or editing bluedragon.xml directly, you'll > need to edit the MySQL datasource settings and set cacheResultSetMetadata > to false. > > > > Paul > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Anthony Hixon, Jr. > *Sent:* Friday, February 13, 2009 4:38 PM > *To:* [email protected] > *Subject:* [OpenBD] Re: Tag Question > > > > Browser stack trace: > > > > java.lang.NullPointerException > at > com.mysql.jdbc.Connection.initializeResultsMetadataFromCache(Connection.java:5917) > at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:884) > at > com.naryx.tagfusion.cfm.sql.cfSQLQueryData.executeAsPreparedStatement(Unknown > Source) > at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.execute(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfSQLQueryData.runQuery(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQUERY.executeStatement(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQueryImplSQL.render(Unknown Source) > at com.naryx.tagfusion.cfm.sql.cfQUERY.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.renderToString(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfFUNCTION.realRun(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfFUNCTION.run(Unknown Source) > at com.naryx.tagfusion.cfm.script.userDefinedFunction.execute(Unknown > Source) > at > com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction(Unknown > Source) > at > com.naryx.tagfusion.cfm.engine.cfComponentData.invokeComponentFunction(Unknown > Source) > at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval(Unknown > Source) > at > com.naryx.tagfusion.expression.compile.cfFullVarExpression.evalNatural(Unknown > Source) > at com.naryx.tagfusion.expression.compile.cfFullVarExpression.Eval(Unknown > Source) > at > com.naryx.tagfusion.expression.compile.CFAssignmentExpression.Eval(Unknown > Source) > at com.naryx.tagfusion.expression.compile.runTime.run(Unknown Source) > at com.naryx.tagfusion.expression.compile.runTime.runExpression(Unknown > Source) > at com.naryx.tagfusion.expression.compile.runTime.runExpression(Unknown > Source) > at com.naryx.tagfusion.cfm.tag.cfSET.render(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.coreRender(Unknown Source) > at com.naryx.tagfusion.cfm.tag.cfTag.render(Unknown Source) > at com.naryx.tagfusion.cfm.file.cfFile.render(Unknown Source) > at com.naryx.tagfusion.cfm.engine.cfSession.onRequest(Unknown Source) > at com.naryx.tagfusion.cfm.engine.cfEngine.service(Unknown Source) > at com.naryx.tagfusion.cfm.cfServlet.service(Unknown Source) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) > at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502) > at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:363) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) > at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:757) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:416) > at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152) > at org.mortbay.jetty.Server.handle(Server.java:324) > at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:502) > at > org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:826) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:523) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:377) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409) > at > org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:497) > > On Fri, Feb 13, 2009 at 4:35 PM, Paul Bonfanti <[email protected]> > wrote: > > Are you seeing a stack trace for this exception in the browser or in > bluedragon.log? If so, could you post the stack trace to the list? > > > > Paul > > > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Anthony Hixon, Jr. > *Sent:* Friday, February 13, 2009 4:33 PM > *To:* openbd > *Subject:* [OpenBD] Tag Question > > > > Are there any known issues using "cfqueryparam"? > > > > I'm getting a "java.lang.NullPointerException" on any of my queries that > use them hitting a MySQL 5 database. The queries work fine if I remove them > and use the actual value. > > > > For example, this will work: > > <cfquery > > name="qPhysicians" datasource="#request.dsn#"> > > *SELECT* PhysicianID, PhyFirstName, PhyLastName > *FROM* physician > *WHERE* PhyStatus = 'A' > *ORDER* *BY* PhyLastName > > </cfquery> > > This will not: > > <cfquery > > name="qPhysicians" datasource="#request.dsn#"> > > *SELECT* PhysicianID, PhyFirstName, PhyLastName > *FROM* physician > *WHERE* PhyStatus = <cfqueryparam cfsqltype="cf_sql_varchar" value="A"> > *ORDER* *BY* PhyLastName > > </cfquery> > > This is only an example. I have several other queries using cfqueryparam > that generate the same NullPointerException. > > Any ideas? > > -- > Anthony Hixon, Jr. > Certified Advanced ColdFusion MX 7 Developer > Mobile: (706) 639-3617 > [email protected] > > > > > Mobile: (706) 639-3617 > [email protected] > > > > > -- Anthony Hixon, Jr. Certified Advanced ColdFusion MX 7 Developer Mobile: (706) 639-3617 [email protected] --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
