/*
* Copyright (c) 2006-2011 Nuxeo SA (http://nuxeo.com/) and others.
*
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
* Florent Guillaume
*/
package org.nuxeo.ecm.core.storage.sql;
import java.io.File;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import org.nuxeo.common.utils.FileUtils;
import org.nuxeo.runtime.api.Framework;
/**
* @author Florent Guillaume
*/
public class DatabaseDerby extends DatabaseHelper {
public static final DatabaseHelper INSTANCE = new DatabaseDerby();
/** This directory will be deleted and recreated. */
private static final String DIRECTORY = "target/test/derby";
private static final String DEF_USER = "sa";
private static final String DEF_PASSWORD = "";
private static final String CONTRIB_XML = "OSGI-INF/test-repo-repository-derby-contrib.xml";
private static final String LOG = "target/test/derby.log";
private static final String DRIVER = "org.apache.derby.jdbc.EmbeddedDriver";
protected String url;
protected void setProperties() {
Framework.getProperties().setProperty(REPOSITORY_PROPERTY,
repositoryName);
setProperty(DATABASE_PROPERTY, new File(DIRECTORY).getAbsolutePath());
setProperty(USER_PROPERTY, DEF_USER);
setProperty(PASSWORD_PROPERTY, DEF_PASSWORD);
// for sql directory tests
setProperty(DRIVER_PROPERTY, DRIVER);
url = String.format("jdbc:derby:%s;create=true",
Framework.getProperty(DATABASE_PROPERTY));
setProperty(URL_PROPERTY, url);
}
@Override
public void setUp() throws Exception {
super.setUp();
System.setProperty("derby.stream.error.file",
new File(LOG).getAbsolutePath());
// newInstance needed after a previous shutdown
Class.forName(DRIVER).newInstance();
File dbdir = new File(DIRECTORY);
File parent = dbdir.getParentFile();
FileUtils.deleteTree(dbdir);
parent.mkdirs();
// the following noticeably improves performance
System.setProperty("derby.system.durability", "test");
setProperties();
}
@Override
public void tearDown() throws SQLException {
Exception ex = null;
try {
DriverManager.getConnection("jdbc:derby:;shutdown=true");
// after this to reboot the driver a newInstance is needed
} catch (SQLException e) {
String message = e.getMessage();
if ("Derby system shutdown.".equals(message)) {
return;
}
if ("org.apache.derby.jdbc.EmbeddedDriver is not registered with the JDBC driver manager".equals(message)) {
// huh? happens for testClustering
return;
}
ex = e;
} finally {
super.tearDown();
}
throw new RuntimeException("Expected Derby shutdown exception instead",
ex);
}
@Override
public String getDeploymentContrib() {
return CONTRIB_XML;
}
@Override
public RepositoryDescriptor getRepositoryDescriptor() {
RepositoryDescriptor descriptor = new RepositoryDescriptor();
descriptor.xaDataSourceName = "org.apache.derby.jdbc.EmbeddedXADataSource";
Map<String, String> properties = new HashMap<String, String>();
properties.put("createDatabase", "create");
properties.put("databaseName", Framework.getProperty(DATABASE_PROPERTY));
properties.put("user", Framework.getProperty(USER_PROPERTY));
properties.put("password", Framework.getProperty(PASSWORD_PROPERTY));
descriptor.properties = properties;
return descriptor;
}
@Override
public boolean supportsMultipleFulltextIndexes() {
return false;
}
}