Play Framework Junit test case Db error

Question

Am new to play framework and Junit. Have little bit knowledge in java. Based on play framework getting started and documentation am started to write unit tests for play application. When i run the application in normal mode. It works fine with database models.

when i run the application in test mode. it shows jpa query exception and schema not found.

Am attached the test class file for your reference : -

import org.junit.*;
import java.net.*;
import java.util.*;
import play.test.*;
import play.test.FunctionalTest.URL;
import models.*;
import params.*;

public class BasicTest extends UnitTest {



    @Test
    public void testing(){

        //User user = null;
        User user = User.find("byUsernameAndPassword","admin","Y29tcGFzczEyMw==").first();
        assertNotNull(user);
        //assertNotNull("test");
    }

}

Anyone help me to fix this issue.

This is my current application.conf settings in play :

db.url=jdbc:vertica://verticadatabaseurlurl/XXXXXXX
db.driver=com.vertica.Driver
db.user=XXXXX
db.pass=XXXXXX
db.schema=XXXXXX

# JPA Configuration (Hibernate)
# ~~~~~
#
# Specify the custom JPA dialect to use here (default to guess):
 jpa.dialect=org.hibernate.dialect.PostgreSQLDialect
#
# Specify the ddl generation pattern to use. Set to none to disable it 
# (default to update in DEV mode, and none in PROD mode):
 jpa.ddl=none
#
# Debug SQL statements (logged using DEBUG level):
 jpa.debugSQL=true
#
# You can even specify additional hibernate properties here:
# hibernate.use_sql_comments=true
# ...
#
#%test.module.cobertura=${play.path}/modules/cobertura
%test.application.mode=dev
%test.db.url=jdbc:h2:mem:play;MODE=MYSQL;LOCK_MODE=0
%test.db=mem
%test.jpa.ddl=create
%test.mail.smtp=mock

am currently using vertica for database. By this settings can able to run the application in normal mode. In test mode it makes that issue.

http://tinypic.com/r/a48zg4/7 -screenshot reference

Answer 1

What is the JPA configuration you use for the unit tests. More specifc, what's the persistence.xml that you use for unit tests. It might be that you need to add the schema autogeneration config param to the test persistence unit you use, something like:

<persistence-unit name="emApplicationManaged_forTests_h2" transaction-type="RESOURCE_LOCAL">  
    <class>model.Employee</class>  
    <!-- your Entity classes here --> 
    <properties>  
        <!-- your hibernate specific params here -->
        <!-- the below parameter tells hibernate to create the schema when you start your app (test) and to erase it when it finishes: -->
        <property name="hibernate.hbm2ddl.auto" value="create-drop" />    
    </properties>  
</persistence-unit>

The above is for when you use Hibernate JPA implementation. If you use Toplink, try:

<persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"
    version="2.0" xmlns="http://java.sun.com/xml/ns/persistence">
    <persistence-unit name="todos" transaction-type="RESOURCE_LOCAL">
        <!-- entity classes -->
        <properties>
            <!-- eclipselink specific config-->
            <!-- EclipseLink should create the database schema automatically -->
            <property name="eclipselink.ddl-generation" value="create-tables" />
            <property name="eclipselink.ddl-generation.output-mode" value="database" />
        </properties>
    </persistence-unit>
</persistence>

For Play framework, you have special config params that start with test. prefix. Try this: open your application.conf config file and add the lines that configures the test environment for db schema auto-creation:

%test.db=mem
%test.jpa.ddl=create-drop

Then try your tests from the Play unit test running page (localhost:9090/@tests#)

Also check out this Play cheat-sheet, its pretty useful (I think the chapter called "Multidev Environment" is pertinent to your specific issue):

http://playcheatsheet.appspot.com/show/ArtemMedeu/armed/play-cheatsheets