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
-------------------------------------------------------------