are you sure the user is allowed to create tables ? bye norman
Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli <[email protected]>: > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
