Presentation available for download

In November I have been presenting at the last DOAG conference in Germany about documentation in APEX projects ( http://daust.blogspot.de/2012/11/presenting-at-doag-next-week.html ). The presentation (only in German) is now available for download.

Cheers,
~Dietmar.

APEX 4.2.1 Patchset released

Two days ago on Friday, the APEX 4.2.1 patch set has been released.

Although the quality of APEX is really high compared with other products, I tend to ALWAYS wait for the first patch set.

Ok, no more excuses for not upgrading to APEX 4.2 :).

Cheers and enjoy,
~Dietmar.

Speaking at ODTUG's KScope 13 in New Orleans

My abstracts for Oracle Application Express have just been accepted for presentation at ODTUG Kscope13, June 23-27, at the New Orleans Sheraton in New Orleans, LA:

• APEX + XE: a cookbook for a secure setup 
• A spotlight on the smaller improvements of APEX 4.2 

This is THE best conference for Oracle developers worldwide. 900 abstracts have been submitted this year and it was a real challenge to decide what will make it and what not.

Really looking forward to New Orleans. In 2008 I was speaking at ODTUG for the first time in New Orleans.

It was so cool and we had such a good time with my friends Patrick Wolf, Joel Kallman and Carl Backstrom.

Carl, we miss you!!!

See you at New Orleans,
~Dietmar.

Oracle ACE Award received!

Dear all, I have just received the Oracle ACE award for my contributions to the community and my knowledge about Oracle technologies, in particular with regards to Oracle Application Express and Oracle XE.

Thank you Oracle!

This is quite an honor since there are only 15 active Oracle ACEs in Germany:

 and in my area of expertise there is only my friend Denes and me :)

You can find my ACE profile here.

In order to celebrate the award I have received another very special (and tasty :) "award" from my girlfriend Valerie ... mmmmmhhhhh!

See you around at the next ODTUG KScope 2013 in New Orleans or in the forums,
~Dietmar.

P.S.: Thanks to all of my friends who have already congratulated me on Twitter, I appreciate it!

DOAG2012

Yesterday was the second of three days of the DOAG conference in Nürnberg. Once again this was a huge event for Oracle APEX.

We had lots of good APEX presentations from Patrick Wolf, Marc Sewtz, Christian Neumüller Carsten Czarski, Niels de Bruijn, Christian Rokitta, Peter Raganitsch and many others including myself.

We even took the time to have a little APEX Stammtisch

at the booth of my newly founded company JDD Software UG together with Jens Gauger: 

We had an awesome feedback for our first product, the "JDD Spreadsheet Publisher", which is a really flexible MS Excel export tool.

Thanks to all who visited our booth!

Cheers and all the best,
~Dietmar. 

Presenting at DOAG next week

Whow, time is passing by so fast ;).

The DOAG conference 2012 is only a few days away. And there will be 26 presentations around APEX alone!

So come by and experience the APEX enthusiam! Make sure to attend the sessions presented by Marc Sewtz, Patrick Wolf, Christian Neumüller, Carsten Czarski, Peter Raganitsch, Niels de Bruijn and other member of the APEX community. 

I will be talking about documentation in APEX projects "Der Widerspenstigen Zähmung - Dokumentation in APEX Projekten". 

In particular you will see how to extract documentation from your APEX application directly into your MS Word document. 

