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]<mailto:[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]> [mailto:[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]<mailto:[email protected]> Mobile: (706) 639-3617 [email protected]<mailto:[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 !! -~----------~----~----~----~------~----~------~--~---
