> See http://virtualschool.edu/jwaa for details.
bad gateway :)
Sorry. New colloc. Jetty keeps shutting down mysteriously. Its back up now.
You can model your domain data in a way, that no relation goes out of transaction ( say transaction knows nothing about accounts, or whatever is in your domain )
And then you have object "month", which has collection of transactions. And this collection happens to select only those which belong to certain month. ( either date based, or with ID of month )
Then you can archive your transactions away without breaking relations.
Let me see if I understand. I need a single Ledger, Journal, Session, etc table instead of one table per month as now. These each hold six months worth of data instead of one month as now. I also need LedgerArchive, JournalArchive, SessionArchive tables (or files) to store rollover data permanently. Instead of creating new monthly tables during the monthly rollover, I lock the tables and move month 7 (6+1) to the archives. Right?
The only problem I see is that I have to scan six months of transactions to compute an account balance as now, and this is a high-volume computation (nearly every web page needs the account balance). But those monthly tables are a real PITA so maybe its worth it. What do you think?
Do you know a way to cache the account balance each month?
> The legacy app is built precisely this way, withPOJO objects driving JDBC calls. See http://virtualschool.edu/jwaa for details.
bad gateway :)
Sorry, new server coloc; jetty keeps shutting down mysteriously. No idea why. Its back online now.
> Performance is great. But JDBC hardwires mysql SQLpecularities into the app and I really want to avoid that.
Then hibernate is your choice. YOu have your java beans and mapping files. And you can forget about database.
And it has couple of cool features, and is really fast...
-- Brad J. Cox, PhD, 703 361 4751, http://virtualschool.edu http://virtualschool.edu/mybank Digital Rights Management System http://virtualschool.edu/jco Java Cryptographic Objects (JCO) http://virtualschool.edu/jwaa Java Web Application Architecture (JWAA) http://virtualschool.edu/java+ Java Preprocessor (Java+)
------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ xdoclet-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/xdoclet-user
