You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Hemanth Kumar Kanamarlapudi <he...@mindtree.com> on 2009/08/10 08:30:24 UTC
Entity Changes for column definition Not Reflecting in DB
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
Re: Entity Changes for column definition Not Reflecting in DB
Posted by Abdullah Shaikh <ab...@viithiisys.com>.
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 <
hemanth_kanamarlapudi@mindtree.com> 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
>
Re: Can we modify the tag to add extra attribute ?
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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
>
Re: Can we modify the tag to add extra attribute ?
Posted by Scott Gray <sc...@hotwaxmedia.com>.
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
Can we modify the tag to add extra attribute ?
Posted by Kishore Pagadala <Ki...@mindtree.com>.
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
Re: Entity Changes for column definition Not Reflecting in DB
Posted by snowc <ch...@gmail.com>.
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
>
>
>
--
View this message in context: http://www.nabble.com/Entity-Changes-for-column-definition-Not-Reflecting-in-DB-tp24894941p24914145.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Entity Changes for column definition Not Reflecting in DB
Posted by David E Jones <de...@me.com>.
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
Re: Entity Changes for column definition Not Reflecting in DB
Posted by Hans Bakker <ma...@antwebsystems.com>.
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