re-creating a table after new fields added error

[neptune5]

Hi

How can i recreate a table with added fields to it ? i Have added this new field
into the ejb-jar file and the jbosscmp-jdbc file. Also I have methods
that use it and they all compile ok. When I deploy the project it then
complains about the field not being in the table " column not found ".

The default.script file in the data folder contains the details of the sqls
done but this isn't changing after I have changed the definitions of the table in the xml
files. Also if i delete it this makes things even worse or clear it.


using Hypersonic db
and Jboss 3.2.1


Regards Adrian

[pvamstel]

I think but i'm not sure that is a true solution is to drop the table before creating a new one. That is an option you can set in the jdbc-???.xml (Sorry do not know the exact name).

But if you do it like that you will loose all your data