Hi, I'm in your same boat (like many I guess). In an effort to learn best pratice and avoiding to reinvent the wheel, I thought, it may be wise to stick with one of the several java web application frameworks. I'm trying with Spring, which seems quite good, but at least for me, it is not that easy to learn too. I just come across another one called Wicket, which between the other premises, says having focused on easier lerning curve. Hope it helps.
Giorgio On 1/19/06, Warrick Wilson <[EMAIL PROTECTED]> wrote: > > First, if I need to be on a different list, please let me know. I'm > working my way up from Tomcat, which is where the servlet I'm > developing is going to be running. I'm a Java newbie, but I'm on this > project, and the learning curve is steep. Sadly, Google hasn't been my > friend this time - I'm finding conflicting information and so I > searched out a mailing list to ask.... > > I've got Tomcat 5.5.12 running on my Win XP SP2 machine. I'm > developing against that for now. I'm working on a servlet that will be > accessing a MySQL database, so I've grabbed Connector/J from the MySQL > site, and followed their info, plus the Tomcat JNDI Datasource How-To > on settting up a context.xml for my database. > > And that all works. I used the sample JSP from the Datasource How-To > and was able to access my database. > > My issues start when I work on my servlet. The basic tutorials and > examples show something simple all happening within the one > MyServlet.java file - create the JDBC context, set up a DataSource, > get a Connection, and work with some Statements. Everything in one > class implementing the servlet. When things get a little more > complicated (read that as "when you want to do things in the real > world"), then the examples disappear and some handwaving seems to > replace it. That's becoming very confusing, particularly when this is > the first real Java project you've worked on. > > In my case, I want to have some different classes to read and write my > database. Basically, there's one class for handling data coming in, > and a second class to handle data going out. Based on what I've read, > I want to use the "connection pooling" that's already present in the > Commons DBCP that's included with my Tomcat installation. However, > establishing contexts is "expensive" in terms of performance (again, > so I've read), so I want to just use the DataSource I have set up in > my context.xml. So more Googling, more reading, and I ran across some > examples of Connection Pools that use a "Singleton Pattern". Only I > thought I already had a connection pool, and I'm trying to figure out > how to make my design share the DataSource I was setting up in my > servlet init() method, because I thought that would help my servlet's > performance. > > Am I way off-base here? Is there an example that shows how this type > of thing should be designed? Should I just duplicate the > Context/DataSource/Connection/Statement stuff in all my classes? Or is > that the wrong way? > > I could always configure my classes to have a DataSource passed in > from the doGet() or doPost() handlers, but that doesn't seem like the > right approach. I may do that just to get something working, but I > hate learning how to do things the wrong way... > > Thanks in advance for any pointers you can provide... > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >