ADF, JDeveloper

How to deploy ADF application with different name using JDeveloper?

Sometimes there might be a case, when development team shares one WebLogic server instance and each developer needs to deploy and test the same application at the same time. Or whatever the reason it is, there are some simple steps needed to be accomplished in JDeveloper to have another instance of the same application just with different context root. Assuming…

Continue Reading

ADF, JDeveloper

JBO-26041: Failed to post data to database during “Update”… What might be the reason?

Problem: Exception during data save is thrown: oracle.jbo.DMLException: JBO-26041: Failed to post data to database during “Update”: SQL Statement “UPDATE… It might be followed by similar to this one: java.sql.SQLException: Fail to construct descriptor: Unable to resolve type “NVARCHAR2″… Solution: Check if  SQLType attribute of an entity/view object attribute being updated is correct. For example it can be set to…

Continue Reading

ADF, Continuous Query Notification, JDBC, JDeveloper

Override inputListOfValues component model and Continuous Query Notification sample in ADF

Requirement: Standard ADF inputListOfValues component should behave like this: When pressed “Search”, action should stop and wait untill any change happen in DB table being searched When change happen in DB table, search should resume among updated data. If no change happen it should resume after 10 seconds timeout In addition – search input field validation should happen on “Search”…

Continue Reading

ADF, DB Change Notification, JDeveloper, WebSocket

WebSocket together with DB Change Notification in ADF for immediate data refresh in browser (complete sample).

Requirement We have DB table contents displayed in ADF GUI After changes in that DB table (by anyone else in the background) we want to immediately display in our currenlty open browser session Solution To achieve our goal we need somehow to know when changes in DB happen. Once we know when, need to notify browser session in order it…

Continue Reading

ADF, JDeveloper

How to iterate through all view object rows irrespective of specified range size and without impact to current rowset?

ProblemImagine we have iterator binding EmployeesViewIterator with specified range size 25. But we want to iterate through ALL employees available, not just 25 of current range. Solution Create new row set iterator from EmployeesView view object. It will contain ALL rows irrespective of specified range size. Iterate it ! DCIteratorBinding it = (DCIteratorBinding)BindingContext.getCurrent().getCurrentBindingsEntry().get(“EmployeesViewIterator”);RowSetIterator rsi = it.getViewObject().createRowSetIterator(null);   while (rsi.hasNext()) {     Row row = rsi.next());   …

Continue Reading

ADF, JDeveloper, SQL, Weblogic

How to change logging level of standalone or integrated WebLogic in JDeveloper? For example how to capture SQL executed?

In Integrated WebLogic (JDeveloper) this can be done with just few clicks: Open “IntegratedWeblogicServer – Log” window. On the right-hand top corner click “Actions” and choose “Configure Oracle Diagnostic Logging” For getting SQL statements in the output, in the opened logging.xml choose “oracle.jbo” logger with desired logging level. Level “Finest” will generate maximum output. SQL staements shoud definitely be there.…

Continue Reading