Gary Kelleher's Blog http://www.garykelleher.net/wp Just another WordPress site Thu, 12 Apr 2012 21:16:38 +0000 en hourly 1 http://wordpress.org/?v=3.3.2 Thanks for the posting http://www.garykelleher.net/wp/?p=21 http://www.garykelleher.net/wp/?p=21#comments Thu, 12 Apr 2012 21:08:36 +0000 gary http://www.garykelleher.net/wp/?p=21 Well ranked by Google and well written as well:

Broken pipes with Tomcat and DBCP connection

]]> http://www.garykelleher.net/wp/?feed=rss2&p=21 0 SchemaCrawler http://www.garykelleher.net/wp/?p=4 http://www.garykelleher.net/wp/?p=4#comments Thu, 22 Sep 2011 05:35:15 +0000 gary http://www.garykelleher.net/wp/?p=4 Continue reading →]]> I’m working on a project where I choose the database backend at deployment time. Specifically, I’m supporting MySQL and Oracle. As I’m developing and making changes to one database, I need to keep those changes in sync with several other databases. I had a self written tool from several years ago that did a comparison of Hibernate xml files to the jdbc metadata but I suppressed the urge to start reworking that code and did a search for “jdbc vendor independent schema compare” and found SchemaCrawler.

I also found a real nice looking commercial solution for about $399 a seat.

SchemaCrawler was definitely the right choice for my task. I think I had a learning curve of about an hour or so to get to finding my discrepancies and fixing them. I was gratified to see more than the basic information produced especially the primary, unique and foreign key definitions. I’m glad I resisted updating my code (although it would have been fun). It’s time to express gratitude for the time saved with a donation.

]]> http://www.garykelleher.net/wp/?feed=rss2&p=4 0