ava.sql.SQLException: Unexpected token REFERENTIAL, requires COLLATION in statement [SET DATABASE REFERENTIAL]

224 views

Skip to first unread message

Philippe COUAS

unread,

Oct 3, 2012, 5:46:00 AM10/3/12

to Ebean ORM

Hi,

I have following error message on HsqlDB 1.8

Regards
Phil

<?xml version="1.0" encoding="UTF-8" ?>
<testsuite failures="1" time="1.187" errors="0" skipped="0" tests="1"
name="com.example.EmployeeDao2Test">
<properties>
<property name="java.runtime.name" value="Java(TM) SE Runtime
Environment"/>
<property name="sun.boot.library.path" value="C:\java
\jdk1.6.0_21\jre\bin"/>
<property name="java.vm.version" value="20.10-b01"/>
<property name="java.vm.vendor" value="Sun Microsystems Inc."/>
<property name="java.vendor.url" value="http://java.sun.com/"/>
<property name="path.separator" value=";"/>
<property name="guice.disable.misplaced.annotation.check"
value="true"/>
<property name="java.vm.name" value="Java HotSpot(TM) Client VM"/>
<property name="file.encoding.pkg" value="sun.io"/>
<property name="user.country" value="FR"/>
<property name="sun.java.launcher" value="SUN_STANDARD"/>
<property name="sun.os.patch.level" value="Service Pack 3"/>
<property name="java.vm.specification.name" value="Java Virtual
Machine Specification"/>
<property name="user.dir" value="C:\prj_java\TestAgarder
\unitils02\demos\V5b20037_unitils-example"/>
<property name="java.runtime.version" value="1.6.0_35-b10"/>
<property name="java.awt.graphicsenv"
value="sun.awt.Win32GraphicsEnvironment"/>
<property name="java.endorsed.dirs" value="C:\java\jdk1.6.0_21\jre
\lib\endorsed"/>
<property name="os.arch" value="x86"/>
<property name="java.io.tmpdir" value="C:\DOCUME~1\COUAS
\LOCALS~1\Temp\"/>
<property name="line.separator" value="
"/>
<property name="java.vm.specification.vendor" value="Sun
Microsystems Inc."/>
<property name="user.variant" value=""/>
<property name="os.name" value="Windows XP"/>
<property name="classworlds.conf" value="C:\java\apache-
maven-3.0.4\bin\m2.conf"/>
<property name="sun.jnu.encoding" value="Cp1252"/>
<property name="java.library.path" value="C:\java
\jdk1.6.0_21\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:
\WINDOWS;C:\Program Files\PC Connectivity Solution\;C:\WINDOWS
\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files
\Fichiers communs\Roxio Shared\DLLShared\;C:\Program Files\Microsoft
SQL Server\80\Tools\Binn\;C:\Program Files\Fichiers communs\GTK
\2.0\bin;C:/AppPerfect/DevTest/apdevtools/eclipse/plugins/
com.appperfect.teststudio_9.5.0.3026/lib;C:\Program Files\Samsung
\Samsung PC Studio 3\;C:\Program Files\Fichiers communs\Teleca
Shared;C:\java\jdk1.6.0_21/bin;C:\java\apache-maven-3.0.4\bin;C:
\Program Files\Nmap;."/>
<property name="java.specification.name" value="Java Platform API
Specification"/>
<property name="java.class.version" value="50.0"/>
<property name="sun.management.compiler" value="HotSpot Client
Compiler"/>
<property name="os.version" value="5.1"/>
<property name="user.home" value="C:\Documents and Settings\COUAS"/
>
<property name="user.timezone" value="Europe/Paris"/>
<property name="java.awt.printerjob"
value="sun.awt.windows.WPrinterJob"/>
<property name="file.encoding" value="Cp1252"/>
<property name="java.specification.version" value="1.6"/>
<property name="user.name" value="COUAS"/>
<property name="java.class.path" value="C:\java\apache-
maven-3.0.4\boot\plexus-classworlds-2.4.jar"/>
<property name="java.vm.specification.version" value="1.0"/>
<property name="sun.arch.data.model" value="32"/>
<property name="java.home" value="C:\java\jdk1.6.0_21\jre"/>
<property name="sun.java.command"
value="org.codehaus.plexus.classworlds.launcher.Launcher -X -e clean
install"/>
<property name="java.specification.vendor" value="Sun Microsystems
Inc."/>
<property name="user.language" value="fr"/>
<property name="awt.toolkit" value="sun.awt.windows.WToolkit"/>
<property name="java.vm.info" value="mixed mode, sharing"/>
<property name="java.version" value="1.6.0_35"/>
<property name="java.ext.dirs" value="C:\java\jdk1.6.0_21\jre\lib
\ext;C:\WINDOWS\Sun\Java\lib\ext"/>
<property name="sun.boot.class.path" value="C:\java\jdk1.6.0_21\jre
\lib\resources.jar;C:\java\jdk1.6.0_21\jre\lib\rt.jar;C:\java
\jdk1.6.0_21\jre\lib\sunrsasign.jar;C:\java\jdk1.6.0_21\jre\lib
\jsse.jar;C:\java\jdk1.6.0_21\jre\lib\jce.jar;C:\java\jdk1.6.0_21\jre
\lib\charsets.jar;C:\java\jdk1.6.0_21\jre\lib\modules\jdk.boot.jar;C:
\java\jdk1.6.0_21\jre\classes"/>
<property name="java.vendor" value="Sun Microsystems Inc."/>
<property name="maven.home" value="C:\java\apache-maven-3.0.4"/>
<property name="file.separator" value="\"/>
<property name="java.vendor.url.bug" value="http://java.sun.com/
cgi-bin/bugreport.cgi"/>
<property name="sun.cpu.endian" value="little"/>
<property name="sun.io.unicode.encoding" value="UnicodeLittle"/>
<property name="sun.desktop" value="windows"/>
<property name="sun.cpu.isalist" value="pentium_pro+mmx
pentium_pro pentium+mmx pentium i486 i386 i86"/>
</properties>
<testcase time="1.187" classname="com.example.EmployeeDao2Test"
name="count2">
<failure
type="junit.framework.AssertionFailedError:">junit.framework.AssertionFailedError:
null
at junit.framework.Assert.fail(Assert.java:47)
at junit.framework.Assert.assertTrue(Assert.java:20)
at junit.framework.Assert.assertNotNull(Assert.java:214)
at junit.framework.Assert.assertNotNull(Assert.java:207)
at com.example.EmployeeDao2Test.count2(EmployeeDao2Test.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
at
org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:
98)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runTestMethod(UnitilsJUnit4TestClassRunner.java:
174)
at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:
79)
at
org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:
87)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runBeforesThenTestThenAfters(UnitilsJUnit4TestClassRunner.java:
156)
at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:
77)
at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
at
org.unitils.UnitilsJUnit4TestClassRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:
95)
at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:
51)
at org.unitils.UnitilsJUnit4TestClassRunner.access
$000(UnitilsJUnit4TestClassRunner.java:44)
at org.unitils.UnitilsJUnit4TestClassRunner
$1.run(UnitilsJUnit4TestClassRunner.java:62)
at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:
27)
at
org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:
37)
at
org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:
68)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:
236)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:
134)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:
113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:
189)
at org.apache.maven.surefire.booter.ProviderFactory
$ProviderProxy.invoke(ProviderFactory.java:165)
at
org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:
85)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:
103)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:
74)
</failure>
<system-out>runScript
executing 1 of 3 SET DATABASE REFERENTIAL INTEGRITY FALSE
... ignoring error executing SET DATABASE REFERENTIAL INTEGRITY
FALSE error: Unexpected token REFERENTIAL, requires COLLATION in
statement [SET DATABASE REFERENTIAL]
executing 2 of 3 drop table if exists EMPLOYEES
executing 3 of 3 SET DATABASE REFERENTIAL INTEGRITY TRUE
... ignoring error executing SET DATABASE REFERENTIAL INTEGRITY TRUE
error: Unexpected token REFERENTIAL, requires COLLATION in statement
[SET DATABASE REFERENTIAL]
... end of script
runScript
executing 1 of 1 create table EMPLOYEES ( id
integer GENERATED BY DEFAULT...
... end of script
</system-out>
<system-err>log4j:WARN No appenders could be found for logger
(org.unitils.core.ConfigurationLoader).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig
for more info.
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.core.BootupClassPathSearch search
INFO: Classpath search hits in jars[ebean-2.7.7.jar]
pkgs[com.avaje.ebeaninternal.server.bean, com.avaje.ebean.meta,
com.example] searchTime[47]
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.lib.sql.DataSourcePool initialise
INFO: DataSourcePool [hsqldb] autoCommit[false]
transIsolation[READ_COMMITTED] min[1] max[25]
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.core.DefaultServerFactory
setDatabasePlatform
INFO: DatabasePlatform name:hsqldb platform:hsqldb
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.subclass.SubClassManager$1 run
INFO: SubClassFactory parent ClassLoader
[org.apache.maven.surefire.booter.IsolatedClassLoader]
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.deploy.BeanDescriptorManager logStatus
INFO: Entities enhanced[0] subclassed[1]
java.sql.SQLException: Unexpected token REFERENTIAL, requires
COLLATION in statement [SET DATABASE REFERENTIAL]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
at
com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.execute(ExtendedPreparedStatement.java:
136)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:
272)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:
246)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:
224)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runDdl(DdlGenerator.java:
93)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.execute(DdlGenerator.java:
66)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.executeDDL(DefaultServerFactory.java:
347)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
229)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
123)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
63)
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:
64)
at com.avaje.ebean.Ebean$ServerManager.getWithCreate(Ebean.java:225)
at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:181)
at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:147)
at com.avaje.ebean.Ebean.<clinit>(Ebean.java:141)
at com.example.EbeanEmployeeDao.count2(EbeanEmployeeDao.java:88)
at com.example.EmployeeDao2Test.count2(EmployeeDao2Test.java:34)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
at
org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:
98)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runTestMethod(UnitilsJUnit4TestClassRunner.java:
174)
at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:
79)
at
org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:
87)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runBeforesThenTestThenAfters(UnitilsJUnit4TestClassRunner.java:
156)
at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:
77)
at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
at
org.unitils.UnitilsJUnit4TestClassRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:
95)
at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:
51)
at org.unitils.UnitilsJUnit4TestClassRunner.access
$000(UnitilsJUnit4TestClassRunner.java:44)
at org.unitils.UnitilsJUnit4TestClassRunner
$1.run(UnitilsJUnit4TestClassRunner.java:62)
at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:
27)
at
org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:
37)
at
org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:
68)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:
236)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:
134)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:
113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:
189)
at org.apache.maven.surefire.booter.ProviderFactory
$ProviderProxy.invoke(ProviderFactory.java:165)
at
org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:
85)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:
103)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:
74)
java.sql.SQLException: Unexpected token REFERENTIAL, requires
COLLATION in statement [SET DATABASE REFERENTIAL]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.execute(Unknown Source)
at
com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.execute(ExtendedPreparedStatement.java:
136)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:
272)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:
246)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:
224)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.runDdl(DdlGenerator.java:
93)
at
com.avaje.ebeaninternal.server.ddl.DdlGenerator.execute(DdlGenerator.java:
66)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.executeDDL(DefaultServerFactory.java:
347)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
229)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
123)
at
com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
63)
at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:
64)
at com.avaje.ebean.Ebean$ServerManager.getWithCreate(Ebean.java:225)
at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:181)
at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:147)
at com.avaje.ebean.Ebean.<clinit>(Ebean.java:141)
at com.example.EbeanEmployeeDao.count2(EbeanEmployeeDao.java:88)
at com.example.EmployeeDao2Test.count2(EmployeeDao2Test.java:34)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
at
org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:
98)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runTestMethod(UnitilsJUnit4TestClassRunner.java:
174)
at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:
79)
at
org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:
87)
at org.unitils.UnitilsJUnit4TestClassRunner
$TestListenerInvokingMethodRoadie.runBeforesThenTestThenAfters(UnitilsJUnit4TestClassRunner.java:
156)
at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:
77)
at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
at
org.unitils.UnitilsJUnit4TestClassRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:
95)
at
org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:
51)
at org.unitils.UnitilsJUnit4TestClassRunner.access
$000(UnitilsJUnit4TestClassRunner.java:44)
at org.unitils.UnitilsJUnit4TestClassRunner
$1.run(UnitilsJUnit4TestClassRunner.java:62)
at
org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:
27)
at
org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:
37)
at
org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:
68)
at
org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:
236)
at
org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:
134)
at
org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:
113)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:
25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:
189)
at org.apache.maven.surefire.booter.ProviderFactory
$ProviderProxy.invoke(ProviderFactory.java:165)
at
org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:
85)
at
org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:
103)
at
org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:
74)
3 oct. 2012 06:27:40
com.avaje.ebeaninternal.server.transaction.log.FileTransactionLoggerWrapper
initialiseLogger
INFO: Transaction logs in: logs
</system-err>
</testcase>
</testsuite>

