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]
