Object not found: SYSTEM_TABLE_CONSTRAINTS
Bonjour,
J'utilise HSQLDB 2.2.8 avec Unitilis 3.3 un framework de test qui utilise dbunit notament, et j'ai le message d'erreur de connection suivant :
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SYSTEM_TABLE_CONSTRAINTS
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
|
<testcase time="0.468" classname="com.example.EmployeeDao2Test" name="count2">
<error message="Error inserting test data from DbUnit dataset for method public void com.example.EmployeeDao2Test.count2() throws com.example.IEmployeeDao$DataAccessException" type="org.unitils.core.UnitilsException">org.unitils.core.UnitilsException: Error inserting test data from DbUnit dataset for method public void com.example.EmployeeDao2Test.count2() throws com.example.IEmployeeDao$DataAccessException
at org.unitils.dbunit.DbUnitModule.insertTestData(DbUnitModule.java:151)
at org.unitils.dbunit.DbUnitModule$DbUnitListener.beforeTestMethod(DbUnitModule.java:477)
at org.unitils.core.Unitils$UnitilsTestListener.beforeTestMethod(Unitils.java:242)
at org.unitils.UnitilsJUnit4TestClassRunner$CustomTestMethodRunner.executeMethodBody(UnitilsJUnit4TestClassRunner.java:207)
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)
Caused by: org.unitils.core.UnitilsException: Unable to create DbUnit dataset for file EmployeeDaoTest.findsForTitleOnly.xml
at org.unitils.dbunit.DbUnitModule.getDataSet(DbUnitModule.java:310)
at org.unitils.dbunit.DbUnitModule.getTestDataSets(DbUnitModule.java:251)
at org.unitils.dbunit.DbUnitModule.insertTestData(DbUnitModule.java:139)
... 26 more
Caused by: org.unitils.core.UnitilsException: Unable to create DbUnit dataset for input stream.
at org.unitils.dbunit.DbUnitModule.getDataSet(DbUnitModule.java:334)
at org.unitils.dbunit.DbUnitModule.getDataSet(DbUnitModule.java:307)
... 28 more
Caused by: org.unitils.core.UnitilsException: Error while updating database
at org.unitils.database.DatabaseModule.updateDatabase(DatabaseModule.java:174)
at org.unitils.database.DatabaseModule.createDataSource(DatabaseModule.java:237)
at org.unitils.database.DatabaseModule.getDataSource(DatabaseModule.java:116)
at org.unitils.dbunit.DbUnitModule.getDataSet(DbUnitModule.java:326)
... 29 more
Caused by: org.unitils.core.UnitilsException: Error while executing statement: select CONSTRAINT_NAME from INFORMATION_SCHEMA.SYSTEM_TABLE_CONSTRAINTS where CONSTRAINT_TYPE = 'FOREIGN KEY' AND TABLE_NAME = 'DB_VERSION' AND CONSTRAINT_SCHEMA = 'PUBLIC'
at org.unitils.core.dbsupport.SQLHandler.getItemsAsStringSet(SQLHandler.java:215)
at org.unitils.core.dbsupport.HsqldbDbSupport.getForeignKeyConstraintNames(HsqldbDbSupport.java:163)
at org.unitils.dbmaintainer.structure.impl.DefaultConstraintsDisabler.removeForeignKeyConstraints(DefaultConstraintsDisabler.java:70)
at org.unitils.dbmaintainer.structure.impl.DefaultConstraintsDisabler.disableConstraints(DefaultConstraintsDisabler.java:56)
at org.unitils.dbmaintainer.DBMaintainer.updateDatabase(DBMaintainer.java:207)
at org.unitils.database.DatabaseModule.updateDatabase(DatabaseModule.java:171)
... 32 more
Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: SYSTEM_TABLE_CONSTRAINTS
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source)
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at org.unitils.core.dbsupport.SQLHandler.getItemsAsStringSet(SQLHandler.java:207)
... 37 more
Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: SYSTEM_TABLE_CONSTRAINTS
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.error.Error.error(Unknown Source)
at org.hsqldb.SchemaManager.getTable(Unknown Source)
at org.hsqldb.ParserDQL.readTableName(Unknown Source)
at org.hsqldb.ParserDQL.readTableOrSubquery(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableReference(Unknown Source)
at org.hsqldb.ParserDQL.XreadFromClause(Unknown Source)
at org.hsqldb.ParserDQL.XreadTableExpression(Unknown Source)
at org.hsqldb.ParserDQL.XreadQuerySpecification(Unknown Source)
at org.hsqldb.ParserDQL.XreadSimpleTable(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryPrimary(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryTerm(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpressionBody(Unknown Source)
at org.hsqldb.ParserDQL.XreadQueryExpression(Unknown Source)
at org.hsqldb.ParserDQL.compileCursorSpecification(Unknown Source)
at org.hsqldb.ParserCommand.compilePart(Unknown Source)
at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
at org.hsqldb.Session.executeDirectStatement(Unknown Source)
at org.hsqldb.Session.execute(Unknown Source)
... 41 more
</error>
<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.
</system-err>
</testcase>
</testsuite>
ebean.properties file
## 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.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
___________________
unitilis properties file
# comments documenting these unitils configuration properties removed for
# brevity. look for commenting in unitils-default.properties in the root of the
# unitils jar if needed.
unitils.modules=database,dbunit,easymock,inject
unitils.module.hibernate.enabled=false
unitils.module.spring.enabled=false
# these placeholders are set in avaje.properties
#gere la configuration DBUNIT
database.driverClassName=org.hsqldb.jdbcDriver
database.url=jdbc:hsqldb:mem:unitils-example
database.schemaNames=PUBLIC
database.userName=SA
database.password=
database.dialect=hsqldb
# unitils will construct the test database using the ddl file found in this
# directory
dbMaintainer.fileScriptSource.scripts.location=src/main/resources
updateDataBaseSchema.enabled=true
sequenceUpdater.sequencevalue.lowestacceptable=100
dataSetStructureGenerator.xsd.dirName=src/test/resources/dataset-schema
____
DDL file
SET SCHEMA PUBLIC;
CREATE TABLE EMPLOYEES(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(20),TITLE VARCHAR(20),SALARY DOUBLE) |
Auriez vous une idee de mon soucis ?
Merci d'avance Philippe
Regards
Philippe
