DigitalJoel

2010/02/09

What’s in a name?

Filed under: development, java — Tags: — digitaljoel @ 11:27 pm

At work I’m in a committee where we are discussing a versioning strategy for one of our legacy projects. I’m not involved directly with the project, but they pulled me into the committee because of my experience with subversion on our current project. In a part of this meeting, we were talking about the database.

In the application I work on, we are able to version the database. So far, it is small enough that we can copy it in a couple of hours, then run the migration scripts on the new database for the new version, and finally point the new application code at the new database. It’s all quite simple really. Then, if things go awry during the release, we can simply replace the webapp with the old version and point back at the old database. In our case, the database name is the application name, followed by the version. For instance, app-1.7.4. When we do the next release, all the data in app-1.7.4 is copied into app-1.7.5. Anyway, you see what I mean.

So I mentioned this in the meeting today. The DBA for the legacy project looked at me as if I was speaking sacrilege. His eyes were wide as he said;
“You actually change the name of the database for every release?!”
My Response: “Well, yeah. That’s the magic of JNDI. My app doesn’t care about the name of the database it’s pointing at, we just set that up in the JNDI properties and merrily go along.”

So, what’s in a name? I’ll admit I don’t have the most experience in technologies other than Java. This isn’t peculiar to Java web applications, is it?

Advertisements

1 Comment »

  1. The renaming strategy works fine as long as the database is essentially a glorified embedded database. That strategy will not work as soon as somebody expects to have long-term access to the data. Of course, the answer to that is to provide a strong API layer and not let people touch the data directly. 🙂

    DBAs think of the database as the heart of the organization instead of a component of an application. As such, you have a single source for data (like your address). Renaming the database makes finding that single source difficult or impossible.

    And, finally, JNDI doesn’t exist everywhere, so an organization can’t just update a directory and suddenly all the apps will work (wouldn’t that be nice! :). I’m sure Microsoft has a competing Active Directory technology for that as well.

    All of these reasons are why I never want to be in an IT organization again. You have to worry about too many annoying things (like that freaking vendor who insists on changing the name of the database for every release! ;).

    Comment by Travis Jensen — 2010/02/09 @ 11:45 pm


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.