• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    MySQL - MS SQL Connection help need

    Mango Automation general Discussion
    2
    6
    2.5k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F
      fenyoster
      last edited by

      I need help in setting up connection to MySQL server and (or) MS SQL. What am I need to download for MS SQL, how to setting up driver class, connection string, etc.
      When I want to connect to MySQL database i get error: class java.sql.SQLException: No suitable driver found for jdbc:mysql:<host name>/<db>

      1 Reply Last reply Reply Quote 0
      • phildunlapP
        phildunlap
        last edited by phildunlap

        Hi fenyoster,

        I assume this is about the SQL Data Source. You can find the driver class in the help dialogue for that data source. The little blue question mark (?) is next to the title "SQL Properties" on the SQL data source's edit page. The driver for mysql is com.mysql.jdbc.Driver

        It looks like you're getting that error because the url is malformed. Your connection string should look more like jdbc:mysql://<host name>:<port>/<db> and the default port for MySQL is 3306

        I have not attempted to use MSSQL, but if you wish to connect with it you'll need to find a jdbc driver jar, place it somewhere on the classpath for Mango (I recommend Mango/overrides/lib/ for that) and restart Mango (edit: restart may not be needed). Then you should be able to reference its Driver class (Googling suggests this may be the driver class: com.microsoft.sqlserver.jdbc.SQLServerDriver ) and connect to it (Googling suggests: jdbc:sqlserver:// is the prefix).

        1 Reply Last reply Reply Quote 0
        • F
          fenyoster
          last edited by

          @phildunlap said in MySQL - MS SQL Connection help need:

          com.mysql.jdbc.Driver

          I`m updated the configuration as you said, and even further i get the error:
          class java.sql.SQLException: No suitable driver found for jdbc:mysql:<host name>:3306/<db>

          I entered the fields driver class name, connection string username, password. Is there something that must be set?

          1 Reply Last reply Reply Quote 0
          • phildunlapP
            phildunlap
            last edited by

            Does your connection string begin with jdbc:mysql://?

            1 Reply Last reply Reply Quote 0
            • F
              fenyoster
              last edited by

              This post is deleted!
              F 1 Reply Last reply Reply Quote 0
              • F
                fenyoster @fenyoster
                last edited by fenyoster

                @fenyoster That was the problem, as you said! The double slash is failed!

                jdbc:mysql://

                Many Thanks!

                Best Regards,
                Fenyo

                1 Reply Last reply Reply Quote 0
                • First post
                  Last post