So that you can embed a simple tag (e.g. (:apex.application:) into your MS Word document (using your standard company template):

 With a simple macro this will be resolved to: 

and

 Also, you can document tables and views:

 to

Do you want to see the magic live? Come and join me at my presentation at DOAG in Nürnberg. 

Also, you can come to meet me at our booth ( JDD Software: http://jdd-software.com ) . Our first product, the JDD Spreadsheet Publisher is available. You can see the intro video in German or English on Youtube. 

Cheers, 
~Dietmar. 

APEX Listener 1.1.4 on Windows ... ILLEGAL_CHARACTER problems

I am currently setting up the APEX Listener at a new customer. Unfortunately they are running Windows ;).

To be more precise, they are running Windows 2008 Server R2 (64bit). I have installed Apache http server 2.2.22 and Apache Tomcat 7.0.30.

Everything went fine so far. Then I went on installing the APEX Listener 1.1.4. But I couldn't get it to work, I always received the following errors:


18.09.2012 09:59:23 org.apache.catalina.core.StandardContext listenerStart
SCHWERWIEGEND: Exception sending context initialized event to listener instance of class oracle.dbtools.rt.web.SCListener
java.lang.IllegalArgumentException: oracle.dbtools.rt.util.FilePathSyntaxException: ILLEGAL_CHARACTER
at oracle.dbtools.rt.util.Files.checkLegal(Files.java:133)
at oracle.dbtools.rt.util.Files.file(Files.java:98)
at oracle.dbtools.apex.config.ApexConfigFile.chooseExistingFile(ApexConfigFile.java:80)
at oracle.dbtools.apex.config.ApexConfigFile.choose(ApexConfigFile.java:57)
at oracle.dbtools.apex.config.ApexConfig.init(ApexConfig.java:149)

Upon researching the issue, I have found the following threads on the APEX Listener forum: 

- https://forums.oracle.com/forums/thread.jspa?messageID=10470712&#10470712

- https://forums.oracle.com/forums/thread.jspa?messageID=10493101&#10493101

The problem seems to be the within the APEX listener. In order to find the proper location for the configuration files, it will look in different locations on the server. It also checks the environment, the user home variable and the temp directory. Somehow the validation algorithm didn't account for Windows ;).

There is a workaround to set these specific environment variables for Java manually, but I didn't want to change the environment there to fix the problem. 

Anyway, I just reverted to 1.1.3 and everything worked fine! 

Cheers, 

~Dietmar. 

Clarification on Oracle XE licensing - really free for any usage?

There is an updated version on my new blog: http://dietmaraust.com/repost-clarification-on-oracle-xe-licensing-really-free-for-any-usage

Since Oracle XE was initially released in January 2006 I believed there was no usage restriction whatsoever with regards to the type of application you could build with Oracle XE and especially in combination with Oracle Application Express (Oracle APEX).

Just recently a customer of mine was told by an Oracle sales rep in Germany that certain usage scenarios are not covered by the Oracle XE license and he therefore would have to purchase a regular Oracle (at least Standard One) license for that purpose.

This sales rep argued that once you build an application as a hosted solution storing customer data in this database, this is no longer covered by the XE license.

I was stunned and couldn't believe that. Then I had a close look at the official license agreement: http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html

There I noticed that this usage scenario wasn't covered explicitly and I wasn't 100% sure any more. I have checked the forum again and there I saw, that these questions do come up once in a while, here are just a few examples:
https://forums.oracle.com/forums/thread.jspa?messageID=1454706&#1454706
https://forums.oracle.com/forums/thread.jspa?messageID=2775638&#2775638

Thus I decided to get some official statement from Oracle.

Oracle authorities from Database Product Management and Oracle Pricing responded to my request and confirmed that any application-specific usage of Oracle XE is covered by the license agreement and there is no usage related restriction imposed on Oracle XE.

I have explicitly asked for the following use cases:

1) A web application for the internal staff only: A calendaring application where one could record his times of absence. The application is reachable via the internet but protected by a login. Only the employees of the company running Oracle XE are allowed to access the application.

2) A web application used by everybody, no customer content stored in the database: This could be a company website which is built on Oracle XE / APEX. This application is reachable over the internet by everybody. Content is only provided by the company running Oracle XE.

3) A web application used by customers on their own data (no manipulation through website): This could be an application similar to the UPS or DHL tracking of parcels. Information is processed in other backend systems and published to Oracle XE to allow a customer to query for his/her own data.

4) Supporting a business process via a web application among several of my customers: This could be a portal allowing a customer to invite other parties to bid on a public project (like building a railroad track). This portal (built using Oracle APEX and Oracle XE) supports the communication between all parties and allows the upload / download of files with regard to specific parts of the bid.

