Well, I don't know if I'm close to the point you're making, but accessing to a db has (at least) two different meanings:
a- you may read some data from one or more tables, related or non-related by foreign keys; b- you may change some data in one or more tables, that is inserting, updating or deleting one or more records, besides just reading. Case (b) is by far harder than (a): it usually means some sort of concurrency and lock manager, and a way to remap the same data in a non-relational structure, in our case in some sort of Java beans; all the frameworks sketched in the previous mails (J2ee for instance) includes code designed to cope with those aspects of computing. If your requirements are limited to (a), that is just reading some data without any need to write back, the frameworks sketched above may add a lot of overhead without measurable gains: should you have to write in a .jsp stating the number of rows of a table (let's say EMP), you are better off writing a 'simple' Java class which open a JDBC connection, execute a query (SELECT COUNT(*) FROM EMP) and returns the result as a String, and then invoke this class inside the jsp. Of course, if your needs are related to a full-fledged web application, there are no shortcuts: you have to learn how to use a framework or write down a lot of code by yourself (and usually both cases are true) hope this may help bye, d.rizzi -----Messaggio originale----- Da: Adam Hardy [mailto:[EMAIL PROTECTED]] Inviato: venerdi 31 maggio 2002 11.06 A: Struts Users Mailing List Oggetto: Re: R: Design Advice - Relational Databases & Java Objects Yes sure but where would I do that? If I've got a complete DB access & object-relation mapping package between my business classes and my database, then I would have to write a whole new seperate bunch of classes to handle COUNT(*)s queries. I was hoping somebody who uses such a package could tell me how they do it. Perhaps there's some way of specifying it in the mapping definitions that I haven't found yet. I haven't chosen a mapping package yet, so I'm not in that deep. Adam -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
