/** Prepares the database tab */
private Tab setupDatabase(final ValuesManager vm) {
// Prepare the map with all database engines
engines.put(
MYSQL,
new String[] {
"MySQL 5.x",
"com.mysql.jdbc.Driver",
"jdbc:mysql://<server>[,<failoverhost>][<:3306>]/<database>",
"org.hibernate.dialect.MySQLDialect",
"SELECT 1"
});
engines.put(
"PostgreSQL",
new String[] {
"PostgreSQL 9.x",
"org.postgresql.Driver",
"jdbc:postgresql:[<//server>[<:5432>/]]<database>",
"org.hibernate.dialect.PostgreSQLDialect",
"SELECT 1"
});
engines.put(
ORACLE,
new String[] {
"Oracle 10g/11g",
"oracle.jdbc.driver.OracleDriver",
"jdbc:oracle:thin:@<server>[<:1521>]:<sid>",
"org.hibernate.dialect.Oracle10gDialect",
"SELECT 1 FROM DUAL"
});
engines.put(
SQLSERVER,
new String[] {
"SQL Server 2005/2008",
"net.sourceforge.jtds.jdbc.Driver",
"jdbc:jtds:sqlserver://<server>[:<1433>]/<database>;instance=<instance>",
"org.hibernate.dialect.SQLServerDialect",
"SELECT 1"
});
Tab databaseTab = new Tab();
databaseTab.setTitle(I18N.message("database"));
final DynamicForm databaseForm = new DynamicForm();
databaseForm.setWidth(450);
databaseForm.setID("database");
databaseForm.setValuesManager(vm);
databaseForm.setDisabled(true);
RadioGroupItem dbType = new RadioGroupItem();
dbType.setName(DB_TYPE);
dbType.setWrapTitle(false);
dbType.setRequired(true);
dbType.setVertical(false);
dbType.setValueMap(I18N.message(INTERNAL), I18N.message("external"));
dbType.setValue(I18N.message(INTERNAL));
dbType.setRedrawOnChange(true);
dbType.setTitle(I18N.message("dbtype"));
// The database engine, if the External db was chosen
SelectItem dbEngine = new SelectItem();
dbEngine.setTitle(I18N.message("dbengine"));
dbEngine.setWrapTitle(false);
dbEngine.setVisible(false);
dbEngine.setName(DB_ENGINE);
dbEngine.setDefaultValue(MYSQL);
LinkedHashMap<String, String> valueMap = new LinkedHashMap<String, String>();
for (String engine : engines.keySet()) {
valueMap.put(engine, engines.get(engine)[0]);
}
dbEngine.setValueMap(valueMap);
dbEngine.setShowIfCondition(
new FormItemIfFunction() {
public boolean execute(FormItem item, Object value, DynamicForm form) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
RequiredIfValidator ifValidator = new RequiredIfValidator();
ifValidator.setExpression(
new RequiredIfFunction() {
public boolean execute(FormItem formItem, Object value) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
dbEngine.setValidators(ifValidator);
dbEngine.addChangeHandler(
new ChangeHandler() {
public void onChange(ChangeEvent event) {
String selectedItem = (String) event.getValue();
databaseForm.getField(DB_DRIVER).setValue(engines.get(selectedItem)[1]);
databaseForm.getField(DB_URL).setValue(engines.get(selectedItem)[2]);
}
});
// The driver for the external DB
TextItem dbDriver = ItemFactory.newTextItem(DB_DRIVER, "driverclass", null);
dbDriver.setVisible(false);
dbDriver.setDefaultValue(engines.get(MYSQL)[1]);
dbDriver.setWrapTitle(false);
dbDriver.setShowIfCondition(
new FormItemIfFunction() {
public boolean execute(FormItem item, Object value, DynamicForm form) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
dbDriver.setValidators(ifValidator);
// The connection URL to external DB
TextItem dbUrl = ItemFactory.newTextItem(DB_URL, "connectionurl", null);
dbUrl.setWidth(200);
dbUrl.setVisible(false);
dbUrl.setDefaultValue(engines.get(MYSQL)[2]);
dbUrl.setWrapTitle(false);
dbUrl.setShowIfCondition(
new FormItemIfFunction() {
public boolean execute(FormItem item, Object value, DynamicForm form) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
dbUrl.setValidators(ifValidator);
// The username to access the external DB
TextItem dbUsername = ItemFactory.newTextItem(DB_USERNAME, "username", null);
dbUsername.setVisible(false);
dbUsername.setWrapTitle(false);
dbUsername.setShowIfCondition(
new FormItemIfFunction() {
public boolean execute(FormItem item, Object value, DynamicForm form) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
// The password to access the external DB
PasswordItem dbPassword = new PasswordItem();
dbPassword.setVisible(false);
dbPassword.setTitle(I18N.message("password"));
dbPassword.setName(DB_PASSWORD);
dbPassword.setWrapTitle(false);
dbPassword.setShowIfCondition(
new FormItemIfFunction() {
public boolean execute(FormItem item, Object value, DynamicForm form) {
return !I18N.message(INTERNAL).equals(databaseForm.getValue(DB_TYPE));
}
});
databaseForm.setFields(dbType, dbEngine, dbDriver, dbUrl, dbUsername, dbPassword);
databaseTab.setPane(databaseForm);
return databaseTab;
}
