Category: Oracle
One of the annotations available to us when specifying the EJB 3.0 Persistence metadata for our Entities is the @Version annotation. The specification states: “The Version annotation specifies the …
I have done a fair bit of Entity Relationship Modeling. It’s one of the things I probably like most about my job. And one of the things in ERD …
In an earlier post, we embarked on a tour of EJB 3.0 Persistence for J2SE (stand alone out-of-container) applications: Getting Started with EJB 3.0 Persistence out-of-container using the Reference …
The problem I was facing was simple. You have a table with data. The data in that table should be validated. Invalid rows should be deleted. For each deleted …
The new Raptor tool for Database Development contains a feature called Snippets. Snippets are predefined fragments of SQL or PL/SQL code that you can easily include in a piece …
Project Raptor, announced and demonstrated at Oracle Open World, this Fall, has now been released (sort of, as it is still an early adopter release). A free download (60Mb) …
In a previous article –Getting Started with EJB 3.0 Persistence out-of-container using the Reference Implementation (GlassFish) – I have introduced GlassFish, the official Reference Implementation for EJB 3.0, and …
Some of my colleagues have posted their comments to JavaPolis 2005 on our weblog already. See the AMIS Technology blog for these weblog entries. I’ll add my comments to …
As a first recap of my five days at Javapolis, here are my thoughts on trends, past, present and future of the Java platform. Expect to see more in-depth …
Just browsing through my RSS feeds-reader, I stumbled across three very interesting announcements: JSR-220, the Enterprise JavaBean 3.0 specification, has reached Proposed Final Draft status. Programmers should expect that …
While EJB 3.0 persistence gains a lot of attention we should not forget that EJB is more than persistence but also contains session beans and messaging driven beans. Mike …
Since SOA is hot, many presentations were devoted to differents aspects of services. The adoptation of services is growing rapidly. This requires standarization in the way we handle services …
Many frameworks offer support for developing web applications. Allmost all of them implement the MVC pattern. They can be divided into two groups: action based and component based frameworks. …
We just received word about the results from the RAD race at JavaPolis 2005. 12 teams competed against each other, each bringing its favourite technology stack. It is a …
Selenium, a test-tool for Web Applications, was the subject of one of the quicky presentations (15 minutes max) on JavaPolis this week. It is described as: Selenium is a …
Eddie Awad has a nice blog about three apps to format your SQL code. Especially the online tools, SQLinForm en the Online SQL Formatter, are very nice. Both offer …
Since December 2004, we participate in the Oracle Warehouse Builder beta program for 10gR2 – the Paris release. Yesterday, I downloaded the Beta 4 Release, the most recent stage …
Yesterday we received another book shipment. Unfortunately I did not get all the books I had asked for, but they should make a good read over the holiday season. …
Next week, we are off to Antwerp. A crew of seven AMIS Java/J2EE developers will visit JavaPolis, the largest Java/J2EE conference on this side of the Atlantic. I will …
Do you know what it sounds like when a production system comes to a grinding halt? It sounds like a telephone ringing. Actually it sounds like a dozen phones …
For the Designer 10g/WebForms 10g project I am involved with, we had a rather unappealing task to allocate. It involved an unknown number of items prompts that ended with …
Did you (or one of your customers) ever encounter ORA-00942 (table or view does not exist) while working in a (Web) form? No, then you can skip this post. …
JHeadstart can generate a number of powerful search facilities, such as the Quick Search widget and Advanced Search area. It supports several different serach operators such as contains, like, …
While browsing through the OTN Forum on SQL and PL/SQL, I found a question that asked ‘I can copy a table using the create table as select * from …
As of now, JHeadstart 10.1.2.2 is available from http://cso.oracle.com – for organisations who have the JHeadstart Supplement Option. I have recently been making fixes and extensions to JHeadstart Application …
Virtual Private Database is a quite powerful concept. It lets you set up a mechanism in the database that dynamically appends additional filter-conditions to the queries performed by end …
After the announcement of Oracle XE I got really curious about the possibilities of a free Oracle10g database. OK, it is limited to 4GB and it doesn’t allow things like …
Yesterday I had a few mind boggling experiences with Oracle Lite. Together with our customer and my colleague Arjaan, I tried to install Oracle Lite. This is a very …
Triggered by Steve Muench’s weblog, I stumbled across a recent posting by the JHeadstart Team on their current and future activity: The Future of JHeadstart. The big news of …
Validation of business rules, of data oriented business logic, is one of my favorite recurring challenges. Around these rules, there are always interesting discussions about how and especially where …
This article serves two purposes: it extends the JHeadstart Application Generator to set UIX items to "required" based on a new custom Mandatory property – instead of driven from …
AMIS has just published a booklet (250 pages) with the best articles from Magazines, Conferences and this Weblog. A dozen different authors, specialists in various areas such as Oracle …
In my current project – with Oracle Designer 10g, WebForms, Headstart and CDM RuleFrame, Repository Object Browser, CVS, Oracle SCM and Jira for Incident Management as well as TransferWare …
On my current assignment I am working on interfaces between Tibco and Oracle PL/SQL applications. Tibco is a middleware solution that implements a messaging based interface solution between different …
Finally, I have attended to one of my long running frustrations with CDM RuleFrame: the Business Rule Design Transformer, that key Headstart utility that takes Business Rule definitions in …
For one of our sessions for the Knowledge Center Oracle Server Development I had to prepare a presentation and demonstration on new Oracle 10gR2 features in SQL and PL/SQL …
From previous posts, you may have understood that I have been using VPD policies – Virtual Private Database or Fine Grained Access Control – quite extensively in my current …
JHeadstart version: 10.1.2.0 (build 19) and probably 10.1.2.1 ADF UIX version: 2.2.16 JDeveloper version: 10.1.2.17.84 Description After launching a LOV and selecting a value from it, the lookup values …
The next edition of the yearly reunion of the best (and nicest) Oracle Developers in the world is going to be held from June 17th to June 21st, in …
From the OTN Series on “Mastering .NET Application Development with Oracle”, this installment on taking advantage of .NET stored procedures in your applications. See Using .NET Stored Procedures in …
![How Rownum can help you tune a Query]({"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"} "How Rownum can help you tune a Query")