Mashood, If you modify an Entity class, the new column won't automatically get added to the database.
Instead, you need to provide a new Flyway migration SQL script, like all the existing ones in https://github.com/apache/fineract/tree/develop/fineract-provider/src/main/resources/sql/migrations/core_db. Does that make sense? Will you eventually be contributing your improvement to the project with a pull request? Best, M. On Thu, 12 Nov 2020, 13:35 Mashood hassan, <m.mashoo...@gmail.com> wrote: > any help will be greatly appreciated. meanwhile, I search more about it. > > On Thu, Nov 12, 2020 at 5:33 PM Mashood hassan <m.mashoo...@gmail.com> > wrote: > >> ok ok, manually I can create a column and table too, column not found >> error occurs when i create manually column in table and try to get the >> "/founds" through the api >> >> On Thu, Nov 12, 2020 at 5:30 PM Saifudeen Khan <sai...@zucisystems.com> >> wrote: >> >>> I did not do it via program though, I did it manually. What I can help >>> you is to figure out why tables are not created manually as well >>> >>> >>> >>> *From:* Mashood hassan <m.mashoo...@gmail.com> >>> *Sent:* 12 November 2020 17:58 >>> *To:* dev@fineract.apache.org >>> *Subject:* Re: RE: new column in table and new Table in database >>> >>> >>> >>> CAUTION: This email originated from outside of the organization. Do not >>> click links or open attachments unless you recognize the sender and know >>> the content is safe. >>> >>> >>> >>> I am new with spring stuff. but I created a separate spring hibernate >>> project and was able to modify table in memory database >>> >>> >>> >>> On Thu, Nov 12, 2020 at 5:24 PM Mashood hassan <m.mashoo...@gmail.com> >>> wrote: >>> >>> maybe I am missing something in the code. can you give me a little time >>> we can connect on TeamViewer you can check? this will be a great help for >>> me. >>> >>> >>> >>> On Thu, Nov 12, 2020 at 5:20 PM Saifudeen Khan <sai...@zucisystems.com> >>> wrote: >>> >>> Strange. We had some usecases where we wanted frequencies of repayment >>> for both principal and interest is different and able to modify the tables >>> successfully >>> >>> -----Original Message----- >>> From: Mashood hassan <m.mashoo...@gmail.com> >>> Sent: 12 November 2020 17:46 >>> To: dev@fineract.apache.org >>> Subject: Re: RE: new column in table and new Table in database >>> >>> CAUTION: This email originated from outside of the organization. Do not >>> click links or open attachments unless you recognize the sender and know >>> the content is safe. >>> >>> >>> and now i have also created the column MySQL default fineract-database >>> now i am getting the same error Caused by: java.sql.SQLException: No such >>> column: source_of_fund >>> >>> >>> On 2020/11/12 12:02:57, Mashood hassan <m.mashoo...@gmail.com> wrote: >>> > yes, I did this one approach let me confirm this one I will tell you >>> just a mint. >>> > On 2020/11/12 11:53:34, Saifudeen Khan <sai...@zucisystems.com> wrote: >>> > > Did you try creating the column in MySQL manually? >>> > > >>> > > -----Original Message----- >>> > > From: Mashood hassan <m.mashoo...@gmail.com> >>> > > Sent: 12 November 2020 17:21 >>> > > To: dev@fineract.apache.org >>> > > Subject: new column in table and new Table in database >>> > > >>> > > CAUTION: This email originated from outside of the organization. Do >>> not click links or open attachments unless you recognize the sender and >>> know the content is safe. >>> > > >>> > > >>> > > I am working on Fineract. The issue I am facing is when I change in >>> m_fund Entity class to add a new column it compiles without error but it >>> does not create new column in MySQL database. one more strange thing which >>> I came to know that is when I try to monitor the SQL logs by enabling it in >>> the application.properties when it starts compiling it remove my lines >>> which enables the SQL logs it feels like it is rewriting my changes. I am >>> stuck at this stage I want to work on this project. Is there anyway u can >>> help me on this? just guide me a little so that I continue my exploration >>> on this cool project. >>> > > >>> > > 1: what do I want to do? >>> > > I want to add a new column and make new tables in fineract >>> MySQL default. >>> > > 2: what is the issue? >>> > > A new column is not visible in MySQL "m_fund" table even there >>> is not an error >>> > > When I hit API /funds it says you don't have a "funds_type" >>> column in the database. this is after when I make Column in Entity class >>> using @Column and private String... >>> > > >>> > > Thank you >>> > > >>> > > >>> > > >>> > > >>> > > >>> > > Disclaimer: "The contents of this e-mail and any attachments >>> enclosed therein are intended solely for the addressee(s) and may contain >>> confidential and/or privileged information. It may also be the sole >>> intellectual and proprietary resource of Zuci Systems and therefore may be >>> legally protected from disclosure. If you are not the intended recipient of >>> this message, or if this message has been addressed to you by inadvertence, >>> kindly alert the sender by email and then follow with its deletion. If you >>> are not the intended recipient, you are hereby notified that any use, >>> dissemination, copying, or storage of this message or its attachments is >>> strictly prohibited and shall make you liable for consequences under >>> applicable laws." >>> > > >>> > >>> Disclaimer: "The contents of this e-mail and any attachments enclosed >>> therein are intended solely for the addressee(s) and may contain >>> confidential and/or privileged information. It may also be the sole >>> intellectual and proprietary resource of Zuci Systems and therefore may be >>> legally protected from disclosure. If you are not the intended recipient of >>> this message, or if this message has been addressed to you by inadvertence, >>> kindly alert the sender by email and then follow with its deletion. If you >>> are not the intended recipient, you are hereby notified that any use, >>> dissemination, copying, or storage of this message or its attachments is >>> strictly prohibited and shall make you liable for consequences under >>> applicable laws." >>> >>> Disclaimer: "The contents of this e-mail and any attachments enclosed >>> therein are intended solely for the addressee(s) and may contain >>> confidential and/or privileged information. It may also be the sole >>> intellectual and proprietary resource of Zuci Systems and therefore may be >>> legally protected from disclosure. If you are not the intended recipient of >>> this message, or if this message has been addressed to you by inadvertence, >>> kindly alert the sender by email and then follow with its deletion. If you >>> are not the intended recipient, you are hereby notified that any use, >>> dissemination, copying, or storage of this message or its attachments is >>> strictly prohibited and shall make you liable for consequences under >>> applicable laws." >>> >>
