thanks for closing the loop :) bye norman
Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli <[email protected]>: > 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.springfram --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
