> 1) I need BMP (I think), because I have some logic that for example > needs the results of a "select count(*) from ..." and I've yet to work > out how to do that in CMP. Of course, someone might enlighten me :-) >
stay away from BMP, and if you really want CMP you can do all of that using EJB-QL, the most recent specs can do that. If you really need something more complex you might consider Jboss-QL and the Dynamic-QL, this allows for constructing your query qt runtime (suppose you want to select using a list of parameters, but you do not know the size of that list at compile time) did you consider Hibernate ? there already is a cartridge for it > 2) A very important thing in my schema is that the primary key of some > tables cannot be an arbitrary ID like in the generated Andromda code. > For example, I have an admin table where the username is the primary key > because it needs to be unique. Anyone got an idea how to go about this > in Andromda? > I never tried it but I believe some people on this list posted about this once, so I guess it's possible > 3) Finally, how do I get Andromda to include extra finders so I can use > comparison EJB-QL like "SELECT OBJECT(o) FROM XxxxEJB o WHERE o.property > <= ?1". In the generated ejb-jar.xml there's a comment about defining > extra finders in an external XML file. Presumably I don't add the > <<FinderMethod>> stereotype in Poseidon in order that Andromda doesn't > try to generate it, but I can't work out where to put my external > finders file. Any pointers? > open up the EJB cartridge, you only need to change the templates for that (xdoclet tags) > So far I've found Andromda to be almost excellent, I just need to > overcome these showstoppers and it will be the future for my projects. > you must accept the fact that for any serious project you will need to have your own cartridge. That doesn't mean you'll have to write it yourself 100%, most of the time you will only want to change the templates, and that's easy as pie. What I do is copying the existing cartridge and applying changes as I need them, in the end you have a cartridge customized for your project, that's perfectly normal. Suppose you want to do something simple as having a licence statement in the beginning of your Java source code, well... simply put that statement in the template, run andromda, and there it is... Good luck Wouter. ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ Andromda-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/andromda-user
