Hi Jacques, Ummm, what are the implications of deleting a table in ofbiz apart from loss of data contained in that table? Coz I just deleted a table using the SQL processor (am actually just learning Ofbiz, am not yet working on a building a production app). I had previously defined an entity called Patient and after a I deleted the table and I restarted ofbiz, I cant see my entity in the Entity Data Maintenance page of webtools. Issuing the following SQL "SELECT * FROM PATIENT" from the SQL processor page throws an exception, the trace in console.log says: ERROR 42X05: Table/View 'PATIENT' does not exist.
Am I missing something here? All help appreciated, thx Regards Edward Below are my entitymodel.xml and entitygroup.xml files repectively -------------------------------------------------------- <?xml version="1.0" encoding="UTF-8"?> <entitymodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/entitymodel.xsd";> <!-- ========================================================= --> <!-- ======================== Defaults ======================= --> <!-- ========================================================= --> <title>Entities for a Hello world component</title> <description>None</description> <copyright>Copyright (c) Hello World, Inc.</copyright> <author>Edward Banfa</author> <version>0.1</version> <entity entity-name="Patient" package-name="org.helloworld.emedic" title="Entity to represent mentally sick people in government"> <field name="patientId" type="id-ne"/> <field name="firstName" type="id"/> <field name="lastName" type="id"/> <field name="appointment" type="id"/> <prim-key field="patientId"/> </entity> </entitymodel> ------------------------------------------------------------------------- ------------------------------------------------------------------------- <?xml version="1.0" encoding="UTF-8"?> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/entitygroup.xsd";> <entity-group group="org.ofbiz" entity="Patient"/> </entitygroup> -------------------------------------------------------------------------- -----Original Message----- From: Jacques Le Roux [mailto:[EMAIL PROTECTED] Sent: Monday, December 17, 2007 11:56 AM To: [email protected] Subject: Re: Deleting a table http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo Look for Derby, not sure there is exactly an answer but you should find your way from there. Beware that it's not recommended to delete tables in OFBiz... Jacques De : "Edward Banfa" <[EMAIL PROTECTED]> > Hi all. > > > > I would like to know how to delete a table in the Derby database that comes > with Ofbiz. > > > > Actually I have a problem with a an entity that I created, I want to alter > the columns on the entity and hence in the underlying table that represents > the data for the entity. Do I have to drop the existing table or is there a > way I can have ofbiz pickup any changes in the > > entity definition and update the db schema ? > > > > Thank u for ur help in advance > > > > Regards > > > > Edward > >
