Nitai, I do have that option in the admin console. Unchecking it resolved the issue.
Alan, Should I still log this is a bug, or is there already an open case? Thanks both for the super-quick responses. Kris On Sun, Jan 11, 2009 at 1:54 PM, Nitai @ SixSigns <[email protected]>wrote: > Kris > > I had the same problem for a long time. Not sure if the change of the > administration console is in your download, but you should set the > "cacheResultSetMetadata" to false. If you don't have this in your > administration console, then simply add it to your hoststring of the mysql > query param as "?cacheResultSetMetadata=false". > > Kind Regards, > Nitai > > > On Jan 11, 2009, at 8:41 PM, Kris Richardson wrote: > > >> I'm using OpenBD 1.0 and have MySQL 5.0.45. I set up my datasource >> using the MySQL 4/5 driver that's bundled with OpenBD. >> >> When I run a simple query using <cfqueryparam> I get an Open >> Bluedragon Internal Server Error. If I remove the <cfqueryparam> from >> the otherwise same query it runs fine. >> >> Example Code: >> >> 1: <cfquery name="test" datasource="krichardson"> >> 2: SELECT * >> 3: FROM mangoblog as blog >> 4: WHERE id = <cfqueryparam value="default" >> cfsqltype="cf_sql_varchar"/> >> 5: </cfquery> >> >> Version that works: >> >> 1: <cfquery name="test" datasource="krichardson"> >> 2: SELECT * >> 3: FROM mangoblog as blog >> 4: WHERE id = 'default' >> 5: </cfquery> >> >> Additionally, this only seems to be an issue with SELECT statements. I >> can INSERT and UPDATE data using <cfqueryparam> just fine. >> >> 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.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:803) >> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter >> (ApplicationFilterChain.java:290) >> at org.apache.catalina.core.ApplicationFilterChain.doFilter >> (ApplicationFilterChain.java:206) >> at org.apache.catalina.core.StandardWrapperValve.invoke >> (StandardWrapperValve.java:233) >> at org.apache.catalina.core.StandardContextValve.invoke >> (StandardContextValve.java:175) >> at org.apache.catalina.core.StandardHostValve.invoke >> (StandardHostValve.java:128) >> at org.apache.catalina.valves.ErrorReportValve.invoke >> (ErrorReportValve.java:102) >> at org.apache.catalina.core.StandardEngineValve.invoke >> (StandardEngineValve.java:109) >> at org.apache.catalina.connector.CoyoteAdapter.service >> (CoyoteAdapter.java:286) >> at >> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java: >> 190) >> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java: >> 283) >> at >> org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) >> at org.apache.jk.common.ChannelSocket.processConnection >> (ChannelSocket.java:697) >> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt >> (ChannelSocket.java:889) >> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run >> (ThreadPool.java:690) >> at java.lang.Thread.run(Thread.java:619) >> >> >> >> >> > -- > Razuna On-Demand - Hosted Digital Asset Management Solution > Razuna - Open Source Digital Asset Management with Web Content Management > http://www.razuna.com/ > > Kabunto - Open Source Forum Solution > http://www.kabunto.org/ > > Roozani - memorize everywhere > http://www.roozani.com/ > > SixSigns - Enrich people's lives and web experience > http://www.sixsigns.com > http://blog.sixsigns.com > > Follow us on Twitter > http://twitter.com/sixsigns > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 !! -~----------~----~----~----~------~----~------~--~---