Philippe COUAS

unread,

Oct 4, 2012, 12:31:36 AM10/4/12

to Ebean ORM

Hi,

My Logs

INFO: DataSourcePool [hsqldb] autoCommit[false]
transIsolation[READ_COMMITTED] min[1] max[25]

4 oct. 2012 06:28:29

com.avaje.ebeaninternal.server.core.DefaultServerFactory
setDatabasePlatform
INFO: DatabasePlatform name:hsqldb platform:hsqldb

4 oct. 2012 06:28:29

com.avaje.ebeaninternal.server.subclass.SubClassManager$1 run
INFO: SubClassFactory parent ClassLoader
[org.apache.maven.surefire.booter.IsolatedClassLoader]

4 oct. 2012 06:28:29

com.avaje.ebeaninternal.server.deploy.BeanDescriptorManager logStatus
INFO: Entities enhanced[0] subclassed[1]
java.sql.SQLException: Unexpected token REFERENTIAL, requires
COLLATION in statement [SET DATABASE REFERENTIAL]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)

my sql file
SET DATABASE COLLATION "French";
SET REFERENTIAL_INTEGRITY FALSE;
SET SCHEMA PUBLIC;
drop table if exists "PUBLIC"."EMPLOYEES";
CREATE TABLE "PUBLIC"."EMPLOYEES"(ID IDENTITY NOT NULL,NAME
VARCHAR(20),title VARCHAR(20),SALARY DOUBLE,ni INTEGER NOT NULL);

