Activity for Frank Messie
-
Frank Messie posted a comment on discussion Help (English)
Class SalesQuote package com.osix.plx.model; import java.math.; import java.time.; //import java.rmi.; import java.util.; //import javax.ejb.; import javax.persistence.; import org.openxava.annotations.*; import com.osix.plx.calculators.*; import lombok.*; @Getter @Setter @Tab(name="SalesQuote", properties="number , salesOrderNumber,orderDate,totalAmount") @View(name="Quote", members="salesOrderNumber, ") @View(name="Detail", members="year,number, salesOrderNumber, orderDate,,purchaseOrderReference;quoteDetails;...
-
We have an element collection in a SalesQuote entity and a embedddable SalesQuoteDetail. We use the following code for calculating the amount on each line of the ElementCollection. According the tect in the "Invoice" tutorial the amount should be recalculated when Discount or Quantity is changed. However, the recalcuation only works when the record is saved. Is there a solution ? (I checked ChatGPT but that did come up with a solution). @Depends("discount, quantity") public BigDecimal getAmount()...
-
Xavier, I already suspected that the image could not be found. but was not able to solve this. I will test including it in the project and let you know.
-
Hi Xavier, I found the cause of the problem. In the example the following fails ssaAgreement = XPersistence.getManager().find(SsaAgreement.class, ssaId); It requires that ssaId is true id of the class. In my case it isn't . The SsaAgreement class extends the Identifiable class. This means the Id is defined in the Identifable class . It is defined as "oid" (which is hidden) So the solution is to use the following: ssaAgreement = XPersistence.getManager().find(SsaAgreement.class, oId); This works and...
-
Jasper Report allows to include in a report a background image. I copy the report to OX. When I run the report the background image is not shown. I attach the source of the report file as it is available in the OX project. I fully understand if you are not spending time on this Non-Ox issue. But if you have an idea it is very much appreciated.
-
I want to display a logo on a report page. The report is SsaAgreement The logo is a String Logo in SsaAgreement ( @file , 32 bytes) The SsaAgreement is identified by the character field ssaId. When I run the report I get an error "nullpointer "on line 1. I suspect that this is caused by an error in line2 What am I doing wrong ? Xavier, Thanks for all your help AttachedFile img = new AttachedFile(); ** 1** img = FilePersistorFactory.getInstance().find(getSsaAgreement().getLogo()); byte[] fileImg =...
-
Dear Xavier, Thanks. I changed my browser settings. But now I run into another issue that is certainly caused by myself. The openXava component Product cannot be resolved. What is wrong in my code package com.osix.invoicing.actions; import java.util.; import com.osix.invoicing.model.; import org.openxava.actions.; import org.openxava.model.; import org.openxava.util.; import org.openxava.validators.; import net.sf.jasperreports.engine.*; public class PrintProductAction extends JasperReportBaseAction...
-
java.lang.IllegalArgumentException: Invalid character found in method name [0x160x030x010x07O0x010x000x07K0x030x03u0xe1Uh0xbc0x180xc90x06Z0x0f0xb70x110xa2!E0x11r0xc90xa2N0x110xc5z0xbe0x960xe5RUrO ]. HTTP method names must be tokens I am developing a report according to Lesson 2 of the Jasper Report Tutorial It is compiling and running without errors. However, when I say Print report the result is a page with Null in the fields. In the openxava console I get the message above. Is this a Jasper issue...
-
java.lang.IllegalArgumentException: Invalid character found in method name [0x160x030x010x07O0x010x000x07K0x030x03u0xe1Uh0xbc0x180xc90x06Z0x0f0xb70x110xa2!E0x11r0xc90xa2N0x110xc5z0xbe0x960xe5RUrO ]. HTTP method names must be tokens I am developing a report according to Lesson 2 of the Jasper Report Tutorial It is compiling and running without errors. However, when I say Print report the result is a page with Null in the fields. In the openxava console I get the message above. Is this a Jasper issue...
-
Invalid character found in method name [0x160x030x010x07O0x010x000x07K0x030x03P0xff0x930xeb0x160x03b0x020x110x0d[w0x820xbd0xc80xfa0xb8{0x9a0x040x910xbe0xf3d0x0eT0x0bz0xd8i0x160xd7 ]. HTTP method names must be tokens We are running the example as described in lesson 2. It is now compiling and running without errors. But as soon as we create a report we get Null as a result in the fields and in OpenXava console we get the long message. What is wrong ?
-
In Lesson 2 of the Jasperreport lessons we find the following text: "There are different ways to obtain the information, such as from the database or directly from the view where the action is called. We will choose the first option". Is it possible to provide the code to generate a report that contains some of the fields that are shown on the detail page which shows the action which calls the report.? (in stead of querying the fields from the database). Thanks in advance.
-
I discovred a few lines from the console output were missing The correct console output is attached. Sorry for the confusion
-
After running OX for several years without any problem, I was testing a new action. Suddenly to my surprise Ox would not startup anymore. I get a console log which is beyond my understanding I hope somebody can give me a clue where to loo for a solution. The console output is in the attached file. Thanks very much in advance.
-
When we want to open an entity we get the message "Transaction marked as rollback". We have tried to overcome this propblem in many ways . We even deleted the entity from the project and deleted the database table. When we redefine the entity again with the same name (no records in the dadatabase) we get the same message again. Apparently OpenXava (or JPA) "remembers " the status of the transaction on that entity. . What to do? Any help much appreciated.
-
Is it possible to set the value of Foreign key (@JoinColumn) in an action?
-
Hi Javier, I think I came a little closer to understanding the problem. The creation of BusinessUnits by the action is done properly. The update of the AssociationEntity should be done by the cascade mechanism but that does not work. Is something wrong in the mappedBy definition or cascade definition?
-
The bottom line question is how to define the OneTo Many association between the entity businessRelation and the entity businessUnit (persistent) Thanks in advance
-
Javier, It is not a ManyToMany but a OneToMany relationship as follows ==========================================** BusinessRelation @OneToMany (mappedBy="businessRelation", cascade=CascadeType.MERGE) @AddAction ("BusinessRelation.AddMultipleUnits") @CollectionView("CollectionBusinessUnitView") @ListProperties("businessRelationName,businessUnitName,businessUnitId,businessUnitCode") Collection<businessunit> businessUnits;</businessunit> ====================================================== and BusinessUnit...
-
Dear Javier, We are talking about a one-many relation ship. There are many businessUnits members of a businessRelation. I analysed what is happening. In the database I see that the businessUnit records are created. Where it goes wrong is that businessRelation-businessUnit table is not updated. How can I make sure that this happens? ( we use OID's). I hope my explanation is clear and I hope you can give me a hint how to solve this. Thanks in advance.
-
Dear Javier, Thanks for the tip I have written the following code. package com.osix.plx.actions; import org.openxava.actions.; import org.openxava.jpa.; import com.osix.plx.model.*; public class BusinessRelationAddMultipleUnitsToCollectionAction extends CollectionElementViewBaseAction { public void execute() throws Exception { getView().refreshCollections(); Object businessNameObj = getView().getValue("businessRelationName"); String businessRelationName = businessNameObj.toString(); Object businessCodeObj...
-
Dear Xavier, This I am already using. I call an action which extends CreateNewElementInCollectionAction However, my problem is that I cannot use CreateNewElementInCollectionAction as want to create multipe elements. in the same collection. I understand that to do that I have to use BaseAction and connect the action to the collection using a view How do I define the view?
-
Dear Javier, The action contains default values which are written to each element. So , for example if a finance department is entered as one of the orgunit elements, a value for "ogrUnitType="finance" is entered as well as a orgUnitId (something like 12345603). I want to avoid any user interaction. With user interaction it already works. Thanks in advance. I hope this is clear ?
-
We have developed a fairly comprehensive application in OpenXava. Now we would like to clean up a number of things and make use more productive. We need to do the following in an organisation tree we have customer-organisations and each organisation has a standard number of organisational units. We would like to add with one single action a number of standard org units, each with its own specific properties. We suppose to need - a baseAction - within this baseAction for each org unit a CreateNewElementInCollectionAction...
-
Dear Javier, Thanks a lot. I overlooked to modify the ip-address in the context.xml file. I only modified the IP address in the persistence.xml file. The last seems to be enough for a database on the local host. I must say that it is a bit confusing, but now I will remember for ever. Thanks again. The interface improvement in 6.6. is very nice. Great job.
-
I have OpenXava (6.6.1) for development running with a Postgres database installed on a localhost for development. However, I would like to use OpenXava for development with the Postgres database on a remote host. I cannot get this working. Is see the following in the console log: Dec 12, 2021 12:09:07 PM org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation INFO: HHH000204: Processing PersistenceUnitInfo name: default ... Dec 12, 2021 12:09:07 PM org.hibernate.Version logVersion...
-
I have a OneToMany collection.. I can edit each element of the collection. I can create a new element. I can also Add an element: then a view opens from which I can select an element. The problem is that a default view is generated from the definition of the entity and the result is quite unusable. I can customize the tab view, but for some reason the changes to the view are lost when the window is closed. I am sure that there must be a way to define the view. but I cannot find it in the documentation....
-
Dear Javier, While implementing the change suggested by you I made mistake. Now it works !!! Thank you very much!!
-
Dear Javier, Thanks. I dis as suggested. But now I get this message: "Impossible to execute From to action: class java.math.BigDecimal cannot be cast to class com.braedius.plx.model.WarehouseBin (java.math.BigDecimal is in module java.base of loader 'bootstrap'; com.braedius.plx.model.WarehouseBin is in unnamed module of loader org.apache.catalina.loader.ParallelWebappClassLoader @5e21e98f) " I suppose you know the cause of this message. Thanks in advance.
-
I have two tables - Table with movement transactions with qty moved between two storage bin in a warehouse - Table with warehouse storage ins, with an attribute qty The first "movement" table refers to the second warehouse bin table. The movement table contains an action which performs the movement. The GUI part of the action works . However the changes in the referred table are not persisted. The two queries performing the lookup of the two From and To warehouse bins works. I have been looking at...
-
I do a lookup in a table in a ManyToOne relationship. Although I have a referenceView "Simple" defined, I get a view with more columns. When I want to sort on one of the columns I get a pupup "loading" and the in the calling page the following message: ERROR: Cannot invoke "String.indexOf(int)" because "modelName" is null. After I do a page refresh the "loading" stops and the views does the sorting as expected. What can be wrong ?
-
Dear Javier, filesPath=d:/dmrtest is correct and works. I made a nasty mistake ; on the same line of the path definition a single character was not deleted . A good lesson for nay body who changes something in the properties file !! Thanks for spending your time.
-
I changed to filesPath=d:\dmrtest to filesPath=d:\dmrtest Now the path is recognized properly but still get error SEVERE: java.io.File(d:\dmrtest ).mkdir()==false && java.io.File(d:\dmrtest ).exists()==false java.lang.RuntimeException: java.io.File(d:\dmrtest ).mkdir()==false && java.io.File(d:\dmrtest ).exists()==false What is wrong ?
-
I want to store files in d:\dmrtest I configure in properties filesPath=d:\dmrtest That does not work ; I get an error Aug 21, 2020 10:17:02 PM org.openxava.web.editors.FileSystemPersistor <clinit> SEVERE: java.io.File(d:\XavaProject\openxava-6.3.2\workspace\Test\dmrtest ).mkdir()==false && java.io.File(d:\XavaProject\openxava-6.3.2\workspace\Test\dmrtest ).exists()==false java.lang.RuntimeException: java.io.File(d:\XavaProject\openxava-6.3.2\workspace\Test\dmrtest ).mkdir()==false && java.io.File(d:\XavaProject\openxava-6.3.2\workspace\Test\dmrtest...
-
I overlooked the capabilities of @Tab. That meets my requirments. Easy and powerful. As everything in OpenXava
-
No, This demo of the toys management is not what I mean. In openxava one can define named views such as Simple or Detail. In this list on can precisely define which fields are show and in which order. As far as I can see in the documentation there is not such possibility for the definition of a View named "List" which can be defined precisely and which one can define in the Application definition like Detail. Or did I overlook something? Met vriendelijke groeten, Kind regards, Frank Messie Braedius...
-
The layout of the List view can be defined by the user in a very powerfull way. However, this customization is not persistent. Is there a way to define the layout persistent and server based in stead of user session based ? Such as it is possible to define a Detail view. If this is not possible, why not ?
-
Not very clever of me. Careful checking of all cascade setiings solved the problem
-
I have a table where there is a record which I wnat to delete. I get a mesage Cannot delete object in row 0 with key {oid=f49d432a-fff9-44c4-a601-ae31f3b77f3b} What to do ?
-
Is there some guidance in the documentation on importing csv files which have been exported by openxava. I get erross but I am afraid I make a basix mistake. Thanks
-
Hi Javier, Great stuff. Works perfectly and does exactly what I needed. Thank you very much indeed. Met vriendelijke groeten, Kind regards, Frank Messie Braedius Medical Braedius Medical BV Bikbergerweg 18 1272 PM Huizen,The Netherlands Email: frank.messie@braedius.com Phone: +31(0)358876100 Mobile: +31654665520 Web: www.braedius.com Op di, 09/06/2020 02:27 PM, Javier Paniza javierpaniza@users.sourceforge.net schreef: Hi Frank: You can define your own action for creating a new element in collection...
-
In the Test Org a record is created for an Organisation with some information (properties) that have to be "inherited" by all rganisationUnits that are members of the organisation. So, the work flow is the following: * Create the Organisation : we see an empty collection organisationUnits. * We click on the button NEW ( in the header of the collection): a window opens for the new organisationUnit (detail) with a number of properties which we should enter for the organisationUnit. but also two properties...
-
Hi Serge, Thanks for your reaction. That is just what I had done. But it does not work The action does not have access to the master properties. I use the folowing code The master import java.util.; import javax.persistence.; import org.openxava.annotations.*; @Entity public class TestOrg extends Identifiable { @Column (length=10) private String orgId; @Column (length=30) private String orgName; @OneToMany (mappedBy ="testOrg", fetch=FetchType.LAZY, cascade = CascadeType.REFRESH) @ListProperties("testOrg.orgId,...
-
Hi everybody, I have an entity Organisation which is master of an entity OrgUnit which is a collection of children. When I create a new Orgnaisation record I also want to creata OrgUnit child and while doing that I want to run an action (OrgUnit) which has to access properties of the Organisation record. The Action should have a statement like this Object organisationId = getView().getValue("organisation.organisationtId"); What should I do to get this working? Thanks for any tips.
-
I have a "item" Entity ( a table with parts of a technical design). There are revisions of each item like A, B, C etc. What is the easiest way to create a copy of an Item record where only the Revision letter has to be changed and fields like "date" and "description". Any suggestion ? Thanks in adavnce .
-
I forgot to mention I used Firefox to test . Works perfectly. Best regards, Vriendelijke groeten, Frank Messie Braedius Medical B.V. Mobile +31-654665520 The Netherlands On May 12, 2020 18:25:55 "Javier Paniza" javierpaniza@users.sourceforge.net wrote: Hi Frank, I just choose Dutch as my preference language in Chrome and it shows comma for decimal, as attached. I test this with: https://openxava.org/InvoiceDemo/m/Product?detail=1 Try it with your browser and tell me if it shows the decimal comma....
-
Hi Javier, This works !! Great. The date format is handled propely as well!! Thanks a lot. Met vriendelijke groeten, Kind regards, Frank Messie Braedius Medical Braedius Medical BV Bikbergerweg 18 1272 PM Huizen,The Netherlands Email: frank.messie@braedius.com Phone: +31(0)358876100 Mobile: +31654665520 Web: www.braedius.com On Tue, 12/05/2020 06:26 PM, Javier Paniza javierpaniza@users.sourceforge.net wrote: Hi Frank, I just choose Dutch as my preference language in Chrome and it shows comma for...
-
Javier, I made a mistake the locale code should be nl (and not nld). If a put MyLocalDateFormatter in org.openxava.formatters (with exactly the same content as LocalDateFormatter ) I get the same error. I hope you can help. Met vriendelijke groeten, Kind regards, Frank Messie Braedius Medical Braedius Medical BV Bikbergerweg 18 1272 PM Huizen,The Netherlands Email: frank.messie@braedius.com Phone: +31(0)358876100 Mobile: +31654665520 Web: www.braedius.com On Mon, 11/05/2020 09:38 PM, Frank Messie...
-
Javier, I have created in my project a package for formatters. There I have put the MyLocalDateFormatter class. I think I also had to copy the iFormatter class..... is that correct ? But now I get an error: An exception occurred processing [xava/editor.jsp] at line [63] In the GUI I see in red ERROR: An exception occurred processing [xava/editor.jsp] at line [63] 60: String required = view.isEditable() && p.isRequired() ? style.getRequiredEditor():""; 61: %> 62: '/>" class="xava_editor <%=required%>"...
-
Hi Javier, Should I create the MyLocalDateFormatter class in openxava/org.openxava/src/formatters ? What happens when a new release of OpenXava is installed ? Or should I create it somewhere in my own project folder ? Thanks. Frank Email sent using Axigen Free Mail Server: http://www.axigen.com/mail-server/free
-
How should I change the format of the Stereotype localDate ? At an application level independent of the locale ? Any help very much apporeciated ?
-
The decimal notation does not chnage when the locale changes. When chnaging from loacal USEnglish to Dutch the currency symbol changes to € but the decimal point does not chnage to decimal comma, How should one change the number notation at an application level (or Entity level) ? Any clear help is appreciated.
-
OX uses by default the currency symbol as defined by locale for the browser host. I need to change that currency symbol to a symbol applicable for the application (independent of the locale ). In understand I have to do the following 1. define a stereotype for example "MONEY-GBP" 2. create an editor for thet stereotype But then I get lost. In the default editor for MONEY I cannot find a reference to definition of the currency symbol. Please note that the solution should appply to a property in an...
-
I am afraid I did something wrong with a colloer. Now I get the following exeption. org.openxava.util.ElementNotFoundException: Session object naviox_locked not found in controllers.xml How to get rid of this issue?
-
I need to show the amount of money in the Europen format like 000. 000,00 (decimal comma) and wih the currency symbol for the Euro. How can this be done? How can this may be made dynamic , so GBP and with decimal point for a British customer. Any help appreciated.
-
Dear Javier, Thanks I have got this working. I am very impressed by the OpenXava framework. It is really very productive. Met vriendelijke groeten, Kind regards, Frank Messie Braedius Medical Braedius Medical BV Bikbergerweg 18 1272 PM Huizen,The Netherlands Email: frank.messie@braedius.com Phone: +31(0)358876100 Mobile: +31654665520 Web: www.braedius.com On Mon, 27/04/2020 01:06 PM, Javier Paniza javierpaniza@users.sourceforge.net wrote: Hi Frank, Try this: public class OnChangeItemTypeAction extends...
-
Serge , Thanks. That explains the plural words. Any idea about the problem caused by the renaming of an Entity . That is quite serious as the application does not complile anymore? I have been scanning through all files but cannot find a clue.
-
Not essential but I just wnat to understand: In my menu all modules names are singular: @Entity Item is "Item", buut.. Product becomes "Produ cts" Customer becomes "Customers". I cannot find the seeting which is causing this . Anybody knows the reason: An issue that may be related: I changed (refactored) the name of a module from ItemAssembly to ItemBOM . After that change to application will not load anymore (the sign-in is loops every time) and says on the console: apr 26, 2020 8:43:36 PM com.openxava.naviox.Modules...
-
correction; Eclipse underlines getitemTypeCode()
-
Dear Serge, Thanks for your suggestion. But for some reason I don't get it working. I have a a getter for the ManyToOne itemType. But when I say private String test; test= getView().getValue('itemType").getItemTypeCode() ; Eclipse responds with underlining itemTypeCode(). What am I doing wrong ?
-
Hi Javier, I am struggling with a lack of Java knowledge. In the @Entity Item I have: @Entity @View(name="itemView" , members= "itemType; itemTypeCode, itemNumber, revision, itemId, engChange; itemName, itemDescription; dmr, dhf; supplier" ) public class Item extends Identifiable{ @ManyToOne (fetch=FetchType.LAZY, optional=true) @ReferenceView("Simple") @OnChange(OnChangeItemTypeAction.class) private ItemType itemType ; @Column (length=1) private String itemTypeCode; In the Actions package I have:...
-
Hi Javier, Thanks for this help. I have implemented a solution based on a DefaultValueCalculator which is a little smarter ( and more application oriented) than just filling leading zeroes
-
I have a simple lookup Entity "itemType " with two columns "typeId" and "name". There is also an Entiy "Item" with a Manyto One to "ItemType". @ManyToOne(fetch=FetchType.LAZY, optional=true) private ItemType itemType; On one of the columns of "Item" I want to generate a Default Value based on the value of "typeId" selected from the Many ToOne relation. So I pass that value to the DefaultValue Calculator by referring to itemType. Obviously that does not work . In stead I should refer to the typeId...
-
This was the solution I was looking for. Thanks.
-
I want to use to two values that are available in the entity an integer number a string itemtype. I understand that is may not be pssible ? I will think of another way to obtain the the data. I have some ideas.
-
I would like to do something like the following @Column(length = 6) @DefaultValueCalculator(value=ItemIdCalculator.class, properties= @PropertyValue(name="itemType, number")) @ReadOnly private String itemId; But only the first is processed. What is the proper syntax ?
-
My application requires to combine a few fields in an entity into one single field (for example the description field). I could not find an example. Any hints appreciated.
-
I am new to OpenXava and have been scanning the extensive documentation I could not find a simple way to format an integer field with leadingzeros int 1 should be represented as 00001. Any suggestion is appreciated
-
Dear Javier, Thanks for your answers. I think I had already found the solution. Using UUID with Postgres works very well wit the following setting @GenericGenerator(name="uid2", strategy = "uuid2") @GeneratedValue(generator="uid2") // Universally Unique Identifier Key to the solution is in my opinion strategy="uuid2". I suppose applies to for example MariaDb I suggest to include a short note about this in Lesson 2 of the tutorial. Given this approach I can recommend to use postgres as it is a rock...
-
I have a few requirements when choosing the database for development 1. I would like to use UUID's for our database . 2. I also would like to be able to access the database with other applications. 3. Finally I would like to be able to configure the database in such a way that all data are stored in separate directory This means that I would like to use database tools like Mariadb or Postgres that allow the last two requirements. When I tried to use UUID's with mariadb it did not work. Then I tried...
1
