tag:blogger.com,1999:blog-5874979429188093780.post3123083430007219146..comments2024-03-18T06:46:54.352+01:00Comments on Andrej Baranovskij Blog: JDeveloper 11g - Create, Edit and Delete operations in ADF Faces af:table componentAndrej Baranovskijhttp://www.blogger.com/profile/04468230464412457426noreply@blogger.comBlogger36125tag:blogger.com,1999:blog-5874979429188093780.post-75925008577074398322017-07-17T03:34:54.487+02:002017-07-17T03:34:54.487+02:00Hi Andrejus,
I am using 11g PS3. IT is working ve...Hi Andrejus,<br /><br />I am using 11g PS3. IT is working verygood.<br /><br />I have a requirement to implement sequence for job id, but when i implement a sequence and when i create a new row it is in read only mode.<br /><br />Can you please help me with this scenario.<br /><br />Thanks<br />varmarakeshhttps://www.blogger.com/profile/10240982156025398313noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-17935896332392552642014-03-10T15:11:31.152+01:002014-03-10T15:11:31.152+01:00Hello I am new to ADF, I would like to know if you...Hello I am new to ADF, I would like to know if you have an example of an ADF table with basic CRUD functionality, but you can choose which rows will save, by selecting a row for selectBooleanCheckbox. It is possible? <br />Please I need help. <br />Thank you very much.caromevahttps://www.blogger.com/profile/10222025210335284423noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-26435228743725889702012-05-30T08:35:25.300+02:002012-05-30T08:35:25.300+02:00Hi,
Yes - may be this post will help you: http://...Hi,<br /><br />Yes - may be this post will help you: http://andrejusb.blogspot.com/2008/09/jdeveloper-11g-crud-in-adf-form.html<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-68180070637932568182012-05-30T04:41:53.782+02:002012-05-30T04:41:53.782+02:00Hello,
How could I add the row in a Form instead o...Hello,<br />How could I add the row in a Form instead of a table? Same logic? for 11g.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-80482173222062264362011-08-11T13:38:25.617+02:002011-08-11T13:38:25.617+02:00can
you help me.
http://forums.oracle.com/forum...can <br /><br />you help me.<br /><br />http://forums.oracle.com/forums/thread.jspa?threadID=2267085&tstart=0Anonymoushttps://www.blogger.com/profile/03000233582008397917noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-19011532721024185132011-06-09T18:05:21.355+02:002011-06-09T18:05:21.355+02:00Hi ,
I got the issue, actually after deleting the ...Hi ,<br />I got the issue, actually after deleting the row, in my EOImpl of that vo,in the DoDml() method i was trying to set the lastUpdatedBy column value and since the row is already deleted it was not able to find a reference which was throwing the error .<br />Foe resolution, i am now checking the state of the row by <br /> if (this.getEntityState() != STATUS_DELETED)<br />and executing accordingly .<br /><br />Thanks<br />SumitSumit Yadavhttps://www.blogger.com/profile/14099430819984098962noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-72817059274341902572011-06-09T00:18:36.506+02:002011-06-09T00:18:36.506+02:00Hi Andejus,
After selecting the row in my adf tabl...Hi Andejus,<br />After selecting the row in my adf table I am clicking delete and it deletes the row but when i press save and tries to commit the transaction, it throws <br />"Attempt to access dead entity in xyzEO, key=oracle.jbo.Key[10 ] <br /><br />Any pointers ??<br /><br />Thanks<br />Sumit YadavSumit Yadavhttps://www.blogger.com/profile/14099430819984098962noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-81852447983149970462011-05-12T08:57:56.519+02:002011-05-12T08:57:56.519+02:00Hi Andrejus
I am a newbie and have read most of yo...Hi Andrejus<br />I am a newbie and have read most of your works/posts in the internet. Do you have anyother consolidated source where I can get all the information you post?<br /><br />I have some questions regarding this post btw:<br />1. when you set disabled property in the cancel button for eg., you also set which other button has to be disabled at the time this cancel button is enabled. For instance we have !valueHolder.editAction for the disabled property for cancel btn. The questio I have is how this is set or unset using the bean as I see no direct method being called and only the property. how the set/unset take place as you dont explicitly set a listener. The last question is I dont understand the af:setactionlister that well as I dont find any doco on this on the net. please find some time to help<br />Thank you<br />LesLesnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-79479988349571651482011-04-15T13:27:28.254+02:002011-04-15T13:27:28.254+02:00Hi, Andrejus Baranovskis,
You are so efficient. C...Hi, Andrejus Baranovskis,<br /><br />You are so efficient. Cool!<br /><br />Best Regards,<br /><br />AlfredAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-13789066518723902012011-04-02T21:32:46.948+02:002011-04-02T21:32:46.948+02:00Hi,
I have updated sample application, it works n...Hi,<br /><br />I have updated sample application, it works now on 11g PS3. Please download again ;)<br /><br />AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-61584124238002676622011-04-02T15:08:56.301+02:002011-04-02T15:08:56.301+02:00Hi, Andrejus Baranovskis,
Your solution is really...Hi, Andrejus Baranovskis,<br /><br />Your solution is really nice. But when deploy it in JDev 11.1.1.4, after click "Edit" button, then click "Cancel" button, all the rows become editable. Did you ever see this phenomenon?<br /><br />Really appreciate if you can have a look!<br /><br />Best Regards,<br /><br />AlfredAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-77907886184523060802011-02-03T07:32:49.223+01:002011-02-03T07:32:49.223+01:00To- Andrejus Baranovskis
How to insert new record...To- Andrejus Baranovskis<br /><br />How to insert new record in database using ADF form in jdeveloper 11g? How do I use createInsert operation to insert new record?Nileshhttps://www.blogger.com/profile/14974449023394503780noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-69183759539408406792009-12-22T02:55:48.193+01:002009-12-22T02:55:48.193+01:00Hi,
I am following the same example for one of my...Hi,<br /><br />I am following the same example for one of my requirement but i found that On create operation if any DB validation failed i found that table row has became read-only. But same thing is not happening on the Edit.<br /><br />Please guide me how to resolve this issue.Vihaanhttps://www.blogger.com/profile/12649435496996728386noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-24416991826887983042009-09-14T21:24:30.072+02:002009-09-14T21:24:30.072+02:00Hi, wonderfull post I have the problem java.lang.N...Hi, wonderfull post I have the problem java.lang.NullPointerException with the create method, and I already remove the af:validator but still the same, any clue?escapasinlimiteshttps://www.blogger.com/profile/10237266196343967352noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-65957358206690928902009-06-12T03:44:15.146+02:002009-06-12T03:44:15.146+02:00Just found that we can remove the selected row by ...Just found that we can remove the selected row by using the tichTable::getSelectedRowKeys().clear();<br /><br />ThivaThivaharhttps://www.blogger.com/profile/15188646753369169687noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-53537660479115208192009-06-11T14:11:09.470+02:002009-06-11T14:11:09.470+02:00Hi Andrejus,
May i know how can i remove the sele...Hi Andrejus,<br /><br />May i know how can i remove the selected row in ADF table using the code. I need to remove the selected row when another action occurs. So i have the actionListener and the blinded RichTable reference in my backing bean.<br /><br />ThivaThivaharhttps://www.blogger.com/profile/15188646753369169687noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-20875608147586919102008-11-07T17:03:00.000+01:002008-11-07T17:03:00.000+01:00Hi Andrejus,I found that my specific problem with ...Hi Andrejus,<BR/><BR/>I found that my specific problem with JDEV 11G and this create edit delete table is something to do with the cancel button and Rollback.<BR/><BR/>When I add a new row and decide I want to cancel, it won't get rid of the new row.<BR/><BR/>Any thoughts ?<BR/><BR/>MarkAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-2880291211381267892008-11-05T00:05:00.000+01:002008-11-05T00:05:00.000+01:00Thanks for your wonderful blog. I'm also new t...Thanks for your wonderful blog. I'm also new to Jdev11g & so may I ask how I could achieve this functionality? What I would like to do is to show a popup dialog and prompt users for input instead of inline row editing. So, how do I detect whether a row is being selected to disable/enable the Edit button accordingly? Using your example, I tried this EL expression but it does not seem to work. Am I missing sth?<BR/><BR/>disabled='#{bindings.JobsView1Iterator.currentRow== null}'<BR/><BR/>Thanks in advance,<BR/>PhilAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-40213594677067455172008-11-04T18:25:00.000+01:002008-11-04T18:25:00.000+01:00Thanks so much.Thanks so much.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-64902830372022941982008-11-04T18:24:00.000+01:002008-11-04T18:24:00.000+01:00I will test it, will post update.Regards,AndrejusI will test it, will post update.<BR/><BR/>Regards,<BR/>AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-75771105661649867172008-11-04T17:10:00.000+01:002008-11-04T17:10:00.000+01:00Hi Andrejus,I am having difficulties making this w...Hi Andrejus,<BR/><BR/>I am having difficulties making this work from scratch in the new JDEV 11G release.<BR/><BR/>When I add a row, enter nothing and hit cancel the rollback does not clear away the row.<BR/><BR/>Can you test this example out in 11g and see if it works for you?<BR/><BR/>MarkAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-11062989915614771812008-10-02T22:57:00.000+02:002008-10-02T22:57:00.000+02:00Hi,I know how to solve your problem. Its a bug in ...Hi,<BR/><BR/>I know how to solve your problem. Its a bug in TP4 JSF library.<BR/><BR/>Temporary and quick solution is to remove f:validator tags for all columns in the table. It will solve this problem.<BR/><BR/>Regards,<BR/>AndrejusAndrej Baranovskijhttps://www.blogger.com/profile/04468230464412457426noreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-91795746014161523052008-10-02T15:46:00.000+02:002008-10-02T15:46:00.000+02:00I get the same error. I just tried to implement my...I get the same error. I just tried to implement my own version and on the two mandatory fields in my table, I get a nullPointerException in the ADF popup error box. Any thoughts ?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-70624394276204849032008-07-16T14:10:00.000+02:002008-07-16T14:10:00.000+02:00following this example(yours), i created a new one...following this example(yours), i created a new one. after execution on browser, when i performs the second action (for any action like sorting: first action is desc then the second action asc) it returns the error like this:<BR/>Messages for this page are listed below.<BR/>Empno Error <BR/>java.lang.NullPointerException<BR/>Empname Error <BR/>java.lang.NullPointerException<BR/>Empdob Error <BR/>java.lang.NullPointerException<BR/>Salary Error <BR/>java.lang.NullPointerException<BR/><BR/>plz.. help meAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-5874979429188093780.post-50729601185935843132008-05-28T15:01:00.000+02:002008-05-28T15:01:00.000+02:00Hi Andrejus, I actually got a method that calls a ...Hi Andrejus,<BR/><BR/> I actually got a method that calls a for loop over the RowKeySet to delete the rows that are selected with ctrl+mouse click. The rows get deleted from the UI and the table refreshes to reflect the remaining rows. But I am facing an issue with commit...<BR/><BR/>The error is that that "JBO 25019: Entity Row of Key oracle.jbo.key[*KeyValueHere*] not found in DetailEO.<BR/><BR/>The method that I added to the manage bean to perform the delete is:<BR/><BR/>public void onDeleteLevel1(ActionEvent actionEvent) {<BR/> <BR/> FacesContext fctx = FacesContext.getCurrentInstance();<BR/> Application application;<BR/> application = fctx.getApplication();<BR/><BR/> ELContext elctx = fctx.getELContext();<BR/> ExpressionFactory exprfactory = application.getExpressionFactory();<BR/> <BR/> ValueExpression valueExpression = exprfactory.createValueExpression<BR/> (elctx,"#{bindings}",Object.class);<BR/> DCBindingContainer dcbinding =<BR/> (DCBindingContainer) valueExpression.getValue(elctx);<BR/> <BR/> FacesCtrlHierBinding treeRootNode =<BR/> (FacesCtrlHierBinding) dcbinding.get("RatingLevel"); <BR/> <BR/> RowKeySet rowKeySet = (RowKeySet)getRatingsTable1().getSelectedRowKeys();<BR/> for (Object facesTreeRowKey : rowKeySet) {<BR/> getRatingsTable1().setRowKey(facesTreeRowKey);<BR/> JUCtrlHierNodeBinding rowData =<BR/> (JUCtrlHierNodeBinding) getRatingsTable1().getRowData();<BR/> ((JUCtrlHierNodeBinding)treeRootNode.getCollectionModel().<BR/> getRowData()).getRow().remove();<BR/> } <BR/> } <BR/><BR/>I read that the error is caused because the remove() operation will cause the entity row to be removed from cache. <BR/><BR/>Can you please suggest how do I update the cache to retain the lock and then perform the commit.<BR/><BR/>Thanks,<BR/><BR/>ArunAnonymousnoreply@blogger.com