Weblog for the AMIS Technology corner
IT Architecture
Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)
Dec 20th
People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will zoom in on how to consume automatically content of Windows Office document (docx).
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
View more presentations from Marco Gralike
Most (APEX) people know the PL/SQL Gateway functionality of the XDB Protocol Listener, but this is only one very small part of the XDB Repository functionality. To be precise only one “servlet” part of it. Those “servlets” can be based on Java, C or PL/SQL. The PL/SQL Gateway, as it’s name suggests, is based on the PL/SQL part. Another “servlet”, the Native Database Web Service (NDWS), which enables you to create a database SOA endpoint service and more, is based on C code. Beside demonstrating the WebDAV ACL driven security features and database extensibility/interfacing facilities based on the database (no cost option) XMLDB functionality, it also explain one of the coolest features, IMHO, introduced in Oracle 11gR1 called: XDB Repository Events.
There is one big problem in all of this. It is very, very sparsely documented and although there is some, or was some, code out there on the worldwide web, it took me a while to get a feeling of all the specifics at hand. This post will extend on some of the posts I already created to give to a head start of what is possible. This post will demonstrate what you can do with Windows Office documents, nowadays embedded (zipped) XML content, with extentions called: docx, xlsx or pptx…
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
Dec 12th
Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file server. The presentation demonstrated as well how you could extent the “standaard” file server (aka your database) functionality with features like, WebDAV driven ACL Security and XDB Repository Events, which enable you to automatically trigger event driven actions based on, for example, file naming, content, creator or others.
You can find the presentation on Slideshare or enjoy it here.
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
View more presentations from Marco Gralike
During the demonstration in the second half of the presentation, we demonstrated how you can automatically consume the EXIF and KML information embedded in pictures to use it with the Google Earth API. All the code used for this Google Earth demonstration, and more, can be found on the Oracle XMLDB Sample Code page.
Have fun trying it out and if there any questions, post them on the OTN Oracle XMLDB forum.
WebLogic 12c released!
Dec 2nd
At December the 1st, 2011, Oracle announced it’s new major release, the 12c release. As Oracle added the i (internet) at its 8 release, the g(gridcomputing) at its 10 release, now the focus will be on the c(cloudcomputing).
Many new features come out of the fact that Oracle has made its key application server ready for the cloud, that is, ready for to run on enigineered systems, in fact its own Exalogic machine, Oracle’s solution for implementing the cloud.
So let’s take a look what this new release brings us, in this blogpost. There are several new features available in the 12c
New or enhanced WebLogic 12c features
- JAVA EE 6 support all kinds of JEE6 specifications are implemented like :
- JSF 2.0,Java Servlets 3.0 JPA 2.0 and EJB 3.1.
- Managed Beans 1.0
- WebLogic 12c also supports supports Java SE 7 (and Java SE 6).
- Java language optimizations and Internationalization
- Client and server support
- SSL/TLS 1.2 in JSSE to support JAVA Socket Transport security
- Converged Java VM:JRockit and HotSpot are incorporated with the best features from both.The JVM convergence will be a multi-year process, which was confirmed during my presence at Oracle’s Publisher Seminar 2011 during OOW
I won’t discuss the full list in this blog because there’s more about WebLogic than only (although very important of course!) the JAVA EE 6 specifications.
- Support for IDE’s. WebLogic already supported JDeveloper 11.1.1.5, but will come out with the 11.1.1.6 later on. Also suported are Eclipse and NetBeans 7.1 IDE. As said, the JDeveloper 11.1.1.6 and IntelliJIdea IDE will be supported in a later timeframe.
- New enhanced WebLogic Maven Plug-in See the various new options below in this scheme
Solving connection problems using virtualBox:”SOA&BPM Development VM”
Nov 2nd
A few weeks ago I had to work with a virtual box by oracle with a pre installed Database (xe) and weblogic to do some BPM Studio work. After the default installation I expected to just start the Virtual machine, start the weblogic server and enjoying the advantages of having everything installed properly…
Not exactly because I could not get the right connection established and on the virtual machine I could not get the Weblogic Server started. If you encounter the same type of problem here is my solution that worked for me and perhaps as well for you. Hoping this will speed up things and to concentrate more on the BPM stuff then actually fixing the bugs on the VM Boxes J. Read the rest of this entry »
Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups
Oct 14th
In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area.
From 11gR2 on the incremental backup pieces will get the same tag as the datafile copies, and that’s actually different behaviour from pre- 11gR2 versions of the database.
I stumbled on this different behaviour when a backup script, that worked perfectly on 11gR2, got ported to 10gR2 and 11gR1 ( 11.1.7 ).
The script contains a system cleanup of all incrementals, done before a certain date, specifying the tag of the copy [ 'COPY_DATABASE' ].
On 11gR2 the inc1 backups got deleted fine, but the delete on 10gR2 and 11gR1 just wouldn’t work.
By checking v$backup_piece…
select distinct tag
from v$backup_piece
where instr(tag,'TAG')=0;
…and getting no result, it became clear that the tag of the copy datafiles, was’t also the tag of the incrementals.
Once I knew, it was easy to correct the problem.
I just added the tag of my copy datafiles to the incremental backup, and that did the trick.
All incrementals that were supposed to get cleared from the pre-11gR2 system, were deleted.
The incrementals without tag, already on the system, were deleted manually.
My original 11gR2 incremental backup, and delete:
run{
allocate channel d1 device type disk;
backup
filesperset 8
incremental level 1
for recover of copy with tag 'COPY_DATABASE' database;
release channel d1;
}
run {
allocate channel d2 device type disk;
delete noprompt
backupset
tag 'COPY_DATABASE'
completed before 'trunc(sysdate-7)';
release channel d2;
}
The pre-11gR2 version of the incremental backup.. the delete hasn’t changed:
run{
allocate channel d1 device type disk;
backup
filesperset 8
incremental level 1
tag 'COPY_DATABASE'
for recover of copy with tag 'COPY_DATABASE' database;
release channel d1;
}
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
Oct 13th
Steven Feuerstein
In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken in de wereld heeft verzameld en die hij ook mede door zijn nauwe samenwerking met het PL/SQL product team van Oracle kan verifiëren en aanscherpen. Hij laat via code-voorbeelden en interactieve sessies zien hoe je als ontwikkelaar in staat bent om snel, hoogwaardige, goed onderhoudbare en uitbreidbare applicaties kunt maken.
Er is tijdens dit seminar voldoende ruimte om vragen te stellen en ideeën met Steven Feurestein uit te wisselen.
Bij dit seminar zijn de volgende zaken inbegrepen:
- Een exemplaar van het boek Oracle PL/SQL Programming (5th edition) van Steven Feuerstein (twv €71,-).
- Een PL/SQL quiz onder leiding van Steven Feuerstein met leuke prijzen.
- Ook ontvang je een gratis jaarabonnement op het PL/SQL Channel. Hiermee heb je toegang tot 27 uur videotraining (normaal $395).
Dit is de kans om in Nederland in een select gezelschap met één van de experts op PL/SQL gebied kennis te maken en je expertise in Oracle PL/SQL verder te vergroten. Meer informatie of inschrijven kan via deze link.
(NB: Deelname voor deze twee dagen kost 1050 euro)
OOW 2011 – Oracle XMLDB and Big Data
Oct 6th
Last day of Oracle Open World and I am currently attending the last presentations. The first presentation, “Oracle XMLDB: A noSQL Approach to Managing all your Unstructured Data”, deals with the no-SQL approach and using Oracle XML DB in the context of using it with “Big Data”, that is unstructured data. The title of the presentation is “a bit” misleading due it reference to noSQL data handling. XML is mostly used in the area’s of structured, data centric, semi-structured an unstructured, that is document centric data. Due to the flexibility of XML, it can be used for bridging those data content forms. Via the XDB repository, xmltype storage and xmlindex, that content can be moved into the XML DB part of the Oracle database, mapped and categorized. You can use repository events to shred and filter this map while the data is going in regarding interfacing via FTP or WebDAV. In all the presentation addressed a lot of already known fact of the XMLDB functionality and not really how to use it with huge amounts of unstructured data.
Oracle XMLDB XQuery Update in Database Release 11.2.0.3.0
Sep 22nd
I just made use of the very cool OTN Virtual Developer Day Database site. In this environment you can follow OTN Developer Day sessions, for example, at home, while making use of all the material available on that site plus the downloadable Virtualbox OTN Developer Day Appliance. Despite you can choose for tracks like Java, .Net, APEX, there is also a database section which handles (as you might expect it from me regarding interest) Oracle XMLDB functionality.
There is a 1 hour webcast available from Mark Drake, Oracle Product Manager, that takes you along all the basics / general overview (basic due too it is too extensive to show it in only an hour) of possibilities of Oracle XMLDB functionality. For convenience there is also a PDF document that has most of the slide info of the webcast. It doesn’t contain the demo’s or extra Virtualbox OTN Developer Day Appliance first steps info, of course, and what to do to reset the training XMLDB environment in this appliance.
This PDF and the webcast starts with the Oracle safeguard (legal disclaimer), with the general product outline slide saying among others that Oracle is not responsible or obliged to actually build-in features mentioned in that release or in that form…etc…so in that context it looks like…
Oracle XBRL Extention – Second Release now available for Download
Jun 7th
The XBRL Extention, a no cost add-on extention on XML-DB targeting the Extensible Business Reporting Language area, is now available for download. This second release ( p12388668_112020_Generic.zip ) of the Oracle XBRL Extension can be downloaded from the Oracle Support site (https://support.oracle.com). Once you have downloaded the file, please follow the instructions in the README.txt file to install the software.
Here are what’s new in the new in this release:
- New routines createStarSchemaFromFact and createStarSchemaFromHC have been added to PL/SQL package DBMS_ORAXBRLV to retrieve the list of table (view) names of a generated star schema.
- New routine DTS_filelist has been added to PL/SQL package DBMS_ORAXBRL to retrieve a discoverable taxonomy set (DTS).
For more info about the Oracle XBRL Extention see also “Oracle XBRL Extension Ready for Download”.
Getting started with … your career (in Dutch)
Apr 21st
Als bezoeker van deze blog ben je bezig met het maken van mooie oplossingen en nieuwe uitdagingen op technisch gebied. AMIS nodigt je uit om ons team te komen versterken. AMIS wil je op het gebied van Oracle en Java uitdagen de volgende stap in je carrière nemen.
AMIS merkt al enige maanden dat de markt voor Oracle en Java opdrachten aan het aantrekken is en maakt dat concreet met het uitvoeren van innovatieve opdrachten.
Om je een beeld te geven van het werk bij AMIS volgt hieronder een lijst met de trajecten waar we de afgelopen maanden aan gewerkt hebben.
- OSB / SOA Suite implementatie bij een grote informatieverwerkende organisatie.
- Realisatie in ADF 11g van een backend applicatie voor een internetwinkel.
- Realisatie van een SAAS oplossing op basis van Hibernate, Seam en RichFaces.
- Realisatie van een medisch registratiesysteem in ADF.
- Advies op het gebied van het gebruik van ADF 11g in combinatie met JHeadstart voor een energiebedrijf.
- Realisatie van een SOA / BPEL implementatie voor een pensioenfonds.
- Realisatie van een administratiesysteem voor een verzekeraar buiten Nederland (EU) in ADF 11g en JHeadstart.
- Oracle XML DB implementatie voor een grote bank.
- Realisatie van een SOA Suite / BPEL oplossing voor een grote logistieke leverancier.
- Proof of concept ADF 11g bij een groot adviesbureau.
- Oracle APEX / GIS implementatie bij een groot adviesbureau.
- SOA / BPEL traject bij een grote gemeente.
- Oracle WebCenter, ADF 11g, SOA Suite 11g en OSB traject bij een grote wereldwijde dienstverlener.
- Webservice koppeling met ADF en JAX WS voor een grote gemeente.
- Advies en implementatie van een professionele ontwikkelstraat bij een IT-bedrijf
- …..meer
Eva van der Kleij. Neem contact met me op via info@amis.nl of bel 030-6016000 |
We zoeken Oracle, SOA, Java developers die als medewerker van AMIS de vervolgopdrachten gaan uitvoeren. En denk niet direct dat je hiervoor te weinig kennis of ervaring hebt: jouw toekomstige ervaren collega’s doen niets liever dan jou verder helpen. Ons trainingsprogramma voorziet in een grote diversiteit aan opleidingen en tijdens onze interne kennissessies kun je op veel terreinen iets van je collega’s opsteken.
Kom ons eens van wat dichterbij bekijken en maak een afspraak voor een kennismakingsgesprek via Eva van der Kleij op info@amis.nl of bel naar op 030-6016000. Bel ons ook als je meer wilt weten over werken bij AMIS of een van de onderstaande functies. Concreet hebben we de volgende vacatures:
Wellicht sta jij volgende maand met een artikel op deze blog, schrijvend over de nieuwe dingen die je hebt geleerd of toegepast. Tot ziens bij AMIS! |
