Entity Changes for column definition Not Reflecting in DB

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
11 messages Options
Reply | Threaded
Open this post in threaded view
|

Entity Changes for column definition Not Reflecting in DB

Hemanth Kumar Kanamarlapudi
Hi Users,

Can any one please tell me the reason why the changes in my entity definition are not reflected in the database.

For example I have a cardNumber which is earlier Numeric/Integer in entitymodel.xml as well as in database.

Now I changed  cardNumber to Name/String type in entitymodel,xml and restarted ofbiz server. The change is not reflected in database.

I am using MySQL database.

Thanks in Advance.

Regards,
Hemanth



________________________________
http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

Re: Entity Changes for column definition Not Reflecting in DB

Abdullah Shaikh-3
Do you have "check-on-start" & "add-missing-on-start" set to true in your
datasource definition ?


On Mon, Aug 10, 2009 at 12:00 PM, Hemanth Kumar Kanamarlapudi <
[hidden email]> wrote:

> Hi Users,
>
> Can any one please tell me the reason why the changes in my entity
> definition are not reflected in the database.
>
> For example I have a cardNumber which is earlier Numeric/Integer in
> entitymodel.xml as well as in database.
>
> Now I changed  cardNumber to Name/String type in entitymodel,xml and
> restarted ofbiz server. The change is not reflected in database.
>
> I am using MySQL database.
>
> Thanks in Advance.
>
> Regards,
> Hemanth
>
>
>
> ________________________________
> http://www.mindtree.com/email/disclaimer.html
>
Reply | Threaded
Open this post in threaded view
|

Re: Entity Changes for column definition Not Reflecting in DB

David E. Jones-2
In reply to this post by Hemanth Kumar Kanamarlapudi

The Entity Engine only automatically adds new tables and columns, it  
does not automatically change column types. It will, however, warn you  
about the database column type not matching the entity field type.  
Please read through the warnings on startup or on the checkdb page in  
webtools and you'll see this information.

-David


On Aug 10, 2009, at 12:30 AM, Hemanth Kumar Kanamarlapudi wrote:

> Hi Users,
>
> Can any one please tell me the reason why the changes in my entity  
> definition are not reflected in the database.
>
> For example I have a cardNumber which is earlier Numeric/Integer in  
> entitymodel.xml as well as in database.
>
> Now I changed  cardNumber to Name/String type in entitymodel,xml and  
> restarted ofbiz server. The change is not reflected in database.
>
> I am using MySQL database.
>
> Thanks in Advance.
>
> Regards,
> Hemanth
>
>
>
> ________________________________
> http://www.mindtree.com/email/disclaimer.html

Reply | Threaded
Open this post in threaded view
|

Re: Entity Changes for column definition Not Reflecting in DB

hans_bakker
In reply to this post by Hemanth Kumar Kanamarlapudi
The change you did need a unload/reload of the entity if you do not want
to loose existing data.

If you do not mind loosing the content of the entity simply dropping the
entity and restarting ofbiz will do the trick

Regards,
Hans

On Mon, 2009-08-10 at 12:00 +0530, Hemanth Kumar Kanamarlapudi wrote:

> Hi Users,
>
> Can any one please tell me the reason why the changes in my entity definition are not reflected in the database.
>
> For example I have a cardNumber which is earlier Numeric/Integer in entitymodel.xml as well as in database.
>
> Now I changed  cardNumber to Name/String type in entitymodel,xml and restarted ofbiz server. The change is not reflected in database.
>
> I am using MySQL database.
>
> Thanks in Advance.
>
> Regards,
> Hemanth
>
>
>
> ________________________________
> http://www.mindtree.com/email/disclaimer.html
--
Antwebsystems.com: Quality OFBiz services for competitive rates

Reply | Threaded
Open this post in threaded view
|

Re: Entity Changes for column definition Not Reflecting in DB

