[daisy] Error: Table JBPM_JOB does not exist

[Karel Vervaeke]

Piping the output of this program to mysql should do it (untested, check output first ;-))

mysql daisydev_repository -u root -e "show tables like 'jbpm%'" -N|gawk '{ print "alter table "$0" rename to "toupper($0) };'

Regards,
Karel

On Wed, 2008-04-02 at 15:42 -0700, Lou Parisi wrote:
> I figured out what is causing the issue but not sure why or how to fix it.
> 
> I am getting a sql error for JBPM_JOB does not exist because of table name
> case sensitivity.  I suspect this is a result of restoring the database on
> Linux environment from a Windows environment when daisy was moved from
> Windows to Linux.  I am using Daisy 2.1 and MySQL 4.1.14
> 
> I can reproduce the error using the mysql command line as follows:
> 
> mysql> select * from daisyrepository.jbpm_job;
> Empty set (0.20 sec)
> 
> mysql> select * from daisyrepository.JBPM_JOB;
> ERROR 1146 (42S02): Table 'daisyrepository.JBPM_JOB' doesn't exist
> 
> My daisyrepository has all lower case names for all of the table names
> including the JBPM_ tables.
> 
> Comparing to a fresh install of daisy 2.2, all of the JBPM_ tables are upper
> case but the rest of the tables are lower case.  
> 
> The only option I see is to manually rename the tables to upper case from
> the MySQL command line.  Anyone else have a suggestion?
> 
> 
> 
> Lou Parisi wrote:
> > 
> > I am running daisy 2.1 on Linux with MySQL for about 3 months.  I have
> > had the repository stop from time to time without known cause.  The only
> > thing I see in the daisy.log is an error for the table JBPM_JOB does not
> > exist but when I check in mysql I can see the table.  I don't know if
> > this is causing my problem but would like to get rid of this error.  I
> > also don't know if this error has been occurring since we started using
> > daisy or if it is new.
> > 
> > 
>