Category: Databases
Arup Nanda writes about new features for the upcoming Oracle 10gR2 release, targeted at the end of June 2005. In this article, he discussues new SQL and PL/SQL features. …
Just read the post Executing Oracle PL/SQL from Ant on how to use Ant for executing PL/SQL tasks, such as creating Packages and Stored Procedures. I have used Ant …
The tool JPublisher is a little bit unknown. But it is a very handy tool for accessing PL/SQL stored procedures, packages, functions as well as object, collection or reference …
Working for years with Oracle’s relational environment, XML DB is a completely different kind of beast. You’re confronted with all the languages and techniques the XML environment has to …
Yesterday i was reading nice discussions on Asktom about the dual table. Afterwards somehow a "undocumented" Oracle feature popped into my mind again. Last time I used is at …
Recently I encountered the problem of overriding error messages in my project created in JDeveloper using ADF/JHeadstart. I wanted to get rid of messages containing codes like JHS-00106 and …
Papers for the ODTUG 2005 conference are limited to 10 pages. That is not enough. It never is, by the way. This time, I restricted myself to only three …
Imagine this situation: you have created several tables and a view that queries several columns in these tables. Using BC4J you’d create a ViewObject on the view. The ViewObject …
Over the last few days I scanned trough documentation about Oracle10g (Oracle 9i) Lite the get a overview of the possibilities. Furthermore I tried to install the product on …
The Oracle 7Up workshop that I teach every few months introduces many Oracle 8i, 9i and some 10g features to experienced SQL and PL/SQL developers with a firm footing …
Yesterday, I had to install XMLDB on an already very heavy used system. On this UNIX system, an old Oracle IAS is installed, OAS 10g (version 9.0.4) and an …
All statistics on the visits to the posts in the AMIS Technology Weblog are gathered in a MySQL database that sist underneath WordPress. We would like to do some …
This weekend I read a small article in a local Dutch IT-magazine that took me by surprise. I suppose I should have seen it before, but for some reason …
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 …
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 …
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: …
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 …
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 …
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 …
Er is lang op gewacht, maar hij is er nu ook voor Windows – Postgres SQL 8.0.0. Volg de volgende link voor meer informatie: http://www.postgresql.org/about/news.277
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 …
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 …
When I was confronted with the challenge to import about 260 tables from two different Rdb’s into a single Oracle database (9.0.1.x) on a daily basis via a database …
On the 7th of December, I, a database administrator, had a seminar from Mr. Chris Date about “Relational Remodeled” (into the 21st century with the relational model: a technical …
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 …
For one of our projects, we wanted to copy the contents of our production database to the test database. Both databases are accessible via JDBC. After an investigation of …
On OTN there is an excellent online seminar (replay) on the TopLink Object-to-XML support. This feature, which will be available in the upcoming 10.1.3 release, allows converting XML files …
In one of the projects I’m involved in we have to make use of specific Oracle JDBC features. The application runs on Tomcat 5.0.27 and connects to the database …
Thursday the 7th of October a presentation was given on Open Source databases during an Amis (Server Development and Programming Languages) Knowledge Center meeting. The aim was to present …
Java and persistence are hot. And continue to be hot. If I read things correctly, Sun – through Linda DeMichiel and Craig Russell Specification Leads, JSR-220 and JSR-243 – …
After getting a weird NullPointerException using Transaction.commit() in Hibernate during an insert (eventually calling PreparedStatement.clearParameters() which was the source of the exception), it turned out that the JDBC driver …
A quick’n dirty tutorial-by-example for Hibernate: (Using one table, an Oracle9+ database and Hibernate2) 1) download the Hibernate distribution 2) put these jarfiles in /WEB-INF/lib: hibernate2.jar (hibernate core) cglib-full-2.0.2.jar …
Some links to get started with Hibernate: Quickstart with Tomcat "Hibernate Your Data" – ONJava Quickstart Configuration Properties Hibern8IDE
Recently, IBM announced the open-sourcing of their Cloudscape database. a lightweight, Java-based relational database with a footprint of just 2MB. It’s significantly less resource-intensive than enterprise databases like IBM’s …
Yesterday we had an excellent meeting on Java persistency frameworks, in particular Toplink. Oracle Consultant and Java expert Peter Ebell presented on his experiences with Toplink on a very …
The stable 3.x versions of MySQL don’t support stored procedures. Consequently the associated JDBC driver can’t support callable statements. The alpha 4.x versions don’t support stored procedures either, but …
Oracle Data Cartridge is a technology component, part of the Oracle RDBMS (ever since the 8i release), that allows developers to extend the functionality of the database. One area …
A research team of the Alice project from the Dutch Institute for Nuclear and High Engery Physics (NIKHEF) wrote a very elaborate comparison on Oracle, PostgreSQL and MySQL. This …
If you have just installed the MySQL RPMs and wonder what to do next, check out Getting Started with MySQL. This is a wonderful concise to-the-point comprehensible “getting started”, …
You can access a database with Ant. This can be useful when you want to create a database and fill it with some default data at the start/deployment of …