chris snow
In reply to this post by David E. Jones-2
In r4.0 on MS SQL, new columns are not recognized by the entity engine using my setup.  I was told this may be due to the lack of meta data provided by the MS JDBC driver I am using.  I manually add new columns and keys to the database - it's not that much of a big deal for my environment.

David E Jones-4 wrote
The Entity Engine only automatically adds new tables and columns, it  
does not automatically change column types. It will, however, warn you  
about the database column type not matching the entity field type.  
Please read through the warnings on startup or on the checkdb page in  
webtools and you'll see this information.

-David


On Aug 10, 2009, at 12:30 AM, Hemanth Kumar Kanamarlapudi wrote:

> Hi Users,
>
> Can any one please tell me the reason why the changes in my entity  
> definition are not reflected in the database.
>
> For example I have a cardNumber which is earlier Numeric/Integer in  
> entitymodel.xml as well as in database.
>
> Now I changed  cardNumber to Name/String type in entitymodel,xml and  
> restarted ofbiz server. The change is not reflected in database.
>
> I am using MySQL database.
>
> Thanks in Advance.
>
> Regards,
> Hemanth
>
>
>
> ________________________________
> http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

Can we modify the <Security> tag to add extra attribute ?

Kishore Pagadala
I have a requirement where I need to redirect the user to different page based on type of user's registration (SIMPLE registration with minimum fields or COMPLETE registration), for which I need to modify the Security tag.

I want to add an extra attribute called "registrationType" which should forward to different page depending on registration type.
EX:-
<request-map uri="checkout">
        <security auth="true" registrationType="SIMPLE" https="true" />

Can some tell us the flow and files I may need to modify for this requirment ?

Regards,
Kishore

http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

Re: Can we modify the <Security> tag to add extra attribute ?

Scott Gray-2
You could always just use a preprocessor event couldn't you?

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 11/08/2009, at 10:27 PM, Kishore Pagadala wrote:

> I have a requirement where I need to redirect the user to different  
> page based on type of user's registration (SIMPLE registration with  
> minimum fields or COMPLETE registration), for which I need to modify  
> the Security tag.
>
> I want to add an extra attribute called "registrationType" which  
> should forward to different page depending on registration type.
> EX:-
> <request-map uri="checkout">
>        <security auth="true" registrationType="SIMPLE" https="true" />
>
> Can some tell us the flow and files I may need to modify for this  
> requirment ?
>
> Regards,
> Kishore
>
> http://www.mindtree.com/email/disclaimer.html


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Can we modify the <Security> tag to add extra attribute ?

Scott Gray-2
Actually that may not be the best solution, why don't you just use a  
regular event to process the view redirect?

Regards
Scott

On 11/08/2009, at 10:31 PM, Scott Gray wrote:

> You could always just use a preprocessor event couldn't you?
>
> Regards
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
> On 11/08/2009, at 10:27 PM, Kishore Pagadala wrote:
>
>> I have a requirement where I need to redirect the user to different  
>> page based on type of user's registration (SIMPLE registration with  
>> minimum fields or COMPLETE registration), for which I need to  
>> modify the Security tag.
>>
>> I want to add an extra attribute called "registrationType" which  
>> should forward to different page depending on registration type.
>> EX:-
>> <request-map uri="checkout">
>>       <security auth="true" registrationType="SIMPLE" https="true" />
>>
>> Can some tell us the flow and files I may need to modify for this  
>> requirment ?
>>
>> Regards,
>> Kishore
>>
>> http://www.mindtree.com/email/disclaimer.html
>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Can we modify the <Security> tag to add extra attribute ?

BJ Freeman
In reply to this post by Kishore Pagadala
look at how a Customer role is added to registration from the ecommerce
side. You can assign other roles to fit you registrationtypes.


Kishore Pagadala sent the following on 8/11/2009 3:27 AM:

