/*
 * Licensed to the Apache Software Foundation (ASF) under one or more
 * contributor license agreements.  See the NOTICE file distributed with
 * this work for additional information regarding copyright ownership.
 * The ASF licenses this file to You under the Apache License, Version 2.0
 * (the "License"); you may not use this file except in compliance with
 * the License.  You may obtain a copy of the License at
 *
 *      http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package org.apache.jackrabbit.oak.jcr;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import javax.jcr.Repository;
import javax.jcr.RepositoryException;
import javax.jcr.Session;

import org.apache.jackrabbit.oak.plugins.document.DocumentMK;
import org.apache.jackrabbit.oak.plugins.document.DocumentNodeStore;
import org.apache.jackrabbit.oak.plugins.document.rdb.RDBDataSourceFactory;
import org.apache.jackrabbit.oak.query.QueryEngineSettings;

/**
 * A repository stub implementation for the RDB document store.
 */
public class OakDocumentRDBRepositoryStub extends OakRepositoryStub {

    protected static final String URL = System.getProperty("rdb.jdbc-url", ""); // such as: jdbc:h2:mem:oaknodes

    protected static final String USERNAME = System.getProperty("rdb.jdbc-user", "sa");

    protected static final String PASSWD = System.getProperty("rdb.jdbc-passwd", "");

    private final Repository repository;

    /**
     * Constructor as required by the JCR TCK.
     * 
     * @param settings
     *            repository settings
     * @throws javax.jcr.RepositoryException
     *             If an error occurs.
     */
    public OakDocumentRDBRepositoryStub(Properties settings) throws RepositoryException {
        super(settings);

        Session session = null;
        try {
            this.repository = createRepository(URL, USERNAME, PASSWD);

            session = getRepository().login(superuser);
            TestContentLoader loader = new TestContentLoader();
            loader.loadTestContent(session);
        } catch (Exception e) {
            throw new RepositoryException(e);
        } finally {
            if (session != null) {
                session.logout();
            }
        }
        // Runtime.getRuntime().addShutdownHook(new Thread(new ShutdownHook(connection)));
    }

    protected Repository createRepository(String url, String username, String password) {
        DocumentNodeStore m = new DocumentMK.Builder().
                setClusterId(1).
                memoryCacheSize(64 * 1024 * 1024).
                setPersistentCache("target/persistentCache,time").
                setRDBConnection(RDBDataSourceFactory.forJdbcUrl(url, username, password)).
                getNodeStore();
        QueryEngineSettings qs = new QueryEngineSettings();
        qs.setFullTextComparisonWithoutIndex(true);
        return new Jcr(m).with(qs).createRepository();
    }

    public static boolean isAvailable() {
        try {
            Connection c = DriverManager.getConnection(URL, USERNAME, PASSWD);
            c.close();
            return true;
        }
        catch (SQLException ex) {
            // expected
            return false;
        }
    }

    /**
     * Returns the configured repository instance.
     * 
     * @return the configured repository instance.
     */
    @Override
    public synchronized Repository getRepository() {
        return repository;
    }
}

@@ -836,16 +836,37 @@
 k.jcr;%0A%0A
+import java.io.File;%0A
 import j
@@ -881,24 +881,24 @@
 Connection;%0A
-
 import java.
@@ -974,16 +974,39 @@
 perties;
+%0Aimport java.util.UUID;
 %0A%0Aimport
@@ -1296,24 +1296,90 @@
 rceFactory;%0A
+import org.apache.jackrabbit.oak.plugins.document.rdb.RDBOptions;%0A
 import org.a
@@ -1650,44 +1650,40 @@
 %22, %22
-%22); // such as: jdbc:h2:mem:oaknodes
+jdbc:h2:file:./%7Bfname%7Doaktest%22);
 %0A%0A  
@@ -1898,16 +1898,183 @@
 itory;%0A%0A
+    private static final String fname = (new File(%22target%22)).isDirectory() ? %22target/%22 : %22%22;%0A    private static final String jdbcUrl = URL.replace(%22%7Bfname%7D%22, fname);%0A%0A
     /**%0A
@@ -2490,19 +2490,52 @@
 ository(
-URL
+OakDocumentRDBRepositoryStub.jdbcUrl
 , USERNA
@@ -2547,17 +2547,16 @@
 ASSWD);%0A
-%0A
         
@@ -3087,24 +3087,193 @@
 password) %7B%0A
+        String prefix = %22T%22 + UUID.randomUUID().toString().replace(%22-%22,  %22%22);%0A        RDBOptions options = new RDBOptions().tablePrefix(prefix).dropTablesOnClose(true);%0A
         Docu
@@ -3556,16 +3556,25 @@
 assword)
+, options
 ).%0A     
@@ -3885,19 +3885,52 @@
 nection(
-URL
+OakDocumentRDBRepositoryStub.jdbcUrl
 , USERNA

set working default JDBC URL for OakDocumentRDBRepositoryStub