KrisI 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)
--~--~---------~--~----~------------~-------~--~----~
Open BlueDragon Public Mailing List
http://groups.google.com/group/openbd?hl=en
official blog @ http://blog.openbluedragon.org/
!! save a network - trim replies before posting !!
-~----------~----~----~----~------~----~------~--~---
-- Razuna On-Demand - Hosted Digital Asset Management SolutionRazuna - 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
smime.p7s
Description: S/MIME cryptographic signature
