Cannot load JDBC Driver class: net.sourceforge.jtds.jdbc.Driver. Is basically because your application has dependency on jtds.jar which is unavailable in the classpath so first download the jar from here and add it to the classpath. This is where you may want to get start with. Aug 05, 2014 ferchock.spw Joined: 15:33:32 Messages: 1 Offline: Hi Everyone, I have installed All-In-One-SpagoBI-4.2-28042014 on my Windows 8.1 computer. May 16, 2018 Download jTDS - SQL Server and Sybase JDBC driver for free. Open source JDBC 3.0 type 4 driver for Microsoft SQL Server (6.5 up to 2012) and Sybase ASE. JTDS is a complete implementation of the JDBC 3.0 spec and the fastest JDBC driver for MS SQL Server. Sep 21, 2017 Since jTDS 1.3.1 does not provide a functioning JDBC4 implementation, the decision was made to replace jTDS with Microsoft's own SQL Server driver. Microsoft's driver is actively maintained, where jTDS hasn't been updated since 2014 (and prior to the small round of updates done in 2014 it hadn't been updated for multiple years).
Download Jtds Jdbc Driver
I tried real hard but can't solve this problem.
I think maybe it will be somthing easy.
Hope somebody could help.
****************************************
PART OF CONFIG.PROPERTIES FILE
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://localhost/TOPTECH
****************************************
****************************************
PART OF MAIN FILE
'jdbc jar file
#AdditionalJar: mssql-jdbc-7.2.1.jre11.jar
****************************************
****************************************
PART OF THE PROTOKOLL
Waiting for debugger to connect...
Program started.
2019-03-25 21:40:20.217:INFO::main: Logging initialized @591ms to org.eclipse.jetty.util.log.StdErrLog
Mär 25, 2019 9:40:20 PM com.mchange.v2.log.MLog
INFORMATION: MLog clients using java 1.4+ standard logging.
Mär 25, 2019 9:40:20 PM com.mchange.v2.c3p0.C3P0Registry
INFORMATION: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2019-03-25 21:40:20.826:INFOejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_192-b12
2019-03-25 21:40:20.867:INFOejs.session:main: DefaultSessionIdManager workerName=node0
2019-03-25 21:40:20.867:INFOejs.session:main: No SessionScavenger set, using defaults
2019-03-25 21:40:20.869:INFOejs.session:main: node0 Scavenging every 600000ms
2019-03-25 21:40:20.874:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@1d8d30f7{/,file:///C:/toptech/jRDC2/jRDC/Objects/www,AVAILABLE}
2019-03-25 21:40:20.877:INFOejs.AbstractNCSARequestLog:main: Opened C:toptechjRDC2jRDCObjectslogsb4j-2019_03_25.request.log
2019-03-25 21:40:20.892:INFOejs.AbstractConnector:main: Started ServerConnector@1e7c7811{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2019-03-25 21:40:20.893:INFOejs.Server:main: Started @1269ms
Emulated network latency: 100ms
jRDC is running (version = 2.22)
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFORMATION: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hge9saa11enrkqh1o6aolt|445b84c0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge9saa11enrkqh1o6aolt|445b84c0, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://localhost/TOPTECH, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, max...
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.DriverManagerDataSource
WARNUNG: Could not load driverClass net.sourceforge.jtds.jdbc.Driver
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.DriverManagerDataSource
WARNUNG: Could not load driverClass net.sourceforge.jtds.jdbc.Driver
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
I am not sure where to place the class driver file and how to set the class path.
Hope you can help!
THANK YOU
GEORG
I think maybe it will be somthing easy.
Hope somebody could help.
****************************************
PART OF CONFIG.PROPERTIES FILE
DriverClass=net.sourceforge.jtds.jdbc.Driver
JdbcUrl=jdbc:jtds:sqlserver://localhost/TOPTECH
****************************************
****************************************
PART OF MAIN FILE
'jdbc jar file
#AdditionalJar: mssql-jdbc-7.2.1.jre11.jar
****************************************
****************************************
PART OF THE PROTOKOLL
Waiting for debugger to connect...
Program started.
2019-03-25 21:40:20.217:INFO::main: Logging initialized @591ms to org.eclipse.jetty.util.log.StdErrLog
Mär 25, 2019 9:40:20 PM com.mchange.v2.log.MLog
INFORMATION: MLog clients using java 1.4+ standard logging.
Mär 25, 2019 9:40:20 PM com.mchange.v2.c3p0.C3P0Registry
INFORMATION: Initializing c3p0-0.9.5.2 [built 08-December-2015 22:06:04 -0800; debug? true; trace: 10]
2019-03-25 21:40:20.826:INFOejs.Server:main: jetty-9.4.z-SNAPSHOT; built: 2018-05-03T15:56:21.710Z; git: daa59876e6f384329b122929e70a80934569428c; jvm 1.8.0_192-b12
2019-03-25 21:40:20.867:INFOejs.session:main: DefaultSessionIdManager workerName=node0
2019-03-25 21:40:20.867:INFOejs.session:main: No SessionScavenger set, using defaults
2019-03-25 21:40:20.869:INFOejs.session:main: node0 Scavenging every 600000ms
2019-03-25 21:40:20.874:INFOejsh.ContextHandler:main: Started o.e.j.s.ServletContextHandler@1d8d30f7{/,file:///C:/toptech/jRDC2/jRDC/Objects/www,AVAILABLE}
2019-03-25 21:40:20.877:INFOejs.AbstractNCSARequestLog:main: Opened C:toptechjRDC2jRDCObjectslogsb4j-2019_03_25.request.log
2019-03-25 21:40:20.892:INFOejs.AbstractConnector:main: Started ServerConnector@1e7c7811{HTTP/1.1,[http/1.1]}{0.0.0.0:17178}
2019-03-25 21:40:20.893:INFOejs.Server:main: Started @1269ms
Emulated network latency: 100ms
jRDC is running (version = 2.22)
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource
INFORMATION: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 20000, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> 1hge9saa11enrkqh1o6aolt|445b84c0, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> net.sourceforge.jtds.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 1hge9saa11enrkqh1o6aolt|445b84c0, idleConnectionTestPeriod -> 600, initialPoolSize -> 3, jdbcUrl -> jdbc:jtds:sqlserver://localhost/TOPTECH, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 1800, max...
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.DriverManagerDataSource
WARNUNG: Could not load driverClass net.sourceforge.jtds.jdbc.Driver
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)
Mär 25, 2019 9:40:34 PM com.mchange.v2.c3p0.DriverManagerDataSource
WARNUNG: Could not load driverClass net.sourceforge.jtds.jdbc.Driver
java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
I am not sure where to place the class driver file and how to set the class path.
Hope you can help!
THANK YOU
GEORG