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 - [email protected] On Wed, Jul 8, 2009 at 2:48 PM, John Mason <[email protected]> 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: [email protected] [mailto:[email protected]] On Behalf Of John Mason >> Sent: Wednesday, July 08, 2009 2:31 PM >> To: [email protected] >> 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: [email protected] [mailto:[email protected]] On Behalf Of Wes Byrd >>> Sent: Wednesday, July 08, 2009 11:02 AM >>> To: [email protected] >>> 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: [email protected] [mailto:[email protected]] On Behalf Of Clarke >>> Bishop >>> Sent: Wednesday, July 08, 2009 10:42 AM >>> To: [email protected] >>> 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 >> ------------------------------------------------------------- >> >> >> >> >> >> > > > > ------------------------------------------------------------- > 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 > ------------------------------------------------------------- > > > >
