You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@rave.apache.org by Raminderjeet Singh <ra...@gmail.com> on 2012/07/11 18:58:50 UTC
Rave on MySQL
Hi All,
Is anyone running Rave using MySQL? After following the instructions on website, rave is able to create the tables fine but its not uploading the initial data. Did anyone else faced this in past? Suggestions to populate the data?
Thanks
Raminder
Re: Rave on MySQL
Posted by Raminderjeet Singh <ra...@gmail.com>.
Yes it does.
On Jul 11, 2012, at 6:02 PM, Jasha Joachimsthal wrote:
> On 11 July 2012 23:42, Raminderjeet Singh <ra...@gmail.com> wrote:
>
>> +1 for having some JPA abstraction but that need some work and a resource.
>> Right now we can make sure we show such errors to the user. I am familiar
>> with Rave code so i knew where to debug but that may not be true for lot of
>> users. I am going to change the log message type for this one and see if i
>> can make the message obvious enough.
>>
>> I am able to solve my problem by add lower_case_table_names=1 to mysql
>> my.cnf file.
>>
>
> Does that also work for the portal preference values?
>
>
>>
>> Thanks
>> Raminder
>>
>>
>> On Jul 11, 2012, at 5:14 PM, Jasha Joachimsthal wrote:
>>
>>> On 11 July 2012 23:05, Raminderjeet Singh <ra...@gmail.com>
>> wrote:
>>>
>>>> I am able to find the problem. Looks like Rave is creating all the
>> tables
>>>> with lower case and when we query(SELECT * FROM WIDGET) to see if table
>>>> already to insert the data its returning false. Log message is of debug
>>>> level so i was not seeing any error. I changed the log level to debug to
>>>> notice this.
>>>>
>>>> I tried to change this query to lowercase but then problem is coming at
>>>> separate level now( Caused by:
>>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>>>> 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have
>> idea to
>>>> make mysql db case insensitive?
>>>>
>>>
>>> The question in this case should not be "how to fix it in MySQL", but
>> "how
>>> to make it work in any DB". Again we run into the issue of the
>>> initialization with pure SQL queries. I've installed it before in MySQL,
>>> PostgreSQL and Oracle; they all had their own issues when dealing with
>> the
>>> initial data.
>>> We should really move the essential part of the initialization (page
>>> layouts, page types, authorities etc) to some abstraction like JPA and
>>> preferably also other parts of the demo "content" like users and gadget
>>> definitions.
>>>
>>> Another one that will fail on case sensitivity are the portal preference
>>> values (already created an issue for this last month).
>>>
>>>
>>>> I am thinking of this log message level to info or warning.
>>>>
>>>> Thanks
>>>> Raminder
>>>>
>>>>
>>>> On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
>>>>
>>>>> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
>>>>> raminderjsingh@gmail.com> wrote:
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> Is anyone running Rave using MySQL? After following the instructions
>> on
>>>>>> website, rave is able to create the tables fine but its not uploading
>>>> the
>>>>>> initial data. Did anyone else faced this in past? Suggestions to
>>>> populate
>>>>>> the data?
>>>>>>
>>>>>
>>>>> We run Rave on MySQL just fine but we have a custom initial_data script
>>>> we
>>>>> use, although the standard one should work. What errors are you
>> getting?
>>>>>
>>>>>>
>>>>>> Thanks
>>>>>> Raminder
>>>>
>>>>
>>
>>
Re: Rave on MySQL
Posted by Jasha Joachimsthal <ja...@apache.org>.
On 11 July 2012 23:42, Raminderjeet Singh <ra...@gmail.com> wrote:
> +1 for having some JPA abstraction but that need some work and a resource.
> Right now we can make sure we show such errors to the user. I am familiar
> with Rave code so i knew where to debug but that may not be true for lot of
> users. I am going to change the log message type for this one and see if i
> can make the message obvious enough.
>
> I am able to solve my problem by add lower_case_table_names=1 to mysql
> my.cnf file.
>
Does that also work for the portal preference values?
>
> Thanks
> Raminder
>
>
> On Jul 11, 2012, at 5:14 PM, Jasha Joachimsthal wrote:
>
> > On 11 July 2012 23:05, Raminderjeet Singh <ra...@gmail.com>
> wrote:
> >
> >> I am able to find the problem. Looks like Rave is creating all the
> tables
> >> with lower case and when we query(SELECT * FROM WIDGET) to see if table
> >> already to insert the data its returning false. Log message is of debug
> >> level so i was not seeing any error. I changed the log level to debug to
> >> notice this.
> >>
> >> I tried to change this query to lowercase but then problem is coming at
> >> separate level now( Caused by:
> >> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> >> 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have
> idea to
> >> make mysql db case insensitive?
> >>
> >
> > The question in this case should not be "how to fix it in MySQL", but
> "how
> > to make it work in any DB". Again we run into the issue of the
> > initialization with pure SQL queries. I've installed it before in MySQL,
> > PostgreSQL and Oracle; they all had their own issues when dealing with
> the
> > initial data.
> > We should really move the essential part of the initialization (page
> > layouts, page types, authorities etc) to some abstraction like JPA and
> > preferably also other parts of the demo "content" like users and gadget
> > definitions.
> >
> > Another one that will fail on case sensitivity are the portal preference
> > values (already created an issue for this last month).
> >
> >
> >> I am thinking of this log message level to info or warning.
> >>
> >> Thanks
> >> Raminder
> >>
> >>
> >> On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
> >>
> >>> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
> >>> raminderjsingh@gmail.com> wrote:
> >>>
> >>>> Hi All,
> >>>>
> >>>> Is anyone running Rave using MySQL? After following the instructions
> on
> >>>> website, rave is able to create the tables fine but its not uploading
> >> the
> >>>> initial data. Did anyone else faced this in past? Suggestions to
> >> populate
> >>>> the data?
> >>>>
> >>>
> >>> We run Rave on MySQL just fine but we have a custom initial_data script
> >> we
> >>> use, although the standard one should work. What errors are you
> getting?
> >>>
> >>>>
> >>>> Thanks
> >>>> Raminder
> >>
> >>
>
>
Re: Rave on MySQL
Posted by Raminderjeet Singh <ra...@gmail.com>.
+1 for having some JPA abstraction but that need some work and a resource. Right now we can make sure we show such errors to the user. I am familiar with Rave code so i knew where to debug but that may not be true for lot of users. I am going to change the log message type for this one and see if i can make the message obvious enough.
I am able to solve my problem by add lower_case_table_names=1 to mysql my.cnf file.
Thanks
Raminder
On Jul 11, 2012, at 5:14 PM, Jasha Joachimsthal wrote:
> On 11 July 2012 23:05, Raminderjeet Singh <ra...@gmail.com> wrote:
>
>> I am able to find the problem. Looks like Rave is creating all the tables
>> with lower case and when we query(SELECT * FROM WIDGET) to see if table
>> already to insert the data its returning false. Log message is of debug
>> level so i was not seeing any error. I changed the log level to debug to
>> notice this.
>>
>> I tried to change this query to lowercase but then problem is coming at
>> separate level now( Caused by:
>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
>> 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have idea to
>> make mysql db case insensitive?
>>
>
> The question in this case should not be "how to fix it in MySQL", but "how
> to make it work in any DB". Again we run into the issue of the
> initialization with pure SQL queries. I've installed it before in MySQL,
> PostgreSQL and Oracle; they all had their own issues when dealing with the
> initial data.
> We should really move the essential part of the initialization (page
> layouts, page types, authorities etc) to some abstraction like JPA and
> preferably also other parts of the demo "content" like users and gadget
> definitions.
>
> Another one that will fail on case sensitivity are the portal preference
> values (already created an issue for this last month).
>
>
>> I am thinking of this log message level to info or warning.
>>
>> Thanks
>> Raminder
>>
>>
>> On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
>>
>>> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
>>> raminderjsingh@gmail.com> wrote:
>>>
>>>> Hi All,
>>>>
>>>> Is anyone running Rave using MySQL? After following the instructions on
>>>> website, rave is able to create the tables fine but its not uploading
>> the
>>>> initial data. Did anyone else faced this in past? Suggestions to
>> populate
>>>> the data?
>>>>
>>>
>>> We run Rave on MySQL just fine but we have a custom initial_data script
>> we
>>> use, although the standard one should work. What errors are you getting?
>>>
>>>>
>>>> Thanks
>>>> Raminder
>>
>>
Re: Rave on MySQL
Posted by Jasha Joachimsthal <ja...@apache.org>.
On 11 July 2012 23:05, Raminderjeet Singh <ra...@gmail.com> wrote:
> I am able to find the problem. Looks like Rave is creating all the tables
> with lower case and when we query(SELECT * FROM WIDGET) to see if table
> already to insert the data its returning false. Log message is of debug
> level so i was not seeing any error. I changed the log level to debug to
> notice this.
>
> I tried to change this query to lowercase but then problem is coming at
> separate level now( Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
> 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have idea to
> make mysql db case insensitive?
>
The question in this case should not be "how to fix it in MySQL", but "how
to make it work in any DB". Again we run into the issue of the
initialization with pure SQL queries. I've installed it before in MySQL,
PostgreSQL and Oracle; they all had their own issues when dealing with the
initial data.
We should really move the essential part of the initialization (page
layouts, page types, authorities etc) to some abstraction like JPA and
preferably also other parts of the demo "content" like users and gadget
definitions.
Another one that will fail on case sensitivity are the portal preference
values (already created an issue for this last month).
> I am thinking of this log message level to info or warning.
>
> Thanks
> Raminder
>
>
> On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
>
> > On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
> > raminderjsingh@gmail.com> wrote:
> >
> >> Hi All,
> >>
> >> Is anyone running Rave using MySQL? After following the instructions on
> >> website, rave is able to create the tables fine but its not uploading
> the
> >> initial data. Did anyone else faced this in past? Suggestions to
> populate
> >> the data?
> >>
> >
> > We run Rave on MySQL just fine but we have a custom initial_data script
> we
> > use, although the standard one should work. What errors are you getting?
> >
> >>
> >> Thanks
> >> Raminder
>
>
Re: Rave on MySQL
Posted by Raminderjeet Singh <ra...@gmail.com>.
I am able to find the problem. Looks like Rave is creating all the tables with lower case and when we query(SELECT * FROM WIDGET) to see if table already to insert the data its returning false. Log message is of debug level so i was not seeing any error. I changed the log level to debug to notice this.
I tried to change this query to lowercase but then problem is coming at separate level now( Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'rave.JPAPORTALPREFERENCE_VALUES' doesn't exist). Does anyone have idea to make mysql db case insensitive?
I am thinking of this log message level to info or warning.
Thanks
Raminder
On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
> raminderjsingh@gmail.com> wrote:
>
>> Hi All,
>>
>> Is anyone running Rave using MySQL? After following the instructions on
>> website, rave is able to create the tables fine but its not uploading the
>> initial data. Did anyone else faced this in past? Suggestions to populate
>> the data?
>>
>
> We run Rave on MySQL just fine but we have a custom initial_data script we
> use, although the standard one should work. What errors are you getting?
>
>>
>> Thanks
>> Raminder
Re: Rave on MySQL
Posted by Raminderjeet Singh <ra...@gmail.com>.
When i am starting the service no error is coming (that is the problem). Looks like DataSourcePopulator is not getting called in this case. I tried to add a info log in executeScripts method but that is not coming. i am going to try this one more time now and will let you know if i see any error.
Thanks
Raminder
On Jul 11, 2012, at 1:04 PM, Chris Geer wrote:
> On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
> raminderjsingh@gmail.com> wrote:
>
>> Hi All,
>>
>> Is anyone running Rave using MySQL? After following the instructions on
>> website, rave is able to create the tables fine but its not uploading the
>> initial data. Did anyone else faced this in past? Suggestions to populate
>> the data?
>>
>
> We run Rave on MySQL just fine but we have a custom initial_data script we
> use, although the standard one should work. What errors are you getting?
>
>>
>> Thanks
>> Raminder
Re: Rave on MySQL
Posted by Chris Geer <ch...@cxtsoftware.com>.
On Wed, Jul 11, 2012 at 9:58 AM, Raminderjeet Singh <
raminderjsingh@gmail.com> wrote:
> Hi All,
>
> Is anyone running Rave using MySQL? After following the instructions on
> website, rave is able to create the tables fine but its not uploading the
> initial data. Did anyone else faced this in past? Suggestions to populate
> the data?
>
We run Rave on MySQL just fine but we have a custom initial_data script we
use, although the standard one should work. What errors are you getting?
>
> Thanks
> Raminder