Eclipse Community Forums: DTP » SQL Editor -Update Connection Profile programmatic way

Home » Eclipse Projects » DTP » SQL Editor -Update Connection Profile programmatic way(Edit Connection Profile programmatically)

Show: Today's Messages :: Show Polls :: Message Navigator

SQL Editor -Update Connection Profile programmatic way [message #661044]

Tue, 22 March 2011 17:16

Swati Sapar
Messages: 20
Registered: September 2010

Junior Member

Hi,

I want to edit the connection profile that an SQL scrapbook is associated with from the Java code.
I am updating this based on the connection profile selected in SQL Explorer.

My code looks like this :

ISQLEditorConnectionInfo sqlConnectioninfo=((SQLEditor)activeeditor).getConnectionInf o();
sqlConnectioninfo.setConnectionProfileName(conprof.getName() );
sqlConnectioninfo.setProfileStatus(conprof.getConnectionStat e());

Properties properties = conprof.getBaseProperties();
String schemaName= properties.get("org.eclipse.datatools.connectivity.db.databaseName ").toString();
sqlConnectioninfo.setDefaultSchemaName(schemaName);

sqlConnectioninfo.setDatabaseVendorDefinitionId(new
DatabaseVendorDefinitionId(properties.getProperty("org.eclipse.datatools.connectivity.db.vendor ").toString(),properties.getProperty("org.eclipse.datatools.connectivity.db.version ").toString()));

((SQLEditor)activeeditor).setConnectionInfo(sqlConnectioninf o);
((SQLEditor) activeeditor).refreshConnectionStatus();

This does update the Type , Name and Status in connection Profile.
How can I select a default value for Database: field ??
Please find snapshot here:

https:// docs.google.com/leaf?id=0B6xpLLyeT_sYMmUxZDQzZWUtNjVmYS00YWE yLWFhMGYtZDdiODJlM2RmZDY3&sort=name&layout=list& num=50

Thank you,
Swati

Report message to a moderator

Re: SQL Editor -Update Connection Profile programmatic way [message #661668 is a reply to message #661044]

Fri, 25 March 2011 18:12

Swati Sapar
Messages: 20
Registered: September 2010

Junior Member

Found a solution myself.

Create an annonymous SQLEditorConnectionInfo as below and override the getdatabasename method to set the desired db name.

ISQLEditorConnectionInfo sqlConnectioninfo=new SQLEditorConnectionInfo(SQLToolsFacade.getNonSpecificDatabas eVendorDefinitionId()) {
public String getDatabaseName()
{
return dbName;
}
};

Smile

Report message to a moderator

Previous Topic:	Need Help about ODA Ecore
Next Topic:	Embedding SQLBuilder Component

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jul 23 05:55:44 EDT 2014