本文整理汇总了Java中org.pentaho.di.core.database.Database.getSchemas方法的典型用法代码示例。如果您正苦于以下问题:Java Database.getSchemas方法的具体用法?Java Database.getSchemas怎么用?Java Database.getSchemas使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.pentaho.di.core.database.Database
的用法示例。
在下文中一共展示了Database.getSchemas方法的13个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
/**
* Presents a dialog box to select a schema from the database. Then sets the selected schema in the dialog
*/
private void getSchemaNames() {
DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() );
if ( databaseMeta != null ) {
Database database = new Database( loggingObject, databaseMeta );
try {
database.connect();
String[] schemas = database.getSchemas();
if ( null != schemas && schemas.length > 0 ) {
schemas = Const.sortStrings( schemas );
EnterSelectionDialog dialog =
new EnterSelectionDialog( shell, schemas, BaseMessages.getString(
PKG, "SnowflakeBulkLoader.Dialog.AvailableSchemas.Title", wConnection.getText() ), BaseMessages
.getString( PKG, "SnowflakeBulkLoader.Dialog.AvailableSchemas.Message", wConnection.getText() ) );
String d = dialog.open();
if ( d != null ) {
wSchema.setText( Const.NVL( d, "" ) );
setTableFieldCombo();
}
} else {
MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage( BaseMessages.getString( PKG, "SnowflakeBulkLoader.Dialog.NoSchema.Error" ) );
mb.setText( BaseMessages.getString( PKG, "SnowflakeBulkLoader.Dialog.GetSchemas.Error" ) );
mb.open();
}
} catch ( Exception e ) {
new ErrorDialog( shell, BaseMessages.getString( PKG, "System.Dialog.Error.Title" ), BaseMessages
.getString( PKG, "SnowflakeBulkLoader.Dialog.ErrorGettingSchemas" ), e );
} finally {
database.disconnect();
}
}
}
示例2: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames() {
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta != null) {
Database database = new Database(loggingObject, databaseMeta);
try {
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length > 0) {
schemas = Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas, BaseMessages.getString(PKG, "DimensionLookupDialog.AvailableSchemas.Title", wConnection.getText()), BaseMessages.getString(PKG,
"DimensionLookupDialog.AvailableSchemas.Message", wConnection.getText()));
String d = dialog.open();
if (d != null) {
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
} else {
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR);
mb.setMessage(BaseMessages.getString(PKG, "DimensionLookupDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG, "DimensionLookupDialog.GetSchemas.Error"));
mb.open();
}
} catch (Exception e) {
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"), BaseMessages.getString(PKG, "DimensionLookupDialog.ErrorGettingSchemas"), e);
} finally {
if (database != null) {
database.disconnect();
database = null;
}
}
}
}
示例3: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
if(wSchemaname.isDisposed()) return;
DatabaseMeta databaseMeta = jobMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
database.shareVariablesWith(jobMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Title", wConnection.getText()),
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Message"));
String d=dialog.open();
if (d!=null)
{
wSchemaname.setText(Const.NVL(d.toString(), ""));
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Empty.Message"));
mb.setText(BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Empty.Title"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.ConnectionError"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例4: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"InsertUpDateDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"InsertUpDateDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"InsertUpDateDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"InsertUpDateDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"InsertUpDateDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例5: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"CombinationLookupDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"CombinationLookupDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"CombinationLookupDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"CombinationLookupDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"CombinationLookupDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例6: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"DatabaseLookupDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"DatabaseLookupDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"DatabaseLookupDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"DatabaseLookupDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"DatabaseLookupDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例7: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"TableOutputDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"TableOutputDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"TableOutputDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"TableOutputDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"TableOutputDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例8: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"DeleteDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"DeleteDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"DeleteDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"DeleteDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"DeleteDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例9: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"UpdateDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"UpdateDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"UpdateDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"UpdateDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"UpdateDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例10: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
if(wSchema.isDisposed()) return;
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG, "AddSequenceDialog.SelectSequence.Title",wConnection.getText()),
BaseMessages.getString(PKG, "AddSequenceDialog.SelectSequence.Message"));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"AddSequenceDialog.NoSchema.Message"));
mb.setText(BaseMessages.getString(PKG,"AddSequenceDialog.NoSchema.Title"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG, "AddSequenceDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例11: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
if(wSchemaname.isDisposed()) return;
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
database.shareVariablesWith(transMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Title", wConnection.getText()),
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Message"));
String d=dialog.open();
if (d!=null)
{
wSchemaname.setText(Const.NVL(d.toString(), ""));
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Empty.Message"));
mb.setText(BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.Empty.Title"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG, "System.Dialog.AvailableSchemas.ConnectionError"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例12: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"SynchronizeAfterMergeDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"SynchronizeAfterMergeDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"SynchronizeAfterMergeDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"SynchronizeAfterMergeDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"SynchronizeAfterMergeDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}
示例13: getSchemaNames
import org.pentaho.di.core.database.Database; //导入方法依赖的package包/类
private void getSchemaNames()
{
DatabaseMeta databaseMeta = transMeta.findDatabase(wConnection.getText());
if (databaseMeta!=null)
{
Database database = new Database(loggingObject, databaseMeta);
try
{
database.connect();
String schemas[] = database.getSchemas();
if (null != schemas && schemas.length>0) {
schemas=Const.sortStrings(schemas);
EnterSelectionDialog dialog = new EnterSelectionDialog(shell, schemas,
BaseMessages.getString(PKG,"OraBulkLoaderDialog.AvailableSchemas.Title",wConnection.getText()),
BaseMessages.getString(PKG,"OraBulkLoaderDialog.AvailableSchemas.Message",wConnection.getText()));
String d=dialog.open();
if (d!=null)
{
wSchema.setText(Const.NVL(d.toString(), ""));
setTableFieldCombo();
}
}else
{
MessageBox mb = new MessageBox(shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage(BaseMessages.getString(PKG,"OraBulkLoaderDialog.NoSchema.Error"));
mb.setText(BaseMessages.getString(PKG,"OraBulkLoaderDialog.GetSchemas.Error"));
mb.open();
}
}
catch(Exception e)
{
new ErrorDialog(shell, BaseMessages.getString(PKG, "System.Dialog.Error.Title"),
BaseMessages.getString(PKG,"OraBulkLoaderDialog.ErrorGettingSchemas"), e);
}
finally
{
if(database!=null)
{
database.disconnect();
database=null;
}
}
}
}