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

Reply via email to