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
