I'm going to guess that the reported OS version is actually MS Server 2008 and not Vista... or at least I hope so!
The application and the database are obviously on different machines... they could even be in different datacenters half way across the world for all we know. Do you know? There could be a network related problem between the two servers... it could happen. :-) Another thing to consider is the shared hosting scenario. There is just no telling what is going on with the hundreds of other sites using the two different servers. The MySQL server in question might be getting Flushed all the time while new users and databases are added. The service may be restarted as configuration changes happen. "Way back in my day" I had some CF sites hosted on a shared server. It was Linux and Apache. Every time the host would add a new site to the server, they would bounce Apache. Constantly all my sites were going up and down up and down. That was my breaking point to go with a dedicated server and host my customers where I had full control. Anyway... sorry for the tangent. The issue appears to be caused by loss of connection with the database. This is most likely not a CF problem... or a MySQL problem... or maybe not even a problem with the JDBC drivers. My guess is its network related or related to other users of the systems causing connectivity issues (via process restarting or memory flushing and such). ... but that is only a gross guess. Sorry I can't be more specific. Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 2:21 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL Thanks Wes and everyone else who replied! Here are the specifics on the configuration: ColdFusion Version: 8,0,1,195765 Enterprise OS: Windows Vista Version 6.0 (That's kind of scary!) MySQL Version: 4.1.22 OS: Redhat Linux Server_Engine: MyISAM Thanks, Clarke -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Wednesday, July 08, 2009 11:02 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I use CF8 with MySQL almost exclusively. I use both 4.x and 5.x MySQL. I have 200+ websites using this scenario and have never seen this error. There are ton of things to consider for trouble shooting this. One is your datasource. How is that setup? Another the code itself. Yet another is the database and table setup (innoDB, MyISAM, etc...). Any chance we can get these details to help assist further? Wes -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 10:42 AM To: discussion@acfug.org Subject: [ACFUG Discuss] ColdFusion and MySQL I am troubleshooting an application that uses ColdFusion 8 and MySQL. Intermittently, it throws the error below. I've seen on the web where others have had a similar problem. Have any of you seen this? Do you know of a fix? Thanks, Clarke p.s. I originally posted this to the wrong list, so if you're on both lists, please forgive me! java.lang.NullPointerException at com.mysql.jdbc.Statement.setMaxRows(Statement.java:2178) at coldfusion.server.j2ee.sql.JRunStatement.setMaxRows(JRunStatement.java:2 14) at coldfusion.sql.Executive.executeQuery(Executive.java:1276) at coldfusion.sql.Executive.executeQuery(Executive.java:1008) at coldfusion.sql.Executive.executeQuery(Executive.java:939) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:325) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:831) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:521) at cfdbTest32ecfm1104898290.runPage(E:\web\engravedforever.com\WebTools\dbT est3 .cfm:20) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:196) at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:370) at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:273) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java: 48) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:86) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70) at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:74) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersist ence Filter.java:28) at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38) at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.CfmServlet.service(CfmServlet.java:175) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at jrun.servlet.FilterChain.doFilter(FilterChain.java:86) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServ letF ilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at jrun.servlet.FilterChain.doFilter(FilterChain.java:94) at jrun.servlet.FilterChain.service(FilterChain.java:101) at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106) at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42) at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286 ) at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543 ) at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java: 203) at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.j ava: 320) at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java :428 ) at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.jav a:26 6) at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66) ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=gin.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
