The host in question is Media3.net. And, unfortunately while investigating the DB driver question, I discovered they DO have cfexecute turned on!
I recommended they consider Fusionlink, but they picked Media3 because they were listed as a partner on Adobe's website, and because they were turned on by cool control panels and the illusion of control. I can guess why cfexecute is a bad idea, but why exactly -- What's a good example of the risk? Thanks, Clarke -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of John Mason Sent: Wednesday, July 08, 2009 2:54 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL And if they have cfexecute access turn on, get off that host :) John Teddy R. Payne wrote: > If you have CFEXECUTE ability, here is a curious post for that question: > > http://blog.pengoworks.com/index.cfm/2008/1/15/Display-ColdFusion-JDBC-Drivers-on-Windows > > > Teddy R. Payne, ACCFD > Google Talk - teddyrpa...@gmail.com <mailto:teddyrpa...@gmail.com> > > > > On Wed, Jul 8, 2009 at 2:48 PM, John Mason <ma...@fusionlink.com > <mailto:ma...@fusionlink.com>> wrote: > > You'll need to ask the host. > > John > > > > Clarke Bishop wrote: > > 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> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On Behalf Of > John Mason > Sent: Wednesday, July 08, 2009 2:31 PM > To: discussion@acfug.org <mailto: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> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On > Behalf Of Wes Byrd > Sent: Wednesday, July 08, 2009 11:02 AM > To: discussion@acfug.org <mailto: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> > [mailto:ad...@acfug.org <mailto:ad...@acfug.org>] On > Behalf Of Clarke > Bishop > Sent: Wednesday, July 08, 2009 10:42 AM > To: discussion@acfug.org <mailto: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 > <http://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 > ------------------------------------------------------------- > > > > > > > > > > ------------------------------------------------------------- > 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 -------------------------------------------------------------