I’m going to show the basic steps to get ADF Desktop Integration (ADFDI) Excel workbook running. Here is what we need to accomplish: Create Fusion web application with some ADF bussiness components in model layer. Create ADFDI page definition file. This one will be dedicated for excel and provide necessary bindings to be utilised by ADFDI Excel components. Create special…
How to prepare ADF Desktop Integration (ADFDI) bindings to be utilised by Excel worksheet?
In this post I’m going to show how to prepare ADF bindings, which could be utilised by ADF Desktop Integration Excel workbook. This is particularly about type of page definition file, which is special for ADFDI. However just in case I’ll shortly point out to tree and execute action bindings which will be necessary for Excel workbook. In another post…
How to configure ADF Desktop Integration (ADFDI) worksheet to load data automatically on opening?
Assuming that you already have ADFDI excel workbook ready to download data and do it via explicit click of download action (like we did in the post – How to create ADF Desktop Integration (ADFDI) Excel workbook). And now you want to download table data automatically on workbook opening. Here are the steps to be accomplished: Open Worksheet Properties Go…
How to install ADF Desktop Integration (ADFDI) plugin?
Apparently, the very first step needs to be taken before enjoying amazing ADF Desktop Integration (ADFDI) features is installation of ADFDI plugin. It enables desktop integration with MS Excel spreadsheets to manage data from web applications via Excel. Probably the easiest way, which does not need any extra explanation, is just choose Tools -> Install ADF Desktop Integration in JDeveloper. And…
How to adjust WebLogic logging engine to deliver records of desired severity?
In this post I’m going to show how to adjust WebLogic logging levels using Enterprise Manager (EM). I will take as an example tiny demo application for logger demo, which I’ve introduced in my another post – How to add custom logging into ADF application? So this can be done in domain server context. Here is how to reach it: Click…
Location of log records in WebLogic Enterprise Manager (EM)?
In my opinion Enterprise Manager delivers the most convenient way to check log records. It has search and filtering capabilities. It works reliably and provides nice structured information. So where to find them? Lets use tiny sample application which I’ve introduced in my previous post – How to add custom logging into ADF application?. After deploying it to WebLogic server, please…
How to add custom logging into ADF application?
Can’t imagine development without logging. Even in ADF 🙂 For some quick output into local WebLogic console – System.out.println is quite ok. But if we need to have it in more professional and persistent way – java logging tools come to action. In ADF we have ADFLogger class at our service. Naturally it is extended java.util.logging.Logger indeed. So here is…
Is extremely big or low date, indicating infinity safe in SQL?
This is a question I’ll try to answer here. Quite frequently it happens to face SQL code, where extremum dates take place. From a first glance it look OK to use like to_date(‘3000.01.01′,’YYYY.MM.DD’)) for indicating infinity, something that lasts forever. Nobody could bet that no one of our developed nice IT system will even exist at such time point 🙂…
REST with hierarchical (tree) data query and response payload
Probably everyone using REST webservices face requirements which makes you deal with hierarchical (tree) data structures. How to clearly define when data is expected to be returned in a hierarchical structure and when just a flat object? And what if you need different hierarchical responses in different use cases for the same REST resource? Here I’m going to tell you…
ADFDI-05538: The workbook integration has been altered after publishing. What can be the reason?
Here is full error message: ADFDI-05538: The workbook integration has been altered after publishing. It can no longer be used safely. The integration will now terminate. What is the reason? Most probably, you did publish excel with different file name and trying to open previously published (old file name) version. This even can be a legal case, for example if…