Connecting to MySQL 5.0, How?

[feiloiram]

Hi,

I run everything on my local machine that is WIN XP SP2 with IIS, Coldfusion
MX7.0
I just installed MySQL5.0, the service is running and can be reached with
MySQL-client.

I'm trying to set up a new datasource to the MySQL test-database and used the
following guidelines for it:
[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

Basicaly this is what it says :

1.Download a current, stable version of the MySQL Connector J JDBC driver,
available at: [url]http://dev.mysql.com/doc/connector/j/en/index.html[/url]
2.Extract the mysql-connector-java-3.{n}-bin.jar file from the downloaded
archive file.
3.Save the mysql-connector-java-3.{n}-bin.jar file in the cf_root/WEB-INF/lib
directory.
4.Restart the ColdFusion MX server.
5.Add a new data source to the ColdFusion MX Administrator, using the driver
option Other.
Enter the JDBC URL:
jdbc:mysql://[host]:[port]/[database]
6.Enter the Driver Class:
com.mysql.jdbc.Driver
7.Complete username/password, and adjust other data source settings, if
needed.
8.Submit the data source for verification.

This technote is meant for connecting to a MySQL 4.1 and not 5.0.
So the first question should be if this technote is relevant or not.
If not, where can I find more info or can anybody help me?

If it is relevant and also (I think) in all other cases : What is the
port-number through witch I can reach de MySQL-service?

Thx

[feiloiram]

Its me again,

The problem is solved.
I post this answer so nobody wastes time on answering it and also that
everybody knows that the above mentioned Knowledge-page is indeed relevant for
CFMW7.0 en MySQL5.0

I checked were my ...jar -file was and it wasn't in the lib-directory. When I
moved it to that folder I forgot to restart my CF-service.

See you

[mpwoodward *TMM*]

feiloiram wrote:

> Its me again,
>
> The problem is solved.
> I post this answer so nobody wastes time on answering it and also that
> everybody knows that the above mentioned Knowledge-page is indeed relevant for
> CFMW7.0 en MySQL5.0
>
> I checked were my ...jar -file was and it wasn't in the lib-directory. When I
> moved it to that folder I forgot to restart my CF-service.
>
> See you
>

Great to hear you got this resolved. As an aside, you can use this same
method to connect to more or less *any* database that has a JDBC driver
available.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[mxstu]

>As an aside, you can use this same method to connect to more or less *any*
database that has a JDBC driver available.

Matt,

Thanks, that is a good point. Do you know if you connect to "remote"
databases using this method? I have not had a chance to test it, but I would
think you can using the remote server address in the jdbc url.

[cf_menace]

mxstu, you're just connecting to another database. It doesn't make any
difference if it's on your local machine or on a separate (remote) machine, you
use the same connection string using the database server's IP address or URL.
The only thing that will keep you from connecting to a remote db is if the db
server only allows the db user to connect from a specific IP address.

[mxstu]

cf_menace,

That was pretty much what I was thinking. A jdbc url is still a url.. whether
it is for a local or remote machine, but not having tried it myself, I just
wanted confirmation ;-) Thanks.

So what has your experience been with datasources for remote databases? Any
issues or is it pretty much the same as local datasources?

[mpwoodward *TMM*]

mxstu wrote:

>>As an aside, you can use this same method to connect to more or less *any*

>
> database that has a JDBC driver available.
>
> Matt,
>
> Thanks, that is a good point. Do you know if you connect to "remote"
> databases using this method? I have not had a chance to test it, but I would
> think you can using the remote server address in the jdbc url.

Absolutely--as long as the CF server can "see" the database server (in
other words, the db server is available over the network, the right
ports are open, etc.) you can connect to it. It doesn't care whether
it's local or remote.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[mxstu]

Great! Thanks Matt.