Feature Requests item #547494, was opened at 2002-04-23 03:43
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376688&aid=547494&group_id=22866

Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: allow alter-table like create-table

Initial Comment:
Besides defining a create-table in the deployment 
descriptor jbosscmp-jdbc.xml 
for an entity / relation table it would be very 
comfortable to support also an alter-table.

Especially when an existing system is changed over 
time "alter table" functionality simplifies 
deployment: 
For example when an entity bean is configured with 
remove-table=false, the data stays in the database 
when it is undeployed. Now the entity bean is updated 
with an additional field. When deploying the new 
version with "alter-table=true" the missing column is 
added automatically. 

At the moment the user must perfrom an alter table by 
hand and must "know" the table and the new column 
name. Something that CMP should prevent in general.

Furthermore this could allow multiple entity beans to 
use the same table. Lets assume "creat-table=true" 
and "alter-table=true". Then the deployment of the 
first bean would then create the table, the deployment 
of the second bean could adds some columns.
 
The code that must be changed is basically in

org.jboss.ejb.plugins.cmp.jdbc.JDBCStartCommand.java
org.jboss.ejb.plugins.cmp.jdbc.metadata.JDBCEntityMetaD
ata



----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=376688&aid=547494&group_id=22866

_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development

Reply via email to