Hi All,
Good morning.
I have successfully upgrade James from 3.0-M3-SNAPSHOT to 3.0-beta2 release.
James server start good with Derby database and it fails when I modify the
configuration to use MySQL Database.
Our current MySQL Database is setup for 3.0-M3-SNAPSHOT and I haven't done
any modifications to database and getting the error bellow:
*******************
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creati
ng bean with name 'domainlist': Invocation of init method failed; nested
excepti
on is <openjpa-2.1.0-r422266:1071316 nonfatal general error>
org.apache.openjpa.
persistence.PersistenceException: Can't create table 'jamesdb.#sql-59c_120'
(err
no: 150) {stmnt 1897775240 ALTER TABLE JAMES_MAIL_PROPERTY ADD FOREIGN KEY
(MAIL
BOX_ID, MAIL_UID) REFERENCES JAMES_MAIL (MAILBOX_ID, MAIL_UID) ON DELETE
CASCADE
} [code=1005, state=HY000]
at
org.springframework.beans.factory.annotation.InitDestroyAnnotationBea
nPostProcessor.postProcessBeforeInitialization(InitDestroyAnnotationBeanPostProc
essor.java:133)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBean
Factory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanF
actory.java:394)
*******************
Are there any database modifications I am missing? If there are
modifications where can I get the latest modified MySQL DB Script to run in
my database? Please advise.
Thank you,
Sai
