rave-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raminderjeet Singh <raminderjsi...@gmail.com>
Subject Re: Rave on MySQL
Date Wed, 11 Jul 2012 23:07:09 GMT
Yes it does. 

On Jul 11, 2012, at 6:02 PM, Jasha Joachimsthal wrote:

> On 11 July 2012 23:42, Raminderjeet Singh <raminderjsingh@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 <raminderjsingh@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
>>>> 
>>>> 
>> 
>> 


Mime
View raw message