Hi Norman, I just verified and jamesuser has all permissions. Is there any other configuration file other than database.properties file?
Thanks, Sai On Sun, Jul 17, 2011 at 9:38 AM, Norman Maurer <[email protected] > wrote: > 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] > >
