当前位置: 代码迷 >> Java相关 >> java以纯代码的模式调用kettle,总是提示无效的数据库连接
  详细解决方案

java以纯代码的模式调用kettle,总是提示无效的数据库连接

热度:288   发布时间:2016-04-22 21:50:02.0
java以纯代码的形式调用kettle,总是提示无效的数据库连接
整个代码基本就是3.2版本里的那个官方调用代码TransBuilder.java(位于extra文件夹中)     添加了jar包后总是会有异常   现在的异常就是提示

INFO  22-05 17:53:30,750 - Using "C:\Users\suwb\AppData\Local\Temp\vfs_cache" as temporary files store.
INFO  22-05 17:53:31,455 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Scanning for classes in [file:/F:/kettle3.2/data-integration/lib/kettle-engine.jar] matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@76ab2f
INFO  22-05 17:53:31,810 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/formula/RowForumulaContext.class\' due to a java.lang.NoClassDefFoundError with message: org/pentaho/reporting/libraries/formula/FormulaContext
INFO  22-05 17:53:31,825 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/getxmldata/GetXMLData$1.class\' due to a java.lang.NoClassDefFoundError with message: org/dom4j/ElementHandler
INFO  22-05 17:53:31,851 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/infobrightoutput/KettleEtlLogger.class\' due to a java.lang.NoClassDefFoundError with message: com/infobright/logging/EtlLogger
INFO  22-05 17:53:31,852 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/infobrightoutput/KettleValueConverter.class\' due to a java.lang.NoClassDefFoundError with message: com/infobright/etl/model/ValueConverter
INFO  22-05 17:53:31,989 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/scriptvalues_mod/ScriptValuesAddedFunctions.class\' due to a java.lang.NoClassDefFoundError with message: org/mozilla/javascript/ScriptableObject
INFO  22-05 17:53:32,109 - org.pentaho.di.core.util.ResolverUtil@13f7281 - Could not examine class \'org/pentaho/di/trans/steps/webservices/wsdl/ControlWsdlLocator.class\' due to a java.lang.NoClassDefFoundError with message: javax/wsdl/xml/WSDLLocator
INFO  22-05 17:53:32,552 - DBCache - The database cache doesn't exist yet.
Saved transformation to file: NewTrans.xml

INFO  22-05 17:53:32,753 - - - New database connection defined
Exception in thread "main" org.pentaho.di.core.exception.KettleDatabaseException: 
No valid database connection defined!

at org.pentaho.di.core.database.Database.normalConnect(Database.java:274)
at org.pentaho.di.core.database.Database.connect(Database.java:261)
at org.pentaho.di.core.database.Database.connect(Database.java:223)
at org.pentaho.di.core.database.Database.connect(Database.java:213)
at table_to_table.main(table_to_table.java:250)


无效的数据库连接  求解释  (第250行是targetDatabase.connect();)

以下附上我的数据库连接的databasesXML
            "<connection>"+
         "<name>kettle_bs</name>"+
         "<server>localhost</server>"+
         "<type>MYSQL</type>"+
  相关解决方案