1 Reply Latest reply on Oct 2, 2008 1:37 PM by Pete Muir

    Seam and auto-generation across databases

    Tom Schaible Newbie

      Hello everyone,

      I apologize if some of these questions have obvious answers, I'm a bit new to Seam

      I've been working on a fairly large php/mysql web project.  We've gotten to the point where we will soon need some sort of internal administration application.  The admin app would be an internal only tool, and as we'd like to spend as much time as possible spending our time developing the customer facing portion of our project, we're looking at some tools to do some CRUD auto-generation as the basis for our admin app.

      I've been looking at Seam and JBoss Tools (seam-gen) to get started with this.  The one snag I've run into is that our application was designed with horizontal partitioning in mind.  Because of this our data is separated between databases with our lookups and data lists in a static database while our user specific data is in a user database which we intend to partition horizontally as we expand.

      So on to my questions...

      1) Does Seam support cross-db relationships? So could I pull our static data into the user auto-generated screens during the code generation?  The basic auto-generated seam app is definitely good enough for what we need, but modifying every screen to pull in data from the static db when we need it is something we'd like to avoid if possible.

      2) As far as horizontal partitioning goes, I know Hibernate Shards is out there.  From what I've read, it seems to only support a subset of the core Hibernate library for now.  Would this cause any issues if I tried to use it with Seam?

      Thanks for the help.