ADF Desktop Integration (ADFdi)

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…

Continue Reading

ADF Desktop Integration (ADFdi)

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…

Continue Reading

Logging, Weblogic

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…

Continue Reading

ADF, Logging

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…

Continue Reading

Database, SQL and PL/SQL

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 🙂…

Continue Reading

ADF Desktop Integration (ADFdi), ADF Exceptions

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…

Continue Reading

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

How to execute bean method when switching tab in ADF?

Quite common requirement is  to execute some logic when navigating between tabs in ADF application. Luckily in ADF there is a straight forward feature enabling you to do this easily. Its enough just to add disclosureListener to showDetailItem of panelTabbed component and point it to dedicated bean method. Like this: Listener method signature must contain DisclosureEvent parameter: Tiny sample application can be…

Continue Reading