Java SQLStatement.getError方法代码示例

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
 * Copy information from the meta-data input to the dialog fields.
 */ 
public void getData()
{
	for (int i=0;i<stats.size();i++)
	{
		SQLStatement stat = (SQLStatement)stats.get(i);
		TableItem ti = wFields.table.getItem(i); 

		String name         = stat.getStepname();
		DatabaseMeta dbinfo = stat.getDatabase();
		String sql          = stat.getSQL();
		String error        = stat.getError();
		
		if (name!=null)   ti.setText(1, name);
		if (dbinfo!=null) ti.setText(2, dbinfo.getName() );
		if (sql!=null)    ti.setText(3, sql);
		if (error!=null)  ti.setText(4, error);

		Color col = ti.getBackground();
		if (stat.hasError()) col=red;
		ti.setBackground(col);
	}
	wFields.setRowNums();
	wFields.optWidth(true);
}
 

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
/**
 * Copy information from the meta-data input to the dialog fields.
 */
public void getData() {
  for ( int i = 0; i < stats.size(); i++ ) {
    SQLStatement stat = stats.get( i );
    TableItem ti = wFields.table.getItem( i );

    String name = stat.getStepname();
    DatabaseMeta dbinfo = stat.getDatabase();
    String sql = stat.getSQL();
    String error = stat.getError();

    if ( name != null ) {
      ti.setText( 1, name );
    }
    if ( dbinfo != null ) {
      ti.setText( 2, dbinfo.getName() );
    }
    if ( sql != null ) {
      ti.setText( 3, sql );
    }
    if ( error != null ) {
      ti.setText( 4, error );
    }

    Color col = ti.getBackground();
    if ( stat.hasError() ) {
      col = red;
    }
    ti.setBackground( col );
  }
  wFields.setRowNums();
  wFields.optWidth( true );
}
 

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
@Override
public boolean adjustSchema() {
	TableOutputMeta meta = getMeta();
	TableOutputData data = getData();
	TransMeta transMeta = getTransMeta();
	StepMeta stepMeta = meta.getParentStepMeta();
	DBCache dbcache = transMeta.getDbCache();
	StringBuffer messageBuffer = new StringBuffer();

	try {
		RowMetaInterface prev = transMeta.getPrevStepFields(stepMeta.getName());
 		   if (log.isDetailed()) logDetailed("Attempting to auto adjust table structure" );
 		  	
		   if (log.isDetailed()) logDetailed("getTransMeta: "+getTransMeta() );
   		   if (log.isDetailed()) logDetailed("getStepname: "+getStepname() );
   		   
   		   SQLStatement statement = meta.getSQLStatements(transMeta, stepMeta, prev);
   		   
   		   if (log.isDetailed()) logDetailed("Statement: "+statement );
  		   if (log.isDetailed() && statement != null) logDetailed("Statement has SQL: "+statement.hasSQL() );
    		
  		   if(statement != null && statement.hasSQL()) {
    			String sql = statement.getSQL();
     		  	if (log.isDetailed()) logDetailed("Trying: "+sql);
     		  	
				try
				{
				    log.logDetailed("Executing SQL: "+Const.CR+sql);
					data.db.execStatement(sql);
                       
					// Clear the database cache, in case we're using one...
					if (dbcache!=null) dbcache.clear(data.databaseMeta.getName());
				}
				catch(Exception dbe)
				{
                       String error = BaseMessages.getString(PKG, "SQLEditor.Log.SQLExecError", sql, dbe.toString());
                       messageBuffer.append(error).append(Const.CR);
                       return false;
				}

     		  	if (log.isDetailed()) logDetailed("Successfull: "+sql);
  		   } 
  		   else if(statement.getError() == null) {
  			   // there were no changes to be made
  			   return true;
  		   } else {
  			   this.message = statement.getError();
  			   logError(statement.getError());
  			   return false;
  		   }
     	}
     	catch(Exception e) {
		   logError("An error ocurred trying to adjust the table schema", e);
     	}
	return true;
}
 

import org.pentaho.di.core.SQLStatement; //导入方法依赖的package包/类
@Override
public boolean adjustSchema() {
  TableOutputMeta meta = getMeta();
  TableOutputData data = getData();
  TransMeta transMeta = getTransMeta();
  StepMeta stepMeta = meta.getParentStepMeta();
  DBCache dbcache = transMeta.getDbCache();
  StringBuilder messageBuffer = new StringBuilder();

  try {
    RowMetaInterface prev = transMeta.getPrevStepFields( stepMeta.getName() );
    if ( log.isDetailed() ) {
      logDetailed( "Attempting to auto adjust table structure" );
    }

    if ( log.isDetailed() ) {
      logDetailed( "getTransMeta: " + getTransMeta() );
    }
    if ( log.isDetailed() ) {
      logDetailed( "getStepname: " + getStepname() );
    }

    SQLStatement statement = meta.getSQLStatements( transMeta, stepMeta, prev, repository, metaStore );

    if ( log.isDetailed() ) {
      logDetailed( "Statement: " + statement );
    }
    if ( log.isDetailed() && statement != null ) {
      logDetailed( "Statement has SQL: " + statement.hasSQL() );
    }

    if ( statement != null && statement.hasSQL() ) {
      String sql = statement.getSQL();
      if ( log.isDetailed() ) {
        logDetailed( "Trying: " + sql );
      }

      try {
        log.logDetailed( "Executing SQL: " + Const.CR + sql );
        data.db.execStatement( sql );

        // Clear the database cache, in case we're using one...
        if ( dbcache != null ) {
          dbcache.clear( data.databaseMeta.getName() );
        }
      } catch ( Exception dbe ) {
        String error = BaseMessages.getString( PKG, "SQLEditor.Log.SQLExecError", sql, dbe.toString() );
        messageBuffer.append( error ).append( Const.CR );
        return false;
      }

      if ( log.isDetailed() ) {
        logDetailed( "Successfull: " + sql );
      }
    } else if ( statement.getError() == null ) {
      // there were no changes to be made
      return true;
    } else {
      this.message = statement.getError();
      logError( statement.getError() );
      return false;
    }
  } catch ( Exception e ) {
    logError( "An error ocurred trying to adjust the table schema", e );
  }
  return true;
}