nope.. can you show me the files content and also tell me the mysql connector version + server version?
bye norman Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli <[email protected]>: > 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] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
