You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Edward Banfa <ed...@neptunesoftwareplc.com> on 2007/12/17 11:44:01 UTC
Deleting a table
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
Re: Deleting a table
Posted by Adrian Crum <ad...@hlmksw.com>.
Parties, party groups, and party roles are all covered in depth in the Data Model Resource Book.
Edward Banfa wrote:
> Hi all,
> Someone please correct me on this if I am wrong
>
> - A Party is a person or a group.
> - A Party group is a logical grouping of Party's ?
> - A Party/Group can have roles defined as PartyRoles ?
>
> So in my case a single person is a Party and a Patient can be represented as
> a Party group ? so where does party role fit into the mix?
>
> Thnx
>
> Regards
>
> Edward
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Monday, December 17, 2007 5:56 PM
> To: user@ofbiz.apache.org
> Subject: Re: Deleting a table
>
> I have not seen much code using the party role, though that is a good way.
>
> Adrian Crum sent the following on 12/17/2007 8:23 AM:
>
>>Maybe a Patient party role would be more appropriate.
>>
>>
>>BJ Freeman wrote:
>>
>>
>>>like any relational database, if you have tables that are realated and
>>>they have data in them then that data may be lost.
>>>
>>>as a side note: look at using a party as person and create a Patient
>>>Party group. saves doing redundant work
>>>
>>>
>>>Edward Banfa sent the following on 12/17/2007 3:50 AM:
>>>
>>>
>>>>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:jacques.le.roux@les7arts.com] Sent:
>>>>Monday, December 17, 2007 11:56 AM
>>>>To: user@ofbiz.apache.org
>>>>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" <ed...@neptunesoftwareplc.com>
>>>>
>>>>>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
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
>
>
>
>
>
Re: Party
Posted by Jacques Le Roux <ja...@les7arts.com>.
Also you can refer to this page (work in progress...) http://docs.ofbiz.org/display/OFBIZ/Glossary
And making it better by adding comments
Jacques
De : "BJ Freeman" <bj...@free-man.net>
> Party is any person or company.
> it can be a person with a role of employee
> In you case you would create a role Patient
> then you can create a setup for Create Patient
> Like the Create Employee
> party groups are where you want to group different parties together.
> You should also have a permissions for patient
>
> it would be helpful to you before you start out to
> read the data modeling book
> http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Related+Books
> and review
> Training Videos
> http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Documentation+Index
>
> Edward Banfa sent the following on 12/17/2007 9:29 AM:
> > Hi all,
> > Someone please correct me on this if I am wrong
> >
> > - A Party is a person or a group.
> > - A Party group is a logical grouping of Party's ?
> > - A Party/Group can have roles defined as PartyRoles ?
> >
> > So in my case a single person is a Party and a Patient can be represented as
> > a Party group ? so where does party role fit into the mix?
> >
> > Thnx
> >
> > Regards
> >
> > Edward
> >
> > -----Original Message-----
> > From: BJ Freeman [mailto:bjfree@free-man.net]
> > Sent: Monday, December 17, 2007 5:56 PM
> > To: user@ofbiz.apache.org
> > Subject: Re: Deleting a table
> >
> > I have not seen much code using the party role, though that is a good way.
> >
> > Adrian Crum sent the following on 12/17/2007 8:23 AM:
> >> Maybe a Patient party role would be more appropriate.
> >>
> >>
> >> BJ Freeman wrote:
> >>
> >>> like any relational database, if you have tables that are realated and
> >>> they have data in them then that data may be lost.
> >>>
> >>> as a side note: look at using a party as person and create a Patient
> >>> Party group. saves doing redundant work
> >>>
> >>>
> >>> Edward Banfa sent the following on 12/17/2007 3:50 AM:
> >>>
> >>>> 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:jacques.le.roux@les7arts.com] Sent:
> >>>> Monday, December 17, 2007 11:56 AM
> >>>> To: user@ofbiz.apache.org
> >>>> 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" <ed...@neptunesoftwareplc.com>
> >>>>
> >>>>> 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
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>
> >>
> >>
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
Party
Posted by BJ Freeman <bj...@free-man.net>.
Party is any person or company.
it can be a person with a role of employee
In you case you would create a role Patient
then you can create a setup for Create Patient
Like the Create Employee
party groups are where you want to group different parties together.
You should also have a permissions for patient
it would be helpful to you before you start out to
read the data modeling book
http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Related+Books
and review
Training Videos
http://docs.ofbiz.org/display/OFBADMIN/OFBiz+Documentation+Index
Edward Banfa sent the following on 12/17/2007 9:29 AM:
> Hi all,
> Someone please correct me on this if I am wrong
>
> - A Party is a person or a group.
> - A Party group is a logical grouping of Party's ?
> - A Party/Group can have roles defined as PartyRoles ?
>
> So in my case a single person is a Party and a Patient can be represented as
> a Party group ? so where does party role fit into the mix?
>
> Thnx
>
> Regards
>
> Edward
>
> -----Original Message-----
> From: BJ Freeman [mailto:bjfree@free-man.net]
> Sent: Monday, December 17, 2007 5:56 PM
> To: user@ofbiz.apache.org
> Subject: Re: Deleting a table
>
> I have not seen much code using the party role, though that is a good way.
>
> Adrian Crum sent the following on 12/17/2007 8:23 AM:
>> Maybe a Patient party role would be more appropriate.
>>
>>
>> BJ Freeman wrote:
>>
>>> like any relational database, if you have tables that are realated and
>>> they have data in them then that data may be lost.
>>>
>>> as a side note: look at using a party as person and create a Patient
>>> Party group. saves doing redundant work
>>>
>>>
>>> Edward Banfa sent the following on 12/17/2007 3:50 AM:
>>>
>>>> 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:jacques.le.roux@les7arts.com] Sent:
>>>> Monday, December 17, 2007 11:56 AM
>>>> To: user@ofbiz.apache.org
>>>> 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" <ed...@neptunesoftwareplc.com>
>>>>
>>>>> 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
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>
>>
>>
>
>
>
>
>
>
>
>
>
RE: Deleting a table
Posted by Edward Banfa <ed...@neptunesoftwareplc.com>.
Hi all,
Someone please correct me on this if I am wrong
- A Party is a person or a group.
- A Party group is a logical grouping of Party's ?
- A Party/Group can have roles defined as PartyRoles ?
So in my case a single person is a Party and a Patient can be represented as
a Party group ? so where does party role fit into the mix?
Thnx
Regards
Edward
-----Original Message-----
From: BJ Freeman [mailto:bjfree@free-man.net]
Sent: Monday, December 17, 2007 5:56 PM
To: user@ofbiz.apache.org
Subject: Re: Deleting a table
I have not seen much code using the party role, though that is a good way.
Adrian Crum sent the following on 12/17/2007 8:23 AM:
> Maybe a Patient party role would be more appropriate.
>
>
> BJ Freeman wrote:
>
>> like any relational database, if you have tables that are realated and
>> they have data in them then that data may be lost.
>>
>> as a side note: look at using a party as person and create a Patient
>> Party group. saves doing redundant work
>>
>>
>> Edward Banfa sent the following on 12/17/2007 3:50 AM:
>>
>>> 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:jacques.le.roux@les7arts.com] Sent:
>>> Monday, December 17, 2007 11:56 AM
>>> To: user@ofbiz.apache.org
>>> 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" <ed...@neptunesoftwareplc.com>
>>>
>>>> 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
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Deleting a table
Posted by BJ Freeman <bj...@free-man.net>.
I have not seen much code using the party role, though that is a good way.
Adrian Crum sent the following on 12/17/2007 8:23 AM:
> Maybe a Patient party role would be more appropriate.
>
>
> BJ Freeman wrote:
>
>> like any relational database, if you have tables that are realated and
>> they have data in them then that data may be lost.
>>
>> as a side note: look at using a party as person and create a Patient
>> Party group. saves doing redundant work
>>
>>
>> Edward Banfa sent the following on 12/17/2007 3:50 AM:
>>
>>> 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:jacques.le.roux@les7arts.com] Sent:
>>> Monday, December 17, 2007 11:56 AM
>>> To: user@ofbiz.apache.org
>>> 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" <ed...@neptunesoftwareplc.com>
>>>
>>>> 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
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>
>
>
>
Re: Deleting a table
Posted by Adrian Crum <ad...@hlmksw.com>.
Maybe a Patient party role would be more appropriate.
BJ Freeman wrote:
> like any relational database, if you have tables that are realated and
> they have data in them then that data may be lost.
>
> as a side note: look at using a party as person and create a Patient
> Party group. saves doing redundant work
>
>
> Edward Banfa sent the following on 12/17/2007 3:50 AM:
>
>>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:jacques.le.roux@les7arts.com]
>>Sent: Monday, December 17, 2007 11:56 AM
>>To: user@ofbiz.apache.org
>>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" <ed...@neptunesoftwareplc.com>
>>
>>>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
>>>
>>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
Re: Deleting a table
Posted by BJ Freeman <bj...@free-man.net>.
like any relational database, if you have tables that are realated and
they have data in them then that data may be lost.
as a side note: look at using a party as person and create a Patient
Party group. saves doing redundant work
Edward Banfa sent the following on 12/17/2007 3:50 AM:
> 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:jacques.le.roux@les7arts.com]
> Sent: Monday, December 17, 2007 11:56 AM
> To: user@ofbiz.apache.org
> 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" <ed...@neptunesoftwareplc.com>
>> 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
>>
>>
>
>
>
>
>
>
>
>
>
RE: Deleting a table
Posted by Edward Banfa <ed...@neptunesoftwareplc.com>.
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:jacques.le.roux@les7arts.com]
Sent: Monday, December 17, 2007 11:56 AM
To: user@ofbiz.apache.org
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" <ed...@neptunesoftwareplc.com>
> 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
>
>
Re: Deleting a table
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <ed...@neptunesoftwareplc.com>
> 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
>
>
Re: Deleting a table
Posted by Scott Gray <le...@gmail.com>.
OFBiz will add columns for you but won't delete or update columns. In the
WebTools app you can run raw sql against the database to make the necessary
changes.
Regards
Scott
On 17/12/2007, Edward Banfa <ed...@neptunesoftwareplc.com> wrote:
>
> 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
>
>