It looks like a bug in the MySQL driver you are using because of this part of the stack trace:
com.mysql.jdbc.ConnectionImpl.initializeResultsMetadataFromCache(ConnectionImpl.java:5668) It sounds like this is a known bug in the MySQL driver: InitializeResultsMetadataFromCache fails on second call to stored proc http://bugs.mysql.com/bug.php?id=55340 HTH, .Peter Skellington said the following on 12/20/2010 01:31 PM: > Hello, > I think I might have found a bug, can someone please confirm this. > > index.cfm > > <cfparam name="myDBSource" default="myds"> > <cfquery name="qGet" datasource="#myDBSource#"> > SELECT * > FROM clients > WHERE 1 = 1 > AND cuuid = <cfqueryparam value="8000-0019E3F90C4A" > cfsqltype="CF_SQL_VARCHAR"> > AND xdata = <cfqueryparam value="Location" > cfsqltype="CF_SQL_VARCHAR"> > </cfquery> > <cfdump var="#qGet#"> > > When I run this page in my browser it displays the results properly, > but if I click the refresh I get a java.lang.NullPointerException > error, until I modify the page. It runs once and errors from there. I > did find that if I remove the cfqueryparam and run the query as cuuid > = '8000-0019E3F90C4A' etc. it works every time. > > I'm running OpenBD 1.4 release on Jetty 7.2.2 on Mac OS X 10.6.5. > > Thanks, > Charlie > > java.lang.NullPointerException > at > com.mysql.jdbc.ConnectionImpl.initializeResultsMetadataFromCache(ConnectionImpl.java: > 5668) > at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java: > 1373) > 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.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.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java: > 534) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java: > 475) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java: > 119) > at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java: > 516) > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java: > 226) > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java: > 929) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java: > 403) > at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java: > 184) > at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java: > 864) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java: > 117) > at > org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java: > 247) > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java: > 151) > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java: > 114) > at org.eclipse.jetty.server.Server.handle(Server.java:352) > at > org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java: > 596) > at org.eclipse.jetty.server.HttpConnection > $RequestHandler.headerComplete(HttpConnection.java:1051) > at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:590) > at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java: > 212) > at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java: > 426) > at > org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java: > 508) > at org.eclipse.jetty.io.nio.SelectChannelEndPoint.access > $000(SelectChannelEndPoint.java:34) > at org.eclipse.jetty.io.nio.SelectChannelEndPoint > $1.run(SelectChannelEndPoint.java:40) > at org.eclipse.jetty.util.thread.QueuedThreadPool > $2.run(QueuedThreadPool.java:451) > at java.lang.Thread.run(Thread.java:680) > -- Open BlueDragon Public Mailing List http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon official manual: http://www.openbluedragon.org/manual/ Ready2Run CFML http://www.openbluedragon.org/openbdjam/ mailing list - http://groups.google.com/group/openbd?hl=en
