Database —
Having dealt with this lost connection issue more than a few times I thought I should write down the solution.
From the Mongrel FAQs:
Q: Mongrel stops working if it’s left alone for a long time.
If you find that Mongrel stops working after a long idle time
and you’re using MySQL then you’re hitting a bug in the [...]
I came across a cool plugin for Rails that allows you to analyze your queries in MySQL. It takes advantage of the EXPLAIN statement, which you can read about here if you aren’t already familiar with it. And if you aren’t familiar with it, you should get familiar with it :) It’s a really easy [...]
I’m in the process of porting an MSSQL databse to MySQL which powers a CFMX 7 application. Some of the query calls were getting hung up when using multiple queries inside one cfquery tag. By default multiple queries are not permitted. After digging around on the mysql site, turns out there are a [...]
I keep forgetting how to do this and then where to find my notes, so I thought I would post it here…easy to find later.
1. Download MySQL Connector/J 3.1.12..
2. Extract this file and find a file named “mysql-connector-java-3.1.12-bin.jar”. Copy this file into “[cfmx_root]/runtime/lib” (this is for windows)
3. Restart the ColdFusion server.
4. Use the [...]
I’ve been a big fan of MySQL for quite a while, and one of the reasons is its ease and simplicity of use. I’m in the process of migrating a SQL Server database to MySQL and aside from the relief that moving away from SQL Server will bring, I have to mention MySQL’s Migration [...]