You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by ch...@penguinfire.com on 2007/01/11 19:56:01 UTC
Jetspeed looking for UpperCase MySQL table names
Hi,
I have a machine that was using the Jetspeed 2 Portal with a local MySQL
(Windows) Database. I have now tried to get our Jetspeed 2 portal to point to
a remote MySQL (Solaris) database by changing the build.properties, building
our war file again and doing a j2:nodbQuickStart.
When i start Tomcat, i'm getting an error saying "can't find
schema.PREFS_NODE". The prefs_node table does exist in the indicated schema
but the table name is in lower case.
Any idea how to resolve this outside from somehow changing all the table names
from
lower case to upper case?
Thanks,
Charles
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Jetspeed looking for UpperCase MySQL table names
Posted by ch...@penguinfire.com.
That was exactly the problem.
Thanks!
Charles
Quoting "J.Enrique Ruiz-Valenciano" <je...@gmail.com>:
> By default, MySQL is case sensitive for databases and table names in
> *nux, but not in windows, then if you do an export from windows and an
> import in *nux, your application may not work.
>
> It is explained here:
>
> http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html
>
> One solution is to disable case sensitive in mysql by setting the
> "lower_case_table_names" variable in your mysql configuration in *nux.
> For example, in Debian based distributions, edit the file:
>
> /etc/mysql/my.cnf
>
> And add to the [mysqld] section:
>
> lower_case_table_names = 1
>
> Then, create or import your Jetspeed2 schema.
>
> > Hi,
> >
> > I have a machine that was using the Jetspeed 2 Portal with a local MySQL
> > (Windows) Database. I have now tried to get our Jetspeed 2 portal to point
> to
> > a remote MySQL (Solaris) database by changing the build.properties,
> building
> > our war file again and doing a j2:nodbQuickStart.
> >
> > When i start Tomcat, i'm getting an error saying "can't find
> > schema.PREFS_NODE". The prefs_node table does exist in the indicated
> schema
> > but the table name is in lower case.
> >
> > Any idea how to resolve this outside from somehow changing all the table
> names
> > from
> > lower case to upper case?
> >
> > Thanks,
> > Charles
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> > For additional commands, e-mail: jetspeed-user-help@portals.apache.org
> >
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org
Re: Jetspeed looking for UpperCase MySQL table names
Posted by "J.Enrique Ruiz-Valenciano" <je...@gmail.com>.
By default, MySQL is case sensitive for databases and table names in
*nux, but not in windows, then if you do an export from windows and an
import in *nux, your application may not work.
It is explained here:
http://dev.mysql.com/doc/mysql/en/name-case-sensitivity.html
One solution is to disable case sensitive in mysql by setting the
"lower_case_table_names" variable in your mysql configuration in *nux.
For example, in Debian based distributions, edit the file:
/etc/mysql/my.cnf
And add to the [mysqld] section:
lower_case_table_names = 1
Then, create or import your Jetspeed2 schema.
> Hi,
>
> I have a machine that was using the Jetspeed 2 Portal with a local MySQL
> (Windows) Database. I have now tried to get our Jetspeed 2 portal to point to
> a remote MySQL (Solaris) database by changing the build.properties, building
> our war file again and doing a j2:nodbQuickStart.
>
> When i start Tomcat, i'm getting an error saying "can't find
> schema.PREFS_NODE". The prefs_node table does exist in the indicated schema
> but the table name is in lower case.
>
> Any idea how to resolve this outside from somehow changing all the table names
> from
> lower case to upper case?
>
> Thanks,
> Charles
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org