5) A web application used by customers to provide services to others: This could be multi-tenant shop system where different customers open their own shop and upload their product catalogs in order to resell them to their own customers.

Aside from that you would still have to comply to all other elements of the license agreement: http://www.oracle.com/technetwork/licenses/database-11g-express-license-459621.html ,
i.e. you have to comply to the export restriction, your end customers would have to agree to the XE license agreement and so forth.

Cheers and enjoy Oracle XE and Oracle APEX!
~Dietmar.

JasperReportsIntegration: Passing multiple parameters to the report

With the JasperReportsIntegration kit I provide a mechanism to call JasperReports reports from an APEX application.

The reports are stored locally in the filesystem accessible to the j2ee container running the JasperReportsIntegration j2ee application. This application will connect to the desired Oracle schema using connection information deployed in the J2EE container.

This j2ee application provides an url interface to calling the desired report against a desired data source.

So how can we pass parameters to our report, e.g. for producing a report for a specific customer or order number?

Let's consider my test report for that purpose (test.jrxml). The test report will list the user objects installed in the Oracle schema we connect to as well as produce some header information about the selected report locale. You can even pass three parameters to the report called parameter1, parameter2 and parameter3.

So, how can we pass the parameters to the report?

First of all we need to specifiy the parameters in the report itself. I have added the three parameters to the parameter list:

Currently all parameters (which we want to call from the JasperReportsIntegration kit) have to be specified as java.lang.String, no other data types are allowed. I might add that as a new feature in a later release. But for now only strings are allowed:

We assume that we have an APEX page with two page items, P1_FILTER_OBJECT_NAME and P1_FILTER_OBJECT_TYPE.

In order to pass these two parameters to the test report using the pl/sql interface XLIB_JASPERREPORTS, you would do the following:

declare 
  l_additional_parameters varchar2(32767);
begin
  -- set the url for the j2ee application
  -- better retrieve that from a configuration table
  xlib_jasperreports.set_report_url('http://localhost:8090/JasperReportsIntegration/report');

  -- construct addional parameter list
  l_additional_parameters := 'parameter1=' || apex_util.url_encode(:p1_filter_object_name);
  l_additional_parameters := l_additional_parameters || '&parameter2=' || apex_util.url_encode(:p1_filter_object_type);

  -- call the report and pass parameters
  xlib_jasperreports.show_report (p_rep_name => 'test',
                                  p_rep_format => xlib_jasperreports.c_rep_format_pdf,
                                  p_data_source => 'default',
                                  p_additional_params => l_additional_parameters);

  -- stop rendering of the current APEX page
  apex_application.g_unrecoverable_error := true;
end;

Why do we use apex_util.url_encode? This is required since we essentially pass the parameters via an url to the j2ee application. 

When the report is executed, we get the following result (assuming P1_FILTER_OBJECT_NAME=APEX$ and P1_FILTER_OBJECT_TYPE=TRIGGER):

 

Using the test report this will just display the passed parameters. If you want to filter the user objects using the parameters you could modify your query to:

This will filter the result either bei object_name or object_type (in the example I filtered by the object type TRIGGER):

Hope that helps,
~Dietmar.

JasperReportsIntegration 2.0.0 - Beta Test

Hi guys,

I am pleased to announce the beginning of the beta test for the upcoming release 2.0.0 of the JasperReportsIntegration kit.

I welcome you all to participate in the beta test, you might even have the chance to get some extra features in or at put your wish at least on the roadmap.

This release focuses a lot on ease of use, stability and support of different application servers. But there are interesting new features as well:

Support for JasperReports 4.7.0

I have included the latest libraries from JasperReports to stay up to date with the current JasperReports release.

Included Oracle JDBC connection pool

In addition to the JNDI configuration of the data sources you can now use a plain configuration file to use the Oracle JDBC connection pool directly. It is included in the J2EE application. Thus the configuration will be identical on all J2EE servers ... and it is really easy to use :). 

Support for the major application servers

I have already tested on Jetty, Tomcat and Weblogic. Here I will need your support to test against other J2EE servers as well!

