/*******************************************************************************
 * Copyright (c) 2011, 2017 Eurotech and/or its affiliates 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:
 *     Red Hat
 *******************************************************************************/
package org.eclipse.kapua.commons.jpa;

/**
 * H2 Jdbc url connection resolver implementation
 *
 * @since 1.0
 */
public class H2JdbcConnectionUrlResolver implements JdbcConnectionUrlResolver {

    @Override
    public String connectionUrl() {
        return "jdbc:h2:mem:kapua;MODE=MySQL;INIT=create schema if not exists kapuadb\\;SET SCHEMA kapuadb";
    }

}

/*******************************************************************************
 * Copyright (c) 2011, 2017 Eurotech and/or its affiliates 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:
 *     Red Hat
 *******************************************************************************/
package org.eclipse.kapua.commons.jpa;

/**
 * H2 Jdbc url connection resolver implementation
 *
 * @since 1.0
 */
public class H2JdbcConnectionUrlResolver implements JdbcConnectionUrlResolver {

    @Override
    public String connectionUrl() {
        return "jdbc:h2:mem:kapua;MODE=MySQL;INIT=create schema if not exists kapuadb";
    }

}

--- 
+++ 
@@ -20,7 +20,7 @@
 
     @Override
     public String connectionUrl() {
-        return "jdbc:h2:mem:kapua;MODE=MySQL;INIT=create schema if not exists kapuadb";
+        return "jdbc:h2:mem:kapua;MODE=MySQL;INIT=create schema if not exists kapuadb\\;SET SCHEMA kapuadb";
     }
 
 }
Use kapuadb schema by default

Signed-off-by: Elbert Evangelista <6a308fc4e2672d8df3711d12a762bf46d651708f@eurotech.com>
