Re: Beyond RPG CGI -- WEB400

The connection pooling and db pooling objects that I use
work for anything.

they're a back end to my db access objects which in turn
load beans.

Email me privatly if you want a copy of the .java files.

Brad

On Fri, 5 Apr 2002 14:25:57 -0500
 "Joel R. Cochran" <jrc@masi-brac.com> wrote:
> Brad,
>
> Would you be willing to post a short explanation of
> DB/Connection Pooling?
> Is it only for Web stuff or can I use it on stand alone
> Swing applications?
>
> TIA,
>
> Joel R. Cochran
> Director of Internet Services
> VamaNet.com
> (800)480-8810
> mailto:webmaster@vamanet.com
>
>
> > -----Original Message-----
> > From: Brad Stone [mailto:brad@bvstools.com]
> > Sent: Friday, April 05, 2002 10:59 AM
> > To: web400@midrange.com
> > Subject: Re: [WEB400] Beyond RPG CGI
> >
> >
> > Dan,
> >
> > Connection pooling will make a HUGE difference with
> your
> > JDBC connections.  I would guestimate that you would
> see an
> > increase of over 50% performance.  The connection is
> what
> > takes the longest.
> >
> > Websphere has connection pooling built in, but if
> you're
> > like me you like to roll your own.  I've got a
> connection
> > pooling and database pooling objects.
> >
> > So, at startup I load all the db pools, then each db
> pool
> > has it's own connection pool.
> >
> > Made a huge difference in my little apps that I mess
> around
> > with.  And pooling, once understood, is really very
> simple.
> > You don't need Websphere for it.
> >
> > Brad
> > On Thu, 4 Apr 2002 15:32:34 -0700
> >  "Eyers, Daniel" <daniel.eyers@honeywell.com> wrote:
> > > That's sort of where we are... Having achieved a
> > > "critical mass" of knowledge with our developers (who
> > > have struggled
> > > heroically with RPG v. Java), we are having trouble
> > > keeping up with the demand we created.
> > >
> > > One of our next steps is getting the box tuned a
> little
> > > better for web applications.  It tends to drag with
> use.
> > > We may
> > > have gotten to the point where JDBC starts to lose
> it's
> > > appeal (in favor of native 400 connections).
> However, we
> > > are
> > > not yet using connection pooling, so maybe that will
> > > help....
> > >
> > > dan
> > >
> > >
> > > -----Original Message-----
> > > From: Hatzenbeler, Tim [mailto:thatzenbeler@clinitech.net]
> > > Sent: Thursday, April 04, 2002 4:58 PM
> > > To: 'web400@midrange.com'
> > > Subject: RE: [WEB400] Beyond RPG CGI
> > >
> > >
> > > This message is in MIME format. Since your mail
> reader
> > > does not understand
> > > this format, some or all of this message may not be
> > > legible.
> > > --
> > > [ Picked text/plain from multipart/alternative ]
> > > Amen....  I know I have been trying to sell these
> > > capabilities to our
> > > managers, and they finally gave me the freedom to
> write a
> > > large intranet
> > > web application... And they loved it...  It's fast,
> and
> > > it handles indexing
> > > through several million records in sub second
> response
> > > times... And not only
> > > that, I have been given more web projects...  They
> > > actually prefer it on the
> > > as/400, because they know the as/400 has such a nice
> > > database, plus it's
> > > reliable.....  I just had to show them what it could
> do..
> > >
> > > tim
> > >
> > > > -----Original Message-----
> > > > From:   Jim Langston [SMTP:jlangston@celsinc.com]
> > > > Sent:   Thursday, April 04, 2002 12:53 PM
> > > > To:     'web400@midrange.com'
> > > > Subject:        RE: [WEB400] Beyond RPG CGI
> > > >
> > > > Part of the problem, I think, is that CIOs and
> Managers
> > > don't understand
> > > > the
> > > > AS/400 and what it's capable of.  They think of it
> as a
> > > mainframe that's
> > > > okay for business data and is programmed in some
> > > obscure language called
> > > > RPG, what, they playing Role Playing Games on these
> > > things?
> > > >
> > > > Start letting CIOs and Managers know that, hey, the
> > > AS/400 can also do C,
> > > > C++, and now can do Linux, PERL, Java, etc... some
> of
> > > the things they've
> > > > heard about.  So they get a warm glowing feeling,
> if
> > > all the RPG
> > > > programmers
> > > > drop off the face of the earth, they can get
> someone
> > > out there to program
> > > > in
> > > > C, or Java, or PERL...
> > > >
> > > > I definitely agree, it is a problem of perception,
> not
> > > reality.
> > > >
> > > > Regards,
> > > >
> > > > Jim Langston
> > > >
> > > > -----Original Message-----
> > > > From: Jon Paris [mailto:Jon.Paris@Partner400.com]
> > > > Sent: Thursday, April 04, 2002 10:23 AM
> > > > To: web400@midrange.com
> > > > Subject: [WEB400] Beyond RPG CGI
> > > >
> > > >
> > > >  >> CIOs (and managers) who fail to understand that
> > > will fail. period.
> > > >
> > > > <SNIP>
> > > >
> > > > The problem is one of perception - not reality.
> > > >
> > > > Jon Paris
> > > > Partner400
> > > > _______________________________________________
> > > > This is the Web Enabling the AS400 / iSeries
> (WEB400)
> > > mailing list
> > > > To post a message email: WEB400@midrange.com
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > > > or email: WEB400-request@midrange.com
> > > > Before posting, please take a moment to review the
> > > archives
> > > > at http://archive.midrange.com/web400.
> > > _______________________________________________
> > > This is the Web Enabling the AS400 / iSeries (WEB400)
> > > mailing list
> > > To post a message email: WEB400@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > > or email: WEB400-request@midrange.com
> > > Before posting, please take a moment to review the
> > > archives
> > > at http://archive.midrange.com/web400.
> > > _______________________________________________
> > > This is the Web Enabling the AS400 / iSeries (WEB400)
> > > mailing list
> > > To post a message email: WEB400@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > > or email: WEB400-request@midrange.com
> > > Before posting, please take a moment to review the
> > > archives
> > > at http://archive.midrange.com/web400.
> > >
> >
> > Bradley V. Stone
> > BVS.Tools
> > www.bvstools.com
> > _______________________________________________
> > This is the Web Enabling the AS400 / iSeries (WEB400)
> mailing list
> > To post a message email: WEB400@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> > or email: WEB400-request@midrange.com
> > Before posting, please take a moment to review the
> archives
> > at http://archive.midrange.com/web400.
> >
> _______________________________________________
> This is the Web Enabling the AS400 / iSeries (WEB400)
> mailing list
> To post a message email: WEB400@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/web400
> or email: WEB400-request@midrange.com
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/web400.
>

Bradley V. Stone
BVS.Tools
www.bvstools.com