Fine grained logging and better error messages

Iam using log4j as the logging framework now with nicely written logfiles and support for different log levels. Also, everything is checked, no more null pointer exceptions, you should always get a really precise error message. 

Reports can be deployed anywhere on the server

You can manipulate the search path for the report files using an environment variable on the operating system or a setting in the application server configuration (e.g. web.xml). This way you can easily upgrade the integration kit, your reports and the configuration files will not be removed by an undeploy/redeploy of the application. 

Storing files on the application server directly

Storing files on the application server directly (just as Oracle Reports did, destype=FILE). Developers from an Oracle Reports background will like this one. You can enable this feature and provide a filename on the server on which to save a copy of the generated report. 

Directly sending output to a network printer

Also, this is a feature well known from Oracle Reports. Just specify a printer (which is locally known to the application server) and send the output directly to it. You can specify the media (size or tray), the number of copies and whether the output shall be sorted (collate).

You can call the PrinterDiagnostics page to discover the locally installed printer and their settings: 

Major upgrade of the test application

The new version will check everything that is required and give specific suggestions on how to fix it. 

If everything is setup correctly, all tests will pass. 

If anything goes wrong, you will get detailed error messages and precise instructions on how to fix it: 

Quick Start

Personally, I love this one. Especially to get the beginners started I have included the Jetty server in the download. You can start the J2EE application just by clicking on a shell script, can it get any easier?

Even for myself it is nice to have the test report up and running in two minutes :) 

The documentation can be found here. To go to the download directly, click here. 

I have created another forum for the beta test, so please post all questions, issues, findings here: http://www.opal-consulting.de/forums/viewforum.php?f=10 .

Hope you enjoy it :). 

Cheers, 

~Dietmar. 

JasperReports 4.7.0 released

JasperReports 4.7.0 was released a few weeks ago. The new release of the iReport designer is not yet announced on the homepage, but you can download the new files already: http://sourceforge.net/projects/ireport/files/iReport/

I will update the integration kit in a few days. This time it will be released with a major update and lots of new features:

• Included Oracle JDBC connection pool: in addition to the JNDI configuration of the data sources you can now use a plain configuration file to use the Oracle JDBC connection pool directly. It is included in the J2EE application. Thus the configuration will be identical on all J2EE servers. 
• I will test on the major J2EE servers and make sure it runs everywhere. Might need support from the community to test everything. 
• Fine grained logging and better error messages: I am using log4j as the logging framework now with nicely written logfiles and different log levels. 
• Reports can be deployed anywhere on the server: You can manipulate the search path for the report files using an environment variable on the operating system or a setting in the application server configuration (e.g. web.xml). This way you can easily upgrade the integration kit, your reports and configuration files will not be removed by an undeploy/redeploy of the application. 
• Storing files on the application server directly (just as Oracle Reports did, destype=FILE).
• Sending reports directly to a network printer
• Adding security features, especially a token-based validation function for each data source. Using this technique, you can create a token in the database, pass it to the Integration kit and have it validated back in the database. This way you can share a single Tomcat instance among different applications. 

The main focus for this upcoming release was ease of deployment and troubleshooting.

Cheers, 

~Dietmar. 

JasperReports Online Training-free modules

JasperSoft provides online training for JasperReports and the iReport designer. You can find it here: https://www.jaspersoft.com/bi-training-center

Some of the content is free, some of the content is being charged for with a monthly subscription around $200 per month.

One free nugget you should propably have a look at is the configuration of the iReport Table Component.

If that link won't work over time any more, this is how I got there: Home > Services > Training > Online Learning Portal > Enabling Report Interactivity with the Table Component.

Why is that important? In order to have an additional detail query in your report you would have to create a subreport to achieve that. Using subreports requires you to use additional files for each detail query.

Using the Table Component is an alternative approach to that being able to use a subquery within the current report definition - no longer having to use a separate file.

Although this feature is around for a long time (I guess for a year or two) it is not well documented. So you should definitely have a look.

Cheers,
Dietmar.

