Category: Database
I will attempt to introduce analytical functions in a step-by-step manner. A first step into Analytical country could be the following, starting from a very simple aggregation query, exploring …
In this post I will tell you about some of the sessions notably on Struts support in JDeveloper, Java/JDBC support with Oracle 10g and the Data Guard option of …
During the Amsterdam stage of the Oracle Open World Tour, I had a great opportunity to interview John Wookey Senior Vice President, Applications Development at Oracle Corporation. John is …
In this post I will discuss some thoughts I have on the further development of CDM RuleFrame (the Framework for implementing Business Rules). It seems to me that a) …
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 …
Today I tried to put all my biases (I’m a j2ee developer) aside, and had a look at HTML-DB. “Oracle HTML DB is a declarative web-based application development environment …
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
Looking at new features of Oracle 10g we ran into Expression Filters. Here, we will discuss our initial experiences and our conclusions as to how you can make use …
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 …
At 21st July 2004, release 0.8.2 of the PLDoc open source project for generating JavaDoc style documentation for PL/SQL Code (and now also Tables and Views) was published. PLDoc …
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 …
Last week I installed a 10g database on my laptop. I must say this was by far the easiest installation of an oracle database I ever did. One of …
Go to /etc/mail/ and look in the sendmail.mc file. Uncomment and change the entry define(`SMART_HOST',`forward.host.domain'). Additional info: The sendmail.cf is generally considered to be too difficult to be changed …
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 …