Can I find that out directly, or do I have to ask the host? Clarke
-----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:31 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Can you verify that the datasource is using the 4.x driver? John Clarke Bishop wrote: > 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 ------------------------------------------------------------- ------------------------------------------------------------- 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 -------------------------------------------------------------