RE: Beyond RPG CGI

hmmm... we're using Websphere... does Websphere open a bunch of connections for 
use when it boots so when I get a
Connection, WAS is smart enough the use one already established, or do I need 
to get a Connection in some other way???

Here is my Connection method:

public void connect() throws java.lang.Exception {
        // Register the AS/400 driver
        DriverManager.registerDriver( new AS400JDBCDriver() );

        // Connect to the AS/400 database
        setConn(DriverManager.getConnection( getUrl(), getUser(), 
getPassword()));
        }

thanks

dan

-----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.