Database

JDBC Connection Strings for Coldfusion 6.1 / CFMX

Written by mark on April 14, 2009 in ColdFusion , Database , MySQL .

If you're trying to setup ColdFusion MX 6 with MySQL here's how you setup the MySQL datasources.  In CF Administrator go to Datasources and Add a New datasource of type "Other".  Enter your datasource name, username and password and the following fields like this:

JDBC URL: jdbc:mysql://192.168.1.100/DatabaseName
Driver Class: com.mysql.jdbc.Driver
Driver Name:MySQL Connector/J

Make sure you have the latest MySQL drivers installed too.

Tags : No tags

Short url : Unavailable

Discussions : Comments are closed.

MySQL Reusing/Cached Connection Problem

Written by mark on June 16, 2008 in Database , MySQL .

Problem with connecting to multiple databases within the same server is that every time you do:

mysql_connect(host, username, passwd);

it will reuse 'Resource id' for every connection, which means you will end with only one connection reference to avoid that do:

mysql_connect(host, username, passwd, true);

keeps all connections separate.

Tags : No tags

Short url : Unavailable

Discussions : Comments are closed.

SQL Fun

Written by mark on Oct. 19, 2006 in Database , MySQL .

select a.*, ba.column1, bb.column1
from tablea a
join tableb ba on a.column1 = ba.column1 and ba.column2 = 'string'
join tableb bb on a.column1 = bb.column1 and bb.column2 = 'string' and a.column2 = bb.column3
where a.column3 = 'string'

A couple of interesting things about this query. We're matching up 1 row in table a with 2 rows in table b by aliasing table b in two different ways. We're also using the "and" statement in our join, which is a neat trick.

Tags : No tags

Short url : Unavailable

Discussions : Comments are closed.