Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Alter table doesn't find table previously created during DDL
Thank you for the prompt response.  Unfortunately your suggestions didn't resolve my issue.

I am still getting the same error after adding the properties you mentionned and adding the eclipselink provider included in the link you posted. 
[Albeit I didn't use drop-and-create-tables instead create-tables]

I am attaching persistence.xml, orm.xml and a springconfiguration file and the tomcat logs.  Would any more spring config help?  [I have it separate out by functionality]

I am using spring, jpa, tomcat.  The persistence is in one JAR file which is included in a WAR file.

Here are the relevant app logs.   

[EL Info]: 2008.09.03 09:51:12.677--ServerSession(21818125)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 1.1 (Bu
ild SNAPSHOT-20080901)
[EL Config]: 2008.09.03 09:51:13.990--ServerSession(21818125)--Connection(27554537)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>DerbyPlatform
        user name=> ""
        connector=>JNDIConnector datasource name=>null
))
[EL Config]: 2008.09.03 09:51:16.131--ServerSession(21818125)--Connection(32294581)--Thread(Thread[main,5,main])--Connected: jdbc:derby://localhost:15
27/digitalart;create=true
        User: APP
        Database: Apache Derby  Version: 10.4.1.3 - (648739)
        Driver: Apache Derby Network Client JDBC Driver  Version: 10.4.1.3 - (648739)
[EL Config]: 2008.09.03 09:51:16.131--ServerSession(21818125)--Connection(32086044)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
        platform=>DerbyPlatform
        user name=> ""
        connector=>JNDIConnector datasource name=>null
))
[EL Config]: 2008.09.03 09:51:16.131--ServerSession(21818125)--Connection(16881106)--Thread(Thread[main,5,main])--Connected: jdbc:derby://localhost:15
27/digitalart;create=true
        User: APP
        Database: Apache Derby  Version: 10.4.1.3 - (648739)
        Driver: Apache Derby Network Client JDBC Driver  Version: 10.4.1.3 - (648739)
...


[EL Fine]: 2008.09.03 09:51:18.475--ServerSession(21818125)--Connection(13065124)--Thread(Thread[main,5,main])--CREATE TABLE GROUPS_GROUPS (Group_ID B
IGINT NOT NULL, subgroups_ID BIGINT NOT NULL, PRIMARY KEY (Group_ID, subgroups_ID))

...

[EL Fine]: 2008.09.03 09:52:00.336--ServerSession(21818125)--Connection(27510707)--Thread(Thread[main,5,main])--ALTER TABLE GROUPS_GROUPS ADD CONSTRAI
NT GRUPSGROUPSGroupID FOREIGN KEY (Group_ID) REFERENCES GROUPS (ID)
[EL Fine]: 2008.09.03 09:52:00.414--ServerSession(21818125)--Thread(Thread[main,5,main])--VALUES(1)
[EL Warning]: 2008.09.03 09:52:00.492--ServerSession(21818125)--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()



On Tue, Sep 2, 2008 at 1:59 PM, <MICHAEL.OBRIEN@xxxxxxxxxx> wrote:
Eric,
    Hi, verify that both the ddl-generation and ddl-generation-output-mode elements are set in persistence.xml or you may just be generating to an sql file - I ran into this same issue recently when using this schema generation feature.
 
      <property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>
      <property name="eclipselink.ddl-generation.output-mode" value="database"/>
 
    See a recent post on this issue by Tom on this topic in Feb 2008.
 
    Also, verify that if you are running in stand-alone SE mode via transaction-type="RESOURCE-LOCAL" - the default - and not a jndi connection via "JTA" 
    - that you have specificed the target-database
 
    <property name="eclipselink.target-database" value="DerbyPlatform"/>

    Thank you
    /michael

-----Original Message-----
From: Eric Gulatee [mailto:eric.gulatee@xxxxxxxxx]
Sent: Tuesday, September 02, 2008 12:34
To: eclipselink-users@xxxxxxxxxxx
Subject: [eclipselink-users] Alter table doesn't find table previously created during DDL

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

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users


<?xml version="1.0" encoding="UTF-8" ?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence";
	version="1.0">
	<persistence-unit name="DigitalArtJPA"
		transaction-type="RESOURCE_LOCAL">
		<provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
		<properties>
			<property name="eclipselink.logging.level" value="FINEST" />
			<property name="eclipselink.ddl-generation" value="create-tables" />
			<property name="eclipselink.ddl-generation.output-mode" value="database" />
			<property name="eclipselink.target-database" value="DerbyPlatform" />
		</properties>
		<class>da.db.model.ArtCategory</class>
		<class>da.db.model.ArtMovement</class>
		<class>da.db.model.AuditLog</class>
		<class>da.db.model.Buyer</class>
		<class>da.db.model.CartItem</class>
		<class>da.db.model.Commission</class>
		<class>da.db.model.DigitalContent</class>
		<class>da.db.model.DigitalItem</class>
		<class>da.db.model.DigitalItemTag</class>
		<class>da.db.model.Forum</class>
		<class>da.db.model.Gallery</class>
		<class>da.db.model.GalleryTag</class>
		<class>da.db.model.Group</class>
		<class>da.db.model.Post</class>
		<class>da.db.model.Price</class>
		<class>da.db.model.Rating</class>
		<class>da.db.model.RatingAggregate</class>
		<class>da.db.model.RatingContainer</class>
		<class>da.db.model.RememberMe</class>
		<class>da.db.model.Seller</class>
		<class>da.db.model.User</class>
		
	</persistence-unit>
</persistence>

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm";
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
	xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd";
	version="1.0">
</entity-mappings>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans";
	xmlns:aop="http://www.springframework.org/schema/aop"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
	xmlns:context="http://www.springframework.org/schema/context";
	xsi:schemaLocation="http://www.springframework.org/schema/beans 
      http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
      
      http://www.springframework.org/schema/aop 
      http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
       http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd";>

	<bean id="jpaAdapter"
		class="org.springframework.orm.jpa.vendor.EclipseLinkJpaVendorAdapter">
		<property name="databasePlatform"
			value="org.eclipse.persistence.platform.database.DerbyPlatform" >
			</property>
			<property name="generateDdl" value="true"></property>
			<property name="showSql" value="true"></property>
	</bean>
	<bean id="jpaDialect"
		class="org.springframework.orm.jpa.vendor.EclipseLinkJpaDialect">
	</bean>
	<bean id="entityManagerFactory"
		class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
		<property name="dataSource" ref="daDataSource" />
		<property name="persistenceUnitName" value="DigitalArtJPA" />
		<property name="jpaDialect" ref="jpaDialect" />
		<property name="jpaVendorAdapter" ref="jpaAdapter" />

	</bean>
	<aop:aspectj-autoproxy />
	<context:spring-configured />
	<context:load-time-weaver weaver-class="org.springframework.instrument.classloading.ReflectiveLoadTimeWeaver" aspectj-weaving="autodetect"/>
</beans>

Attachment: localhost.2008-09-03.log
Description: Binary data

Attachment: catalina.2008-09-03.log
Description: Binary data

Back to the top