> I have a requirement where I need to redirect the user to different page based on type of user's registration (SIMPLE registration with minimum fields or COMPLETE registration), for which I need to modify the Security tag.
>
> I want to add an extra attribute called "registrationType" which should forward to different page depending on registration type.
> EX:-
> <request-map uri="checkout">
>         <security auth="true" registrationType="SIMPLE" https="true" />
>
> Can some tell us the flow and files I may need to modify for this requirment ?
>
> Regards,
> Kishore
>
> http://www.mindtree.com/email/disclaimer.html
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.

Reply | Threaded
Open this post in threaded view
|

RE: Can we modify the <Security> tag to add extra attribute ?

Kishore Pagadala
Actual problem:
Unlike the Ofbiz default registration implementation, we have two different types of user registration called SIMPLE and COMPLETE. If user not registered, he/she has to forward to a particular registration page dynamically.

We thought to specify the registrationType as attribute in security tag
        <security auth="true" registrationType="SIMPLE" />

If the above mechanism doesn't work, I thought to implement two request-map called 'SimpleRegistration' and 'CompleteRegistration' which will redirect to the caller request-map after registration is complete.

Regards,
Kishore



-----Original Message-----
From: Scott Gray [mailto:[hidden email]]
Sent: Wednesday, August 12, 2009 11:37 AM
To: [hidden email]
Subject: Re: Can we track the previous Request map

You can't.  Keep in mind it is much better to talk about the actual
problem you are trying to solve rather than talking about the problem
your solution has created.  It makes it much easier for others to
suggest alternative solutions.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 12/08/2009, at 6:00 PM, Kishore Pagadala wrote:

> I have a common utility request-map which will be called by other
> request-maps based on response type. Once this request-map is
> complete, it has to redirect to the caller.
>
> <request-map uri="commonUtility">
>        // After completion, redirect to calling request-map
> </request-map>
>
>
> How can we redirect to calling Request-Map ?



-----Original Message-----
From: BJ Freeman [mailto:]
Sent: Tuesday, August 11, 2009 4:29 PM
To: [hidden email]
Subject: Re: Can we modify the <Security> tag to add extra attribute ?

look at how a Customer role is added to registration from the ecommerce
side. You can assign other roles to fit you registrationtypes.


Kishore Pagadala sent the following on 8/11/2009 3:27 AM:

> I have a requirement where I need to redirect the user to different page based on type of user's registration (SIMPLE registration with minimum fields or COMPLETE registration), for which I need to modify the Security tag.
>
> I want to add an extra attribute called "registrationType" which should forward to different page depending on registration type.
> EX:-
> <request-map uri="checkout">
>         <security auth="true" registrationType="SIMPLE" https="true" />
>
> Can some tell us the flow and files I may need to modify for this requirment ?
>
> Regards,
> Kishore
>
> http://www.mindtree.com/email/disclaimer.html
>

--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.


http://www.mindtree.com/email/disclaimer.html
Reply | Threaded
Open this post in threaded view
|

RE: Can we modify the <Security> tag to add extra attribute ?

Charles Tjandra


Hello to All,

Is there new parameters in <security> tag?
Did I miss or something?

Kindly let me know. Thanks.

- Charles TJ



-----Original Message-----
From: Kishore Pagadala [mailto:[hidden email]]
Sent: 12 Agustus 2009 13:24
To: [hidden email]
Subject: RE: Can we modify the <Security> tag to add extra attribute ?


Actual problem:
Unlike the Ofbiz default registration implementation, we have two different
types of user registration called SIMPLE and COMPLETE. If user not
registered, he/she has to forward to a particular registration page
dynamically.

We thought to specify the registrationType as attribute in security tag
        <security auth="true" registrationType="SIMPLE" />

If the above mechanism doesn't work, I thought to implement two request-map
called 'SimpleRegistration' and 'CompleteRegistration' which will redirect
to the caller request-map after registration is complete.

Regards,
Kishore