1 2 3 Previous Next 82 Replies Latest reply: Feb 1, 2012 10:13 AM by Ultimatorx Go to original post RSS
      • 40. Re: [CF8] java.lang.NullPointerException
        Fusecast Community Member
        I am having this same error
        =================================
        java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:214) at... etc... etc..
        =================================

        Is there any help on this topic? Adobe? Please?
        • 41. Re: [CF8] java.lang.NullPointerException
          JCondo
          We are having the same issues in our shop. We are running CF 8 on Solaris using Oracle as the database. The error and the inconsistency of the error is exactly how you describe. It started happening immediately after the upgrade.

          Has Adobe provided any guidance on this yet?
          • 42. Re: [CF8] java.lang.NullPointerException
            Joshua_Russell
            i have the same problem on a daily razor server. every now and then it throws a 500 error for no reason. saying there is a problem with either some system code or programming code.

            then when i refresh its fine :S
            • 43. Re: [CF8] java.lang.NullPointerException
              Fusecast Community Member
              Hey all,

              The only way I found to solve this problem thus far was to go into the Data Source Menu in the CF Admin and UNCHECK the "Maintain Connections" check box (in the Advanced settings). I know it is said this may cause other issues but I have not see any since I made the change to several virtual host account DSN's. So far it's worked great for me. You'll be the better judge in each of your different circumstances. I hope this helps cause nothing else I've tried to this point has.
              • 44. Re: [CF8] java.lang.NullPointerException
                FreedomNet Community Member
                Same problem for us - detailed description is at (created before I found this thread):

                http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=1&catid=7&threadid=13 91203&highlight_key=y&keyword1=jdbc%2EStatement%2EsetMaxRows

                Unchecking "maintain connections" is not a viable solution for us. We have a very heavy database environment.

                Does anyone else have a solution?

                Has anyone with a support contract reported it to Adobe? What's their answer.
                • 45. Re: [CF8] java.lang.NullPointerException
                  yogonaise Community Member
                  It is unbelievable that Macromedia or Adobe hasn't done anything about this bug. This serious bug is now almost a year present!

                  ColdFusion is worthless while this bug stays in it. Even the most simple query throws the error now and then. Like someone else said, usually after a period of inactivity.
                  • 46. Re: [CF8] java.lang.NullPointerException
                    yogonaise Community Member
                    By the way, my nick says junior member, but I am here since 1998 (under antoher nick, for which I don't have the email address/password anymore).

                    Anyway, after 1 year waiting for a solution from Adobe that didn't come, finally, after 10 years, I abandoned ColdFusion and I switched to PHP.

                    So Adobe, what are you gonna do? Fix this bug? If not, maybe it is better to stop with ColdFusion at all?
                    • 47. [CF8] java.lang.NullPointerException
                      Fusecast Community Member
                      I completely understand the frustration. It is a pain and to date I have yet to see a fix or any real help. This issue and an alternative to Dreamweaver (that's not CFEclipse) is what I have been asking Adobe to help CF developers out with for some time. I miss Homesite. ;)
                      • 48. Re: [CF8] java.lang.NullPointerException
                        BKBK MVP
                        Let's follow another strategy. Run the following query on the MySQL database

                        show variables;

                        What value do you get for wait_timeout and for interactive_timeout ? Each has a default value of 28800, that is, 8 hours, converted into seconds.

                        Is either of the values much lower for your MySQL server? If so, increase it or have it increased. You can do so, for example, by adding the line

                        wait_timeout=28800

                        or the line

                        interactive_timeout=28800

                        or both to the [mysqld] section of the my.ini configuration file. Restart the MySQL server for the changes to take effect.



                        • 49. Re: [CF8] java.lang.NullPointerException
                          FreedomNet Community Member
                          quote:

                          What value do you get for wait_timeout and for interactive_timeout ? Each has a default value of 28800, that is, 8 hours, converted into seconds.




                          This is a new server using Red Hat, default installation and values - both wait_timeout and internactive_timeout are 100 (not 28800). I'll change these values and do some testing and report back.
                          • 50. Re: [CF8] java.lang.NullPointerException
                            yogonaise Community Member
                            interactive_timeout: 100
                            wait_timeout: 1200

                            But this hasn't anything to do with it. It is something with the MySQL driver. With the Adobe software, it gives random errors. But when you can make the ColdFusion DSN with the Helm control panel, there are no errors. Same MySQL server with same values. Thus, the software from Helm is better than the software from Adobe...
                            • 51. Re: [CF8] java.lang.NullPointerException
                              Newsgroup_User Community Member

                              Maybe Helm uses a newer and|or better driver then ships with ColdFusion!
                              Since, while Adobe provides the drivers, they do not write them. Other
                              companies write the drivers. (P.S. this is a large reason for the price
                              difference between standard and enterprise ColdFusion, the licensee fees
                              paid by Adobe to Oracle for the native Oracle driver included in
                              Enterprise)

                              Adobe nee Macromedia nee Alaire provide documentation on how to
                              update|change database drivers anytime it is desirable to do so.
                              Especially since a stable ColdFusion server can easily live much longer
                              then the lifespan of a driver version.

                              • 52. [CF8] java.lang.NullPointerException
                                yogonaise Community Member
                                Well, with the introduction of ColdFusion 8, the least Adobe could have done was to provide a working MySQL driver. This one has a bug. And we are almost a year later, and nothing has been fixed yet.

                                I have begged my webhost not to update the older servers from CF7 to CF8 because CF8 isn't functioning 100% with the provided drivers. It is a shame that this has to happen! And my webhost agrees and they don't update any more servers. So this bug costs Adobe money, because clients do not buy the products anymore because they doesn't seem to work.
                                • 53. Re: [CF8] java.lang.NullPointerException
                                  FreedomNet Community Member
                                  quote:

                                  Originally posted by: Newsgroup User

                                  Since, while Adobe provides the drivers, they do not write them. Other
                                  companies write the drivers.



                                  Newsgroup User - Do you work for Adobe? Hope not, as I hope this is not a common view point with them.

                                  --- Rant mode ON ----
                                  Adobe charges $7,500 for this product to run on a single server and says it works with MySQL 4 or 5. We make purchasing decisions based on these claims. We don't care if they write the DB driver or acquire it. It needs to work as advertised and as it did on prior CF releases. The view that "if MySQL access does not work, you can try and find drivers yourself" is B.S. The number of people that have reported this problem and the length of time without Adobe comment/help or intervention is shameful.

                                  We had planned to open an incident ($500) with Adobe to get a resolution to this but getting a "not our problem - we did not write the driver" response is not something I care to drop $500 on.

                                  We have 3 licenses of CF Enterprise we have to decide on for a customer in 17 days. Looks like our response will be to not use CF for this client and save the $22,500 . Unfortunately we have quite a few other clients that it will be tougher to migrate off CF.
                                  --- Rant mode OFF ----

                                  BKBK - thanks for the suggestion. We will try that and if it works, or not, will report back.
                                  • 54. Re: [CF8] java.lang.NullPointerException
                                    yogonaise Community Member
                                    It was because of this thread coming alive again that I had a look at this again. Unbelievable nothing has happened!

                                    Well, to hell with it: I have spend too much time on the troubles with CF over the past years already. Do you remember the fixes and work-arounds for datasources that couldn't be found a couple of years ago? They didn't learn from that at all.

                                    And besides, my new PHP pages do load a lot faster then the same pages in ColdFusion. So I am happy without CF now!

                                    I also recall a large website called "myspace.com" which had switched from CF to .NET, with a 75% performance increase. Way to go Adobe! (now probably the slowest corporate site in the world)
                                    • 55. Re: [CF8] java.lang.NullPointerException
                                      Newsgroup_User Community Member
                                      FreedomNet wrote:

                                      > Newsgroup User - Do you work for Adobe? Hope not, as I hope this is not a
                                      > common view point with them.
                                      >

                                      No I do *NOT* work for Adobe, and these Forums are not official adobe
                                      support, but rather community friends helping friends, so since my help
                                      is undesired, I'll stop offering it to you.

                                      If one would still like a suggestion try contacting these folks who do
                                      work for Adobe, but be warned that this link is a year out of date,
                                      because that is how long it has been since I have had a need to engage
                                      Adobe with our $7,499x7 purchase.

                                      http://www.forta.com/blog/index.cfm/2007/10/9/ColdFusions-Dedicated-Account-Managers
                                      • 56. Re: [CF8] java.lang.NullPointerException
                                        FreedomNet Community Member
                                        quote:

                                        No I do *NOT* work for Adobe, and these Forums are not official adobe
                                        support, but rather community friends helping friends, so since my help
                                        is undesired, I'll stop offering it to you.




                                        Newsgroup User - my apologies. I jumped to the conclusion that you were with Adobe and that this was their "unofficial" position. That got my blood pressure up that there was no shot at a resolution and that we had invested a lot of time and money in something that did not do simple inserts or selects any longer in MySQL. Sorry.
                                        • 57. Re: [CF8] java.lang.NullPointerException
                                          FreedomNet Community Member
                                          quote:

                                          Originally posted by: BKBK
                                          Let's follow another strategy. Run the following query on the MySQL database

                                          show variables;

                                          What value do you get for wait_timeout and for interactive_timeout ? Each has a default value of 28800, that is, 8 hours, converted into seconds.

                                          Is either of the values much lower for your MySQL server? If so, increase it or have it increased. You can do so, for example, by adding the line

                                          wait_timeout=28800

                                          or the line

                                          interactive_timeout=28800

                                          or both to the [mysqld] section of the my.ini configuration file. Restart the MySQL server for the changes to take effect.



                                          BKBK - changing the 2 timeout's above appears to have done the trick for us - THANK YOU SO MUCH! We will keep testing, as it is possible it has not shown up yet since it is an intermittent thing, but I think this will work for us - thanks again!
                                          • 58. Re: [CF8] java.lang.NullPointerException
                                            FreedomNet Community Member
                                            quote:

                                            changing the 2 timeout's above appears to have done the trick for us - ...



                                            Spoke too soon, changing the timeout values does not resolve this issue. Does any one else have a suggestion?
                                            • 59. Re: [CF8] java.lang.NullPointerException
                                              wbnc1902
                                              I too am having the same null pointer exception issue. After talking my boss into spending $7K on CF8 Enterprise, I cannot just jump ship to PHP, so I will love to know if there is anything we can about this.

                                              I have turned off "Maintain Connection across all clients" on my test database connection to see if that will help. But it looks like this issue (from reading the above posts) has something to do with the MySQL 4/5 driver. I seriously hope something can be done about this as I have been thinking it was my code all along.
                                              • 60. [CF8] java.lang.NullPointerException
                                                (BPC)
                                                Sign me up as another casualty of this debilitating error inflicted upon a CF8/MySQL 5.0 user.

                                                Here it is for all to see again and again and again...


                                                "Error Occurred While Processing Request

                                                The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.

                                                Null Pointers are another name for undefined values."
                                                • 61. Re: [CF8] java.lang.NullPointerException
                                                  BKBK MVP
                                                  In my opinion, the best clue to this puzzel so far is that given by Rich.Thibault early on in this thread, namely,

                                                  " ... your post got me looking at their source code. The NPE happens at line 2178, which I believe is this line inside setMaxRows():

                                                  http://svn.mysql.com/svnpublic/connector-j/tags/5.0.5/connector-j/src/com/mysql/jdbc/State ment.java

                                                  this.connection.unsetMaxRows(this);

                                                  So it looks like CF is invoking setMaxRows() after the connection has already gone dead (null). It should be detecting the dead connection, removing it from the pool, and starting a new one."



                                                  • 62. Re: [CF8] java.lang.NullPointerException
                                                    wbnc1902 Community Member
                                                    Is there anything that can be done on our end to prevent, reduce this problem? I have, for the moment, had some luck by unchecking " Maintain connections across client requests". However this problem seems to be so random that I am not sure if it has been fixed or I just have not experienced it yet.
                                                    • 63. Re: [CF8] java.lang.NullPointerException
                                                      peter farrer
                                                      :smile; My first ever posting so please be patient with me.
                                                      I have had the same problem and this forum has helped greatly, many thanks to all. While I am getting my ISP to change the wait_timeout from 20 secs. I have put in place this fix in the application.cfc file.

                                                      <cftry>
                                                      <CFQUERY NAME="qGlobalStatus"
                                                      DATASOURCE="#application.shopDSN#"
                                                      USERNAME="#application.userName#"
                                                      PASSWORD="#application.shopPass#">

                                                      SELECT fldErrorhandling,
                                                      fldShopOpen
                                                      FROM tglobals;
                                                      </CFQUERY>
                                                      <CFIF qGlobalStatus.fldShopOpen EQ False>
                                                      <CFLOCATION addtoken="no" url="shopClosed.htm">
                                                      </CFIF>
                                                      <!---to prevent page error caused by mysql wait_timeout; set too low.--->
                                                      <cfcatch type="java.lang.NullPointerException">
                                                      <CFLOCATION addtoken="no" url="#CGI.SCRIPT_NAME#?#CGI.QUERY_STRING#">
                                                      </cfcatch>
                                                      </cftry>
                                                      • 64. Re: [CF8] java.lang.NullPointerException
                                                        peter farrer Community Member
                                                        :smile; My first ever posting so please be patient with me.
                                                        I have had the same problem and this forum has helped greatly, many thanks to all. While I am getting my ISP to change the wait_timeout from 20 secs. I have put in place this fix in the application.cfc file.


                                                        <cftry>
                                                        <CFQUERY NAME="qGlobalStatus"
                                                        DATASOURCE="#application.shopDSN#"
                                                        USERNAME="#application.userName#"
                                                        PASSWORD="#application.shopPass#">

                                                        SELECT fldErrorhandling,
                                                        fldShopOpen
                                                        FROM tglobals;
                                                        </CFQUERY>

                                                        <!---to prevent page error caused by mysql wait_timeout; set too low.--->
                                                        <cfcatch type="java.lang.NullPointerException">
                                                        <CFLOCATION addtoken="no" url="#CGI.SCRIPT_NAME#?#CGI.QUERY_STRING#">
                                                        </cfcatch>
                                                        </cftry>
                                                        It works well and certainly easier than recoding in php or .net.
                                                        • 65. Re: [CF8] java.lang.NullPointerException
                                                          peter farrer Community Member
                                                          :smile; My first ever posting so please be patient with me.
                                                          I have had the same problem and this forum has helped greatly, many thanks to all. While I am getting my ISP to change the wait_timeout from 20 secs. I have put in place this fix in the application.cfc file.


                                                          <cftry>
                                                          <CFQUERY NAME="qGlobalStatus"
                                                          DATASOURCE="#application.shopDSN#"
                                                          USERNAME="#application.userName#"
                                                          PASSWORD="#application.shopPass#">

                                                          SELECT fldErrorhandling,
                                                          fldShopOpen
                                                          FROM tglobals;
                                                          </CFQUERY>

                                                          <!---to prevent page error caused by mysql wait_timeout; set too low.--->
                                                          <cfcatch type="java.lang.NullPointerException">
                                                          <CFLOCATION addtoken="no" url="#CGI.SCRIPT_NAME#?#CGI.QUERY_STRING#">
                                                          </cfcatch>
                                                          </cftry>
                                                          It works well and certainly easier than recoding in php or .net.
                                                          • 66. Re: [CF8] java.lang.NullPointerException
                                                            peter farrer Community Member
                                                            Sorry about the 3 posts but the forum website is acting strangely. pete
                                                            • 67. Re: [CF8] java.lang.NullPointerException
                                                              peter farrer Community Member
                                                              Sorry about the 3 posts but the forum website is acting strangely. pete
                                                              • 68. Re: [CF8] java.lang.NullPointerException
                                                                yogonaise Community Member
                                                                Ofcourse it is acting strangely, it is written in ColdFusion.
                                                                • 69. Re: [CF8] java.lang.NullPointerException
                                                                  Newsgroup_User Community Member
                                                                  Hello yogonaise,

                                                                  Instead of ??????

                                                                  > Ofcourse it is acting strangely, it is written in ColdFusion.
                                                                  >


                                                                  • 70. Re: [CF8] java.lang.NullPointerException
                                                                    BKBK MVP

                                                                    I have an idea. Coldfusion 8 has a new setting in the Administrator for MySQL datasources. It is the checkbox field, "Validation query". My idea is that it has something to do with this particular NullPointerException.

                                                                     

                                                                    To my knowledge, no one yet knows what is responsible for the broken connection. Is it the database driver, the database itself or an external influence such as a firewall? However, we know one thing for sure. When the current connection drops, the driver makes no attempt to get a new connection from the connection pool. That led me to the following hypothesis about how Coldfusion 8 and the MySQL driver work together:

                                                                     

                                                                    1) if the current connection fails the Validation Query must run

                                                                     

                                                                    and

                                                                     

                                                                    2) if the Validation Query fails, no new connection is obtained from the connection pool; instead, an exception is silently thrown.

                                                                     

                                                                    That could then explain the NullPointerException. By default, the Validation Query field is empty. If, for whatever reason, the database connection is broken then, by my hypothesis, the validation query is run. This fails, for the query is nonexistent. As a result, no new connection is obtained from the connection pool. Instead, an exception is silently thrown.

                                                                    • 71. Re: [CF8] java.lang.NullPointerException
                                                                      OldStyle33

                                                                      Has a solution to this bug been created?  I am receiving the same random error when we upgraded to CF8 from CF7.  Please help...

                                                                       

                                                                      Server Product  ColdFusion 
                                                                      Version  8,0,1,195765   
                                                                      Edition  Standard   
                                                                      Java Version  1.6.0_04   
                                                                      Java Vendor  Sun Microsystems Inc.   
                                                                      Java Vendor URL  http://java.sun.com/   
                                                                      Java Home  C:\ColdFusion8\runtime\jre   
                                                                      Driver  SeeFusion (MySQL5) - mysql-connector-java-commercial-5.0.5-bin.jar, seefusion.jar

                                                                      • 72. Re: [CF8] java.lang.NullPointerException
                                                                        MaryJo Community Member

                                                                        I wanted to resurrect this old post because I have a client that is seeing this error on a site and he's tried moving it to CF9 and is getting the same error. It does generally occur on the same query, but it's a pretty simply update statement, the only variable in the query is definitely not null (verified in an error dump), the same code runs fine on many other sites without issue. But we are seeing this on a regular basis:

                                                                         

                                                                        java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.sql.Executive.executeQuery(Executive.java:1267) at coldfusion.sql.Executive.executeQuery(Executive.java:1009) at coldfusion.sql.Executive.executeQuery(Executive.java:940) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:838) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:528)

                                                                         

                                                                        Has anyone found a solution for this?

                                                                        • 73. Re: [CF8] java.lang.NullPointerException
                                                                          MaryJo Community Member

                                                                          Oops, small correction. It does appear the setMaxRows issue was indeed corrected in CF9 and we're now getting the underlying error that caused that one to occur on CF8. We haven't yet figured it out yet but does appear to be something that's causing a null exception...I've got enough information on the exact steps that recreate it so should be able to track it down.

                                                                          • 74. Re: [CF8] java.lang.NullPointerException
                                                                            mwollny

                                                                            We're suffering from the same issue; unfortunately none of the suggestions in this thread have done anything for us. I have created a detailed explanation of the symptoms in my blog at http://devbox.computec.de/2010/06/coldfusion-8-and-mysql-5-1-via-jdbc-help-needed/. Is there any news or any other suggestions to get CF8 and MySQL 5.1 to play nice?

                                                                            • 75. Re: [CF8] java.lang.NullPointerException
                                                                              sloap_000

                                                                              We finally figured this out on our box.  Turns out that we had set the maxtimeout on the mysql box low for some other applications we have running against it.  So, when we configured the timeout for each datasource to be less than the maxtimeout on the mysql box, all was well. set mysql max timeout = 60 seconds...datasource timeouts at 58 seconds.  obviously, you can configure as you see fit, we figured at the one minute point someone was throwing the keyboard anyway. ;-)

                                                                              • 76. Re: [CF8] java.lang.NullPointerException
                                                                                Shrutipriya

                                                                                Hi I am working on an application which requires integration with Twitter. I have used twitter4j api,n when i tried to run the server and client it is giving the following error.  Can you help me get through this.

                                                                                 

                                                                                [Thread-4] INFO  twitter4j.internal.logging.Logger - Will use class

                                                                                twitter4j.internal.logging.SLF4JLoggerFactory as logging factory.

                                                                                14:20:48.375 [Thread-4] INFO  t.internal.http.HttpClientFactory - Will use twitt

                                                                                er4j.internal.http.alternative.HttpClientImpl as HttpClient implementation.

                                                                                14:20:48.531 [Thread-4] DEBUG twitter4j.http.OAuthAuthorization - OAuth base str

                                                                                ing: POST&http%3A%2F%2Fapi.twitter.com%2F1%2Fdirect_messages%2Fnew.json&oauth_co

                                                                                nsumer_key%3D2n2xvpH3gK1gjAawipnDw%26oauth_nonce%3D-385779984%26oauth_signature_

                                                                                method%3DHMAC-SHA1%26oauth_timestamp%3D1285568448%26oauth_token%3D180266706-lOs2

                                                                                Jj46bXBTsKJaQiE4XMM0Vj3z6Jslg5UgpEVS%26oauth_version%3D1.0%26screen_name%3Dpifi3

                                                                                %26text%3Daaa

                                                                                java.lang.NullPointerException

                                                                                        at twitter4j.internal.http.BASE64Encoder.encode(BASE64Encoder.java:46)

                                                                                        at twitter4j.http.OAuthAuthorization.generateSignature(OAuthAuthorizatio

                                                                                n.java:321)

                                                                                        at twitter4j.http.OAuthAuthorization.generateAuthorizationHeader(OAuthAu

                                                                                thorization.java:216)

                                                                                        at twitter4j.http.OAuthAuthorization.generateAuthorizationHeader(OAuthAu

                                                                                thorization.java:257)

                                                                                        at twitter4j.http.OAuthAuthorization.getAuthorizationHeader(OAuthAuthori

                                                                                zation.java:95)

                                                                                        at twitter4j.internal.http.alternative.HttpClientImpl.request(HttpClient

                                                                                Impl.java:166)

                                                                                        at twitter4j.internal.http.HttpClientWrapper.request(HttpClientWrapper.j

                                                                                ava:72)

                                                                                        at twitter4j.internal.http.HttpClientWrapper.post(HttpClientWrapper.java

                                                                                :103)

                                                                                        at twitter4j.Twitter.sendDirectMessage(Twitter.java:964)

                                                                                        at multiverse.org.mxr.qri.server.util.TwitterIntegration1.SendChatMessag

                                                                                e(TwitterIntegration1.java:55)

                                                                                        at multiverse.org.mxr.qri.server.service.impl.GiftSendService.process(Gi

                                                                                ftSendService.java:127)

                                                                                        at multiverse.org.mxr.qri.server.service.impl.GiftSendService.<init>(Gif

                                                                                tSendService.java:41)

                                                                                        at multiverse.org.mxr.qri.server.util.MessageRouter.run(MessageRouter.ja

                                                                                va:40)

                                                                                • 77. Re: [CF8] java.lang.NullPointerException
                                                                                  Steve.Rittler

                                                                                  Shrutipriya-

                                                                                  Please start a new thread - this is not at all related to the topic the others were talking about.

                                                                                   

                                                                                  Also, if you haven't gone too far with your solution, I highly recommend using the monkehTweet project to connect to Twitter from ColdFusion. Open source, works great (using it on a project now) and really easy to work with.  http://monkehtweet.riaforge.org/

                                                                                   

                                                                                  Steve

                                                                                  • 78. Re: [CF8] java.lang.NullPointerException
                                                                                    agentfitz3

                                                                                    I am suffering from this same problem.  I am receiving all sorts of random, disturbing errors, and after realizing that all the stacktraces started the same way, I found myself here.

                                                                                     

                                                                                    All the errors start like this: java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178)

                                                                                     

                                                                                    Is anyone aware of any reliable fix for this??


                                                                                    Thanks,

                                                                                    Brian

                                                                                    • 79. Re: [CF8] java.lang.NullPointerException
                                                                                      Steve.Rittler Community Member

                                                                                      Have you tried tweaking all the timeout settings (both on the CF and MySQL side) as suggested in any of the prior posts?

                                                                                       

                                                                                      Failing that, please provide more information:

                                                                                      * OS/version

                                                                                      * CF version (and any/all updaters and hotfixes applied)

                                                                                      * code snippet

                                                                                      * exact exception/stack information

                                                                                       

                                                                                      Or if you don't feel like doing any of that, try a clean re-installation of ColdFusion. I know it sounds dramatic, but sometimes it's the easiest way out.

                                                                                       

                                                                                      steve