Re-Post – CSS Properties That Give Designers Fits

I am a huge fan of Design Festival.  They do a great job of posting informative and original content.

This is one form my notes that I was looking for today, and wanted to share.

http://designfestival.com/5-css-properties-that-give-designers-fits/

(As this site is also my personal notebook, it is also so I can find it again.)

New Direction for Tim St. Hilaire

It is an exciting time for me.   November 2012 I will be joining the elite ranks of Enkitec.  This is a big move because I will be ending my 16 year career with BAE SYSTEMS.  I have been very fortunate as my career with BAE has been blessed with challenges, opportunities, and a whole host of skilled and interesting individuals.  It was a tough decision to make, but one that I feel is right for me.

The move to Enkitec is my accepting of my true passion.  I love application development, and in particular, truly enjoy the Oracle APEX framework.  This position will let me fully realize that passion and has opportunity written all over it.  To that end, I am looking forward working with my new team and getting to know the Enkitec group.

Oracle Open World 2012 – APEX in a Large Organization

This presentation was given by me in September 30, 2012.  It was during the Oracle Open World 2012 Symposium Sunday.  This is a brief review of how the use of Oracle Application Express was utilized and grew within a large organization.  Thanks to all who were able to attend. If you have any questions, feel free to contact me.

APEX in a Large Organization – OOW 2012

APEX Chart Notes

Here are a few of the notes and links for APEX charts (AnyChart) that I often refer to:

Oracle Document – How – To
Oracle Documentation (4.1)
AnyChart Reference – XML
AnyChart Reference – Features

Apex Chart Examples on line

ODTUG – Kscope12 – All about the APEX Listener

As any good presenter would do, I updated my slides to the very last minute.  It is always exciting and rewarding to speak at the ODTUG conference.  I have uploaded here my last version of the slide deck. 

Also – as a note to the individuals that were visiting the talk…  The demonstration with the custom image directory worked – but my image directory was for a 4.0 instance, not for a 4.1 – causing the login screen to fail to be seen as the new CSS and JS files being requestsd were not available.

Kscope12-St.Hilaire-ApexListener

ODTUG – Kscope12 Compelling, Dynamic, Graphical



I have the privilege this year to present at the Oracle Developer Tools User Group and share some ideas around the generation of e-mail messages in APEX allowing the usage of graphics and templates that are developed in the APEX tool itself.  I have attached my last version of the slides for Kscope12 here for reference.

If you have questions about the implementation or want more information, feel free to contact me.

Kscope12-St.Hilaire-eMail_Generation

Glassfish, APEX Listener, and 403

In preparation for my ODTUG talk on the APEX Listener, I was updating my virtual machine to include the latest version Glassfish application server and deploying the APEX listener to talk to my XE database.  Nice little setup.  The Tomcat version of the listener is still working as I expected.  I have been using Tomcat for some time, but understanding that it is not a supported platform, I wanted to be able to show the APEX Listener features with Glassfish.

I went through all the steps in the Listener documentation.  Very concise and direct.  Everything seemed fine, until I ran into the dreaded HTTP 403 error.  This error basically means “you have been weighed, you have been measured, and found wanting.”  The application knows who you are, but you do not have the rights to continue.

Here is the details at the time of writing:

  • Glassfish 3.1.2
  • Java 1.6
  • Oracle XE 11g
  • Apex Listener 1.1.3
  • CentOS 6.0

After deploying the APEX Listener, the documented steps outline how to add users that are explicit to the configuration of the APEX Listener.  This allows usability of some of the advanced configuration and programming features of the Listener.  These users need specific group membership to be picked up by the .

Admin – Allowed to run the http://host:port/apex/listenerAdmin
Manager – Allowed to run the http://host:port/apex/listenerStatus

Note: one of the most common issues with group membership is case sensitivity.  First letter is capital.

After following all of the steps perfectly, you should be able to run the http://host:port/apex/listenerConfigure because this does not require any authentication.  After the listener is configured the first time, you will get the following message:

“The APEX Listener is already configured. Please login as Administrator to access APEX Listener Administration.”

To configure the listener via the web interface or tweak settings after the initial setup, you need to access either the listenerAdmin or listenerStatus page with a valid account having the group membership identified above.  Even after the groups have been setup per the documentation you may still receive the HTTP 403 error preventing you from editing the page.

I have tracked this issue down to a small setting in the security settings on Glassfish.  The JACC (Java Authorization Contract for Containers) by default … does not work as I want it to.  This needs to be switched to “simple” to complete the setup as documented in listener documentation.  That being said, I am sure the default provider (com.sun.enterprise.security.provider.PolicyWrapper) can be setup to work, but I do not have the energy or the will to try to figure it out right now.

The following image identifies the setting I am referring to.

After making the modifications, you should be able to run the listenerAdmin utility with an account that has been given the Admin group.

 

For the Record – Who’s on First

Who’s On First

 First Base:  Who

Second Base: What

Third Base:  I Don’t Know

Pitcher:  Tomorrow

Catcher:  Today

Short Stop:  I Don’t Give a Darn

Left Field:  Why

Center Field:  Because

Right Field: Nobody

APEX URL Syntax

I am always forgetting the syntax for the APEX URL construction.

http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/concept_url.htm

f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly

1-App:
2-Page:
3-Session:
4-Request:
5-Debug:
6-ClearCache:
7-itemNames:
8-itemValues:
9-PrinterFriendly

APEX backups

Martin always seems to have figured out a question I currently have, but he did it months ago.   This is a great article and example of doing an APEX backup using a windows Batch File.  This does not replace database backups, but will let you recover a single application if needed.  In DBA terms, only the records needed are extracted.

http://www.talkapex.com/2012/04/command-line-backups-for-apex.html