Did you know? DZone has great portals for Python, Cloud, NoSQL, and HTML5!

Persistence

  • submit to reddit

Subtle SQL differences: Constraint names

The various SQL product vendors implement subtle differences in the way they interpret SQL. In this case, I’ve been examining the reuse of constraint names within a schema / database (which is yet another story: what’s a schema, what’s a database?)....

0 replies - 1487 views - 12/13/11 by Lukas Eder in Articles

Development schema, production schema

Most of us separate development data from production data, physically or at least, logically (except maybe Chuck Norris (official website, no kidding!)). If you’re lucky and you can afford multiple Oracle / other-expensive-database licenses, you might...

0 replies - 1853 views - 11/19/11 by Lukas Eder in Articles

jOOQ-meta. A “hard-core SQL” proof of concept

jOOQ-meta is more than just meta data navigation for your database schema. It is also a proof of concept for the more complex jOOQ queries. It is easy for you users to believe that the simple vanilla queries of this form will work:

0 replies - 1879 views - 11/18/11 by Lukas Eder in Articles

Hibernate by Example - Part 2 (DetachedCriteria)

So last time we helped out justice league to effectively manager their super heroes. Today we focus on how The Avengers will be using Hibernate's Detached Criteria to find out their enemies with respect to each superhero so as to protect their super heroes....

0 replies - 2413 views - 11/11/11 by Dinuka Arseculeratne in Articles

Use jOOQ inside your H2 database

I recently became aware of an interesting use-case for jOOQ when I was optimising my own H2 database integration tests: H2 stored functions H2 knows two operation modes for stored functions: “Inline mode” with source code provided“Reference mode”...

0 replies - 2013 views - 11/04/11 by Lukas Eder in Articles

Avoid Lazy JPA Collections

  Hibernate (and actually JPA) has collection mappings: @OneToMany, @ManyToMany, @ElementCollection. All of these are by default lazy. This means the collections are specific implementations of the List or Set interface...

5 replies - 2771 views - 10/27/11 by Bozhidar Bozhanov in Articles

How to Load or Save Image using Hibernate – MySQL

This tutorial will walk you throughout how to save and load an image from database (MySQL) using Hibernate. Requirements For this sampel project, we are going to use:

1 replies - 2929 views - 10/23/11 by Loiane Groner in Articles

The Coming SQL Collapse

13 replies - 5764 views - 10/12/11 by Rob Williams in Articles

More Holes in Our Persistence Models

What is science? The practice of making up a fake world, filling it up with only data that the Scientist approves, in pursuit of publishing a fairy tale about what happened when the scientist‘s hypothesis was tested against his sanitized surrogates. We...

0 replies - 2877 views - 10/03/11 by Rob Williams in Articles

Hibernate by Example - Part 1 (Orphan removal)

So i thought to do a series of hibernate examples showing various features of hibernate. In the first part i wanted to show about the Delete Orphan feature and how it may be used with the use of a story line. So let us begin :)   Prerequisites: In...

9 replies - 4887 views - 09/23/11 by Dinuka Arseculeratne in Articles

Revisiting OLTP and OLAP

Databases are as ubiquitous as computers. They are often, erroneously, attributed to data-intensive, long-term storage solutions. Yet in reality they are used in one shape or form in most programs. From word processors to media players to web-browsers. All...

0 replies - 2411 views - 08/29/11 by Ashod Nakashian in Articles

Hibernate Gotchas!

I've been using Hibernate for some time now and when I don't work on a hibernate project for a while I find myself doing the same mistakes I did the previous times So here is a sort of watch list for my self hopefully will be useful to someone else as well.

4 replies - 5695 views - 08/25/11 by Andrew Salvadore in Articles

Having Database Tests Ready in 10 Minutes with DbUnit Express

DbUnit Express is my wrapper around DbUnit that intends to make it extremely easy to set up a test of a code that interacts with a database. It is preconfigured to use an embedded Derby database (a.k.a. JavaDB, part of SDK) and uses convention over...

0 replies - 2948 views - 07/28/11 by Jakub Holý in Articles

DBUnit unable to import data for CollectionTable witout Primary Key

I ran into an issue running some DBUnit tests trying to seed a database where tables do not have primary keys such as CollectionTables in JPA. This blog illustrates how to the http://www.dbunit.org/properties/primaryKeyFilter property to refresh a table...

2 replies - 2548 views - 07/10/11 by Mick Knutson in Articles

JPA 2, The Access annotation

JPA 1 has a strict rule about what the access when defining your meta annotations (you database to java mapping). In jpa 1 the standard was the way the ID was mapped.

1 replies - 5040 views - 07/01/11 by Jelle Victoor in Articles