My ebean.properties

## -------------------------------------------------------------
## Load (Dev/Test/Prod) server specific properties
## -------------------------------------------------------------
## This is a possible alternative to using JNDI to set environment
## properties externally (to the WAR file). This is another way
## your Dev, Test and Prod servers can have different properties.

#load.properties.override=${CATALINA_HOME}/conf/myapp.ebean.properties

ebean.ddl.generate=true
ebean.ddl.run=true

ebean.debug.sql=true
ebean.debug.lazyload=false

#ebean.search.jar=

## -------------------------------------------------------------
## Transaction Logging
## -------------------------------------------------------------

## Use java util logging to log transaction details
#ebean.loggingToJavaLogger=true

## General logging level: (none, explicit, all)
ebean.logging=all

## Sharing log files: (none, explicit, all)
ebean.logging.logfilesharing=all

## location of transaction logs
ebean.logging.directory=logs
#ebean.logging.directory=${catalina.base}/logs/trans

## Specific Log levels (none, summary, binding, sql)
ebean.logging.iud=sql
ebean.logging.query=sql
ebean.logging.sqlquery=sql

## Log level for txn begin, commit and rollback (none, debug, verbose)
ebean.logging.txnCommit=none

## -------------------------------------------------------------
## DataSources (If using default Ebean DataSourceFactory)
## -------------------------------------------------------------

