I am using Jboss 4.0.2

I have a table already created in the database(mysql 4.0.1). It has a column "id" craeted in the database. verified it using mysql

when i make alter-table=true in jbosscmp-jdbc.xml, jboss is now trying to create a column "ID" and the database says it already exists.

1. JBoss is performing uppercase of the column name before checking if it exists in JDBCStartCommand.java: 112.

Hence, it does not find the column name "ID" in the string array cached from the meta data and then tries to execute alter-table

2. When it tries to execute alter-table, it tries to pass "id" instead of "ID" and ofcourse database will not like this.

Looks like this is a bug in jboss 4.0.2


Any immediate fix for this?
thanks
Sudhir