Hi,
I use Unitilis with HSQLDB 1.8 and ORM EBEAN and i have following error message
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.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99) at org.unitils.UnitilsJUnit4TestClassRunner$CustomTestMethodRunner.executeMethodBody(UnitilsJUnit4TestClassRunner.java:208) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66) at org.unitils.UnitilsJUnit4TestClassRunner$CustomTestClassMethodsRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:141) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35) at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52) at org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:84) 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.TestMethodRunner.executeMethodBody(TestMethodRunner.java:99) at org.unitils.UnitilsJUnit4TestClassRunner$CustomTestMethodRunner.executeMethodBody(UnitilsJUnit4TestClassRunner.java:208) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java:81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java:75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java:45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java:66) at org.unitils.UnitilsJUnit4TestClassRunner$CustomTestClassMethodsRunner.invokeTestMethod(UnitilsJUnit4TestClassRunner.java:141) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java:35) at org.junit.internal.runners.TestClassRunner$1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java:34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java:52) at org.unitils.UnitilsJUnit4TestClassRunner.run(UnitilsJUnit4TestClassRunner.java:84) 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) 8 juil. 2012 19:44:42 com.avaje.ebeaninternal.server.transaction.log.FileTransactionLoggerWrapper initialiseLogger INFO: Transaction logs in: logs
Where is my mistake ? Regards Philippe
Anonymous
You seem to have CSS turned off. Please don't fill out this field.
I don't think this has anything to do with Unitils Looking at the stack-trace I think it's more related to com.avaje DdlGenerator
grtz, Tim
Hi,
I use Unitilis with HSQLDB 1.8 and ORM EBEAN and i have following error message
Where is my mistake ?
Regards
Philippe
I don't think this has anything to do with Unitils
Looking at the stack-trace I think it's more related to com.avaje DdlGenerator
grtz,
Tim