derby In memory database + junit

Question

I got an exception below when trying to use derby in memory database in JUNITTEST.

java.sql.SQLNonTransientConnectionException: Database 'memory:testDB' dropped. at org.apache.derby.iapi.error.StandardException.newException(Unknown Source)

@Before
public void setUp() throws Exception {
    String driver = "org.apache.derby.jdbc.EmbeddedDriver";
    String connectionURL = "jdbc:derby:memory:testDB;create=true";
    Class.forName(driver);
    Connection conn = DriverManager.getConnection(connectionURL);
    super.setUp();
}

@After
public void tearDown() throws Exception {
    String connectionURL = "jdbc:derby:memory:testDB;drop=true";
    DriverManager.getConnection(connectionURL);
}

I assume the exception is occuring in your tearDown() method? It is normal for "drop=true" to throw a "Database dropped" exception. Is that what your question is about? — Bryan Pendleton, Oct 14 '15 at 23:54

score 0 · Answer 1 · edited May 23 '17 at 11:59

0

If you are using Maven for your build, you can use the derby-maven-plugin, which I wrote and is available on GitHub and via Maven Central. It will take care of starting and stopping the database for you before your tests.

You can check here for my answer to a similar question.

edited May 23 '17 at 11:59

Community

1
1

answered Dec 11 '15 at 15:13

carlspring

31,231
29
115
197

derby In memory database + junit

1 Answers1