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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