#DEFINI ebean.server
datasource.default=hsqldb
#datasource.default=h2

datasource.hsqldb.username=SA
datasource.hsqldb.password=
datasource.hsqldb.databaseUrl=jdbc:hsqldb:mem:unitils-example
datasource.hsqldb.databaseDriver=org.hsqldb.jdbcDriver
datasource.hsqldb.minConnections=1
datasource.hsqldb.maxConnections=25
datasource.hsqldb.heartbeatsql=SELECT COUNT(1) FROM
INFORMATION_SCHEMA.SYSTEM_CATALOGS
datasource.hsqldb.isolationlevel=read_committed

Regards
Phil

> type="junit.framework.AssertionFailedError:">junit.framework.AssertionFailedError:

> null
> at junit.framework.Assert.fail(Assert.java:47)
> at junit.framework.Assert.assertTrue(Assert.java:20)
> at junit.framework.Assert.assertNotNull(Assert.java:214)
> at junit.framework.Assert.assertNotNull(Assert.java:207)
> at com.example.EmployeeDao2Test.count2(EmployeeDao2Test.java:36)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
> at

> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:

> 25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.junit.internal.runners.TestMethod.invoke(TestMethod.java:59)
> at
> org.junit.internal.runners.MethodRoadie.runTestMethod(MethodRoadie.java:
> 98)
> at org.unitils.UnitilsJUnit4TestClassRunner

> $TestListenerInvokingMethodRoadie.runTestMethod(UnitilsJUnit4TestClassRunner.java:

> 174)
> at org.junit.internal.runners.MethodRoadie$2.run(MethodRoadie.java:
> 79)
> at

