- Jtds Vs Microsoft Jdbc Driver
- Cannot Load Jdbc Driver Class Net.sourceforge.jtds.jdbc.driver
- Cannot Load Jdbc Driver Class 'net.sourceforge.jtds.jdbc.driver'
Dear All,
Now that I am able to launch the Spoon.bat after installing java 8 ( thanks to JohanHammink for your help in another post ) , I am stuck currently in establishing a DB connection with MSSQL.
I also had restarted my machine reading the same in one of the posts, but that did not help. Please let me know of anything that can resolve this. Thanks in advance.
Tanisha
The entire error looks like below :
Error connecting to database [DBConnection] rg.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver
org.pentaho.di.core.exception.KettleDatabaseException:
Error occurred while trying to connect to the database
Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver
at org.pentaho.di.core.database.Database.normalConnect(Database.java:472)
at org.pentaho.di.core.database.Database.connect(Database.java:370)
at org.pentaho.di.core.database.Database.connect(Database.java:341)
at org.pentaho.di.core.database.Database.connect(Database.java:331)
at org.pentaho.di.core.database.DatabaseFactory.getConnectionTestReport(DatabaseFactory.java:80)
at org.pentaho.di.core.database.DatabaseMeta.testConnection(DatabaseMeta.java:2795)
at org.pentaho.ui.database.event.DataHandler.testDatabaseConnection(DataHandler.java:598)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157)
at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141)
at org.pentaho.ui.xul.swt.tags.SwtButton.access$500(SwtButton.java:43)
at org.pentaho.ui.xul.swt.tags.SwtButton$4.widgetSelected(SwtButton.java:137)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.eclipse.jface.window.Window.runEventLoop(Window.java:820)
at org.eclipse.jface.window.Window.open(Window.java:796)
at org.pentaho.di.ui.xul.KettleDialog.show(KettleDialog.java:80)
at org.pentaho.di.ui.xul.KettleDialog.show(KettleDialog.java:47)
at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:116)
at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:60)
at org.pentaho.di.ui.trans.step.BaseStepDialog.showDbDialogUnlessCancelledOrValid(BaseStepDialog.java:779)
at org.pentaho.di.ui.trans.step.BaseStepDialog$AddConnectionListener.widgetSelected(BaseStepDialog.java:1374)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.trans.steps.tableinput.TableInputDialog.open(TableInputDialog.java:436)
at org.pentaho.di.ui.spoon.delegates.SpoonStepsDelegate.editStep(SpoonStepsDelegate.java:127)
at org.pentaho.di.ui.spoon.Spoon.editStep(Spoon.java:8789)
at org.pentaho.di.ui.spoon.trans.TransGraph.editStep(TransGraph.java:3179)
at org.pentaho.di.ui.spoon.trans.TransGraph.mouseDoubleClick(TransGraph.java:775)
at org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1359)
at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7990)
at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9290)
at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:685)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Driver class 'net.sourceforge.jtds.jdbc.Driver' could not be found, make sure the 'MS SQL Server' driver (jar file) is installed.
net.sourceforge.jtds.jdbc.Driver
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:515)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:456)
.. 55 more
Caused by: java.lang.ClassNotFoundException: net.sourceforge.jtds.jdbc.Driver
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:490)
.. 56 more
Hostname :GNM8102
Port :1433
Database name :Comcast
Process Automation has been using a 3rd party JDBC Driver for the SQL Server database. Whatsapp plus themes xml free download version. Delver for mac. Starting in 4.3 sp3 we are now including the option to use a driver provided by Microsoft during the install or upgrade. Could not load db driver class: net.sourceforge.jtds.jdbc.Driver. Jigsaw puzzle maker mac.
- ⋅100分求《新手学HTML+CSS》的光盘内容
- ⋅运行时错误1004 类worksheet的paste方法无效
- ⋅去掉xml里的非法字符问题
Jtds Vs Microsoft Jdbc Driver
等级
结帖率 100%
Cannot Load Jdbc Driver Class Net.sourceforge.jtds.jdbc.driver
把数据库连接写在jsp中能访问数据库，但写在server.xml中tomcat启动时错误为：
[ksystem] DEBUG [main] ClickstreamListener.(28) | ClickstreamLogger constr
ucted
[ksystem] ERROR [main] JDBCExceptionReporter.logExceptions(46) | Cannot load JDB
C driver class 'null'
[ksystem] ERROR [main] JDBCExceptionReporter.logExceptions(46) | Cannot load JDB
C driver class 'null'
Cannot load JDBC driver class 'null'
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:523)。。。。。
server.xml的配置为：
driverName='net.sourceforge.jtds.jdbc.Driver'
connectionURL='jdbc:jtds:sqlserver://localhost/shtzdb;charset=gb2312;autoReconnect=true'
connectionName='sa' connectionPassword='sa'
userTable='tb_sys_user' userNameCol='user_code' userCredCol='password'
userRoleTable='tb_sys_user_role' roleNameCol='role_code' />
factory
org.apache.commons.dbcp.BasicDataSourceFactory
maxActive
100
maxIdle
30
maxWait
10000
username
sa
password
sa
driverClassName
net.sourceforge.jtds.jdbc.Driver
defaultAutoCommit
true
url
jdbc:jtds:sqlserver://localhost/shtzdb;charset=gb2312;autoReconnect=true
removeAbandoned
true
removeAbandonedTimeout
60
logAbandoned
true
[ksystem] DEBUG [main] ClickstreamListener.(28) | ClickstreamLogger constr
ucted
[ksystem] ERROR [main] JDBCExceptionReporter.logExceptions(46) | Cannot load JDB
C driver class 'null'
[ksystem] ERROR [main] JDBCExceptionReporter.logExceptions(46) | Cannot load JDB
C driver class 'null'
Cannot load JDBC driver class 'null'
java.lang.NullPointerException
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSou
rce.java:523)。。。。。
server.xml的配置为：
driverName='net.sourceforge.jtds.jdbc.Driver'
connectionURL='jdbc:jtds:sqlserver://localhost/shtzdb;charset=gb2312;autoReconnect=true'
connectionName='sa' connectionPassword='sa'
userTable='tb_sys_user' userNameCol='user_code' userCredCol='password'
userRoleTable='tb_sys_user_role' roleNameCol='role_code' />
factory
org.apache.commons.dbcp.BasicDataSourceFactory
maxActive
100
maxIdle
30
maxWait
10000
username
sa
password
sa
driverClassName
net.sourceforge.jtds.jdbc.Driver
defaultAutoCommit
true
url
jdbc:jtds:sqlserver://localhost/shtzdb;charset=gb2312;autoReconnect=true
removeAbandoned
true
removeAbandonedTimeout
60
logAbandoned
true
Cannot Load Jdbc Driver Class 'net.sourceforge.jtds.jdbc.driver'
点赞 只看楼主引用举报楼主收起
