Hallo,
After creating the database schema I can successfully insert objects.
But if I will do the schema creation (DbGenerator.runGenerator)
after I already have some objects in the database (so the user can
change the mapping!) I will get an error [1], the mapping is in [2].
To avoid possible caching I deleted all the database, before I
overwrite the schema like:
Collection rooms = getAllRooms();
getContext().deleteObjects(rooms);
getContext().commitChanges();
Collection tis = getAllTimeIntervals();
getContext().deleteObjects(tis);
getContext().commitChanges();
Collection subjects = getAllSubjects();
getContext().deleteObjects(subjects);
getContext().getEntityResolver().clearCache();
getContext().getObjectStore().getDataRowCache().clear();
getContext().commitChanges();
The problem is (I think) that cayenne think there is a Subject with
ID = 349. But there is no subject with this ID! It WAS removed from
the database with the schemacreation and with the deleteObjects to
make it secure...
Maybe cayenne calculated an incorrect order of the statements,
because sometimes it works sometimes not?
What is wrong?
What else should I remove?
I use Cayenne 1.2.1 and derby 10.2.1.1
Thank you in advance, Peter Karich.
[1] INFO QueryLogger: INSERT INTO TIMEINTERVAL (DURATION_TIME,
ROOM_FK, START_TIME, SUBJECT_FK, TIMEINTERVAL_ID) VALUES
(?, ?, ?, ?, ?)
INFO QueryLogger: [bind: 30, 236, 427, 349, 200]
INFO QueryLogger: *** error.
java.sql.SQLException: INSERT on table 'TIMEINTERVAL' caused a
violation of foreign key constraint 'SQL061214022418000' for key
(349). The statement has been rolled back.
at
org.apache.derby.client.am.SQLExceptionFactory.getSQLException
(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException
(Unknown Source)
at
org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
org.objectstyle.cayenne.access.jdbc.BatchAction.runAsIndividualQueries
(BatchAction.java:224)
at
org.objectstyle.cayenne.access.jdbc.BatchAction.performAction
(BatchAction.java:117)
at
org.objectstyle.cayenne.access.DataNodeQueryAction.runQuery
(DataNodeQueryAction.java:95)
at org.objectstyle.cayenne.access.DataNode.performQueries
(DataNode.java:309)
at
org.objectstyle.cayenne.access.DataDomainFlushAction.runQueries
(DataDomainFlushAction.java:255)
at
org.objectstyle.cayenne.access.DataDomainFlushAction.flush
(DataDomainFlushAction.java:177)
at org.objectstyle.cayenne.access.DataDomain.onSyncFlush
(DataDomain.java:830)
at org.objectstyle.cayenne.access.DataDomain$2.transform
(DataDomain.java:801)
at
org.objectstyle.cayenne.access.DataDomain.runInTransaction
(DataDomain.java:856)
at org.objectstyle.cayenne.access.DataDomain.onSync
(DataDomain.java:798)
at org.objectstyle.cayenne.access.DataContext.flushToParent
(DataContext.java:1261)
at org.objectstyle.cayenne.access.DataContext.commitChanges
(DataContext.java:1165)
[2] <?xml version="1.0" encoding="utf-8"?>
<data-map project-version="1.1">
<property name="defaultLockType" value="optimistic"/>
<property name="defaultPackage" value="de.gstpl.data"/>
<property name="defaultSuperclass" value="Timetable"/>
<property name="clientSupported" value="true"/>
<db-entity name="DB_PROPERTIES">
<db-attribute name="DATA_MAP" type="LONGVARCHAR"
isMandatory="true"/>
<db-attribute name="DAY_DURATION" type="INTEGER"
isMandatory="true"/>
<db-attribute name="DAY_NO" type="INTEGER" isMandatory="true"/>
<db-attribute name="DAY_START" type="INTEGER"
isMandatory="true"/>
<db-attribute name="DB_PROPERTIES_ID" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
<db-attribute name="DEFAULT_ROOM_CAPACITY" type="INTEGER"
isMandatory="true"/>
<db-attribute name="LAST_MAP_UPDATE" type="DATE"
isMandatory="true"/>
<db-attribute name="MIN_TIME_INTERVAL" type="INTEGER"
isMandatory="true"/>
<db-attribute name="USEFUL_TIME_INTERVAL" type="INTEGER"
isMandatory="true"/>
<db-attribute name="VERSION" type="VARCHAR" isMandatory="true"
length="10"/>
</db-entity>
<db-entity name="GROUPY">
<db-attribute name="GROUPY_ID" type="INTEGER" isPrimaryKey="true"
isMandatory="true"/>
<db-attribute name="NAME" type="VARCHAR" isMandatory="true"
length="50"/>
</db-entity>
<db-entity name="PERSON">
<db-attribute name="LOGIN" type="VARCHAR" length="50"/>
<db-attribute name="NAME" type="VARCHAR" isMandatory="true"
length="50"/>
<db-attribute name="PERSON_ID" type="INTEGER" isPrimaryKey="true"
isMandatory="true"/>
</db-entity>
<db-entity name="PERSON_SUBJECT">
<db-attribute name="PERSON_FK" type="INTEGER"
isMandatory="true"/>
<db-attribute name="PERSON_SUBJECT_ID" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
<db-attribute name="SUBJECT_FK" type="INTEGER"
isMandatory="true"/>
</db-entity>
<db-entity name="ROOM">
<db-attribute name="CAPACITY" type="INTEGER"/>
<db-attribute name="DESCRIPTION" type="VARCHAR" length="512"/>
<db-attribute name="DISTANCE" type="INTEGER"/>
<db-attribute name="KIND_U" type="VARCHAR" length="15"/>
<db-attribute name="LOCATION_U" type="VARCHAR" length="15"/>
<db-attribute name="NAME" type="VARCHAR" isMandatory="true"
length="50"/>
<db-attribute name="ROOM_ID" type="INTEGER" isPrimaryKey="true"
isMandatory="true"/>
</db-entity>
<db-entity name="SUBJECT">
<db-attribute name="DESCRIPTION" type="VARCHAR" length="512"/>
<db-attribute name="NAME" type="VARCHAR" isMandatory="true"
length="50"/>
<db-attribute name="SEMESTER_U" type="INTEGER"/>
<db-attribute name="SUBJECT_ID" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
</db-entity>
<db-entity name="TIMEINTERVAL">
<db-attribute name="DURATION_TIME" type="INTEGER"
isMandatory="true"/>
<db-attribute name="ROOM_FK" type="INTEGER"/>
<db-attribute name="START_TIME" type="INTEGER"/>
<db-attribute name="SUBJECT_FK" type="INTEGER"/>
<db-attribute name="TIMEINTERVAL_ID" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
</db-entity>
<db-entity name="VISIBLE_TABLE">
<db-attribute name="COLUMN_NAME" type="VARCHAR"
isMandatory="true" length="50"/>
<db-attribute name="GROUP_FK" type="INTEGER"
isMandatory="true"/>
<db-attribute name="TABLE_NAME" type="VARCHAR" isMandatory="true"
length="25"/>
<db-attribute name="VISIBLE_TABLE_ID" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
</db-entity>
<obj-entity name="DBProperties"
className="de.gstpl.data.DBProperties"
clientClassName="DBProperties" lock-type="optimistic"
dbEntityName="DB_PROPERTIES">
<obj-attribute name="dataMap" type="java.lang.String" db-
attribute-path="DATA_MAP"/>
<obj-attribute name="dayDuration" type="java.lang.Integer" db-
attribute-path="DAY_DURATION"/>
<obj-attribute name="dayNo" type="java.lang.Integer" db-attribute-
path="DAY_NO"/>
<obj-attribute name="dayStart" type="java.lang.Integer" db-
attribute-path="DAY_START"/>
<obj-attribute name="defaultRoomCapacity"
type="java.lang.Integer" db-attribute-path="DEFAULT_ROOM_CAPACITY"/>
<obj-attribute name="lastMapUpdate" type="java.util.Date" db-
attribute-path="LAST_MAP_UPDATE"/>
<obj-attribute name="minTimeInterval" type="java.lang.Integer" db-
attribute-path="MIN_TIME_INTERVAL"/>
<obj-attribute name="usefulTimeInterval" type="java.lang.Integer"
db-attribute-path="USEFUL_TIME_INTERVAL"/>
<obj-attribute name="version" type="java.lang.String" db-
attribute-path="VERSION"/>
</obj-entity>
<obj-entity name="Group" className="de.gstpl.data.person.Group"
clientClassName="Group" lock-type="optimistic" dbEntityName="GROUPY">
<obj-attribute name="name" type="java.lang.String" db-attribute-
path="NAME"/>
</obj-entity>
<obj-entity name="Person" className="de.gstpl.data.Person"
clientClassName="Person" lock-type="optimistic" dbEntityName="PERSON">
<obj-attribute name="login" type="java.lang.String" db-attribute-
path="LOGIN"/>
<obj-attribute name="name" type="java.lang.String" db-attribute-
path="NAME"/>
</obj-entity>
<obj-entity name="Room" className="de.gstpl.data.Room"
clientClassName="Room" lock-type="optimistic" dbEntityName="ROOM">
<obj-attribute name="KIND_U" type="java.lang.String" db-attribute-
path="KIND_U"/>
<obj-attribute name="LOCATION_U" type="java.lang.String" db-
attribute-path="LOCATION_U"/>
<obj-attribute name="capacity" type="java.lang.Integer" db-
attribute-path="CAPACITY"/>
<obj-attribute name="description" type="java.lang.String" db-
attribute-path="DESCRIPTION"/>
<obj-attribute name="distance" type="java.lang.Integer" db-
attribute-path="DISTANCE"/>
<obj-attribute name="name" type="java.lang.String" db-attribute-
path="NAME"/>
</obj-entity>
<obj-entity name="Subject" className="de.gstpl.data.Subject"
clientClassName="Subject" lock-type="optimistic"
dbEntityName="SUBJECT">
<obj-attribute name="SEMESTER_U" type="java.lang.Integer" db-
attribute-path="SEMESTER_U"/>
<obj-attribute name="description" type="java.lang.String" db-
attribute-path="DESCRIPTION"/>
<obj-attribute name="name" type="java.lang.String" db-attribute-
path="NAME"/>
</obj-entity>
<obj-entity name="TimeInterval"
className="de.gstpl.data.TimeInterval"
clientClassName="TimeInterval" lock-type="optimistic"
dbEntityName="TIMEINTERVAL"
superClassName="de.gstpl.data.TimeableImpl">
<obj-attribute name="durationTime" type="java.lang.Integer" db-
attribute-path="DURATION_TIME"/>
<obj-attribute name="startTime" type="java.lang.Integer" db-
attribute-path="START_TIME"/>
</obj-entity>
<obj-entity name="VisibleTable"
className="de.gstpl.data.person.VisibleTable" lock-
type="optimistic" dbEntityName="VISIBLE_TABLE">
<obj-attribute name="columnName" type="java.lang.String" db-
attribute-path="COLUMN_NAME"/>
<obj-attribute name="tableName" type="java.lang.String" db-
attribute-path="TABLE_NAME"/>
</obj-entity>
<db-relationship name="visibleTables" source="GROUPY"
target="VISIBLE_TABLE" toMany="true">
<db-attribute-pair source="GROUPY_ID" target="GROUP_FK"/>
</db-relationship>
<db-relationship name="timeables" source="PERSON"
target="PERSON_SUBJECT" toMany="true">
<db-attribute-pair source="PERSON_ID" target="PERSON_FK"/>
</db-relationship>
<db-relationship name="person" source="PERSON_SUBJECT"
target="PERSON" toMany="false">
<db-attribute-pair source="PERSON_FK" target="PERSON_ID"/>
</db-relationship>
<db-relationship name="subject" source="PERSON_SUBJECT"
target="SUBJECT" toMany="false">
<db-attribute-pair source="SUBJECT_FK" target="SUBJECT_ID"/>
</db-relationship>
<db-relationship name="timeables" source="ROOM"
target="TIMEINTERVAL" toMany="true">
<db-attribute-pair source="ROOM_ID" target="ROOM_FK"/>
</db-relationship>
<db-relationship name="persons" source="SUBJECT"
target="PERSON_SUBJECT" toMany="true">
<db-attribute-pair source="SUBJECT_ID" target="SUBJECT_FK"/>
</db-relationship>
<db-relationship name="timeables" source="SUBJECT"
target="TIMEINTERVAL" toMany="true">
<db-attribute-pair source="SUBJECT_ID" target="SUBJECT_FK"/>
</db-relationship>
<db-relationship name="room" source="TIMEINTERVAL" target="ROOM"
toMany="false">
<db-attribute-pair source="ROOM_FK" target="ROOM_ID"/>
</db-relationship>
<db-relationship name="subject" source="TIMEINTERVAL"
target="SUBJECT" toMany="false">
<db-attribute-pair source="SUBJECT_FK" target="SUBJECT_ID"/>
</db-relationship>
<db-relationship name="group" source="VISIBLE_TABLE"
target="GROUPY" toMany="false">
<db-attribute-pair source="GROUP_FK" target="GROUPY_ID"/>
</db-relationship>
<obj-relationship name="visibleTables" source="Group"
target="VisibleTable" deleteRule="Cascade" db-relationship-
path="visibleTables"/>
<obj-relationship name="timeables" source="Person"
target="Subject" deleteRule="Nullify" db-relationship-
path="timeables.subject"/>
<obj-relationship name="timeables" source="Room"
target="TimeInterval" deleteRule="Nullify" db-relationship-
path="timeables"/>
<obj-relationship name="persons" source="Subject" target="Person"
deleteRule="Nullify" db-relationship-path="persons.person"/>
<obj-relationship name="timeables" source="Subject"
target="TimeInterval" deleteRule="Cascade" db-relationship-
path="timeables"/>
<obj-relationship name="room" source="TimeInterval" target="Room"
deleteRule="Nullify" db-relationship-path="room"/>
<obj-relationship name="subject" source="TimeInterval"
target="Subject" deleteRule="Nullify" db-relationship-path="subject"/>
<obj-relationship name="group" source="VisibleTable"
target="Group" deleteRule="Nullify" db-relationship-path="group"/>
<query name="Delete"
factory="org.objectstyle.cayenne.map.SQLTemplateBuilder" root="data-
map" root-name="GSTPL">
<property name="cayenne.GenericSelectQuery.fetchingDataRows"
value="true"/>
<sql><![CDATA[delete from $table]]></sql>
</query>
<query name="GetColumnNames"
factory="org.objectstyle.cayenne.map.SQLTemplateBuilder" root="data-
map" root-name="GSTPL">
<property name="cayenne.GenericSelectQuery.fetchingDataRows"
value="true"/>
<sql><![CDATA[select * from $table where 1=2]]></sql>
</query>
<query name="GetTI"
factory="org.objectstyle.cayenne.map.SQLTemplateBuilder" root="obj-
entity" root-name="TimeInterval">
<sql><![CDATA[select * from TIMEINTERVAL where
START_TIME = $start and
DURATION_TIME = $duration and
ROOM_ID = $roomId and
SUBJECT_ID = $subjectId]]></sql>
</query>
<query name="SelectTable"
factory="org.objectstyle.cayenne.map.SQLTemplateBuilder" root="data-
map" root-name="GSTPL">
<property name="cayenne.GenericSelectQuery.fetchingDataRows"
value="true"/>
<sql><![CDATA[select * from $table]]></sql>
</query>
<query name="SetSchema"
factory="org.objectstyle.cayenne.map.SQLTemplateBuilder" root="data-
map" root-name="GSTPL">
<property name="cayenne.GenericSelectQuery.fetchingDataRows"
value="true"/>
<sql><![CDATA[set schema $schemaName]]></sql>
</query>
</data-map>
___________________________________________________________ Der
frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo!
Mail: http://mail.yahoo.de
