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



View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3893475#3893475

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3893475


-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to