Hi Norman, I dropped entire schema and was able to start James properly with new schema.
Please ignore this error. Thank you, Sai On Sun, Jul 17, 2011 at 10:34 AM, Norman Maurer < [email protected]> wrote: > is it a "clean" database or do you have old james tables in there ? > > bye > norman > > Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli > <[email protected]>: > > database.properties > > ---------------------------- > > database.driverClassName=com.mysql.jdbc.Driver > > database.url=jdbc:mysql://localhost/jamesdb > > database.username=jamesuser > > database.password=jamespass > > vendorAdapter.database=MYSQL > > openjpa.streaming=false > > > > > > MySQL Connertor version: > > ------------------------------------- > > mysql-connector-java-5.1.8-bin.jar > > > > > > MySQL Server 5.1.41 Community Server TCP/IP > > > > Thanks, > > Sai > > > > > > On Sun, Jul 17, 2011 at 10:21 AM, Norman Maurer < > > [email protected]> wrote: > > > >> 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- > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
