All,
I am have the following problem after migrating from
hibernate to eclipselink.
I am using
derby network server,
spring,
jpa.Either version of eclipselink 1.1 (Snapshot or
1.1-M1) exhibit the problem.
Basically the DDL creates a table.
Then when it tries to add constraints etc, it fails out not finding the
table. I connected to the DB and indeed, none of the tables are
there. [I am guessing due to a failure, it rollsback]
However I do find two connections(With different ids.)
Why are there two connections being make for DDL generation? Is this the
cause of the problem? Any way to disable this?
Any
insights? Any advice on how to debug/fix this would be
appreciated.
Cheers,
Eric Gulatee
[EL Fine]: 2008.09.02
12:06:28.546--ServerSession(30398855)--Connection(623145)--Thread(Thread[main,5,main])--CREATE
TABLE SELLER (ID BIGINT NOT NULL,
COMMISSIONABLE SMALLINT DEFAULT 0,
USER_ID BIGINT, PRIMARY KEY (ID))
....
[EL Fine]:
2008.09.02
12:06:41.142--ServerSession(30398855)--Connection(21997319)--Thread(Thread[main,5,main])--ALTER
TABLE SELLER ADD CONSTRAINT FK_S
ELLER_USER_ID FOREIGN KEY (USER_ID)
REFERENCES USERS (ID)
[EL Fine]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'SELLER' because it does not exist.
Error Code:
-1
[EL Info]: 2008.09.02
12:06:22.513--ServerSession(30398855)--Thread(Thread[main,5,main])--EclipseLink,
version: Eclipse Persistence Services - 1.1 (Bu
ild
SNAPSHOT-20080901)
[EL Config]: 2008.09.02
12:06:23.154--ServerSession(30398855)--Connection(13540744)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>DerbyPlatform
user
name=> ""
connector=>JNDIConnector datasource name=>null
))
[EL Config]:
2008.09.02
12:06:25.920--ServerSession(30398855)--Connection(11291231)--Thread(Thread[main,5,main])--Connected:
jdbc:derby://localhost:15
27/digitalart;create=true
User: APP
Database: Apache
Derby Version:
10.3.2.1 -
(599110)
Driver: Apache Derby
Network Client JDBC Driver Version:
10.4.1.3 - (648739)
[EL Config]: 2008.09.02
12:06:25.920--ServerSession(30398855)--Connection(21408383)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
platform=>DerbyPlatform
user
name=> ""
connector=>JNDIConnector datasource name=>null
))
[EL Config]:
2008.09.02
12:06:25.920--ServerSession(30398855)--Connection(6529416)--Thread(Thread[main,5,main])--Connected:
jdbc:derby://localhost:152
7/digitalart;create=true
User: APP
Database: Apache
Derby Version:
10.3.2.1 -
(599110)
Driver: Apache Derby
Network Client JDBC Driver Version:
10.4.1.3 - (648739)
[EL Info]: 2008.09.02
12:06:26.045--ServerSession(30398855)--Thread(Thread[main,5,main])--file:/C:/development/apache-tomcat-6.0.14/webapps/DigitalArt
Web/WEB-INF/lib/da-db-0.0.1-SNAPSHOT.jar-DigitalArtJPA
login successful
[EL Fine]: 2008.09.02
12:06:26.201--ServerSession(30398855)--Connection(30135567)--Thread(Thread[main,5,main])--CREATE
TABLE AUDITLOG (ID BIGINT NOT N
ULL, USERNAME VARCHAR(255), SESSIONID
VARCHAR(255), ACTION VARCHAR(255), MESSAGE VARCHAR(255), IP VARCHAR(255),
USERAGENT VARCHAR(255), TIMESTAMP TIME
STAMP, PRIMARY KEY (ID))
[EL
Fine]: 2008.09.02
12:06:26.905--ServerSession(30398855)--Connection(12668444)--Thread(Thread[main,5,main])--CREATE
TABLE PRICE (ID BIGINT NOT NULL
, CURRENCY VARCHAR(255), PRICE FLOAT,
PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:27.889--ServerSession(30398855)--Connection(8099005)--Thread(Thread[main,5,main])--CREATE
TABLE GROUPS_GROUPS (Group_ID BI
GINT NOT NULL, subgroups_ID BIGINT NOT
NULL, PRIMARY KEY (Group_ID, subgroups_ID))
[EL Fine]: 2008.09.02
12:06:28.546--ServerSession(30398855)--Connection(623145)--Thread(Thread[main,5,main])--CREATE
TABLE SELLER (ID BIGINT NOT NULL,
COMMISSIONABLE SMALLINT DEFAULT 0,
USER_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:29.312--ServerSession(30398855)--Connection(28761926)--Thread(Thread[main,5,main])--CREATE
TABLE GROUPS_USERS (groups_ID B
IGINT NOT NULL, users_ID BIGINT NOT NULL,
PRIMARY KEY (groups_ID, users_ID))
[EL Fine]: 2008.09.02
12:06:29.796--ServerSession(30398855)--Connection(15983101)--Thread(Thread[main,5,main])--CREATE
TABLE GALLERY (ID BIGINT NOT NU
LL, NAME VARCHAR(255), OWNER_ID BIGINT,
PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:30.156--ServerSession(30398855)--Connection(3328477)--Thread(Thread[main,5,main])--CREATE
TABLE DIGITALITEM_DIGITALCONTENT
(DigitalItem_ID BIGINT NOT NULL,
publicimages_ID BIGINT NOT NULL, PRIMARY KEY (DigitalItem_ID,
publicimages_ID))
[EL Fine]: 2008.09.02
12:06:30.609--ServerSession(30398855)--Connection(18482955)--Thread(Thread[main,5,main])--CREATE
TABLE SELLER_DIGITALITEM (Selle
r_ID BIGINT NOT NULL, images_ID BIGINT NOT
NULL, PRIMARY KEY (Seller_ID, images_ID))
[EL Fine]: 2008.09.02
12:06:31.406--ServerSession(30398855)--Connection(12566875)--Thread(Thread[main,5,main])--CREATE
TABLE USERS (ID BIGINT NOT NULL
, PASSWORD VARCHAR(255), USERNAME
VARCHAR(255), EMAIL VARCHAR(255), FIRSTNAME VARCHAR(255), LASTNAME
VARCHAR(255), LOCKED SMALLINT DEFAULT 0, PRIMARY
KEY (ID))
[EL Fine]:
2008.09.02
12:06:32.031--ServerSession(30398855)--Connection(12675504)--Thread(Thread[main,5,main])--CREATE
TABLE RATINGAGGREGATE (ID BIGIN
T NOT NULL, NUMBEROFRATINGS BIGINT,
SUMOFRATINGS BIGINT, RATING FLOAT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:32.406--ServerSession(30398855)--Connection(33243950)--Thread(Thread[main,5,main])--CREATE
TABLE DIGITALCONTENT (ID BIGINT
NOT NULL, CONTENT BLOB(64000), NAME
VARCHAR(255), MIMETYPE VARCHAR(255), CREATIONDATE TIMESTAMP, DIGITALITEM_ID
BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:32.922--ServerSession(30398855)--Connection(30848762)--Thread(Thread[main,5,main])--CREATE
TABLE ARTMOVEMENT (ID BIGINT NO
T NULL, NAME VARCHAR(255), CATEGORY_ID
BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:33.297--ServerSession(30398855)--Connection(32164457)--Thread(Thread[main,5,main])--CREATE
TABLE SELLER_COMMISSION (Seller
_ID BIGINT NOT NULL, commissions_ID BIGINT
NOT NULL, PRIMARY KEY (Seller_ID, commissions_ID))
[EL Fine]: 2008.09.02
12:06:33.750--ServerSession(30398855)--Connection(26854007)--Thread(Thread[main,5,main])--CREATE
TABLE GROUPS (ID BIGINT NOT NUL
L, NAME VARCHAR(255), PRIMARY KEY
(ID))
[EL Fine]: 2008.09.02
12:06:34.094--ServerSession(30398855)--Connection(33019339)--Thread(Thread[main,5,main])--CREATE
TABLE FORUM_POST (Forum_ID BIGI
NT NOT NULL, post_ID BIGINT NOT NULL,
PRIMARY KEY (Forum_ID, post_ID))
[EL Fine]: 2008.09.02
12:06:34.454--ServerSession(30398855)--Connection(13533811)--Thread(Thread[main,5,main])--CREATE
TABLE DIGITALITEMTAG (ID BIGINT
NOT NULL, TAGVALUE VARCHAR(255),
ITEM_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:34.860--ServerSession(30398855)--Connection(5164432)--Thread(Thread[main,5,main])--CREATE
TABLE POST_POST (Post_ID BIGINT
NOT NULL, childPosts_ID BIGINT NOT NULL,
PRIMARY KEY (Post_ID, childPosts_ID))
[EL Fine]: 2008.09.02
12:06:35.188--ServerSession(30398855)--Connection(16982935)--Thread(Thread[main,5,main])--CREATE
TABLE ARTCATEGORY (ID BIGINT NO
T NULL, NAME VARCHAR(255), PRIMARY KEY
(ID))
[EL Fine]: 2008.09.02
12:06:35.673--ServerSession(30398855)--Connection(13363913)--Thread(Thread[main,5,main])--CREATE
TABLE COMMISSION_SELLER (FK_COM
MISSION_ID BIGINT NOT NULL, FK_USER_ID
BIGINT NOT NULL, PRIMARY KEY (FK_COMMISSION_ID, FK_USER_ID))
[EL Fine]:
2008.09.02
12:06:36.094--ServerSession(30398855)--Connection(29576068)--Thread(Thread[main,5,main])--CREATE
TABLE COMMISSION (ID BIGINT NOT
NULL, FORUM_ID BIGINT, BUYER_ID
BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:36.470--ServerSession(30398855)--Connection(8949509)--Thread(Thread[main,5,main])--CREATE
TABLE CARTITEM (ID BIGINT NOT NU
LL, CREATIONDATE TIMESTAMP, QUANTITY
INTEGER, USER_ID BIGINT, IMAGE_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]:
2008.09.02
12:06:36.923--ServerSession(30398855)--Connection(26414956)--Thread(Thread[main,5,main])--CREATE
TABLE DIGITALITEM (ID BIGINT NO
T NULL, NAME VARCHAR(255), DESCRIPTION
VARCHAR(255), CREATIONDATE TIMESTAMP, GALLERY_ID BIGINT, SELLER_ID BIGINT,
PRICE_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:37.329--ServerSession(30398855)--Connection(16796086)--Thread(Thread[main,5,main])--CREATE
TABLE SELLER_GALLERY (Seller_ID
BIGINT NOT NULL, galleries_ID BIGINT
NOT NULL, PRIMARY KEY (Seller_ID, galleries_ID))
[EL Fine]: 2008.09.02
12:06:37.767--ServerSession(30398855)--Connection(21687596)--Thread(Thread[main,5,main])--CREATE
TABLE POST (ID BIGINT NOT NULL,
CREATIONTIME TIMESTAMP, MESSAGE
VARCHAR(255), MODIFICATIONTIME TIMESTAMP, TITLE VARCHAR(255), CREATEDBY_ID
BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:38.095--ServerSession(30398855)--Connection(2816958)--Thread(Thread[main,5,main])--CREATE
TABLE ARTCATEGORY_ARTMOVEMENT (A
rtCategory_ID BIGINT NOT NULL,
movements_ID BIGINT NOT NULL, PRIMARY KEY (ArtCategory_ID,
movements_ID))
[EL Fine]: 2008.09.02
12:06:38.470--ServerSession(30398855)--Connection(31403932)--Thread(Thread[main,5,main])--CREATE
TABLE BUYER (ID BIGINT NOT NULL
, USER_ID BIGINT, PRIMARY KEY (ID))
[EL
Fine]: 2008.09.02
12:06:38.876--ServerSession(30398855)--Connection(6476609)--Thread(Thread[main,5,main])--CREATE
TABLE RATINGCONTAINER (ID BIGINT
NOT NULL, SELLER_ID BIGINT, IMAGE_ID
BIGINT, GALLERY_ID BIGINT, AGGREGATERATING_ID BIGINT, PRIMARY KEY (ID))
[EL
Fine]: 2008.09.02
12:06:39.204--ServerSession(30398855)--Connection(4731775)--Thread(Thread[main,5,main])--CREATE
TABLE COMMISSION_MOVEMENT (Commi
ssion_ID BIGINT NOT NULL, movements_ID
BIGINT NOT NULL, PRIMARY KEY (Commission_ID, movements_ID))
[EL Fine]:
2008.09.02
12:06:39.689--ServerSession(30398855)--Connection(11388872)--Thread(Thread[main,5,main])--CREATE
TABLE GALLERYTAG (ID BIGINT NOT
NULL, TAGVALUE VARCHAR(255),
GALLERY_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:40.048--ServerSession(30398855)--Connection(17305916)--Thread(Thread[main,5,main])--CREATE
TABLE REMEMBERME (ID BIGINT NOT
NULL, TOKEN VARCHAR(255), USER_ID
BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:40.345--ServerSession(30398855)--Connection(11467066)--Thread(Thread[main,5,main])--CREATE
TABLE RATING (ID BIGINT NOT NUL
L, VALUE INTEGER, USERWHOVOTED_ID BIGINT,
CONTAINER_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:40.689--ServerSession(30398855)--Connection(25927388)--Thread(Thread[main,5,main])--CREATE
TABLE FORUM (ID BIGINT NOT NULL
, NAME VARCHAR(255), GALLERY_ID BIGINT,
IMAGE_ID BIGINT, PRIMARY KEY (ID))
[EL Fine]: 2008.09.02
12:06:41.048--ServerSession(30398855)--Connection(29333335)--Thread(Thread[main,5,main])--ALTER
TABLE GROUPS_GROUPS ADD CONSTRAI
NT GRUPSGROUPSGroupID FOREIGN KEY
(Group_ID) REFERENCES GROUPS (ID)
[EL Fine]: 2008.09.02
12:06:41.080--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'GROUPS_GROUPS' because it does not exist.
Error Code: -1
Call: ALTER
TABLE GROUPS_GROUPS ADD CONSTRAINT GRUPSGROUPSGroupID FOREIGN KEY (Group_ID)
REFERENCES GROUPS (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Connection(21997319)--Thread(Thread[main,5,main])--ALTER
TABLE SELLER ADD CONSTRAINT FK_S
ELLER_USER_ID FOREIGN KEY (USER_ID)
REFERENCES USERS (ID)
[EL Fine]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'SELLER' because it does not exist.
Error Code: -1
Call: ALTER TABLE
SELLER ADD CONSTRAINT FK_SELLER_USER_ID FOREIGN KEY (USER_ID) REFERENCES USERS
(ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.142--ServerSession(30398855)--Connection(6638311)--Thread(Thread[main,5,main])--ALTER
TABLE GROUPS_USERS ADD CONSTRAINT
GROUPSUSERSusersID FOREIGN KEY
(users_ID) REFERENCES USERS (ID)
[EL Fine]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'GROUPS_USERS' because it does not exist.
Error Code: -1
Call: ALTER
TABLE GROUPS_USERS ADD CONSTRAINT GROUPSUSERSusersID FOREIGN KEY (users_ID)
REFERENCES USERS (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Connection(9777260)--Thread(Thread[main,5,main])--ALTER
TABLE GALLERY ADD CONSTRAINT GALL
ERY_OWNER_ID FOREIGN KEY (OWNER_ID)
REFERENCES SELLER (ID)
[EL Fine]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'GALLERY' because it does not exist.
Error Code: -1
Call: ALTER TABLE
GALLERY ADD CONSTRAINT GALLERY_OWNER_ID FOREIGN KEY (OWNER_ID) REFERENCES
SELLER (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.158--ServerSession(30398855)--Connection(26316652)--Thread(Thread[main,5,main])--ALTER
TABLE DIGITALITEM_DIGITALCONTENT
ADD CONSTRAINT DGTLTMDGTLCDgtltmD
FOREIGN KEY (DigitalItem_ID) REFERENCES DIGITALITEM (ID)
[EL Fine]:
2008.09.02
12:06:41.173--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'DIGITALITEM_DIGITALCONTENT' because it does not exist.
Error Code:
-1
Call: ALTER TABLE DIGITALITEM_DIGITALCONTENT ADD CONSTRAINT
DGTLTMDGTLCDgtltmD FOREIGN KEY (DigitalItem_ID) REFERENCES DIGITALITEM
(ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Connection(3128787)--Thread(Thread[main,5,main])--ALTER
TABLE SELLER_DIGITALITEM ADD CONS
TRAINT SLLRDGITALITEMmgsD FOREIGN KEY
(images_ID) REFERENCES DIGITALITEM (ID)
[EL Fine]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'SELLER_DIGITALITEM' because it does not exist.
Error Code: -1
Call:
ALTER TABLE SELLER_DIGITALITEM ADD CONSTRAINT SLLRDGITALITEMmgsD FOREIGN KEY
(images_ID) REFERENCES DIGITALITEM (ID)
Query: DataModifyQuery()
[EL
Fine]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Connection(21572862)--Thread(Thread[main,5,main])--ALTER
TABLE DIGITALCONTENT ADD CONSTRA
INT DGTLCNTENTDGTLTMID FOREIGN KEY
(DIGITALITEM_ID) REFERENCES DIGITALITEM (ID)
[EL Fine]: 2008.09.02
12:06:41.173--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'DIGITALCONTENT' because it does not exist.
Error Code: -1
Call: ALTER
TABLE DIGITALCONTENT ADD CONSTRAINT DGTLCNTENTDGTLTMID FOREIGN KEY
(DIGITALITEM_ID) REFERENCES DIGITALITEM (ID)
Query:
DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Connection(5122103)--Thread(Thread[main,5,main])--ALTER
TABLE ARTMOVEMENT ADD CONSTRAINT
RTMOVEMENTCTGORYID FOREIGN KEY
(CATEGORY_ID) REFERENCES ARTCATEGORY (ID)
[EL Fine]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'ARTMOVEMENT' because it does not exist.
Error Code: -1
Call: ALTER
TABLE ARTMOVEMENT ADD CONSTRAINT RTMOVEMENTCTGORYID FOREIGN KEY (CATEGORY_ID)
REFERENCES ARTCATEGORY (ID)
Query: DataModifyQuery()
[EL Fine]:
2008.09.02
12:06:41.189--ServerSession(30398855)--Connection(31124738)--Thread(Thread[main,5,main])--ALTER
TABLE SELLER_COMMISSION ADD CONS
TRAINT SLLRCMMISSIONSllrD FOREIGN KEY
(Seller_ID) REFERENCES SELLER (ID)
[EL Fine]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.189--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'SELLER_COMMISSION' because it does not exist.
Error Code: -1
Call:
ALTER TABLE SELLER_COMMISSION ADD CONSTRAINT SLLRCMMISSIONSllrD FOREIGN KEY
(Seller_ID) REFERENCES SELLER (ID)
Query: DataModifyQuery()
[EL Fine]:
2008.09.02
12:06:41.205--ServerSession(30398855)--Connection(6874745)--Thread(Thread[main,5,main])--ALTER
TABLE FORUM_POST ADD CONSTRAINT F
ORUM_POSTForum_ID FOREIGN KEY (Forum_ID)
REFERENCES FORUM (ID)
[EL Fine]: 2008.09.02
12:06:41.205--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.205--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'FORUM_POST' because it does not exist.
Error Code: -1
Call: ALTER TABLE
FORUM_POST ADD CONSTRAINT FORUM_POSTForum_ID FOREIGN KEY (Forum_ID) REFERENCES
FORUM (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.205--ServerSession(30398855)--Connection(31169359)--Thread(Thread[main,5,main])--ALTER
TABLE DIGITALITEMTAG ADD CONSTRA
INT DGITALITEMTAGTEMID FOREIGN KEY
(ITEM_ID) REFERENCES DIGITALITEM (ID)
[EL Fine]: 2008.09.02
12:06:41.205--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.205--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'DIGITALITEMTAG' because it does not exist.
Error Code: -1
Call: ALTER
TABLE DIGITALITEMTAG ADD CONSTRAINT DGITALITEMTAGTEMID FOREIGN KEY (ITEM_ID)
REFERENCES DIGITALITEM (ID)
Query: DataModifyQuery()
[EL Fine]:
2008.09.02
12:06:41.205--ServerSession(30398855)--Connection(3695891)--Thread(Thread[main,5,main])--ALTER
TABLE POST_POST ADD CONSTRAINT PO
ST_POST_Post_ID FOREIGN KEY (Post_ID)
REFERENCES POST (ID)
[EL Fine]: 2008.09.02
12:06:41.220--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.220--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'POST_POST' because it does not exist.
Error Code: -1
Call: ALTER TABLE
POST_POST ADD CONSTRAINT POST_POST_Post_ID FOREIGN KEY (Post_ID) REFERENCES
POST (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.220--ServerSession(30398855)--Connection(479186)--Thread(Thread[main,5,main])--ALTER
TABLE COMMISSION_SELLER ADD CONSTR
AINT CMMSSONSELLERFKSRD FOREIGN KEY
(FK_USER_ID) REFERENCES SELLER (ID)
[EL Fine]: 2008.09.02
12:06:41.220--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.220--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'COMMISSION_SELLER' because it does not exist.
Error Code: -1
Call:
ALTER TABLE COMMISSION_SELLER ADD CONSTRAINT CMMSSONSELLERFKSRD FOREIGN KEY
(FK_USER_ID) REFERENCES SELLER (ID)
Query: DataModifyQuery()
[EL Fine]:
2008.09.02
12:06:41.220--ServerSession(30398855)--Connection(30193051)--Thread(Thread[main,5,main])--ALTER
TABLE COMMISSION ADD CONSTRAINT
COMMISSIONBUYER_ID FOREIGN KEY (BUYER_ID)
REFERENCES BUYER (ID)
[EL Fine]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'COMMISSION' because it does not exist.
Error Code: -1
Call: ALTER TABLE
COMMISSION ADD CONSTRAINT COMMISSIONBUYER_ID FOREIGN KEY (BUYER_ID) REFERENCES
BUYER (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Connection(32961489)--Thread(Thread[main,5,main])--ALTER
TABLE CARTITEM ADD CONSTRAINT CA
RTITEM_USER_ID FOREIGN KEY (USER_ID)
REFERENCES USERS (ID)
[EL Fine]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'CARTITEM' because it does not exist.
Error Code: -1
Call: ALTER TABLE
CARTITEM ADD CONSTRAINT CARTITEM_USER_ID FOREIGN KEY (USER_ID) REFERENCES
USERS (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.236--ServerSession(30398855)--Connection(17512901)--Thread(Thread[main,5,main])--ALTER
TABLE DIGITALITEM ADD CONSTRAINT
DIGITALITEMPRICEID FOREIGN KEY
(PRICE_ID) REFERENCES PRICE (ID)
[EL Fine]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'DIGITALITEM' because it does not exist.
Error Code: -1
Call: ALTER
TABLE DIGITALITEM ADD CONSTRAINT DIGITALITEMPRICEID FOREIGN KEY (PRICE_ID)
REFERENCES PRICE (ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Connection(11448605)--Thread(Thread[main,5,main])--ALTER
TABLE SELLER_GALLERY ADD CONSTRA
INT SLLRGLLERYgllresID FOREIGN KEY
(galleries_ID) REFERENCES GALLERY (ID)
[EL Fine]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'SELLER_GALLERY' because it does not exist.
Error Code: -1
Call: ALTER
TABLE SELLER_GALLERY ADD CONSTRAINT SLLRGLLERYgllresID FOREIGN KEY
(galleries_ID) REFERENCES GALLERY (ID)
Query: DataModifyQuery()
[EL
Fine]: 2008.09.02
12:06:41.252--ServerSession(30398855)--Connection(2232367)--Thread(Thread[main,5,main])--ALTER
TABLE POST ADD CONSTRAINT POST_CR
EATEDBY_ID FOREIGN KEY (CREATEDBY_ID)
REFERENCES USERS (ID)
[EL Fine]: 2008.09.02
12:06:41.267--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.267--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on 'POST'
because it does not exist.
Error Code: -1
Call: ALTER TABLE POST ADD
CONSTRAINT POST_CREATEDBY_ID FOREIGN KEY (CREATEDBY_ID) REFERENCES USERS
(ID)
Query: DataModifyQuery()
[EL Fine]: 2008.09.02
12:06:41.267--ServerSession(30398855)--Connection(6806619)--Thread(Thread[main,5,main])--ALTER
TABLE ARTCATEGORY_ARTMOVEMENT ADD
CONSTRAINT RTCTGRYRTMVmvmntsD
FOREIGN KEY (movements_ID) REFERENCES ARTMOVEMENT (ID)
[EL Fine]:
2008.09.02
12:06:41.267--ServerSession(30398855)--Thread(Thread[main,5,main])--VALUES(1)
[EL
Warning]: 2008.09.02
12:06:41.267--ServerSession(30398855)--Thread(Thread[main,5,main])--Exception
[EclipseLink-4002] (Eclipse Persistence Service
s - 1.1 (Build
SNAPSHOT-20080901)):
org.eclipse.persistence.exceptions.DatabaseException
Internal Exception:
java.sql.SQLSyntaxErrorException: 'ALTER TABLE' cannot be performed on
'ARTCATEGORY_ARTMOVEMENT' because it does not exist.
Error Code:
-1