Skip to main content
A
Anonymous
December 29, 2006
Answered

Coldfusion Administration:Adding Data Sources Error

  • December 29, 2006
  • 1 reply
  • 2317 views
* 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?
    This topic has been closed for replies.
    Correct answer 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)

    quote:
    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
    http://www.fordwebs.com


    "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.
    > http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253
    >
    > 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?
    >




    1 reply

    N
    Newsgroup_User
    Inspiring
    December 29, 2006
    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.

    http://www.adobe.com/cfusion/search/index.cfm?loc=en_us&term=Communication+failure+during+handshake

    Jochem


    --
    Jochem van Dieten
    Adobe Community Expert for ColdFusion
    A
    Anonymous
    December 30, 2006
    I followed the instructions from that link but i am still facing some problems.
    http://www.adobe.com/cfusion/knowledgebase/index.cfm?id=6ef0253

    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?
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices