Hi, sorry there seems to be no replies to your message. Currently Middlegen does not support more than one schema..
Not sure I entirely understand your problem. You want to access the entities from several WAR files? This should be no problem as long as all WAR files are placed in the same EAR as the ejb-jar file.. If you want it more split up, you'd have to use some remote session bean facade to access the entity beans since CMP should use local and not remote interfaces. Using the VALUEOBJECT_REFACTORING_BRANCH from cvs will let you create such session bean facades.. If the problem is having a set of entity beans from different schemas, Middlegen would have to be modified some to support this. I don't even know if this is common practice in J2EE.. .eivind On Sat, 18 Oct 2003, Michael Harm wrote: > Hi. > > Sorry if this is a silly one.. I'm new to this. > > We have a set of tables that are sort of a shared resource to be used > across multiple projects. It's in a schema called "vocabulary" (on > oracle 9i). > > There are other projects that use these tables, with foreign key > relationships into them. Those projects each are in their own schema. > > I'd like to be able to deploy these projects separately into jboss > (3.2.1), each in their own WAR file, but preserving the CMR > relationships to "vocabulary". > > But middlegen operates at the granularity of a single schema, as near > as I can tell. So the CMR relationships don't happen. I can run > middlegen twice for a given project, once on, say, "clinical_trials", > and again on "vocabulary", but it doesn't kick out the right cmr stuff. > ejbdoclet lets me add additional entity descriptors to the > ejb-jar.xml, but doesn't seem to have a hook for additional > <ejb-relation> thingies. And maybe it's a bad idea to have an entitity > (say, a bean from the "vocabulary" schema) existing in multiple WAR > files anyway. > > I've tried using oracle's synonyms, creating a synonym of > vocabulary.concept as 'concept' visible in schema 'clinical_trials' > with the fk relationship on that, but middlegen still doesn't see the > 'concept' guy, even if its explicitly named in the <table> directives. > I've also tried leaving off the 'schema' attribute to the middlegen > task and coding the schema prefix in the <table> directives, but it > doesn't see the tables with a schema prefix. > > What's the best practice for having a bean that is used across multiple > projects? Keep everything in the same schema, and each project picks > the stuff it needs using the middlegen <table> directive rather than > scooping in everything? Is there a danger in having beans referencing > a given table deployed to multiple WAR files? Or is jboss smart enough > to figure this out? > > I'll get more concrete: in schema vocabulary, there's a table called > CONCEPT with pk concept_id. In schema clinical_trials there's a table > TRIAL, with a field trial_type_id. It's got a foreign key relationship > to vocabulary.concept(concept_id). When I do a project relating to > clinical_trials, I'd like to end up with cmr relationships, and be able > to get to the concept bean. And there's another project in schema > clinical_repository that has other tables with fk relationships into > vocabulary.concept(concept_id), and I'd like those to be able to > reference a concept bean as well. > > Any tips on the right way to architect this? > > (in this case, the stuff in the 'vocabulary' schema is all read-only. > That may help with this particular case, and any info that would be > great, but I'd also like to know about the more general case where the > shared schema isn't readonly). > > Thanks! > > Michael Harm > Stanford University School of Medicine > > > > ------------------------------------------------------- > This SF.net email sponsored by: Enterprise Linux Forum Conference & Expo > The Event For Linux Datacenter Solutions & Strategies in The Enterprise > Linux in the Boardroom; in the Front Office; & in the Server Room > http://www.enterpriselinuxforum.com > _______________________________________________ > middlegen-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/middlegen-user > ------------------------------------------------------- This SF.net email is sponsored by OSDN developer relations Here's your chance to show off your extensive product knowledge We want to know what you know. Tell us and you have a chance to win $100 http://www.zoomerang.com/survey.zgi?HRPT1X3RYQNC5V4MLNSV3E54 _______________________________________________ middlegen-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/middlegen-user
