Presenting at OGh APEX World 2015

On March 25th 2015 at the beautiful venue of the former cruise ship SS Rotterdam, the next edition of APEX World by the Dutch Oracle Users Group (OGh) will take place.

SS Rotterdam

There is a long list of very interesting speakers there. David Peake, Steven Feuerstein, Joel Kallman, Dimitri Gielis, John Scott and Peter Raganitsch, just to name a few, have been selected to deliver presentations and keynotes at this event. And I’m proud to say that my name is also on that list.

I’m planning to do a presentation based on the following abstract:

APEX and SOA – The best of two worlds
Many companies have invested in an APEX application or a Service Oriented Architecture. But why not use both? In this presentation we will see the possibilities offered by APEX and the Oracle SOA Suite to communicate and integrate with eachother.

I hope to see a lot of familiar faces there and also a lot of new faces that want to learn more about this subject.

If you would like to attend, more information can be found on the OGh website. There are still some seats left, but they are going fast!

Christmas Giveaway and Packt $5 eBook Bonanza

Packt’s $5 eBonanza returns

Following the success of last year’s festive offer, Packt Publishing will be celebrating the Holiday
season with an even bigger $5 offer.

From Thursday 18th December, every eBook and video will be available on the publisher’s website for
just $5. Customers are invited to purchase as many as they like before the offer ends on Tuesday
January 6th, making it the perfect opportunity to try something new or to take your skills to the next
level as 2015 begins.

With all $5 products available in a range of formats and DRM-free, customers will find great value
content delivered exactly how they want it across Packt’s website this Xmas and New Year.

Find out more at www.packtpub.com/packt5dollar

5-dollar-promo

Adding to the fun, Packt has given me the opportunity to give away 3 free copies of my APEX Cookbook, Second Edition (the eBook).
To win, simply comment on this post or use the contact form with your nicest new year wishes before the end of December 31st 2014 (Dutch time) and I will randomly select 3 winners.

Winners will be contacted by Packt to arrange details for receiving their prize.

Happy 10th birthday Packt Publishing

The publisher that has given me the chance to write my 2 APEX Cookbooks is celebrating it’s tenth birthday.
For a limited time (until July 5th) Packt Publishing is offering all it’s eBooks and video’s for a reduced price of $10.

More information can be found at the 10 year Packt celebration page.

This is a great chance to get a copy of the APEX Cookbook Second Edition if you haven’t got it yet.

Oracle SOA Suite 11g Certified Implementation Specialist

Last week I took the Oracle SOA Suite 11g Certified Implementation Specialist exam (1Z0-478) and passed.

Oracle Certified Specialist

Oracle Certified Specialist

I can now officially wear the badge of Oracle Certified Specialist.
So in the future you will also see some SOA related posts on this blog next to the APEX content.

Oracle Certified Specialist

Oracle Certified Specialist

APEX Cookbook Giveaway Contest!

My publisher Packt has given me the opportunity to start a contest. 3 lucky winners will receive a copy of my book for free!

Book Give-away:
Hold a chance to win free copy of the Oracle APEX Cookbook 2nd Edition, just by commenting!
For the contest we have 3 copies of Oracle APEX Cookbook 2nd Edition, to be given away to 3 lucky winners.

How you can win:

To win your copy of this book, all you need to do is come up with a comment below highlighting the reason “why you would like to win this book”.

Duration of the contest & selection of winners:

The contest is valid for a week from 12th to 19th of March, and is open to everyone. Winners will be selected on the basis of their comment posted.

About the book:

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook : Second Edition gives clear steps to create web applications, while explaining you the concepts and bringing out useful tips and techniques to make learning interesting for you. In this second edition, readers can learn how to modify themes and templates and how to use the new HTML5 and CSS3 features. Book also explains how to create visual effects such as tool tips and fading options. Furthermore, topics such as web services, publishing, administration, team development, and web sheets will be covered. After reading this book, readers can create feature-rich web applications in Application Express 4.2 with ease and confidence.

This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand. Readers new to APEX will find recipes to start development and an experienced user will find ways to improve productivity and efficiency and make the most of APEX to enhance their applications.

Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition
Oracle APEX Cookbook Second Edition

Oracle APEX Cookbook Second Edition

After months of hard work, Marcel van der Plas and I have finally finished the Second Edition of our Oracle APEX Cookbook.
Two new chapters and many new recipes describe how to build even better APEX applications.
The first new chapter is on HTML5 and CSS3 and explains how to use new item types, templates and much more.
The other new chapter explains how to build applications for Mobile devices like Smartphones.

To ensure the quality of the book, many well-known names from the Application Express community have helped to review the book. People like Dimitri Gielis, Maarten van Luijtelaar and Surachart Opun reviewed the first edition. To this line-up the names of Learco Brizzi, Iloon Ellen-Wolff, Ronald Rood, Tony Jedlinski and Benjamin Kweku Intsiful have been added.

The book can be purchased on the website of Packt Publishing and many other webstores.

The author and his book

The author and his book

Win my book!

On his blog, the German APEX developer Carsten Cerny has put up a competition to win my book.
Click here to visit Carsten’s site and enter the competition.

It’s a great promotion for the Oracle APEX 4.0 Cookbook.

So thanks to Carsten and be sure to visit his site for more information on this competition and APEX Development in general.

Update: the competition has finished and the winners Phil and Stephane will be receiving the book shortly. Congratulations to them!

Pre-order Oracle APEX 4.0 Cookbook now!

For the past months I have been working together with Marcel van der Plas on a book on APEX 4.0. The publisher Packt has just released the website, so it can now be pre-ordered.

Find the link here: Oracle APEX 4.0 Cookbook

The book offers more than 70 recipes that cover almost all topics of Application Express 4.0.
We are currently finishing up and expect that the book will come out in January.

Configure APEX in Oracle 11g

Application Express comes packaged with the OracleXE and Oracle11g database versions. In XE you can get started with APEX right away. In 11g the embedded PL/SQL gateway has to be configured first. These steps take you through the process of running the configuration script apxconf.sql.
Running this script enables you to configure the port for the Oracle XML DB HTTP server and to specify a password for the Oracle Application Express ADMIN account. Then you unlock the ANONYMOUS account.

Perform the following steps:

1. Open a terminal window and enter the following commands:

cd $ORACLE_HOME/apex
sqlplus sys/ as sysdba
@apxconf

2. Enter an administrator password for the Application Express Administrator account and press Enter.

3. Enter 8080 for the port for the XDB HTTP server and press Enter. This is also the default port. Change this number when another application (eg. Tomcat) is running on the same port. Keep in mind that ports below 1024 are not advisable when running Linux/Unix.
(The embedded PL/SQL gateway has now been configured.)

4. Unlock the anonymous user. From your terminal window, enter the following command:

ALTER USER ANONYMOUS ACCOUNT UNLOCK;

And now you’re all set to start developing APEX applications in 11g.

When you later want to change the port on which APEX is configured, you can run the following command:
dbms_xdb.sethttpport('9090');
If you want to check what the current port is, use the following query:
select dbms_xdb.gethttpport from dual;

For more information, visit the Oracle site at www.oracle.com