Women in Technology

Hear us Roar



Article:
  ColdFusion MX on Mac OS X, Part 4
Subject:   problem cf debugging
Date:   2003-01-21 12:27:20
From:   dicklacara
Response to: problem cf debugging

Was FB's JDBC Driver jar in /Library/Java/Extensions/


I haven't played with FB and CFMX on the released version (just the port). It has been a while, but I remember having some problems with FB.


It could be, that you have done something to your particular database, that is causing the errors -- FB could have detected an error in the db and is restricting your access. (I have seen this happen on several different RDBMSs, if they are not shut down properly).


Can you start with a clean copy of the FB database?


Can you run the query through ViennaSQL or the SQL GUI that comes with FB?


Can you approximate the db on another RDBMS (the built-in PointBase allows uo to 500 records in a db)?


You didn't include the contents of the query in the error message -- Is CF choking on the query or FB?


If it is CF, could you create the query string as a variable, display it, then include it between the cfquery tags? It would be nice to see the query.


Whenyou do resololve it, please post the solution.


Dick



Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • problem cf debugging
    2003-01-21 12:58:17  anonymous2 [View]

    Dick,

    I am accessing the FB DB with no problems at all. And I access the FB DB through SQL4X Manager J just fine.

    The query error is happening not in my cfm page but the CFMX debugging cfm page and if I turn off debugging I get no errors at all.

    Ian

    PS - if you want to look at the query you have a copy already on your machine in the /[jrun root]/servers/[server name]/cfusion/WEB-INF/debug/classic.cfm file on line 214. here is a copy if you'd like to see.

    <cfquery dbType="query" name="cfdebug_execution" debug="false">
    SELECT (endTime - startTime) AS executionTime
    FROM qEvents
    WHERE type = 'ExecutionTime'
    </cfquery>