Update 12.07.2012: Here is another link: https://www.jaspersoft.com/blog-entry/jasperreports-interactivity-the-table-component

I have also updated the link for the configuration of the iReport Table Component, it was broken.
 

JasperReportsIntegration 1.3.0.2 available - now supporting JasperReports 4.6.0

Hi guys,

I have updated the JasperReportsIntegration kit. The new libraries 4.6.0 of JasperReports are now included.

The integration kit itself has not changed. Thus you can simply update the JasperReports libraries to version 4.6.0. This process is explained in the FAQ.

You can find all details, FAQ and downloads here: http://www.opal-consulting.de/tools .

Hopefully I will publish another new version soon, I would like to include an Oracle connection pool in order to simplify the configuration of the data sources which is completely different on all J2EE servers :(. I did this for performance reasons but it didn't turn out to be such a good choice.

Cheers,
Dietmar.

ODTUG KScope12 - Slides and Samples uploaded

Hi guys,

the samples for my JasperReports presentation at ODTUG KScope12 are now available online, you can download them here: 2012-06-28-ODTUG-KScope12-jasper-reports-samples.zip

Although you can download the slides for both of my presentations from the ODTUG site, you can download them here as well:

• Taming of the Shrew - Documenting an APEX Application
• Oracle Reports to JasperReports

I hope that all DDL scripts are included in the sample archive. If anything is missing or you have problems, please drop me a note. 

Cheers, 

Dietmar. 

Oracle APEX Training am 29.10.2012

Wir (Denes Kubicek und Dietmar Aust) freuen uns, das nächste APEX Training bekannt geben zu können.

Es findet am 29.10.2012 bis zum 31.10.2012 erneut in Bensheim bei Frankfurt statt, im Aleehotel.

Oracle APEX: Knowhow aus der Praxis - jetzt auf APEX 4.1!

Nutzen Sie das Wissen und die Erfahrung von

• Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und
• Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX und regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World)

, um Best Practice Vorgehensweisen aus vielen erfolgreichen APEX Projekten zu lernen.

Neben einer Fülle an Informationen, die wir in vielen erfolgreichen APEX Projekten erarbeitet haben, sind insbesondere die abendlichen Sessions (von 19:00-21:00) als Highlight zu nennen.

Dort stehen wir Ihnen für zusätzliche Hands-On Sessions zur Verfügung, um die Beispiele des Tages durchzuarbeiten oder auch, um konkrete Fragestellungen in Ihren aktuellen Projekten zu diskutieren.
Weitere Details zum Kurs sowie die Anmeldung finden Sie hier.

~Dietmar.

Slides for the DOAG Development Conference in Bonn (14.06.2012)

Hi guys,

since I cannot upload my slides for my presentation in Bonn ( http://daust.blogspot.de/2012/05/join-me-at-doag-development-conference.html ) to the doag.org website due to a size limitation (5MB), I will provide all files (script, presentations slides and sample files) here:

http://www.opal-consulting.de/downloads/presentations/2012-06-14-DOAG-Development-Bonn/

But beware, they are all in German ;). 

Cheers,
Dietmar.

JasperReportsIntegration howto article republished

Hi guys,

this article has been published already two years ago in the ODTUG magazine, but it should still work the same way:

http://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/Opal-Consulting-JasperReportsIntegration.pdf

If you have any issues, please let me know.

Cheers,
Dietmar.

Join me at the DOAG Development Conference in Bonn (14.06.2012)

Typically, the DOAG e.V. is hosting its yearly conference in Nuremberg. The DOAG is the German Oracle User Group and the DOAG conference is the premier event in Germany focusing on everything Oracle. There you will find all kinds of presentations for developers, DBAs, management and so forth.

For the first time though, the DOAG will host a smaller conference in Bonn, solely for Oracle developers. The conference covers the following four tracks: "PL/SQL and APEX", "Java and Open Source", "Forms, Reports, ADF, BI-Publisher", "BPM and Softwarearchitecture".
Find the complete conference program as PDF online.

You can get more information on the conference website, you can also register online. 

