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 !!
-~----------~----~----~----~------~----~------~--~---
