Am 03.11.2006 um 00:01 schrieb Christian Mittendorf:
Thanks to all of your for hints!
Ok, I'm now quite close to what I would like to accomplish. Except
for one Exception...
09:43:01,565 INFO [QueryLogger] *** error.
java.sql.SQLException: Unexpected token in statement [CREATE CACHED
TABLE invoices (anum VARCHAR(45) NULL, belegNummer BIGINT NOT NULL,
cid BIGINT NOT NULL, id BIGINT NOT NULL, mahnStufe INTEGER NOT NULL,
opNummer VARCHAR(45) NOT NULL, rechnungsBetrag DOUBLE(22]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
at org.objectstyle.cayenne.access.DbGenerator.safeExecute
(DbGenerator.java:399)
at org.objectstyle.cayenne.access.DbGenerator.runGenerator
(DbGenerator.java:339)
at de.freenet.cayenne.junit.DatabaseTestCase.setUpDataNodes
(DatabaseTestCase.java:66)
at de.freenet.cayenne.junit.DatabaseTestCase.setUp
(DatabaseTestCase.java:38)
at junit.framework.TestCase.runBare(TestCase.java:125)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run
(JUnit3TestReference.java:128)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run
(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
(RemoteTestRunner.java:460)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests
(RemoteTestRunner.java:673)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run
(RemoteTestRunner.java:386)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main
(RemoteTestRunner.java:196)
I've validated the cayenne project with the modeler and everything
seems to be fine. In the xml the table looks like this:
<obj-entity name="Invoices"
className="de.freenet.cayenne.bonitaet.Invoices"
dbEntityName="invoices">
<obj-attribute name="anum" type="java.lang.String" db-attribute-
path="anum"/>
<obj-attribute name="belegNummer" type="java.lang.Long" db-attribute-
path="belegNummer"/>
<obj-attribute name="cid" type="java.lang.Long" db-attribute-
path="cid"/>
<obj-attribute name="mahnStufe" type="java.lang.Integer" db-
attribute-path="mahnStufe"/>
<obj-attribute name="opNummer" type="java.lang.String" db-attribute-
path="opNummer"/>
<obj-attribute name="rechnungsBetrag" type="java.lang.Double" db-
attribute-path="rechnungsBetrag"/>
<obj-attribute name="rechnungsDatum" type="java.util.Date" db-
attribute-path="rechnungsDatum"/>
</obj-entity>
Any idea anybody?
Christian
