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-mail: [email protected] > >
