tag:blogger.com,1999:blog-5874979429188093780.post4274039926785683094..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: CRUD Operations in Oracle ADF 11g Table Using PopUp ComponentAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger50125tag:blogger.com,1999:blog-5874979429188093780.post-65851116991995042652016-11-01T11:28:32.265+01:002016-11-01T11:28:32.265+01:00very helpful, thanks you Andrejus Baranovskis
very helpful, thanks you Andrejus Baranovskis<br />fayzahttps://www.blogger.com/profile/06113226806373852229noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-43961142737799102902015-04-24T19:14:51.282+02:002015-04-24T19:14:51.282+02:00Hi. i'm new on adf world and im trying to call...Hi. i'm new on adf world and im trying to call CreateWithParams from backing bean, to catch exception and execute rollback method.<br />Or you can help me to call rollback method on entity validator and call rollback without losing current row?huaymashttps://www.blogger.com/profile/05013810852738159274noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-89339707801877620562013-06-18T11:05:22.037+02:002013-06-18T11:05:22.037+02:00Yes, should be possible.
AndrejusYes, should be possible.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-22370779734393923902013-06-18T11:01:14.618+02:002013-06-18T11:01:14.618+02:00Nice Post.
Is it possible to invoke the popup on ...Nice Post.<br /><br />Is it possible to invoke the popup on mouse over over a table row?<br /><br />Thanks,<br />NachiAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-47829148287137595712013-04-18T07:33:29.326+02:002013-04-18T07:33:29.326+02:00Hi,
PopUp is better as described in this post, is...Hi,<br /><br />PopUp is better as described in this post, is more lightweight. But anyway, I have in 2009 posted CRUD with dialog as well: http://andrejusb.blogspot.com/2009/11/crud-operations-in-jdeveloperadf-11g-r1.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-54453308547109644222013-04-17T22:42:32.087+02:002013-04-17T22:42:32.087+02:00Hello Andrejus,
Thank You for great post!
We pla...Hello Andrejus,<br /><br />Thank You for great post!<br /><br />We plan to use many CreateEdit popop windows for CRUD operations (like in Your example).<br />I also found example where Edit Page and Bounded TaskFlow as Popup are used.<br />http://jneelmani.blogspot.com/2012/12/adf-how-to-implement-create-edit.html<br />Just I wonder, which method is recommended to use. What are advantages and disadvantages?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-8044003875839757912013-04-05T06:24:55.863+02:002013-04-05T06:24:55.863+02:00Sure, you need to add CreateInsert in page definit...Sure, you need to add CreateInsert in page definition. Keep in mind - I never have a goal to describe every little step, thats why I post sample code - for the reader to look and research by himself as well, otherwise it would be too easy :-)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-28296647684492430492013-04-04T22:13:28.913+02:002013-04-04T22:13:28.913+02:00Actually, it looks like the step to add CreateInse...Actually, it looks like the step to add CreateInsert to the page's binding's is missing. Once I did that I was able to replicate the page just fine.<br /><br />Just go to your pages bindings table and add the CreateInsert operation.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-84209761701777695612013-02-12T07:06:38.363+01:002013-02-12T07:06:38.363+01:00I guess you forgot to call CreateInsert operation ...I guess you forgot to call CreateInsert operation as Task Flow initializer method, before loading fragment in the popup.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-92123648139988218232013-02-12T07:03:45.456+01:002013-02-12T07:03:45.456+01:00Hi sir,
I am trying to implement this
examp...Hi sir,<br /> I am trying to implement this<br />example. When I try to add a new record with the popup, the popup fields are non-editable. What can be the mistake?<br /><br />Infanta. infantafdohttps://www.blogger.com/profile/11843241284094049214noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-89939364419007439672012-04-02T12:45:15.638+02:002012-04-02T12:45:15.638+02:00Hi Andrejus
i'm trying to reproduce this examp...Hi Andrejus<br />i'm trying to reproduce this example in HR shema using ADF 11.1.2.1 and keep geting a strange mistake: every time Insert button is pressed, popup is showing with a blank row following a message "Error: A value is required" for each required attribute. Like some kind of submit is invoked, but I'm not able to resolve this. Can you help me?MarioKhttps://www.blogger.com/profile/17092512230136516758noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-60549848005173378032012-02-03T09:33:13.556+01:002012-02-03T09:33:13.556+01:00Make sure these 3 properties are set in your table...Make sure these 3 properties are set in your table:<br /><br />selectedRowKeys="#{bindings.DepartmentsView1.collectionModel.selectedRow}"<br /> selectionListener="#{bindings.DepartmentsView1.collectionModel.makeCurrent}"<br /> rowSelection="single"<br /><br />Looks like row selection is not executing correctly.<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-32802423752964662322012-02-02T22:00:12.238+01:002012-02-02T22:00:12.238+01:00Hi,
I'm new in ADF, sorry if this question i...Hi, <br /><br />I'm new in ADF, sorry if this question is Dummy. I'm trying to implement this example, the difference is that mi View Object has a where condition with a parameter (because i need to show some data of the table, not all of them). Also, in the bindings section, I have an ExecuteWithParams action and an InvoqueAction with always refresh to show the data when the page load. <br /><br />When I try to add a new record with the popup, it always edit the first record of the table. What should i do to show the filtered data and insert new rows with the popup?.<br /><br /><br />Thanks in advance and sorry for my english.Cgpradanoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-36786354213174703672011-10-18T11:13:45.591+02:002011-10-18T11:13:45.591+02:00You may try to use Row.REFRESH_UNDO_CHANGES. Check...You may try to use Row.REFRESH_UNDO_CHANGES. Check this post: http://andrejusb.blogspot.com/2008/09/jdeveloper-11g-crud-in-adf-form.html<br /><br />Also Chris post: http://one-size-doesnt-fit-all.blogspot.com/2007/02/jdeveloper-and-art-of-rollback.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-67907149653057784312011-10-18T09:41:04.152+02:002011-10-18T09:41:04.152+02:00I have the following scenario. I have two custom b...I have the following scenario. I have two custom buttons on my pop-up, that when 'OK' button is pressed, it submits the form as a new row to the database. I am using 'CreateInsert' operation. When 'Cancel' is pressed, I use the following lines to revert the changes made by 'CreateInsert':<br /><br />OperationBinding operationBinding = getBindings().getOperationBinding("Rollback"); operationBinding.execute();<br /><br />My pop-up is triggered when a value is changed in a dropdown of a table. This makes my popup to appear. Now, when I cancel the popup and revert, I want the value of my dropdown to change back to it's old value, since no change was made. Before, when I was using bindings to update, and not 'CreateInsert', I used this code snippet:<br /><br />DCBindingContainer bindings =(DCBindingContainer)ADFUtils.resolveExpression("#{bindings}");<br />DCIteratorBinding iter = bindings.findIteratorBinding("ItemVO1Iterator");<br />Row row = iter.getViewObject().getCurrentRow();<br />row.refresh(Row.REFRESH_WITH_DB_FORGET_CHANGES);<br /><br />however, after rollback is done, the row I get is always null. I suspect this is because the current row is dropped to the position before the first row. How can I solve this problem, so I can revert the 'CreateInsert' AND also change the dropdown status back to it's original value?Andrejs Daskohttps://www.blogger.com/profile/10744582547029203737noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-27485903648048372232011-10-17T09:40:38.141+02:002011-10-17T09:40:38.141+02:00Yes of course, you can call CreateWithParams progr...Yes of course, you can call CreateWithParams programmatically as you are describing. In order to set parameter values programmatically as well, make sure to use correct EL for NDValus field for NamedData (for example reference value from Request Scope, set before invoking action).<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-67392104335823411952011-10-17T09:22:44.661+02:002011-10-17T09:22:44.661+02:00You may try to use CreateWithParams:
Is there a w...You may try to use CreateWithParams:<br /><br />Is there a way to do that programmatically from a backing bean? I have been using popupFetchEvent to call CreateInsert and it worked just fine:<br /><br />BindingContainer bindings = getBindings();<br />OperationBinding operationBinding = bindings.getOperationBinding("CreateInsert");<br />operationBinding.execute();<br /><br />If I could only call CreateWithParameters and set the parameters in this same method prior to calling execute, that would be exactly what I need.<br /><br />Perhaps, if you know a better way to call this function programmatically, please share.Andrejs Daskohttps://www.blogger.com/profile/10744582547029203737noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-76572029254552334242011-10-15T17:18:59.850+02:002011-10-15T17:18:59.850+02:00You may try to use CreateWithParams: http://andrej...You may try to use CreateWithParams: http://andrejusb.blogspot.com/2011/02/createwithparams-operation-for-oracle.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-65256214191697209252011-10-14T16:23:22.262+02:002011-10-14T16:23:22.262+02:00I was able to implement your approach in my applic...I was able to implement your approach in my application, however I have the following problem. I require some fields to be set by default, and not have every field of the table as an input text field. What is the best way to set these properties?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-71149919143840331032011-08-22T22:57:14.154+02:002011-08-22T22:57:14.154+02:00Hi,
Is there any way of making the popup refre...Hi,<br /> <br /> Is there any way of making the popup refresh on the press of a button??<br /><br />ThanksIM'pRoPeRhttps://www.blogger.com/profile/06570190427323066691noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-54068778996088581072011-08-22T22:55:18.456+02:002011-08-22T22:55:18.456+02:00Hi,
I am trying to add rows to a child table usi...Hi,<br /><br /> I am trying to add rows to a child table using createinsert operation of the child table within a popup. The trouble im having is that on clicking the createinsert (ADF button) the popup closes. But the button performs its task. <br /><br /> Is there any way i can make the popup refresh on the press of the button?<br /><br />Thanks <br />RohinIM'pRoPeRhttps://www.blogger.com/profile/06570190427323066691noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-22740794504530716462010-11-01T05:22:59.089+01:002010-11-01T05:22:59.089+01:00Can you provide any sample for doing that in backi...Can you provide any sample for doing that in backing beanAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-66682556508481577872010-10-29T16:17:54.115+02:002010-10-29T16:17:54.115+02:00Hi,
You can implement this functionality in Backi...Hi,<br /><br />You can implement this functionality in Backing Bean method.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-77620295355979038702010-10-28T08:55:03.992+02:002010-10-28T08:55:03.992+02:00I want the user to give flexibility where he can c...I want the user to give flexibility where he can choose the column and criteria and udpate multiple rows based on that criteria. Say i have a table with columns employee name,age,dept and want to allow user <br />to choose at runtime the column say age and some condition like name age>26 and update all the rows for it.similarly he can use other column and criteria dynamicallyAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-35956652213472465322010-06-17T19:40:32.077+02:002010-06-17T19:40:32.077+02:00Hi,
Didn't reproduced. For me popupCanceledLi...Hi,<br /><br />Didn't reproduced. For me popupCanceledListener is called only when pressing keyboard Cancel button or built-in Cancel button. It is called when closing popup with X. In all other cases, not called.<br /><br />Regards,<br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.com