|
Hi, another simple Connection Pool with caching of prepared Statements would be http://sourceforge.net/projects/c3p0/ it supports JDBC 2.0 DataSources and could be implemented using JNDI. And its pretty simple. For a beginners project like this I would recommend STRUTS, but be carefull, if you don't use ejbs to put the business logic in a model layer; thinking along session beans and entity beans. I would not recommend using record level I/O from the toolbox, that would cause very poor design by replicating the database structure in the application (I know, this will push up the postings in this group) Dieter Bender On Montag, 8. März 2004 19:10, Ivan Hurtado wrote: > For this project I'm designing, it will ALL reside on > a single as400 machine. There are no other > servers/machines involved here. That is why I am > hesitant to jump into the EJB world for this. I want > something simple to produce and which performs fast. > If I avoid EJB, then I can disregard the need for > expensive Websphere Enterprise Servers and such, > simply using Tomcat as a standalone. Also I don't have > to deal with the EJB complexity. However, I was > looking for good alternatives since using EJB does > provide much system level functionality via the > container (i.e state mgmt, threading, transaction > control, pooling, persistence, etc.). > > I have looked at google searches for EJB. I know I can > use JDO, or even Record-Level I/O from jt400, to > access the database instead of using CMP. But I was > concerned about how much of that system level code I'd > have to write myself if I did not EJB at all. > > To consolidate some of the responses, it sounds like I > can use something called Proxool to handle connection > pooling. And Hibernate (not familiar with it) to > handle persistence (not sure if this is instead of or > in addition to using JDO). Then that leaves state > mgmt, threading and transaction control to be dealt > with... any suggestions on how to best deal with those > items without EJB? > > Thx! > > --- Dieter Bender <dieter.bender@xxxxxxxxxxxx> wrote: > > Joe, > > > > > I don't mean to completely diss the EJB > > > > architecture; there are benefits > > > > > to EJB for some sites like Amazon.com, where they > > > > may have failover > > > > > among dozens of machines. That might be what > > > > Dieter refers to as > > > > > "scalability". But for single-machine use (as is > > > > typical on an > > > > > iSeries), the EJB model is definitely overkill. > > > > agreed in this point. Putting JSPs and EJBs on > > WebSphere on a single cpu as400 > > would not even crawl. I was talking on a distributed > > environment with an > > as400 as database server and some linux boxes as > > application server. > > > > Dieter > > > > > Joe > > > > > > _______________________________________________ > > > This is the Java Programming on and around the > > > > iSeries / AS400 (JAVA400-L) > > > > > mailing list To post a message email: > > > > JAVA400-L@xxxxxxxxxxxx > > > > > To subscribe, unsubscribe, or change list options, > > > visit: > > > > http://lists.midrange.com/mailman/listinfo/java400-l > > > > > or email: JAVA400-L-request@xxxxxxxxxxxx > > > Before posting, please take a moment to review the > > > > archives > > > > > at http://archive.midrange.com/java400-l. > > > > -- > > mfG > > > > Dieter Bender > > > > > > DV-Beratung Dieter Bender > > Wetzlarerstr. 25 > > 35435 Wettenberg > > Tel. +49 641 9805855 > > Fax +49 641 9805856 > > www.bender-dv.de > > eMail dieter.bender@xxxxxxxxxxxx > > > > _______________________________________________ > > This is the Java Programming on and around the > > iSeries / AS400 (JAVA400-L) mailing list > > To post a message email: JAVA400-L@xxxxxxxxxxxx > > To subscribe, unsubscribe, or change list options, > > visit: > > http://lists.midrange.com/mailman/listinfo/java400-l > > or email: JAVA400-L-request@xxxxxxxxxxxx > > Before posting, please take a moment to review the > > archives > > at http://archive.midrange.com/java400-l. > > __________________________________ > Do you Yahoo!? > Yahoo! Search - Find what you?re looking for faster > http://search.yahoo.com > _______________________________________________ > This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) > mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/java400-l > or email: JAVA400-L-request@xxxxxxxxxxxx > Before posting, please take a moment to review the archives > at http://archive.midrange.com/java400-l. -- mfG Dieter Bender DV-Beratung Dieter Bender Wetzlarerstr. 25 35435 Wettenberg Tel. +49 641 9805855 Fax +49 641 9805856 www.bender-dv.de eMail dieter.bender@xxxxxxxxxxxx
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.