The Hotsos Conference 2010 agenda has been set-up and the topics are being in the…
www.xmldb.nl Posts
Apparently there is already a Early Adopter Release since september, but even so, I am very happy that the first XMLDB features are getting implemented. The readme describes the new feature for XMLDB as
- XML Type tables are visible in the Connections navigator
- XML Type columns data can be edited in Data tab
I tried it a bit and saw to my plesant surprise that it also provides, will provide, direct XDB Repository access to files and folders. Really cool. The first (small) mistake was also noticed by me, in the overview, describing an XML Schema as a datatype BLOB. Hint for the Oracle SQL Developer Team, a more descriptive, correct content type can be deducted from the XDB$RESOURCE table due to the fact that the content type/mime type will be display in this table (see also xdbresource.xsd) “purchaseOrder.xsd” as text/xml.
Look and feel regarding the editing of XMLType is a bit like Toad does it, at least in the Early Adapter version. Not a direct possibility to edit an XML document, but a extra window that pops-up before you get the option to edit the content.
Click on the picture to enlarge
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.
Click on the picture to enlarge