Re: Database application howto?

[Todd Kuebler <tk...@cisco.com>]

Hi Zufeng,

My opinion, there are undoubtedly others:

I am not a big fan of Torque for even simple db applications.  Just use 
jdbc, it's not like writing sql is hard or anything.  If your application 
warrants it you can use EJBs instead.  There are other object/db mapping 
tools like Object Bridge that do this better than torque _if_ your object 
model and db schema don't have too big an impedance miss-match.

I would recommend using connection pooling at the infrastructure level via 
jndi, that way it is completely out of the application domain and 
universally managed for everyone on your app server.   We also found some 
serious scaling and performance issues with Torque and switched away from 
using it even inside of jetspeed, your mileage my vary of course.

For the transactional stuff EJBs come to mind as the obvious J2EE 
approach  ( as long as your transaction needs fit into the flat 
transaction/OTS model).


-tk


At 12:36 AM 9/18/2003 -0700, Zufeng Huang wrote:
>All,
>
>As you know, Jetspeed uses Turbine as its core
>framework, and Torque as the persistent layer. I just
>took a look at Turbine and Torque, but doubt comes
>on...
>
>According to Torque's document online, we can develop
>VERY simple database applications, but if I need to
>operate several tables during a transaction/at one
>time, how to??? Another, it seems Torque doesn't
>provide transaction, such as rollback, commit(maybe
>it's auto-commit).
>
>Is there any document covers its database connection
>pool management? how to use its connection pool?
>
>Finally, I just want to know what's the best way to
>develop DB-based applications in Jetspeed. Use JDBC
>pool provided by Torque or do it by myself?
>
>thanks,
>
>__________________________________
>Do you Yahoo!?
>Yahoo! SiteBuilder - Free, easy-to-use web site design software
>http://sitebuilder.yahoo.com
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jetspeed-dev-help@jakarta.apache.org