Object Relational Bridges

My next assignment at work will be creating a new subsystem within our internet banking application. It will require me to persist some objects to the oracle database. Now at present the application is doing nasty things like

ResultSet rs = sql.getResultSet(“SELECT firstname, lastname from Customer ” + “where userid=” + Integer.toString(id)); rs.next(); String firstName = rs.getString(“firstname”); String lastName = rs.getString(“lastname”); User u = new User(firstName, lastName);

Now this is apalling and needs to change, that’s part of the reason I was bought on. However I’m having difficulty deciding what strategy to use. The Active Record that Patrick has been discussing looks interesting and an easy place to start. However I feel that we might benefit from something a little more formal. Knowing where to start is a challenge though. What I’d like to see is a comparison of java persistence methods. Though google doesn’t seem to know of any.

I think that for the time being I’ll start with the Active Record strategy, then later on I may move to something a little cooler. JDOs , hibernate etc.

Posted on February 15th, 2003 | 1 comment | Commenting Closed
Matthew E. Porter

Matthew E. Porter February 15th, 2003 @ 04:26 AM

I would recommend Hibernate (http://hibernate.bluemars.net). Check my blog for why.

Sponsors

Hosted excellently by RailsMachine