If you like you can join me there, I will be presenting on "from Oracle Reports to Jasper Reports": 

Many customers are moving away from Oracle Forms to other alternatives. Oracle APEX is an especially interesting option because it leverages existing Oracle database skills (SQL and PL/SQL) nicely. But what about your existing Oracle Reports? This presentation will cover the open source solution, JasperReports, as a viable alternative. The session will cover the typical use cases and design patterns used when building reports in Oracle Reports and how to implement them using JasperReports. You will learn how to get started with JasperReports and how to integrate that functionality into your APEX applications.

Cheers,
~Dietmar.

Presenting at ODTUG KScope in June

This year from the 24th to the 28th of June I will be attending the ODTUG KScope conference in San Antonio, Texas.

Here is what ODTUG says about the conference:

ODTUG Kscope12 is the place to be for the Oracle technical community in 2012. If you are a developer, architect, technical lead, or database administrator who works with Application Express, Business Intelligence, Oracle EPM; including Hyperion products, Essbase, Planning; Database Development or Fusion Middleware, Kscope12 is where you should be. It’s hard to find a conference that’s big enough to attract world renowned speakers and small enough to get the chance to share knowledge. Kscope12 is that conference.

I could not agree more. It is really fun to meet up with all my friends from the Oracle APEX community, learn about the new features of the upcoming Oracle APEX release firsthand from the developers and get in touch with sooo many excellent developers from around the world. This is definitely the most important conference for any Oracle developer to attend.

This year I will have two presentations:

• Taming of the Shrew - Documenting an APEX Application
• Oracle Reports to JasperReports

Cheers and looking forward to seeing you there,
~Dietmar.

JasperReportsIntegration - new support forums available

