ADF

How to implement contextual events between parent page and region?

   Contextual events are necessary when need to communicate between separate regions or between parent page and region in ADF application. Here I’ll describe one approach to implement this. It is a little improvement of classic approach, because of event handling java interface is created and event consumer is implementing it. It is convenient, when need to separate data control…

Continue Reading

ADF, ADF Desktop Integration (ADFdi), ADF Exceptions

ADF Desktop Integration Excel worksheet exception on upload operation: ArgumentException: invalid area string: N5:Q5,S5

Full exception stack: ArgumentException: invalid area string: N5:Q5,S5 Source: adfdi-excel-om-api Stack: at oracle.adf.client.windows.excel.om.api.ExcelRangeAreas.ParseRangeAddress() at oracle.adf.client.windows.excel.om.api.cache.ExcelRangeCache.get_RangeAreas() at oracle.adf.client.windows.excel.om.api.ExcelRangeReader..ctor(ExcelRange range, Int32 maxRows) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.InitDataRangeIterator() at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.ProcessRows(Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.TableOperationHelper.Run(RTColumn rtColumnFlaggedOrChanged, Int32 cRowsFlaggedOrChanged, Boolean abortOnFail) at oracle.adf.client.windows.excel.runtime.uicomponent.table.DEGUploadHelper.Upload(Boolean haveOptions, Boolean abortOnFail, Boolean downloadAfterUpload) at oracle.adf.client.windows.excel.runtime.uicomponent.RTDataEntryGrid.Invoke(RTComponentAction rtAction) at oracle.adf.client.windows.excel.runtime.uicomponent.RTActionCollection.DoInvoke(RTColumnCollection parent) This exception is thrown when data upload to server is requested. Range N5:Q5,S5 specifies cells…

Continue Reading

ADF Desktop Integration (ADFdi)

ADF dekstop integration (ADFdi) plugin with macro enabled file doesn’t work when opened from MS Internet Explorer. File is opened but nothing is loaded. Why?

Actually this is not an issue or bug, it is not even directly related to ADFdi. Everything work as supposed to 🙂 ADFdi plugin can’t function properly, because Excel opens file in a protected view. This happens because AES (Attachment Execution Services) marks file as downloaded from internet (only MS IE and Outlook can do this). Before showing file contents…

Continue Reading

ADF, JDeveloper, SQL and PL/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

ADF, ADF Desktop Integration (ADFdi), ADF Exceptions

ADFDI-00502: The client was unable to establish an unauthenticated session with the web application. What can be the reason?

I have experienced such error. The reason was, that web application didn’t know, that servlet “adfdiRemoteServlet”, responsible for Excel workbook connectivity, should be secured. Problem happens only when ADF security is set to “ADF Authentication and Authorization”. This means, that ADF takes care not just for login, but for access to various resources (in our case it is adfdiRemoteServlet) as…

Continue Reading

ADF, SOA and BPM, Weblogic

How to configure local integrated WebLogic non-SOA domain to access BPM worklist on separate SOA-enabled domain?

ADF and BPM task flow on separate domains? No doubt this is frequent issue for developers working with ADF/BPM.There are several advantages to have it working: No need to install SOA stuff locally if You’re developing just ADF Faster deployments to integrated WebLogic Possibility of debugging Isolated ADF enviroment for developing In my case the last one was most important.…

Continue Reading

ADF

Submit of ADF selectManyShuttle pre-selected values without pre-selection change

Our requirement is to implement af:selectManyShuttle with preselected values. New records in database table must be created according to selected values. If user change something in the selection, everything works fine. But if user agrees with default selection and does not want to do any changes and just submits a form, we have a problem – nothing is submitted. af:selectManyShuttle…

Continue Reading

Logging, Weblogic

How to filter OSB logging and redirect log records to any desirable destination?

The best practice to accomplish this task is to use Weblogic server startup class. In this class we should take Weblogic server “Logger” object and use it to attach additional appender. This appender can be implemented to redirect log messages to any destination You prefer. Log4j supports dozen of standard destinations, providing built in appenders like JDBCAppender, JMSAppender, FileAppender and many…

Continue Reading