Virtual Development Server: Modern Infrastructure
Create the Foundation for easy Development
After my 2016 series about my Virtual Development Server I have learned a lot. It’s time for a major overhaul with new technologies. It should be a lot more flexible and usable for development and course environments. See how I will restart!
Slides for my german presentation DOAG2021 "Forms and Reports 12c - Processes and Automation in Development and Operations" available
Project report about an Oracle Forms and Reports 12c Automation
I have presented last week on DOAG 2021. For all non DOAG members - you can find the german presentation on Slideshare too:
Forms and Reports 12c - Processes and Automation in Development and Operations - I am a speaker at DOAG 2021
Project report about an Oracle Forms and Reports 12c Automation
The current target architecture of IKB’s credit and loan management is based on Oracle ADF and SOA and of course the database. But how can you protect in this time your Oracle Forms & Reports longtime investments, can you support their Development Lifecycle by Automation?
Add Code to Oracle Reports via Forms FormsAPI Master
How to do Mass Changes with in your Oracle Reports with FormsAPI Master
For our migration to Oracle ADF we have to identify, which Forms and Reports modules are still really called. For Forms we already have implemented a call statistic. In this blog post I show you how you can automatically implement the same into over 200 reports.
Slides for my german presentation DOAG2020 "Our way to 19c" available
Project report about an Oracle Database Upgrade - Slides
I have presented last week on DOAG 2020. For all non DOAG members - you can find the german presentation on Slideshare too:
Our way to 19c - I am a speaker at DOAG 2020
Project report about an Oracle Database Upgrade
Already 4 years we plan the upgrade from 11c to a new supported version. If you speak german and you are interested in some of our experiences, you should come and attend my presentation at DOAG 2020 Wednesday, Nov. 18, 15:00 online.
Show your Oracle Forms and Reports diffs from Git
See diff for your Forms and Reports modules with tools from ORCL Toolbox and Git difftool wrapper
You have successfully versioned your Oracle Forms & Reports module with git. What if you could see the diff for your module after changes from your working copy or between two commits? See my solution with the tools from ORCL Toolbox and a Git difftool wrapper.
Slides and for my german presentation APEXCONN20 "Agile Oracle Database Modeling and Development (AgileOracleDatabase)" available
How to do Agile Oracle Database Modeling and Development - Slides and Video
I have presented last week on APEX Connect 2020 again. For all non DOAG members - you can find the german presentation on Slideshare too:
Slides for my german presentation DOAG2019 "Agile Oracle Database Modeling and Development (AgileOracleDatabase)" available
How to do Agile Oracle Database Modeling and Development - Slides
I have presented last week on DOAG 2019. For all non DOAG members - you can find the german presentation on Slideshare too:
Agile Oracle Database Modeling and Development (AgileOracleDatabase) - I am a speaker at DOAG2019
How to do Agile Oracle Database Modeling and Development
We try to be agile in developing and merging our features into branches when they are ready for use.
Slides for my german presentation DOAG2018 "Regulatorics - Offside is when the referee whistles" available
How to implement Regulatorics into the Software Development Lifecycle - Slides
I have presented last week on DOAG 2018 in Nuremberg. For all non DOAG members - you can find the german presentation on Slideshare too:
"Regulatorics: Offside is when the referee whistles" - I am a speaker at DOAG2018
How to implement Regulatorics into the Software Development Lifecycle
Today my presentation is confirmed: "Regulatorics: Offside is when the referee whistles". Maybe the German title will be better understood: "Regulatorik: Abseits ist, wenn der Schiedsrichter pfeift".
Slides for my german presentation DOAG2017 "PLSQL - Therefore, whoever binds forever - automate your tests" available
How to Test Automation into Database Development - Slides
I have presented last week on DOAG 2017 in Nuremberg. For all non DOAG members - you can find the german presentation on Slideshare too:
Provide access to WebLogic DMS Spy Servlet for readonly users
For security reasons and to prevent the configuration drift it is recommendable to use read only access of WebLogic configuration for analyzing problems. For read only access of configuration and logs WebLogic provides out of the box the group Monitors. Unfortunately you cannot access DMS Spy Servlet with this group, which is useful for analyse runtime values of the server. Only users which belongs to the Administrators group and therefore have full access can access DMS Spy Servlet and this is not configurable in WebLogic by default.
"PL/SQL: Therefore, whoever binds forever: automate your tests" - I am a speaker at DOAG2017
How to Test Automation into Database Development - Slides
Today my presentation is confirmed: "Therefore, whoever binds forever: automate your tests". Maybe the German title will be the better understood: "PL/SQL: Drum test-automatisiere, wer sich sich ewig bindet!"
DEVCAMP17 wrap up
Yesterday I attend the annual barcamp DEVCAMP of the DOAG development community. There are mostly developers with SQL, PL/SQL, Forms & Reports, ADF, JET background and some Java, Javascript and APEX developers too. And not to forget: 1 dba and some managers. Here is my summary.
Fix "BEA-000394: Deadlock detected" for Weblogic with ADF Applications 12.2.1.2
If you try the newest version 12.2.1.2 (or maybe earlier versions too) you see, that your managed server does not restart
Virtual Development Server: Provide Docker images in docker registry for Oracle XE Database and others
For later creation of containers as needed in the deployment process we have first to build docker images whenever we do not find suitable one in docker hub.
Set all WebLogic log levels to "Inherit" via WLST
Logging is a very useful feature of WebLogic. Unfortunately the log levels, which are set after a clean install of WebLogic or some of the Fusion Middleware product creates a lot of noise and therefore it costs I/O performance.
Virtual Development Server: Add swapfile to VirtualBox as requirement for installing Oracle or build Oracle docker images
As I want later build Oracle docker images, some of this need a swapfile. Per default my used Vagrantbox does not have one, so later steps will fail.
Virtual Development Server: Add enough ram and disk space to VirtualBox for further server components
As I want later build docker images and run docker containers I have to provide enough ram and disk space for this. Per default the Vagrantboxes have vmdk disks, these have a static size and are to small for my purposes.
Virtual Development Server: Creating Virtualbox machine including docker containers with Vagrant
As I want to decouple my development server from my computer as much as possible I want to create first a virtual machine with linux.
Oracle TranslationHub neither supported for 12c Database, 12c Forms/Reports or 64 bit!
If you need TranslationHub (Windows only) for your forms and reports development please immediately stop if you plan to move to one of the these
Javaland 2016 conference day 1
This year I have decided to give the Javaland conference a try. I’m not a java professional, but in the program was listed a lot of interesting testing presentations, so my company booked for me.
Slides for my german presentation DOAG2015 "Bob the Builder: Build/Deploy of ADF enterprise applications" available
Faster Build and Deployment of ADF Projects - Slides
I have presented last week on DOAG 2015 in Nuremberg. For all non DOAG members - you can find the german presentation on Slideshare too:
SLES shell script to check required os packages according to documentation before starting oracle forms and reports installation
If you try to install Oracle Forms & Reports 11.1.2.2 on SLES 11.3 than despite all installer checks are passed maybe you get a error message.
"Bob the Builder: Build/Deploy of ADF enterprise applications" - I am a speaker at DOAG2015
Faster Build and Deployment of ADF Projects
Today my presentation is confirmed: "Bob the Builder: Build/Deploy of ADF enterprise applications".
Fix code editor save actions in JDeveloper 12.1.3: keep the order of actions
If you work with JDeveloper 12.1.3 and you work with code editor save actions the order of actions could be relevant for you. For an example you use lot of asterisk (*) imports and JDeveloper should edit the code to import only classes that you actually use in the code.
Fix completion insight in JDeveloper 12.1.3: show return type again
If you work with JDeveloper 12.1.3 you may missing the return type of methods in completion insight.
Slides for my german presentation DOAG2014 "The Dirty Dozen – ADF Migration to 12c in the IKB" available
Report about 12c ADF Migration Projekt
I have presented last week on DOAG 2014 in Nuremberg. For all non DOAG members - you can find the german presentation on Slideshare too:
ADF Architecture Practice - JDeveloper Silent Install of Extensions
This article describes how to standardize your JDeveloper Installation as requested in Planning & Getting Started - Team, Skills and Development Environments.
See you at DOAG 2014 “The Dirty Dozen – ADF Migration to 12c in the IKB” room Kopenhagen on 11/19/2014 at 10:00 am
The presentation is ready, time for travelling now.
ADF Architecture Practice - JDeveloper Silent Patch
This article describes how to standardize your JDeveloper Patching as requested in Getting Started - Team, Skills and Development Environments.
ADF Architecture Practice - JDeveloper Silent Install
This article describes how to standardize your JDeveloper Installation as requested in Planning & Getting Started - Team, Skills and Development Environments.
ADF Architecture Practice Series
From now on I will create a series of lessons to implement the knowledge of the ADF Architecture Course from Oracle ADF product management. Here you can find the <videos and the presentations. This post will be the index of this lessons, so bookmark it for further use!
"The Dirty Dozen - ADF Migration to 12c in the IKB" - I am a speaker at DOAG2014
Report about 12c ADF Migration Projekt
Today the official program is online for DOAG conference 2014 in Nuremberg. My presentation is confirmed "The Dirty Dozen - ADF Migration to 12c in the IKB".
Find problems when you develop: using XRebel with Oracle ADF
Some days before ZeroTurnaround has released XRebel , a new tool to recognized problems in your web applications, when you make your developer test. This was promising, so I give it a short try for Oracle ADF applications.
Slides for my german presentation "Quality Assurance for ADF projects" available
How to check the quality in ADF Development Life Cycle - Slides
I have presented today on DOAG Development 2014 in Dusseldorf. For all non DOAG members - you can find the german presentation on Slideshare too:
Quality Assurance for ADF projects
How to check the quality in ADF Development Life Cycle - Slides
If you speak german and you are interested in quality assurance for your ADF projects you should come and attend my presentation at DOAG Development on 06/04/2014 in Duesseldorf.
Deploy your ADF Mobile App to a virtual Android device from JDeveloper IDE
If you tired from the android emulator speed you may have read Chris Muir’s article ADF Mobile: Avoiding the Android Emulator with AndroVM. In the meantime the successor AndroVM is GENYMOTION. Let’s integrate this instead now!
Have released PMD JDeveloper Extension 5.0.5
I have finished now my work on integrating last PMD version 5.0.5 into JDeveloper.
Write ADF static code analysis rules with PMD and running these in JDeveloper
Do you know, that PMD can analyse XML files since version 5? Many of ADF files are XML configuration files - wouldn’t it be a good idea to create some static code analysis rules for ADF too?
PMD Integration with JDeveloper through Ant External Tools
After little code change in pmd the integration like described in some blogs from Shay Shmeltzer is now possible.
Fasten your Oracle Forms and Reports 11g Server start on Unix derivates
Do you see a slow start of your WebLogic managed server for Forms & Reports on Unix derivate? We had this problem too on SuSe SLES 11 and Forms and Reports 11.1.2.
Save JDeveloper application workings sets in the application workspace - please vote for this enhancement request
If you create for an example a big adf application you may want to add all of your entities to one base application for reuse labels, validation and and so on. If you have a big database schema than in short time you have a problem to find your entity. In JDeveloper there is a neat feature to overcome this problem: working sets!
Oracle Reports Designer 11g 64bit on Windows7 64bit very buggy - Use Reports 32bit instead!
As I have seen in Oracle certification matrix Forms & Reports 11g 64bit is supported under Windows7 64bit. So I tried to install it and to work with it. Unfortunately there are serious bugs in it, please read for more information MOS Doc ID 1395965.1.
TranslationHub 11g is only available as 32 bit - requires Forms and Reports 11g too in 32 bit for Development
I have done the whole may scripting silent installs of several developer tools. Among them was Fusion Middleware 11.1.2 Forms & Reports. I see that oracle certifies the 64bit installers on win7 64bit and so I have successfully script this after a lot of time. I want not speak about the many errors in silent installers here. But what if you want to use TranslationHub too?
Have released PMD JDeveloper Extension 4.3
Sorry for a time without new post - but I have finished now my work on integrating last PMD version 4.3 into JDeveloper.
Oracle Forms 11 running as application in Java Webstart
According to my last post today I will show you the basic configuration for forms 11g. Unfortunately webstart in forms 11g it is not as easy as in 10g, but it works too!
Oracle Forms 10 running as application in Java Webstart
Many people miss in webforms the possibility to run forms as a separate application. They have a lot of problems to handle browser back button an so on. The good news - there is a way to do this with Java Webstart. The bad news - it is not supported by Oracle. But we run this since four years now and is very stable.