[opencms-dev] weird error in opencms

[Marius Popa Adrian]

On Fri, 12 Sep 2003 23:49:03 +0300
Marius Popa Adrian <mapopa at reea.net> wrote:

> opencms5.0+(jdk1.4.2),redhat9,mysql,(tomcat 4.1.27)
> 
> if i open the mysql console (with the same user) the table exists in the database ocmstest 
> 
> select * from cms_systemid;
> +------------------------+------+
> | TABLE_KEY              | ID   |
> +------------------------+------+
> | CMS_GROUPS             |   61 |
> | CMS_USERS              |   51 |
> | CMS_TASKPAR            |   11 |
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 
> com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed. 
> root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker. 
> root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]General error: Table 'ocmstest.CMS_SYSTEMID' doesn't exist. 
> root cause was java.sql.SQLException: General error: Table 'ocmstest.CMS_SYSTEMID' doesn't exist

If run this query from the mysql (table name in uppercase)
select * from CMS_SYSTEMID;
ERROR 1146: Table 'ocmstest.CMS_SYSTEMID' doesn't exist 
So it seems the query is case sensitive (This is why it throws the exception)

Any patches for linux?