Oracle Warehouse Builder 10gR2 (beta), a first impression
As in most project the need for a representable test data set existed in a recently started one. The data was available in a small MS Access database (7 …
Category: Oracle
FireFox on the march – 29%! : Browser Statistics from the AMIS Technology Weblog
Our weblog started last July. Since then we had over 250000 hits from over 45000 different IP-addresses. Last night, I sat down to do a comparison between the various …
Installing Tomcat5.5 and integrating it with Apache 1.3
Recently I have upgraded my web server at home to the latest version of Tomcat (version 5.5.7 at the moment of this writing). Time to document my steps a …
Lots of little interesting notes on Oracle 9i & 10g – database design, DBA, architecture, performance etc. from the Tom Kyte seminar
Last week, I sat with six colleagues at the AskTom Live – seminar with Tom Kyte. You can see us sitting here in the frontrow. You may have seen …
Model driven Design of ETL functions
Analysis and functional design for regular application development has been standardised over the years. Now working on Business Intelligence (BI) projects for the last one and a half years, …
Discussion on The Server Side: Comparing Microsoft Yukon (SQL Server 2005, Beta release) with Oracle 10g
I ran into an interesting discussion on The Server Side: Comparing Oracle 10g and SQL Server Yukon. It contains a link to a white paper: Features, strengths, and weaknesses …
Tom Kyte part II. Using what we have learned
In this post we will tune a query from being hopelessly slow to fast. We will use “explain plan” to analyze the query plan. We will see how Oracle …
Default Display Value – ADF JHeadstart icing on the cake
If you want to set default values for ViewObject Attributes in new records, you can now very easily do so when your application makes use of the ADF JHeadstart …
Struts best practices – white paper on JavaWorld
An interesting white paper: Struts best practices Multiple options are available for solving problems with Struts. When deciding among these alternatives, the choice must be based on parameters such …
Pie Charts in SQL – how pathetic can you get?
I have written a number of posts on alternative, far fetched usages of Table Functions. My all-time high thusfar was a post titled Table FUNctions: select a graph in …
Tom Kyte about Things we "know"
Last week I attended the Tom Kyte seminar in Utrecht. This was a very impressive seminar held by a real Oracle database Guru. Tom says he still thinks of …
Stored Java to run an OS command, copy a file and get a directory listing in Oracle
Oracle 8.1.5 introduced the ability to choose Java as a language to implement a stored procedure. One of our customers required the following functionalities from within an Oracle database: …
Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required
![Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required]({"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"} "Courtesy of Tom Kyte: Generating rows in SQL with the CUBE statement – no dummy table or table function required")
In a previous post Making up records in SQL Queries – Table Functions and 10g Model clause I discussed how you can make use of either a Table Function …
ADF UIX tidbits – things I want to remember but never do… (conditional expressions, switcher/if/data bound)
This post does not contain anything spectacular. I will discuss various ways in UIX to conditionally display elements using very trivial techniques – a databound rendered attribute, the if …
XSLT is Way Faster Using Java 5
Interesting post by Dino Fancellu on SoftwareReality.com, XSLT is Way Faster Using Java 5, talks about how by replacing Xalan by XSLTC and Crimson by Xerces Sun JDK 5.0 …
Combine Oracle Toplink and the Spring Framework – Rod Johnson & Jim Clark
An interesting article Of Persistence and POJOs: Bridging the Object and Relational Worlds, by Rod Johnson and Jim Clark in Mastering J2EE Application Development Series on OTN (the Oracle …
Using ADF without JDeveloper – good insight in the mechanics behind Oracle's Application Development Framework and JSR-227
It has always been my understanding that choosing ADF (Oracle’s relative new Application Development Framework and the – perhaps premature – implementation of the JSR-227 – means choosing JDeveloper. …
Templates in Oracle JDeveloper
Chris Schalk has posted a very interesting blog on web templates in JDeveloper 10.1.2 (production) and JDeveloper 10.1.3 (preview). This how-to is only published on the Chris Schalk’s blog …
BPEL-Soft – Oracle's previous acquisition showcased during AMIS Query
Want to know more on Oracle BPEL Process Manager and in particular about the upcoming release with the JDeveloper plugin? This article gives an overview as well as some …
Missed MySQL New Toolset
I apparently completely missed the new MySQL toolset, which was announced on December the 8th 2004. The MySQL database ships now with easy-to-use visual database tools: MySQL Query Browser …
AMIS Query on Oracle BPEL Process Manager – Overview, Latest developments and a Preview of the (beta) JDeveloper plugin
Today – January 27th – we have another AMIS Query, this time on Oracle BPEL Process Manager. AMIS Queries are a series of expert technical sessions for AMIS staff, …
(When) Should we embark on ADF JHeadstart?
Organizations currently using JHeadstart 9.0.4.x or 9.0.5.x (for JDeveloper 9i or JDeveloper 10g (9.0.5.x) may wonder whether and when they should pick up the soon to be released ADF …
W3C Recommendations Enhance SOAP Performance
Read this today on http://w3.org: The World Wide Web Consortium today released three W3C Recommendations to improve Web services performance by standardizing the transmission of large binary data. “Web …
Effective Oracle by Design
Title: Effective Oracle by Design – Design and Build High-Performance Oracle Applications Author: Thomas Kyte Published by: Oracle Press ISBN: 0-07-223065-7 Publication Date: 2003 Details: 664 pages, $59.99; www.OraclePressBooks.com …
Oracle Business Intelligence Spreadsheet Add-In Available for Download
As was announced early in 2004, Oracle has just released the Oracle Business Intelligence Spreadsheet Add-In. This is an add-in for Excel. OracleBI Spreadsheet Add-In enables end users to …
Publishing PL/SQL Based WebServices
January 24, 2005
Database, IT, Java, Oracle, Oracle WebLogic Server, PL/SQL, Web HTML5 CSS3
2 Comments
This post discusses how a Web Service can be published based on a PL/SQL Package inside the Oracle Database – using Oracle 10g JDeveloper. In this article we will …
Migration from JHeadstart 9.0.4.x or 9.0.5.x to ADF JHeadstart (beta)
You may have seen our AMIS Library System application (ALS). It is shipped as demo-application (for JHeadstart & Toplink) with JHeadstart 9.0.5.x. We also have a BC4J version of …
GNU utilities for Win32
Windows is not shipped with a lot of tools for the developer. Simple tools like grep, sed, make are not provided. Today I installed UnxUtils. A set of GNU …
Consuming Web Services from PL/SQL – Part II: A pure PL/SQL solution using UTL_HTTP (Oracle 9i or 10g)
This post discusses how a Web Service can be consumed from PL/SQL inside the Oracle Database through the use of the UTL_HTTP supplied package. In this article we will …
Paris for the Designer
Today I looked into a pre release of Oracles Warehouse Builder 10gR2 (Paris). This comprehensive tool can be used to create complex data warehoused holding data from many different …
ADF JHeadstart Beta – Impressions of Build 10
Today we received a hot build of ADF JHeadstart Beta for JDeveloper 10.1.2 (build 10). We have been experimenting with the ADF JHeadstart beta build for several months now …
ADF Faces JHeadstart ?
Andrej Koelewijn spotted a Jason Jacobi post on OTN regarding an upcoming utility for migration of UIX pages to ADF Faces/JSP pages. The upcoming JHeadstart release will support ADF …
Addition to LOG4PLSQL to make loglevel adjustments at runtime.
I have recently used the LOG4PLSQL software for logging in a small application. I missed the possibility to change the logging level at runtime. In the production environment code …
Single Sign On for Web Applications – Use of Windows Login details
The post JCIFS and jWebUnit by Matt Raible describes use of JCIFS to achieve single sign on for web applications based on the Windows Login. On my current project, …
Starting with JasperReports
January 20, 2005
AMIS, Databases, Java, Oracle, Oracle WebLogic Server, Tools, Web HTML5 CSS3, Web/Java
81 Comments
My first days at AMIS I examined JasperReports (v. 0.6.3), an open source report-generating library. This tool is entirely written in Java and uses XML report templates to generate …
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 …
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 …
OpenVPN: How to safely access a database behind a firewall
OpenVPN is an open source VPN implementation which can be found on http://www.openvpn.net With OpenVPN, you can: tunnel any IP subnetwork or virtual ethernet adapter over a single UDP …