Joe- I would suggest cocoon to fulfill this requirement as Database views can be xsp generated to XML (XML is then transformed by cocoon container to your view) Check out http://cocoon.apache.org/2.1/userdocs/concepts/ Martin-
----- Original Message ----- From: "N/A" <[EMAIL PROTECTED]> To: "Tomcat Users List" <users@tomcat.apache.org>; <[EMAIL PROTECTED]> Sent: Saturday, November 26, 2005 11:07 AM Subject: Re: Java database schema managers? > Go to sourceforge, get Druid. > > ----- Original Message ----- > From: "Joe Reger, Jr." <[EMAIL PROTECTED]> > To: <users@tomcat.apache.org> > Sent: Friday, November 25, 2005 2:28 PM > Subject: OT: Java database schema managers? > > > A bit off-topic but I haven't found a good answer elsewhere. > > Problem: Single Tomcat/Java/MySql app deployed to many > companies/users. As users upgrade the app we need to change their > database schema (update tables, add columns, delete columns, etc). > > Current solution: We have a homegrown infrastructure of simple java > classes that manunally make database updates. I.e. we send "ALTER > table..." commands. > > Problem with current solution: Database-dependent. Seems like this is > a common problem and there would be open source projects to handle it. > We've seen Hibernate's schema management features and are impressed > but we can't move to Hibernate completely right now. > > Any other ideas? > > Thanks and sorry for the off-topic. > > Joe > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >