MySQL Connector/J - driver not recognised

This should help.

http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=tn_19170

Connector/J version 3.1 release 3.1.11 or 3.1.12 cannot be used with
ColdFusion MX 7 because of mySQL Bug 13469. Connector/J 3.1.13 fixes this
bug, so driver version 3.1.10 or 3.1.13 should be used. All Connector/J
version 3.0 releases and all (currently beta) version 3.2 releases work with
ColdFusion MX 7.

http://dev.mysql.com/downloads/connector/j/3.1.html

--
Ken Ford
Adobe Community Expert
Fordwebs, LLC
http://www.fordwebs.com


"erasmus" <webforumsuser@macromedia.com> wrote in message
news:ehfiso$8ig$1@forums.macromedia.com...
> CF version: ColdFusion MX7
> MySQL: Ver 14.12 Distrib 5.0.22, for pc-linux-gnu (i486) using readline
> 5.1
> platform: ubuntu 6.06
> JDBC URL: jdbc:mysql://nbox:3306/recordings *
> driver class: com.mysql.jdbc.driver
> driver name: MySQL Connector/J
> driver jar:
> /opt/coldfusionmx7/wwwroot/WEB-INF/lib/mysql-connector-java-5.0.3-bin.jar
>
> message: java.sql.SQLException: No suitable driver available for
> ngn_recordings, please check the driver setting in resources file, error:
> null
>
> In an ideal world, I feel, the installation would check itself and show
> the
> driver in the pull-down ;-}
> Failing that, can anyone out there give me clear and unambiguous
> instructions
> for getting MX7 on speaking-terms with my database? Thanks in advance,
> especially as anyone with this valuable knowledge probably has to post it
> here
> pretty regularly ... even if I didn't immediately find it with a forum
> search.
>
> N
>
> * database alive and well when checked from MyQSL command-line ...
>