• 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

    MSSQL Data Source ClassNotFoundException

    Mango Automation general Discussion
    2
    2
    1.4k
    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.
    • E
      eksantrik
      last edited by

      I installed Mango on my Windows 10 laptop to start testing. Trying to build an MSSQL data source to database located on my laptop. Seeing the following error:
      INFO 2017-10-11T03:42:34,330 (com.serotonin.m2m2.sql.SqlDataSourceRT.initialize:510) - Error while initializing data source
      java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
      at java.net.URLClassLoader.findClass(URLClassLoader.java:381) ~[?:1.8.0_131]
      at java.lang.ClassLoader.loadClass(ClassLoader.java:424) ~[?:1.8.0_131]
      at java.lang.ClassLoader.loadClass(ClassLoader.java:357) ~[?:1.8.0_131]
      at java.lang.Class.forName0(Native Method) ~[?:1.8.0_131]
      at java.lang.Class.forName(Class.java:264) ~[?:1.8.0_131]
      at com.serotonin.m2m2.sql.SqlDataSourceRT.initialize(SqlDataSourceRT.java:498) [sql-ds-3.2.0.jar:?]
      at com.serotonin.m2m2.sql.SqlDataSourceRT.manageConnection(SqlDataSourceRT.java:281) [sql-ds-3.2.0.jar:?]
      at com.serotonin.m2m2.sql.SqlDataSourceRT.doPoll(SqlDataSourceRT.java:298) [sql-ds-3.2.0.jar:?]
      at com.serotonin.m2m2.rt.dataSource.PollingDataSource.doPollNoSync(PollingDataSource.java:196) [mango-3.2.1.jar:?]
      at com.serotonin.m2m2.rt.dataSource.PollingDataSource.scheduleTimeoutImpl(PollingDataSource.java:162) [mango-3.2.1.jar:?]
      at com.serotonin.m2m2.rt.dataSource.PollingDataSource$1.scheduleTimeout(PollingDataSource.java:70) [mango-3.2.1.jar:?]
      at com.serotonin.m2m2.util.timeout.TimeoutTask.run(TimeoutTask.java:59) [mango-3.2.1.jar:?]
      at com.serotonin.timer.Task.runTask(Task.java:179) [mango-3.2.1.jar:?]
      at com.serotonin.timer.TaskWrapper.run(TaskWrapper.java:23) [mango-3.2.1.jar:?]
      at com.serotonin.timer.OrderedThreadPoolExecutor$OrderedTaskCollection.run(OrderedThreadPoolExecutor.java:307) [mango-3.2.1.jar:?]
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
      at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]

      My driver class setting is as follows: com.microsoft.sqlserver.jdbc.SQLServerDriver

      My connection string is as follows: jdbc:sqlserver://127.0.0.1:1433;database=Bisson;integratedSecurity=false;

      I am not sure what I am missing here.

      Please advise.

      Thanks,

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

        Hi eksantrik,

        The JDBC driver for MSSQL is not bundled with Mango. You can download it here: https://docs.microsoft.com/en-us/sql/connect/sql-connection-libraries#anchor-20-drivers-relational-access (has links for 6.0 and 6.2 for Java currently). You want the .tar.gz download, it'll have the driver compiled for Java 8, so copy that jar into your Mango/overrides/lib directory and try again.

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