XFILES « blog.gralike.com

17Jan/10Off

Updated XML(DB) Content

For my and your convenience, I have updated my "XML Content" page so it is a little bit easier to find the XML posts. There weren't that many typical XML posts although I think the list has been added with another 20 post links. 2009 was a year with al lot of economic pressure (therefore more work and less energy to do some extra fun stuff in the evening), testing the Oracle 11gR2 beta software over and over again and a lot more presentations training and preparations to get it done.

Anyway. I hope it will make a useful list and get you started on some of the XML DB features.

Filed under: 11gR1, 11gR2, APEX, XFILES, XMLDB No Comments

26Nov/09Off

XFILES (Part 6) – XFiles for APEX EA 0.1 – Available for Download

The XFiles for Apex "Early Adapter" 0.1. release, is available for download.

In principle its the same stuff I got from Mark Drake and posted about before, but now also with the APEX SQL workspace import script as well. I have to start somewhere and I shouldn't let you wait too long playing around with it yourself. If need more info, then also have a look at the original PPT's from Mark and Carl used during their OOW 2008 presentation.

Roel Hartman and I am trying / made a first attempt of an installation manual. So try it yourself first (...on a test environment of course...) with the hints given here by me and have a look later at the XFiles post that describes the proper installation steps needed.

Be aware that there are certain pre conditions that should be met. We, Roel and I, identified at least the following:

Tagged as: EA 0.1, XFILES, XFILES for APEX Continue reading

23Nov/09Off

XFILES (Part 5) – How to Open Up the XML DB Repository for APEX ?

The biggest problem the APEX application has, regarding XML DB interaction, is that it doesn't understand / support (yet) typical XML DB structures like the datatype / operator "XMLType". To make APEX capable to support these structures some coding has to be done transforming an XMLtype value into other datatypes like CLOB or a varchar2.

In the XFILES application this is supported via the package "XFILES_APEX_SERVICES". This package contains, among others, a function called "LISTDIRECTORY" which shows the content of files and (underneath) directories in a (root) directory.

For example, via WebDAV access, Oracle XML DB Repository content can be made visible while using Windows Explorer, of the following /home directory.

Click on the picture to enlarge

The actual content seen here (or via HTTP, FTP) is a representation of an XMLType table in the database called XDB$RESOURCE.

Tagged as: path_view, resource_view, xdb$resource, xfiles_apex_services Continue reading

15Nov/09Off

XFILES (Part 4) – The Supporting XDB Utility Packages Needed

Its free. Its cool. You need them for the APEX XFILES demo application. As far a as I know now, you need two supporting PL/SQL packages to make the APEX XFILES application work:

The origins of those PL/SQL packages, etc, are supporting code used by the XMLDB Development team themselves. More info, demo's or scripts can be found on the OTN XMLDB website. The XMLDB Development team started to split the scripts up for use in specific areas. The old xdbutility zip package had most of them still combined. Now the xdbutilities.zip package with PL/SQL scripts and packages (aka the "Oracle XML DB Ease of Use Tools for Structured Storage") its specific usage is pinpointed on manipulating and managing XML Schemas which are used for XMLType based storage (I saw that 99% of them reflect, are usable with XMLType tables Object Relational storage only). In the now, for the first time, available document it states:

Tagged as: xdb utilities, xdbmp, xdbutilities Continue reading

8Nov/09Off

XFILES (Part 3) – The APEX Look and Feel

Had my adventures today. Most of the packages are compile and the XDB utility packages are in place (will come back on those in a later post). Apparently as said before, Mark has added some extra new functionality "Application Security" for use with APEX. This almost locked me out today after bringing into place all the packages, dependencies etc. While almost finished, my APEX "admin" account was locked out. I did a reset of the admin password but then I got the neat security message: "Access denied by Application security check. Application access restricted to internal workspace users.". Oops.

Although...Its actually cool ...

Hacked my way in via amongst others resetting the admin password again and xdbconfig.xml content that controls the (as it is called in the APEX domain) PL/SQL Gateway (aka the XMLDB Protocol Server).

The looks...

I don't think a lot has changed to the application since Carl and Mark worked on it, besides the now build-in Application Security part (Managing XML Content with Oracle XML DB and Oracle Application Express). I didn't cross-reference it yet with the "original" from OOW 2008, checking it via my old pictures of the presentation in 2008

Anyway. So does it look like? Have a look at the following pictures.

You might have already seen the web page in my earlier post. It also enables you to login using a defined "Application Principle" account.