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.
MSSQL Data Source ClassNotFoundException
-
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,
-
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.