You are viewing a plain text version of this content. The canonical link for it is here.
Posted to server-dev@james.apache.org by Saibabu Vallurupalli <sa...@gmail.com> on 2011/07/17 15:29:26 UTC
MySQL configuration fails
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
Re: MySQL configuration fails
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
I have old James and data already in there. Do I have to clean it?
Thanks,
Sai
On Sun, Jul 17, 2011 at 10:34 AM, Norman Maurer <
norman.maurer@googlemail.com> 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
> <sa...@gmail.com>:
> > 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 <
> > norman.maurer@googlemail.com> 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
> >> <sa...@gmail.com>:
> >> > 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 <
> >> norman.maurer@googlemail.com
> >> >> wrote:
> >> >
> >> >> are you sure the user is allowed to create tables ?
> >> >>
> >> >> bye
> >> >> norman
> >> >>
> >> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
> >> >> <sa...@gmail.com>:
> >> >> > 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: server-dev-unsubscribe@james.apache.org
> >> >> For additional commands, e-mail: server-dev-help@james.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> >> For additional commands, e-
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: MySQL configuration fails
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
I cleaned the database and tried to start James server one more time and got
the similar error:
*************
Caused by: org.springframework.beans.factory.BeanCreationException: Error
creati
ng bean with name 'mailetcontext': Injection of resource dependencies
failed; ne
sted exception is org.springframework.beans.factory.BeanCreationException:
Error
creating bean with name 'usersrepository': Injection of resource
dependencies f
ailed; nested exception is
org.springframework.beans.factory.BeanCreationExcepti
on: Error creating bean with name 'domainlist': Invocation of init method
failed
; nested exception is <openjpa-2.1.0-r422266:1071316 nonfatal general error>
org
.apache.openjpa.persistence.PersistenceException: Can't create table
'jamesdb.#s
ql-1540_2' (errno: 150) {stmnt 754485704 ALTER TABLE JAMES_MAIL_PROPERTY ADD
FOR
EIGN KEY (MAILBOX_ID, MAIL_UID) REFERENCES JAMES_MAIL (MAILBOX_ID, MAIL_UID)
ON
DELETE CASCADE} [code=1005, state=HY000]
*************
Thanks,
Sai
On Sun, Jul 17, 2011 at 10:34 AM, Norman Maurer <
norman.maurer@googlemail.com> 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
> <sa...@gmail.com>:
> > 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 <
> > norman.maurer@googlemail.com> 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
> >> <sa...@gmail.com>:
> >> > 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 <
> >> norman.maurer@googlemail.com
> >> >> wrote:
> >> >
> >> >> are you sure the user is allowed to create tables ?
> >> >>
> >> >> bye
> >> >> norman
> >> >>
> >> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
> >> >> <sa...@gmail.com>:
> >> >> > 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: server-dev-unsubscribe@james.apache.org
> >> >> For additional commands, e-mail: server-dev-help@james.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> >> For additional commands, e-
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: MySQL configuration fails
Posted by Norman Maurer <no...@googlemail.com>.
thanks for closing the loop :)
bye
norman
Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
<sa...@gmail.com>:
> 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 <
> norman.maurer@googlemail.com> 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
>> <sa...@gmail.com>:
>> > 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 <
>> > norman.maurer@googlemail.com> 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
>> >> <sa...@gmail.com>:
>> >> > 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 <
>> >> norman.maurer@googlemail.com
>> >> >> wrote:
>> >> >
>> >> >> are you sure the user is allowed to create tables ?
>> >> >>
>> >> >> bye
>> >> >> norman
>> >> >>
>> >> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
>> >> >> <sa...@gmail.com>:
>> >> >> > 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: MySQL configuration fails
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
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 <
norman.maurer@googlemail.com> 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
> <sa...@gmail.com>:
> > 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 <
> > norman.maurer@googlemail.com> 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
> >> <sa...@gmail.com>:
> >> > 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 <
> >> norman.maurer@googlemail.com
> >> >> wrote:
> >> >
> >> >> are you sure the user is allowed to create tables ?
> >> >>
> >> >> bye
> >> >> norman
> >> >>
> >> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
> >> >> <sa...@gmail.com>:
> >> >> > 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: server-dev-unsubscribe@james.apache.org
> >> >> For additional commands, e-mail: server-dev-help@james.apache.org
> >> >>
> >> >>
> >> >
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> >> For additional commands, e-
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: MySQL configuration fails
Posted by Norman Maurer <no...@googlemail.com>.
is it a "clean" database or do you have old james tables in there ?
bye
norman
Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
<sa...@gmail.com>:
> 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 <
> norman.maurer@googlemail.com> 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
>> <sa...@gmail.com>:
>> > 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 <
>> norman.maurer@googlemail.com
>> >> wrote:
>> >
>> >> are you sure the user is allowed to create tables ?
>> >>
>> >> bye
>> >> norman
>> >>
>> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
>> >> <sa...@gmail.com>:
>> >> > 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: server-dev-unsubscribe@james.apache.org
>> >> For additional commands, e-mail: server-dev-help@james.apache.org
>> >>
>> >>
>> >
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: MySQL configuration fails
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
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 <
norman.maurer@googlemail.com> 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
> <sa...@gmail.com>:
> > 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 <
> norman.maurer@googlemail.com
> >> wrote:
> >
> >> are you sure the user is allowed to create tables ?
> >>
> >> bye
> >> norman
> >>
> >> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
> >> <sa...@gmail.com>:
> >> > 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: server-dev-unsubscribe@james.apache.org
> >> For additional commands, e-mail: server-dev-help@james.apache.org
> >>
> >>
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: MySQL configuration fails
Posted by Norman Maurer <no...@googlemail.com>.
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
<sa...@gmail.com>:
> 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 <norman.maurer@googlemail.com
>> wrote:
>
>> are you sure the user is allowed to create tables ?
>>
>> bye
>> norman
>>
>> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
>> <sa...@gmail.com>:
>> > 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: server-dev-unsubscribe@james.apache.org
>> For additional commands, e-mail: server-dev-help@james.apache.org
>>
>>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org
Re: MySQL configuration fails
Posted by Saibabu Vallurupalli <sa...@gmail.com>.
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 <norman.maurer@googlemail.com
> wrote:
> are you sure the user is allowed to create tables ?
>
> bye
> norman
>
> Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
> <sa...@gmail.com>:
> > 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: server-dev-unsubscribe@james.apache.org
> For additional commands, e-mail: server-dev-help@james.apache.org
>
>
Re: MySQL configuration fails
Posted by Norman Maurer <no...@googlemail.com>.
are you sure the user is allowed to create tables ?
bye
norman
Am Sonntag, 17. Juli 2011 schrieb Saibabu Vallurupalli
<sa...@gmail.com>:
> 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: server-dev-unsubscribe@james.apache.org
For additional commands, e-mail: server-dev-help@james.apache.org