kettle迁移创建表和表数据

最新推荐文章于 2025-06-10 10:22:19 发布

最新推荐文章于 2025-06-10 10:22:19 发布 · 1.6k 阅读

文章标签：

#kettle批量创建表

kettle 专栏收录该内容

5 篇文章

订阅专栏

本文介绍如何使用Kettle在Oracle数据库中动态创建表。通过读取配置信息，连接到本地Oracle实例，并根据变量定义的表名构造DDL语句来实现表的创建。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public boolean processRow(StepMetaInterface smi, StepDataInterface sdi) throws KettleException
{
     // First, get a row from the default input hop
  //
  Object[] r = getRow();

  String databasesXML =
         "<?xml version=\"1.0\" encoding=\"UTF-8\"?>" +
         "<connection>" +
           "<name>kettle</name>" +
           "<server>127.0.0.1</server>" +
           "<type>Oracle</type>" +
           "<access>Native</access>" +
           "<database>orcl</database>" +
           "<port>1521</port>" +
           "<username>kscenter20151207</username>" +
           "<password>kscenter</password>" +
         "</connection>";
  org.pentaho.di.core.database.DatabaseMeta dbmeta = new org.pentaho.di.core.database.DatabaseMeta(databasesXML);;

  if(dbmeta!=null)
  {
   org.pentaho.di.core.database.Database db=new org.pentaho.di.core.database.Database(dbmeta);

   try
   {
    db.connect();

String tablename = getVariable("TABLENAME");

    logBasic("开始创建表：" + tablename);

    if(tablename!=null && tablename.trim().length()>0)
    {
     org.pentaho.di.core.row.RowMetaInterface outputRowMeta = getInputRowMeta().clone();
     logBasic("row:"+outputRowMeta);
     String sql = db.getDDL(tablename, data.inputRowMeta);//${TABLENAME}
     //String sql = db.getDDL(tablename, outputRowMeta);//${TABLENAME}
     db.execStatement(sql.replace(";", ""));

     logBasic(sql);
    }
   }
   catch(Exception e)
   {
    logError("创建表出现异常",e);

   }finally{
    db.disconnect();
   }
  }
  return false;
}