本文整理汇总了Java中org.pentaho.di.core.SQLStatement.getError方法的典型用法代码示例。如果您正苦于以下问题:Java SQLStatement.getError方法的具体用法?Java SQLStatement.getError怎么用?Java SQLStatement.getError使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.pentaho.di.core.SQLStatement
的用法示例。
在下文中一共展示了SQLStatement.getError方法的4个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getData
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);
}
示例2: getData
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 );
}
示例3: adjustSchema
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;
}
示例4: adjustSchema
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;
}