rave-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jasha Joachimsthal <ja...@apache.org>
Subject Re: Rave on MySQL
Date Wed, 11 Jul 2012 22:02:31 GMT
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
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message