Consuming Web Services from PL/SQL – Part I: Using Java Stored Procedures
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of Java Stored Procedures. In this article, we will create …
Author: Lucas Jellema
I Love Lucene – interesting article on TSS about Jakarta Java Based text-search engine
I found a very interesting article on how to get started – and what to expect – from Lucene, the Jakarta Apache text search engine library written entirely in …
JHeadstart for JDeveloper 10.1.2
The Oracle JHeadstart team is working hard on their ADF JHeadstart release for JDeveloper 10.1.2, to be released shortly – within a month according to the current plan. This …
Publish Diagrams in Oracle Designer – create PNG, GIF, TIFF, JPEG and BMP files for Designer Diagrams
Recently I installed Oracle Designer 9.0.4.5 – a maintenance release, released on November 18th. Previous releases were 10g (9.0.4.3) and patch release 9.0.4.4. All these releases contain a new …
SVG (Scalable Vector Graphics) and Maps of the World
January 12, 2005
Data Warehousing & BI, IT, Java, Oracle, Oracle WebLogic Server, Web HTML5 CSS3
No Comments
I have some vague plans for presenting statistics using SVG and a World Map. I was thinking for example about the spread of the visitors of our Website across …
XSLT in action – rather trivial tricks for XSLT that I always seem to forget
Recently I dipped into XSLT somewhat more seriously than I had done for quite some time. For some reason, I find XSLT not so intuitive to me that all …
How to lookup information based on IP address – e.g. for Website-visitors
During the last few years I have had several occasions to wonder who used the website and web-applications I had helped develop and deploy. Most recently I had this …
Paper on JDeveloper as tool for PL/SQL Development
Tonight I completed a paper on using JDeveloper as a tool for Database Design and Generation as well as PL/SQL Development. This paper is in Dutch and will be …
Oracle 10g Discoverer Drake available for download
One of the Christmas presents from Oracle this year was the release of the 10g Business Intelligence tools. Most interesting among them was probably the long awaited Drake release …
SVG, XSLT and JSP/JSTL: Generating Digital Gauge or Speedometer Chart based on dynamic data
SVG in combination with XML/XSLT is a tremendously powerful architecture to produce dynamic charts based on XML data – that can easily be generated from databases such as Oracle …
AMIS Technology Weblog – Statistics, Graphics and Becoming an Author (‘blogger’)
In July 2004 we at AMIS started this Weblog. Initially we primarily wanted to share knowledge among all people working at AMIS. Later we decided to make the Blog …
Generating SVG Graphics in JSPs using JSTL & XSL(T) – from MySQL to Bar Chart and Pie Chart
This post discusses how data retrieved from a MySQL or Oracle database using the JSTL SQL tags is processed as XML document, transformed using XSL and rendered as SVG …
XSL Transforming XML generated from SQL results using JSTL tags in JSP pages – putting JSTL to the test
While working on more advanced Statistics Reporting for our weblog, I did some investigations into JSTL and more specifically the XML and SQL tags. Yes, I know I have …
AMIS Query – Oracle BPEL Process Manager Dissected (Thursday 27th January)
BPEL is emerging as the standard for assembling a set of discrete services into an end-to-end process flow, radically reducing the cost and complexity of process integration initiatives. The …
Enabling Role-based security management in Oracle Designer 6i/9i/10g through the Repository Object Browser
Managing users and privileges on countless folders and application systems, configurations and workareas as is the job of the Repository Administrator can be quite a task. Each privilege on …
Providing default-values for find-pages in JHeadstart applications (UIX/BC4J/Struts)
An interesting problem we were working on some time ago is the following: a JHeadstart application – release 9.0.4.5 created with UIX, BC4J and Struts, JDeveloper 9.0.3 – has …
Book Review: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration by Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault
Title: Oracle Database 10g New Features – Oracle10g Reference for Advanced Tuning and Administration Authors: Daniel Liu, Don Burleson, Madhu Tumma, Mike Ault Published by: Rampant Tech Press ISBN: …
Pivoting in SQL using the 10g Model Clause
In this post we discuss pivoting of records in SQL - either splitting or merging records. Typically this is done using PL/SQL based Table Functioins, UNION (for splitting records) …
For our eyes only – Oracle EPB (Enterprise Planning & Budgeting)
Last Friday we enjoyed one of the special privileges we have in our partnership with Oracle in The Netherlands – we have a private session on one of Oracle’s …
Parallelizing Table Functions (instead of paralysing)
![Parallelizing Table Functions (instead of paralysing)]({"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"http:\/\/seattletimes.nwsource.com\/ABPub\/2012\/08\/02\/2018836700.jpg","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"} "Parallelizing Table Functions (instead of paralysing)")
In this post I explore the parallel execution of Table Functions. I was told it could be done, I have seen the examples and now I have tried it …
Of Data Guard and the Night Watch; a Date with Chris at the Rijksmuseum
Last Thursday evening was special. On the occasion of Chris Date’s visit to The Netherlands, the product marketing department of Oracle Netherlands had gathered some 25 odd (could also …
9.0.4.5 Maintenance Release Oracle Designer available
Today I discovered the 9.0.4.5 maintenance release for Oracle Designer 10g on MetaLink. It has been released on November 18th, so this is not hot news. The 9.0.4.5 is …
Table FUNctions: select a graph in SQL
You may seen some enthousiastic ramblings on Table Functions in earlier posts I have written. This is another one. With approximately 50 lines of code, you can select crude …
The December shipment is in: New books have arrived
Last week we received another shipment of books for our evergrowing library. Among this shipment were these titles:
Tom Kyte presenting in The Netherlands – 8,9 and 10 February
On February 8, 9 and 10, Tom Kyte will present a seminar – just around the corner, in Utrecht. See Seminar Details for details. The event is organized by …
SchemaSurf (Freeware) – Browser based tool to navigate the database
Perhaps SchemaSurf from Cobblesoft – FREEWARE – is worth a little investigation. SchemaSurfTM is a browser-based tool for querying your Oracle database schemas. Unlike most other tools, SchemaSurf does …
Making up records in SQL Queries – Table Functions and 10g Model clause
From time to time there is a need in my SQL queries to have access to a table with a specific number of records. Sometimes I want to explode …
Tip for Oracle Designer API programming
Today I was at a customer site where we discussed programming using the API for Oracle Designer and Oracle SCM. I demonstrated the F5 function key in both the …
Another JDeveloper extension: Force Delete utility for ViewObjects (ADF Business Components pka BC4J)
This post is the sequel to AMIS publishes a ViewObject Copy tool – JDeveloper 10g Extension (plugin) for ADF Business Components that we released last week. That post announced …
SQL Script to empty out/cleanse a user schema
OK, it is a fairly trivial task. But when you have to prepare for workshops etc. it may take a lot of time to purge/cleanse/empty all student’s schemas without …
Interesting articles on various subjects
November 5, 2004
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
1 Comment
In this post I collect references to interesting articles on a variety of topics – Java, SQL, Business Intelligence, Web Services, HTML/CSS, JavaScript – that I have come across. …
Oracle (finally) announced release of Enterprise Planning and Budgeting
From both the Oracle website as well as Mark Rittman’s weblog the release of Oracle’s new enterprise level Business Intelligence product Enterprise Planning and Budgetting was announced. This tool …
AMIS publishes a ViewObject Copy tool – JDeveloper 10g Extension (plugin) for ADF Business Components
We at AMIS work hard and with great fun at developing high quality applications. We like to use good tools and we like to push those tools to the …
Google Desktop Search – no more agonizing searches for lost documents
This weekend I installed the Google Desktop Search tool. It is currently in Beta, it is free, about 400K in size and can be downloaded from http://desktop.google.com/. After you …
JHeadstart recipe – non-databound search-criteria
From today’s customer assignment I extract the following recipe – for BC4J, JSP and Struts.: Suppose that on the FindPage of our JHeadstart generated JSP application we would like …
JBoss releases library for Aspect Oriented Programming
JBoss just released JBoss AOP 1.0 Final production release. See the announcement on The Server Side – JBoss AOP 1.0. It has a plugin for Eclipse but can be …
AMIS publishes Extensions for the JHeadstart Application Generator
Today AMIS announces the immediate availability of the AMIS JHeadstart Application Generator Extensions. A free set of enhancements for JHeadstart 10g (9.0.5.x) that will allow you to generate much …
Oracle Designer – on Design Editor performance and Repository Maintenance
Yesterday it was an almost nostalgic day. For several years – primarily in the late 1990’s – I was heavily engaged in everything to do with Oracle Designer, its …
AMIS Library System – JHeadstart 9.0.5.x (BC4J, JSP+JSTL) Demo Application released
October 20, 2004
Java, Oracle Application Development Framework, Oracle WebLogic Server, Tools
No Comments
Today, AMIS released the JHeadstart 9.0.5.x version of the ALS application for BC4J and JSP/JSTL. Download the zip-file with the entire application, the database setup and the JDeveloper 10g …
BC4J and Distributed deployment (in particular of JHeadstart Applications)
Thusfar we have been lucky – or careless – to not have had to consider distributed application deployment. However, web-applications running in the DMZ accessed by internet users directly …