ADF Desktop Integration (ADFdi)

How to evaluete excel formula in cell of ADF Desktop Integration table component?

Problem I was trying to evaluate excel formula in cell of ADFdi  table component. My try was unsuccessfull, got formula rendered as a literal string in the cell. Solution Apparently when ADFdi plugin evaluates value expression of particular column, it needs to know what kind of output you expect in the cell. Is it a literal value, o some instructions…

Continue Reading

ADF, ADF Exceptions

ADF How to access bind variable from view object row?

Problem I just faced a requirement to pass bind variable value to one of view object attributes LOV. It looks straight forward while we can provide view criteria and bind variable values to LOV’s view object via view accessor: I thought that it should be no problem just to write a groovy expression into parameters value field: adf.object.viewObject.myBindVariable But  I’ve…

Continue Reading

SQL

Get “ORA-56901: non-constant expression is not allowed for pivot|unpivot values” ? Not a big deal, check a workaround!

Problem Get “ORA-56901: non-constant expression is not allowed for pivot|unpivot values” while trying to execute SQL statement with pivot clause. Lets consider this tiny sample: Here is the table:   SQL statement with PIVOT clause and constant expressions, which executes successfully: SQL statement with PIVOT clause and dynamic expressions, which fails: Solution Workaround – just don’t use PIVOT at this…

Continue Reading

ADF

ADF application layout messed up after migration to 12.2.1 … What might be the reason ?

Problem: After migration of ADF application from 12.1.3 to 12.2.1 layout was messed up. In particular – component stretching was disordered. Reason: As ADF is going step by step to adaptive layouting, component stretching is optimized accordingly. In version 11.1.1.7 new context parameter was introduced: oracle.adf.view.rich.geometry.DEFAULT_DIMENSIONS. It basically tells what dimensions for stretchable components should be applied by default. For example…

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, JDBC

How to select all JDBC Database Change Notification Registrations and clean them?

Question: How do I select all database change notifications registered via JDBC driver by my DB user? Answer: select * from user_change_notification_regs Question: How do I clean all of my DB change notifications? Answer: Database change notifications registered via JDBC driver can be deregistered only the same way – using JDBC driver. Therefore you need to execute this code: This…

Continue Reading

ADF, ADF Application Module

I get JBO-25200: Application module is not connected to a database exception. What can be the reason?

Problem Time to time “JBO-25200: Application module is not connected to a database” exception is raised while browsing ADF application Solution Tune ADF application module by disabling “Support Dynamic JDBC Credentials”. However this solution may not work in your case, depends on the root cause. Comment If I understand this option correctly, it is needed only when application users must…

Continue Reading