CMP Primer related question..

[Kevin Duffey]

Title: RE: Deleting cookies with Orion

Hi all,   I got the CMP Orion Primer, but it leaves me in the dark on a couple of things (as does the Orion Primer..which shows EJB). It appears EJB isn't all that hard, but the primers, and other articles I have been looking at, don't clearly state how you can test and develop EJB without having to keep on repackaging it into a jar file, deploying it, etc. I can't imagine every time you make a change to an entity bean or session bean that you have to repackage the thing and redeploy it. Isn't there any way you can develop EJBs as you do servlets, javabeans and jsp pages..an "open" dir structure. I guess worse case scenario if this can't be done, a good script that you run each time you make a change that compiles, packages and deploys it would be handy..is one available?   Also, about Orion..when using CMP, does Orion automatically do connection pooling for you (for database connections)? I see there is the ability to use a PooledConnection in servlets, but I am unclear if when using CMP Orion (and other J2EE app servers for that matter) use an internal connection pool that you can set the size of somehow.   Lastly, on our site we currently use our own home-brewn persistence layer. It does the job, but a query of 600 station objects appears to use about 400MB of memory. I assume our code is very bad..I didn't write it..but it doesn't make much since to me as to why a query with only 400 objects being created would require so much memory. None the less, alot of our queries use joins with other tables. I read somewhere that complex O/R mapping wont be available until EJB 2.0, so does that mean I can't do a query of an object that requires joins? I am unclear as to how exactly when using CMP you would get joins to work. For example, a one to many relationship of a particular table...say a user with many transactions. Also, what if each transaction had many "sub transactions". Thus, the first table would be many users. Each user can have many transactions, and each transaction could have many sub-transactions. Is this possible now with CMP, Orion and O/R?   thanks.