hi!
You are not alone. I tried today to create my MySQL-tables by my ejbs. if they 
already exist and the alter-table - value is true, jbossas wants to duplicate 
the primary-column in my table. i can understand my mysql-db, why it says: 
"Stupid boy! Why do you want to duplicate a column?". Sounds like a bug in 
jboss, or?
Perhaps jboss wants to test the table. First it inserts some datas, then it 
deletes them again and then it wants to test the table-structure:

2005-06-27 15:38:14,453 DEBUG
  |   [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Infolabel]
  |   Insert Entity SQL: INSERT INTO infolabel (idinfolabel, filanguage, fiinfo,
  |    value) VALUES (?, ?, ?, ?)
  | 2005-06-27 15:38:14,453 DEBUG
  |    [org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand.Infolabel]
  |    Entity Exists SQL: SELECT COUNT(*) FROM infolabel WHERE idinfolabel=?
  | 2005-06-27 15:38:14,453 DEBUG
  |    [org.jboss.ejb.plugins.cmp.jdbc.JDBCCommandFactory.Infolabel]
  |    entity-command: [commandName=default,commandClass=class
  |     org.jboss.ejb.plugins.cmp.jdbc.JDBCCreateEntityCommand,attributes={}]
  | 2005-06-27 15:38:14,453 DEBUG
  |    [org.jboss.ejb.plugins.cmp.jdbc.JDBCRemoveEntityCommand.Infolabel]
  |    Remove SQL: DELETE FROM infolabel WHERE idinfolabel=?
  | 2005-06-27 15:38:14,468 WARN
  |     [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Infolabel] ALTER
  |     TABLE infolabel ADD idinfolabel INTEGER NOT NULL
  | 2005-06-27 15:38:14,484 ERROR
  |    [org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.Infolabel] Could not
  |    alter table infolabel: Duplicate column name 'idinfolabel'

Can i tell jbossas, that it should skip this step?

Grüße aus Deutschland,
Sven

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

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


-------------------------------------------------------
SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
from IBM. Find simple to follow Roadmaps, straightforward articles,
informative Webcasts and more! Get everything you need to get up to
speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click
_______________________________________________
JBoss-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to