I have just published my new support forums for my JasperReportsIntegration kit (http://www.opal-consulting.de/tools).

You can find it here: www.opal-consulting.de/forums/

Please post all of your questions about JasperReports and the integration here, you can also place your enhancement requests there.

Cheers,
Dietmar.

Oracle Reports to JasperReports-I need your questions

Hi guys,

at the next ODTUG conference (http://kscope12.com/) I will be speaking about about moving your existing reports written in Oracle Reports to JasperReports.

Since many people are moving away from Oracle Forms, Oracle APEX seems to be a natural choice, since you can leverage your existing PL/Skills as well as your existing PL/SQL business logic nicely.

But what about your reporting needs? What alternative will you choose for your existing reports written in Oracle Reports?

What questions would be interesting for making a choice and migrating your reports?

Here are a few samples:

• are there any license costs involved?
• are all features that we need, supported? What are these features, that YOU need?
• are there any limits, e.g. the size of the files that can be generated?
• how can JasperReports integrated into my APEX application and secured?
• is it performant?
• is there a batch interface like rwcli? 

What are your questions?

Cheers,
Dietmar.

Jasper Reports Ultimate Guide now available for free

Hi guys,

many of you might be using Jasper Reports for designing your reports with Oracle APEX. The documentation provided by Jasper Soft had to be paid for.

I have just noticed that the Ultimate Guide is now available for free! So check it out: https://www.jaspersoft.com/store/jasperreports-ultimate-guide-documentation

It is not based on the latest version of Jasper Reports but nevertheless useful.

Cheers,
Dietmar.

JasperReportsIntegration 1.3.0.1 available

I have just released a bugfix for version 1.3.0, it is version 1.3.0.1.

The new version and the updated documentation is available here: https://www.opal-consulting.de/apex/f?p=20090928:4:0:::::

• Direct download: https://www.opal-consulting.de/downloads/free_tools/JasperReportsIntegration/1.3.0/
• Change log / release notes: https://www.opal-consulting.de/apex/f?p=20090928:10:0::NO:10::

Cheers and best regards, 

Dietmar. 

New APEX Stammtisch in Munich (13.03.2012 / 19:30)

I am currently working on a project in Munich and I will be joining Carsten Czarski at his APEX Stammtisch in Munich.

See more details here if you like to join: https://blogs.oracle.com/apexcommunity_deutsch/entry/apex_stammtisch_in_münchen_13

Looking forward to meeting up with many other APEX aficionados while having a good German beer and some excellent local dishes.

Cheers and see you there,
Dietmar.

New APEX Stammtisch in Siegburg am 2.3.2012 / 19:00

Just as a reminder, we are having our next APEX Stammtisch (get together) this friday in Siegburg.

Please register for the Stammtisch so that we can make sure there is enough room for everybody:

https://www.opal-consulting.de/apex/f?p=107:11:0:::11:P11_EVT_ID:51

Cheers and hope to see you there, 

Dietmar. 

New Training Oracle APEX 4.0 / 4.1: New Features

Our next training is scheduled for March 2012. You can find the details on www.opal-consulting.de.

---

Wir (Denes Kubicek und Dietmar Aust) freuen uns, das nächste APEX Training bekannt geben zu können.

Es findet am 26.03.2012 bis zum 27.03.2012 erneut in Bensheim bei Frankfurt statt, im Alleehotel.

Oracle APEX 4.0 / 4.1: New Features

In diesem Kurs zeigen Ihnen zwei ausgewiesene Experten im Oracle APEX Umfeld die neuen Features der Oracle APEX Version 4 (4.0 und auch 4.1). Die Version 4 steigert die Produktivität der Anwendungsentwickler wieder einmal signifikant, insbesondere die neue Plugin-Infrastruktur, Dynamic Actions sowie das neue Error Handling.

Nutzen Sie das Wissen und die Erfahrung von

• Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und
• Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle Apex, aktiv in den OTN Foren zu Apex und Oracle XE, mit Präsentationen auf den letzten DOAG Veranstaltungen.

Neben einer Fülle an Informationen, wie die neuen Features von APEX 4.0 / 4.1 am besten in Ihren Applikationen eingesetzt werden können, ist insbesondere die abendliche Q&A Session (von 19:00-21:00) als Highlight zu nennen.
Dort stehen wir Ihnen für zusätzliche Hands-On Sessions zur Verfügung, um die Beispiele des Tages durchzuarbeiten oder auch, um konkrete Fragestellungen in Ihren aktuellen Projekten zu diskutieren.

Zum Inhalt:

• Überblick der neuen Features, was ist alles neu
• Der Umgang mit Websheets, wie kann man die neuen Wiki-ähnliche Funktionalitäten sinnvoll nutzen
• Dynamic Actions, wie man AJAX Funktionalität deklarativ (ohne zu programmieren) in seinen Applikationen einsetzt
• Erweiterbarkeit von APEX über Plug-Ins, benutzerdefinierten Elementtypen und Regionen
• Verbesserungen der Tabular Forms, insbesondere die Validierungen und die Unterstützung zusätzlicher Elementtypen
• Die Verwendung der neuen Elementtypen
• Verbesserungen der mächtigen interaktiven Berichte mit komplexeren Filtern, Gruppierungen und das Abonnement von Benachrichtigungen
• Team Development, das Projekt direkt mit APEX managen
• Verbesserungen im Application Builder
• Neue Möglichkeiten der Chart-Engine sowie neue Diagrammtypen (GANTT und Kartendarstellungen)
• Web Services, deklarative Unterstützung von REST-Webservices
• Administration, Vereinfachungen in der Administration sowie im Deployment von Applikationen
• Umgang mit dem neuen APEX Listener
• Das neue Error-Handling, schöne Fehlermeldungen für interne Fehler sowie nicht länger redundante Validierungen programmieren müssen
• Mobile APEX: Anwendungen für Smartphones und Tablets entwickeln

Wir freuen uns, dieses Mal Peter Raganitsch als Gastredner bei uns im Kurs zu haben. Er ist in der APEX Community ebenfalls sehr bekannt und hält regelmäßig Vorträge zur Oracle APEX. Er wird das Thema "Mobile APEX: Anwendungen für Smartphones und Tablets entwickeln" behandeln.

Weitere Details zum Kurs sowie die Anmeldung finden Sie hier.

~Dietmar Aust.