Women in Technology

Hear us Roar



Article:
  ColdFusion MX on Mac OS X, Part 4
Subject:   problem cf debugging
Date:   2003-01-20 21:03:22
From:   anonymous2
let me explain how I use my computer and develop my CF apps. I develop on my powerbook G4 and I go back and forth between the office and home all the time. And when I saw that Macromedia released a supported version of CF for the Mac I jumped at it.


I installed CFMX J2EE on JRun4 and all went well. Followed the drections, blah, blah, blah... The end of the day came so I shut everything down and took my computer home.


Got home opened up the sleeping computer and start everything up like I first started it and the page comes up just fine but *bang* all the debugging info does not work. so i plug along trying to figure it out, reinstall, get the debugging to work, restart and *bang*. I think that it comes down to permissions but, I am not sure. So I go through the steps and make sure that i always use 'sudo' and such but the debugging information has not returned.


I am frustrated and have not been able to make any progress with this. Has anyone encountered this problem and if so have you been able to fix it?



Ian Sheridan
ians@vminc.net



here is the java error that I get:


java.sql.SQLException
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:66)
at coldfusion.sql.JdbcImpl.getConnection(JdbcImpl.java:54)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:207)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:384)
at cfclassic2ecfm2048376825._factor4(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:218)
at cfclassic2ecfm2048376825._factor5(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:406)
at cfclassic2ecfm2048376825._factor6(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:613)
at cfclassic2ecfm2048376825.runPage(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:716)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:145)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:299)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:75)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:27)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:51)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:99)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:95)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:438)
at cfclassic2ecfm2048376825._factor4(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:218)
at cfclassic2ecfm2048376825._factor5(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:406)
at cfclassic2ecfm2048376825._factor6(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:613)
at cfclassic2ecfm2048376825.runPage(/opt/JRun4/servers/ians/cfusion/WEB-INF/debug/classic.cfm:716)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:145)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:299)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:62)
at coldfusion.filter.CfincludeFilter.include(CfincludeFilter.java:30)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:75)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:27)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:51)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.CfmServlet.service(CfmServlet.java:99)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:95)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)


javax.servlet.ServletException: Error Executing Database Query.
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:99)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invokeNext(JRunRequestDispatcher.java:408)
at jrun.servlet.JRunRequestDispatcher.forwardInvoke(JRunRequestDispatcher.java:378)
at jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:157)
at jrun.servlet.file.FileServlet.service(FileServlet.java:300)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:226)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

Full Threads Oldest First

Showing messages 1 through 4 of 4.

  • problem cf debugging
    2003-01-21 07:22:22  dicklacara [View]

    A couple of things:

    You don't have to shut everything down, just close the cover -- I have a TiBook and I go all over with it. Usually I have CFMX running under both JRun and Tomcat -- sometimes, even the port.-- I very seldom stop ColdFusion, except to recycle some services for new database drivers, etc.

    I assume you mean the debugging settings in the CFMX Administrator -- I have no problems retaining the settings across reboots of the system.

    You have installed JRun in a non-standard location, /opt/JRun4/ -- the standard (default ) location is /Applications/JRun4/ -- this may be causing your permissions problems.

    You should not run JRun ar CFMX as root user (su root or sudo)

    You are getting a database error -- What RDBMS are you using: At work? At home?

    Is the database on the PowerBook or another machine?

    Finally, if you think you have found a legitimate bug, you might want to contact Macromedia!

    Dick
    • problem cf debugging
      2003-01-21 11:38:54  anonymous2 [View]

      well ok the owner permissions are all now for my user. and I have stopped using sudo. boots up fine with no errors.

      About the non-standard install DIR; this problem was happening when i had installed to the deault DIR also.

      In the cf admin I have the debugging turned on in classic mode with the deault settings.

      The DB that I am using is Frontbase 3.5d. Accessing that DB through JDBC is working fine. This resides on my computer. during my trouble shooting I have removed FB's jar and I still get the DB error that I had shown above.

      The error that I have above is happening in the debugging information at the bottom of the page (essentionally the classic.cfm debugging page).

      the reason that this is making me taer my hair out is that, at first it worked.

      If I find out what the fix is I will post it here too.

      thanks,

      Ian Sheridan
      ians@vminc.net
      • problem cf debugging
        2003-01-21 12:27:20  dicklacara [View]

        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


        • 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>