Coldfusion Administration:Adding Data Sources Error

[abhishek77]

* Connection verification failed for data source: online_store
[]java.sql.SQLException: Communication failure during handshake. Is there a
server running on localhost:3306?
The root cause was that: java.sql.SQLException: Communication failure during
handshake. Is there a server running on localhost:3306?

Thats the message I get when I try to add a mysql database using the
coldfusion admin page. I never get this error when I add an access database.

Where could I be going wrong?

Could anyone help or suggest something?

[Jochem van Dieten **AdobeCommunityExpert**]

abhishek77 wrote:

> * Connection verification failed for data source: online_store
> []java.sql.SQLException: Communication failure during handshake. Is there a
> server running on localhost:3306?
> The root cause was that: java.sql.SQLException: Communication failure during
> handshake. Is there a server running on localhost:3306?
>
> Thats the message I get when I try to add a mysql database using the
> coldfusion admin page. I never get this error when I add an access database.

[url]http://www.adobe.com/cfusion/search/index.cfm?loc=en_us&term=Communication+failure+dur ing+handshake[/url]

Jochem


--
Jochem van Dieten
Adobe Community Expert for ColdFusion

[abhishek77]

I followed the instructions from that link but i am still facing some problems.
[url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]

Regd the drivers and connectors, I had downloaded MySQL Connector/J 5.0

where it states to enter jdbc url, i entered in the following:
jdbc:mysql://[localhost]:[3306]/[online_store]

for driver class: com.mysql.jdbc.5.0.4

I am confused with steps 2 and 3.

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 thecf_root/WEB-INF/lib
directory.

What i am confused about is do we extract the main zip file to a folder of
same name and copy and paste the jar file to destination folder or do we
extract the jar file itself which opens up 3 folders and paste to destination
folder?

below is the error i get.

Connection verification failed for data source: online_store
[]java.sql.SQLException: No suitable driver available for online_store, please
check the driver setting in resources file, error: com.mysql.jdbc.5.0.4
The root cause was that: java.sql.SQLException: No suitable driver available
for online_store, please check the driver setting in resources file, error:
com.mysql.jdbc.5.0.4

also would you know how to add a .sql file as a datasource to coldfusion
administration?

[Ken Ford - *ACE*]

Extract the mysql-connector-java-5.0.4-bin.jar file only.

Place it in the WEB-INF/lib folder.

Restart ColdFusion services

Don't use the brackets, do it like this:

jdbc:mysql://localhost:3306/online_store

And the Driver class should be exactly like this:

com.mysql.jdbc.Driver


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


"abhishek77" <webforumsuser@macromedia.com> wrote in message
news:en5ij8$7bm$1@forums.macromedia.com...

>I followed the instructions from that link but i am still facing some
>problems.
> [url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]
>
> Regd the drivers and connectors, I had downloaded MySQL Connector/J 5.0
>
> where it states to enter jdbc url, i entered in the following:
> jdbc:mysql://[localhost]:[3306]/[online_store]
>
> for driver class: com.mysql.jdbc.5.0.4
>
> I am confused with steps 2 and 3.
>
> 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
> thecf_root/WEB-INF/lib
> directory.
>
> What i am confused about is do we extract the main zip file to a folder of
> same name and copy and paste the jar file to destination folder or do we
> extract the jar file itself which opens up 3 folders and paste to
> destination
> folder?
>
> below is the error i get.
>
> Connection verification failed for data source: online_store
> []java.sql.SQLException: No suitable driver available for online_store,
> please
> check the driver setting in resources file, error: com.mysql.jdbc.5.0.4
> The root cause was that: java.sql.SQLException: No suitable driver
> available
> for online_store, please check the driver setting in resources file,
> error:
> com.mysql.jdbc.5.0.4
>
> also would you know how to add a .sql file as a datasource to coldfusion
> administration?
>

[Ventice Tech]

I did it and it worked like a charm.

One thing to note, the WEB-INF/lib folder is under your cold fusion mx install
directory for those who may not have known (e.g.
C:\CFusionMX7\wwwroot\WEB-INF\lib)

[q]Originally posted by: Newsgroup User
Extract the mysql-connector-java-5.0.4-bin.jar file only.

Place it in the WEB-INF/lib folder.

Restart ColdFusion services

Don't use the brackets, do it like this:

jdbc:mysql://localhost:3306/online_store

And the Driver class should be exactly like this:

com.mysql.jdbc.Driver


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


"abhishek77" <webforumsuser@macromedia.com> wrote in message
news:en5ij8$7bm$1@forums.macromedia.com...

>I followed the instructions from that link but i am still facing some
>problems.
> [url]http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253[/url]
>
> Regd the drivers and connectors, I had downloaded MySQL Connector/J 5.0
>
> where it states to enter jdbc url, i entered in the following:
> jdbc:mysql://[localhost]:[3306]/[online_store]
>
> for driver class: com.mysql.jdbc.5.0.4
>
> I am confused with steps 2 and 3.
>
> 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
> thecf_root/WEB-INF/lib
> directory.
>
> What i am confused about is do we extract the main zip file to a folder of
> same name and copy and paste the jar file to destination folder or do we
> extract the jar file itself which opens up 3 folders and paste to
> destination
> folder?
>
> below is the error i get.
>
> Connection verification failed for data source: online_store
> []java.sql.SQLException: No suitable driver available for online_store,
> please
> check the driver setting in resources file, error: com.mysql.jdbc.5.0.4
> The root cause was that: java.sql.SQLException: No suitable driver
> available
> for online_store, please check the driver setting in resources file,
> error:
> com.mysql.jdbc.5.0.4
>
> also would you know how to add a .sql file as a datasource to coldfusion
> administration?
>

[/q]