Oak Table Seminar – Optimizing Oracle Performance by Design by Jonathan Lewis (day 2)
Jonathan Lewis Optimizing Oak
Category: Database
Getting started with the EJB 3.0 Query Language (EJBQL 3.0) using GlassFish reference implementation
This article is the sequel to EJB 3.0 Persistence – Introducing EJBQL 3.0, an introduction to EJB QL from an historical, strategic and functional perspective. In this post I …
Getting started with Unit Testing of JDBC based DAOs with the Spring Framework (introducing DBUnit)
For one of our Java projects, I wanted to help a colleague getting started with unit testing. Due to high time pressure, there was a real risk that – …
Oracle buys Sleepycat
It becomes stranger and stranger. After bying the open source company InnoBase, Timesten, and others, Oracle now also bought SleepyCat. Oracle also released its own freeware in the form …
AMIS Query on Oracle Enterprise Service Bus, Oracle WebServices Manager, SOA & BPEL. …and not about JBoss
Yesterday we had another of our AMIS Query sessions – for technical specialists from AMIS, our business relations and even our collpetitors in the Dutch marketplace. Some 30 people …
Oracle acquires SleepyCat – open-source BerkeleyDB embeddable database engine now owned by Oracle
It was a rumour – actually one of three: JBoss, SleepyCat and Zend PHP, see our article Is Oracle buying JBoss? Or Zend PHP? Or SleepyCat? Or all of …
Does a simple in-line view affect performance?
![Does a simple in-line view affect performance?]({"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"} "Does a simple in-line view affect performance?")
A while ago on the SQL and PL/SQL forum on Oracle Technology Network someone asked a question regarding a pivot query. Because the question was justed posted I was …
Is Oracle buying JBoss? Or Zend PHP? Or SleepyCat? Or all of them?
This article Oracle’s Open-Source Shopping Spree in Business Week Online suggests that Oracle is involved in serious discussions with JBoss, Zend and SleepyCat about a take over – for …
Getting started with the Dali plugin for Eclipse supporting EJB 3.0 Persistence
EJB 3.0 Persistence is a topic that is high on our list. We have written a substantial number of blog articles on it after doing quite some research as …
EJB 3.0 Persistence – Workshop Materiaal
Gisteren, donderdag 9 februari, hadden we een uitstekende bijeenkomst rondom EJB 3.0 Persistence API. Met z’n 16-en – waarvan twee geïnteresseerde externen – hebben we in goed drie uur …
Starting with EJB 3.0 Persistence in Eclipse 3.1 using the GlassFish Reference Implementation
This article describes a quick route to starting out with the relatively new EJB 3.0 Persistence API from the Eclipse 3.1 IDE. In a subsequent article, I will discuss …
Implementing Virtual IP addresses with Oracle 10g/RAC for E-Business Suite 11i
Oracle 10g Cluster Ready Services enables databases to use a Virtual IP address to configure the listener on. This feature is to assure that oracle clients quickly failover when …
Calling Stored Procedures using plain SQL – For when SQL is allowed but calls to Stored Procedures are not
While investigating the relatively new EJB 3.0 Persistence API, I came under the impression that the specification does not cater for Stored Procedures. In general, there seem to be …
Generate a native Excel file with SQLX
I wanted to generate an Excel file with data coming from an Oracle database. One of the best ways to do this is to generate an Microsoft Excel XML …
EJB 3.0 Persistence – Introducing EJBQL 3.0
EJB QL or Enterprise Java Beans Query Language has been introduced in the EJB 2.0 Specification, back in 2001. For some reason, it never grew on me. I did …
How to properly start OC4J on a production server.
January 5, 2006
Databases, Java, Oracle, Oracle E-Business Suite, Oracle WebLogic Server, Web HTML5 CSS3
7 Comments
The proper way to start OC4J is sparsely documented by Oracle: To start OC4J in a standalone environment, issue the following command from the j2ee/home/ directory: java -jar …
ASM made easy
Great article about ASM on the website of Howard Rogers: http://www.dizwell.com/oracle/articles/desktop_asm.html For both Linux and Windows.
EJB 3.0 Persistence – using the @Version annotation for Optimistic Locking – in the GlassFish Reference Implementation
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 …
EJB 3.0 Persistence – ManyToMany relations or the objectification of the intersection table
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 …
How to use weak ref cursors and bulk collects into a table of objects to clean up data
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 …
Oracle releases Raptor – free tool for Database Development (SQL, PL/SQL, database object browsing)
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) …
Three interesting announcements – EJB 3.0, Eclipse WTP and a new database: H2 (source included, Java)
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 …
EJB 3.0 Reference Implementation with teeth – Open Source EJB 3.0 by Sun and Oracle (Report from JavaPolis)
There are some major waves in J(2)EE territory captivating much of the focus of the audience at this year’s JavaPolis – and beyond. One undoubtedly is Java Server Faces. …
SQL formatting
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 …
Copy Triggers when you Copy a Table
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 …
My First Oracle XE
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 …
Resetting the parameters in the Headstart Report Launch Form – small but useful change
I would not be offended if you were to decide to quickly skip this article. It ain’t much. However, for my current project it proved pretty important, this apparent …
Oracle Lite Part 2, how to get started (continued)
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 …
Sending CLOB data from Tibco (Java) to PL/SQL stored procedures
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 …
Oracle 10gR2 – Conditional PL/SQL Compilation
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 …
New Release Times Ten
Oracle announces release 6 of their In Memory database, more details here. Faster, bigger, better and easier… well, let’s try it first.
Using .NET Stored Procedures in Oracle 10gR2
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 …
Oracle to offer free database
Released on 25th October 2005, Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint database based on the Oracle Database 10g Release 2 code base that’s …
Oracle Lite and Java
Oracle lite is a very interesting product. As the name indicates, is it a lite version of the Oracle database and thus capable of running on a PDA, laptop …
Functional Partitioning
We all know partitioning for performance issues or for storing historical data. But partitioning can also be used for functional purposes such as creating a savepoint in batchrun. Such …
SQL+ connect identifier
Sergio describes on his blog how you can connect with sql+ to to a database without the need of the tnsnames.ora file. This is great, but only available since …
Introducing new Oracle10g R2 features for Application Development (article in Dutch)
For the Fall 2005 issue of OGh Visie, the magazine of the Dutch Oracle User Group, I have written an article introducing the most enticing new features for Application …
10gR2 New Feature: Asynchronous Commit
Again a very good post on a 10gR2 feature by Natalka Roshak. This time she writes about the Asynchronous Commit in 10gR2. See: 10gR2 New Feature: Asynchronous Commit Asynchronous …
VPD Policy Tester
My VPD policies were causing troubles when I was running the Forms: ORA-28113 Policy Predicate Has Error . I could not easily figure out which Policy it was, as …
Use of TODO tags to quickly generate a tasklist for PL/SQL development
There are quite a few neat tricks we can steal from other technology stacks and communities for use with PL/SQL development. I have recently written an article on AOP …