> org.junit.internal.runners.MethodRoadie.runBeforesThenTestThenAfters(MethodRoadie.java:
> 87)
> at org.unitils.UnitilsJUnit4TestClassRunner
> $TestListenerInvokingMethodRoadie.runBeforesThenTestThenAfters(UnitilsJUnit4TestClassRunner.java:

> 156)
> at org.junit.internal.runners.MethodRoadie.runTest(MethodRoadie.java:
> 77)
> at org.junit.internal.runners.MethodRoadie.run(MethodRoadie.java:42)
> at

> org.unitils.UnitilsJUnit4TestClassRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:
> 95)
> at
> org.junit.internal.runners.JUnit4ClassRunner.runMethods(JUnit4ClassRunner.java:

> 51)
> at org.unitils.UnitilsJUnit4TestClassRunner.access
> $000(UnitilsJUnit4TestClassRunner.java:44)
> at org.unitils.UnitilsJUnit4TestClassRunner
> $1.run(UnitilsJUnit4TestClassRunner.java:62)
> at
> org.junit.internal.runners.ClassRoadie.runUnprotected(ClassRoadie.java:
> 27)
> at
> org.junit.internal.runners.ClassRoadie.runProtected(ClassRoadie.java:
> 37)
> at

> org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:

> 68)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:
> 236)
> at

> org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:

> 134)
> at
> org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:
> 113)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
> at

> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:

> 25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at

> org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:

> 189)
> at org.apache.maven.surefire.booter.ProviderFactory
> $ProviderProxy.invoke(ProviderFactory.java:165)
> at

> org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:
> 85)
> at
> org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:

> 103)
> at
> org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:
> 74)
> </failure>
> <system-out>runScript
> executing 1 of 3 SET DATABASE REFERENTIAL INTEGRITY FALSE
> ... ignoring error executing SET DATABASE REFERENTIAL INTEGRITY
> FALSE error: Unexpected token REFERENTIAL, requires COLLATION in
> statement [SET DATABASE REFERENTIAL]
> executing 2 of 3 drop table if exists EMPLOYEES
> executing 3 of 3 SET DATABASE REFERENTIAL INTEGRITY TRUE
> ... ignoring error executing SET DATABASE REFERENTIAL INTEGRITY TRUE
> error: Unexpected token REFERENTIAL, requires COLLATION in statement
> [SET DATABASE REFERENTIAL]
> ... end of script
> runScript
> executing 1 of 1 create table EMPLOYEES ( id
> integer GENERATED BY DEFAULT...
> ... end of script
> </system-out>
> <system-err>log4j:WARN No appenders could be found for logger
> (org.unitils.core.ConfigurationLoader).
> log4j:WARN Please initialize the log4j system properly.

> log4j:WARN Seehttp://logging.apache.org/log4j/1.2/faq.html#noconfig

> com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.execute(ExtendedPreparedStatement.java:
> 136)
> at
> com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatement(DdlGenerator.java:
> 272)
> at
> com.avaje.ebeaninternal.server.ddl.DdlGenerator.runStatements(DdlGenerator.java:

> 246)
> at
> com.avaje.ebeaninternal.server.ddl.DdlGenerator.runScript(DdlGenerator.java:
> 224)
> at
> com.avaje.ebeaninternal.server.ddl.DdlGenerator.runDdl(DdlGenerator.java:
> 93)
> at
> com.avaje.ebeaninternal.server.ddl.DdlGenerator.execute(DdlGenerator.java:
> 66)
> at

> com.avaje.ebeaninternal.server.core.DefaultServerFactory.executeDDL(DefaultServerFactory.java:
> 347)
> at
> com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
> 229)
> at
> com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:
> 123)
> at
> com.avaje.ebeaninternal.server.core.DefaultServerFactory.createServer(DefaultServerFactory.java:

> 63)
> at com.avaje.ebean.EbeanServerFactory.create(EbeanServerFactory.java:
> 64)
> at com.avaje.ebean.Ebean$ServerManager.getWithCreate(Ebean.java:225)
> at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:181)
> at com.avaje.ebean.Ebean$ServerManager.<init>(Ebean.java:147)
> at com.avaje.ebean.Ebean.<clinit>(Ebean.java:141)
> at com.example.EbeanEmployeeDao.count2(EbeanEmployeeDao.java:88)
> at com.example.EmployeeDao2Test.count2(EmployeeDao2Test.java:34)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:
> 39)
> at