RE: [ACFUG Discuss] ColdFusion and MySQL
I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - 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 -
RE: [ACFUG Discuss] ColdFusion and MySQL
Sorry if I wasn't clear about something. As you said, Maintain connections across client requests is the default. It's when you turn it off that the mySQL problem goes away with some server/driver configurations. If maintain connections is off, then CF has to recreate the connection for each query which obviously hurts performance and server load. However, with maintain connections off, the mySQL problem goes away. I think that what's happening is that ColdFusion somehow loses track of the database connection, but then still tries to use the connection. And, the error I've seen is the result. If CF always has to recreate the connection, it can't lose track so everything is fine. Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Friday, July 10, 2009 1:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL That's very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The Maintain connections across client requests is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured. where is the problem with this? I don't see any real performance impact because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 http://www.dynapp.com/ _ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - 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 FusionLink 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 FusionLink 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 - image001.gif
Re: [ACFUG Discuss] ColdFusion and MySQL
If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children. -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the performance hit from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron On Fri, Jul 10, 2009 at 1:59 PM, Clarke Bishopcbis...@resultantsys.com wrote: Sorry if I wasn’t clear about something. As you said, “Maintain connections across client requests” is the default. It’s when you turn it off that the mySQL problem goes away with some server/driver configurations. If maintain connections is off, then CF has to recreate the connection for each query which obviously hurts performance and server load. However, with maintain connections off, the mySQL problem goes away. I think that what’s happening is that ColdFusion somehow loses track of the database connection, but then still tries to use the connection. And, the error I’ve seen is the result. If CF always has to recreate the connection, it can’t lose track so everything is fine. Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Friday, July 10, 2009 1:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL That’s very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The “Maintain connections across client requests” is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured… where is the problem with this? I don’t see any real “performance impact” because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: · The problem exists only for MySQL with ColdFusion running under Windows · If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn’t a fix. · So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn’t find it and throws the error. · Maybe there’s a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it’s a ColdFusion or MySQL bug. I just don’t know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke - To unsubscribe from this list, manage your
RE: [ACFUG Discuss] ColdFusion and MySQL
Sorry to ask a dumb question, but how, exactly would you Test the system. Do you mean use some set of methods to try and break in, or is there some sort of standard test suite? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dean H. Saxe Sent: Friday, July 10, 2009 2:40 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children. -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the performance hit from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron - 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 -
Re: [ACFUG Discuss] ColdFusion and MySQL
There are many suites you can use (Foundstone Enterprise, Nessus, etc.) and manual methods too. But unless your host agrees to it and you want to pay for it, you're left with whatever info they can give you about penetration testing they have had done in the past. -dhs -- Dean H. Saxe d...@fullfrontalnerdity.com A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children. -- John James Audubon On Jul 10, 2009, at 4:35 PM, Clarke Bishop wrote: Sorry to ask a dumb question, but how, exactly would you Test the system. Do you mean use some set of methods to try and break in, or is there some sort of standard test suite? Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Dean H. Saxe Sent: Friday, July 10, 2009 2:40 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL If you have security concerns, there is only one way to figure out if they are valid. Test the system. With permission, of course. Dean H. Saxe d...@fullfrontalnerdity.com A true conservationist is a person who knows that the world is not given by his fathers, but borrowed from his children. -- John James Audubon On Jul 10, 2009, at 2:30 PM, Clarke Bishop wrote: I looked, but couldn't find the message you mentioned. Please resend it. I'm about to conclude that I just need to switch hosts due to security concerns, so that may fix the problem, too. Clarke -Original Message- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Cameron Childress Sent: Friday, July 10, 2009 2:10 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Clarke- Did you see the message I forwarded to the list a few days ago regarding compression in the driver? Also - I'm not sure what the load profile of this website is, but the performance hit from turning maintain connections off is not usually visible till you are under relatively high load. When you turned it off, did you see a performance degrade? If not, it may be an easier (and less expensive) fix than changing DB platforms. -Cameron - 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 -
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Just to be clear, I didn’t take it as patronizing. “We cool.” :-) But I stand by my statement (and confused by Jasun’s laughter. I was being serious. But maybe that’s what he was laughing at.) /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 5:36 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL All, And allow me to apologize here as I did not hit the correct reply to send a personal note to Charlie. I am by no means trying to be patronizing in public here. I was attempting to resolve a difference in vernacular. Mia culpa Charlie, Teddy - 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 -
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Ah, ok. Thanks. :-) And to be clear, Teddy, I did in my reply say that you could have meant either form of bandwidth. Meant to clarify that in my note below. Juggling many things today, including a very cool announcement to come later today about a special CF Meetup event. Will share more after I post that later today. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Jasun Sent: Thursday, July 09, 2009 2:16 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL I wasn't laughing at what you said Charlie. To the contrary... I had to agree. What I found amusing had to do with the irony that some of us may not have the bandwidth to deal with links broken by a line wrap, but we will go to great lengths to point out that it IS broken. And Teddy... no offense intended. You should always feel free to take my comments and throw them in a vat of acid... ;) - 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 -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
I wasn't laughing at what you said Charlie. To the contrary... I had to agree. What I found amusing had to do with the irony that some of us may not have the bandwidth to deal with links broken by a line wrap, but we will go to great lengths to point out that it IS broken. And Teddy... no offense intended. You should always feel free to take my comments and throw them in a vat of acid... ;) On Thu, Jul 9, 2009 at 1:47 PM, Charlie Arehart char...@carehart.orgwrote: Just to be clear, I didn’t take it as patronizing. “We cool.” :-) But I stand by my statement (and confused by Jasun’s laughter. I was being serious. But maybe that’s what he was laughing at.) /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Teddy R. Payne *Sent:* Wednesday, July 08, 2009 5:36 PM *To:* discussion@acfug.org *Subject:* Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL All, And allow me to apologize here as I did not hit the correct reply to send a personal note to Charlie. I am by no means trying to be patronizing in public here. I was attempting to resolve a difference in vernacular. Mia culpa Charlie, Teddy - 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 FusionLink http://www.fusionlink.com -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Charlie/Jasun, Excellent! And we look forward to the special announcement for the CF Meetup. Teddy
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Just posted it (on the meetup site), and was about to send it to the group here. Coming right up. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Thursday, July 09, 2009 3:13 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL Charlie/Jasun, Excellent! And we look forward to the special announcement for the CF Meetup. Teddy - 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 -
Re: [ACFUG Discuss] ColdFusion and MySQL
Clarke, What version of MySQL are you using? I believe 5+ is InnoDB storage only. Teddy
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=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 -
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
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
Re: [ACFUG Discuss] ColdFusion and MySQL
Doug G. gets a gold star for the day for the CF approach to display the drivers. =) (not being patronizing here)
RE: [ACFUG Discuss] ColdFusion and MySQL
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
Re: [ACFUG Discuss] ColdFusion and MySQL
Since you're on CF8, you can try the CFDBINFO tag. For example, cfset datasrc = myDatasource cfdbinfo type=version datasource=#datasrc# name=dbdata cfdump var=#dbdata# 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] 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 - 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 -
broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
You know, I’ve always been a bit mystified whenever anyone makes note of that. :-) I realize you said it to be helpful, Teddy, and I do appreciate the concern. More often, it’s from someone complaining. But doesn’t it happen so often that people should just realize they need to join the two lines? :-) I will note that I did a blog entry some years ago on a feature that one might be able to use in such a case, by surrounding the URL in brackets (), which some clients would honor as meaning to keep the URL together. I didn’t find it always worked, though, so I stopped worrying about it (for the reasons above): http://tipicalcharlie.blog-city.com/avoid_url_break_in_email.htm Let’s test it here: http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version And for any interested, I counted and see that this broke below at 76 chars. I looked in Outlook (my email client) and sure enough, it has a feature that sets that count (toolsoptionsmail formatmessage formatinternet formatplain text optionsautomatically wrap text at). It’s set to 76. I would wonder, if I increased that, if it might cause some readers to get email that would have regular paragraphs run off the right of the screen. :-) /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 3:56 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] ColdFusion and MySQL Charlie, I think that your URL broke across two lines. http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_version The above link should work. Teddy R. Payne, ACCFD Google Talk - teddyrpa...@gmail.com On Wed, Jul 8, 2009 at 3:38 PM, Charlie Arehart char...@carehart.org wrote: And for those not on CF8, there are still other ways that don't require CFEXECUTE or direct access to the server. Here's a blog entry I did on 3 ways to find info on the version of DB drivers being used by CF, varying based on what level of access you have to the server: http://www.carehart.org/blog/client/index.cfm/2006/8/8/checking_jdbc_driver_ version They're focused on getting info on the built-in CF drivers, but they may help. /charlie - 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 -
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Well, I hope that will help you in the future to get your URL(s) across to those (like me) who may not have too much bandwidth for any given email. T
RE: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
Eh? I don’t understand, honestly. How does a broken URL affect bandwidth? I’ll assume you don’t mean bytes but time. You mean it’s regard as an offense if a URL breaks? But it’s not something people do intentionally. It’s done by their mail clients. The solution is just to hit reply, so you can edit the email, and then hit delete at the end of the line, to be able to proceed. If someone is offering a helpful URL for a problem, it seems little odd to assert that “forcing them to do all that” to get the value of the email is an infringement/offense against their time. Since we know each other, I am certainly fascinated to have the chance to learn of this perspective. It totally surprises me, to be honest. /charlie From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Teddy R. Payne Sent: Wednesday, July 08, 2009 4:17 PM To: discussion@acfug.org Subject: Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL Well, I hope that will help you in the future to get your URL(s) across to those (like me) who may not have too much bandwidth for any given email. T - 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 -
RE: [ACFUG Discuss] ColdFusion and MySQL
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
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
omg... headache from laughing :) On Wed, Jul 8, 2009 at 4:55 PM, Charlie Arehart char...@carehart.orgwrote: Eh? I don’t understand, honestly. How does a broken URL affect bandwidth? I’ll assume you don’t mean bytes but time. You mean it’s regard as an offense if a URL breaks? But it’s not something people do intentionally. It’s done by their mail clients. The solution is just to hit reply, so you can edit the email, and then hit delete at the end of the line, to be able to proceed. If someone is offering a helpful URL for a problem, it seems little odd to assert that “forcing them to do all that” to get the value of the email is an infringement/offense against their time. Since we know each other, I am certainly fascinated to have the chance to learn of this perspective. It totally surprises me, to be honest. /charlie *From:* ad...@acfug.org [mailto:ad...@acfug.org] *On Behalf Of *Teddy R. Payne *Sent:* Wednesday, July 08, 2009 4:17 PM *To:* discussion@acfug.org *Subject:* Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL Well, I hope that will help you in the future to get your URL(s) across to those (like me) who may not have too much bandwidth for any given email. T - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformhttp://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 FusionLink http://www.fusionlink.com/ -
Re: [ACFUG Discuss] ColdFusion and MySQL
You can access and easily see other accounts hosted on that server or even gain control of the server itself. If the CF service is under Local System account privileges which is the default, cfexecute will have complete access to the server's file system. CFExecute should be turned off and the CF services should be under a custom restricted account system account. John ma...@fusionlink.com Clarke Bishop wrote: 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
Re: broken urls in email RE: [ACFUG Discuss] ColdFusion and MySQL
All, And allow me to apologize here as I did not hit the correct reply to send a personal note to Charlie. I am by no means trying to be patronizing in public here. I was attempting to resolve a difference in vernacular. Mia culpa Charlie, Teddy
