That was exactly the problem. Thanks!
Charles Quoting "J.Enrique Ruiz-Valenciano" <[EMAIL PROTECTED]>: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
