I am looking for an object-mapping (to sql relational DB) solution for Struts.
I have a medium sized database application which I've developed in struts. (around 25 tables in PostgreSQL) I've been using a home-brew lightweight data-access bean system -- using perl scripts to generate beans that interact with the database. The java source these scripts generate need a lot of manual editing, so making changes to the object model can be a nightmare. I tried downloading Torque 2.1, but had problems, so then I tried Torque 3.0b1. It seems like Torque isn't going to integrate well with my already existing tables. I use some postgres types such as TEXT and BOOLEAN, which I would expect to map to LONGVARCHAR and BIT respectively, but in the SQL that torque spit out they were "bytea" and "". I can't find mention of "bytea" in postgres docs, and obviously "" isn't going to do much for me. =) After reading the Torque docs, I really like what it offers but I'm not sure that it will work for me. Are there any other solutions that people can recommend? Or should I try modifying torque to fit my needs? I don't have any EJB experience but I've heard good things about JBoss. I've also heard the going EJB can really slow an application down. I've also noticed some talk of Expresso on this list, would this be worth trying? Thanks for any advice! -james -- [] James A. Hillyerd <[EMAIL PROTECTED]> - Java Developer [] PGP 1024D/D31BC40D F87B 7906 C0DA 32E8 B8F6 DE23 FBF6 4712 D31B C40D -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
