• Subject: RE: DB2/400 for EntityBeans(CMP)
  • From: "Clapham, Paul" <pclapham@xxxxxxxxxxxxx>
  • Date: Fri, 1 Dec 2000 08:43:09 -0800

>               I have been trying to use DB2/400 for EntityBeans(CMP). I
>weblogic 5.1 in my Windows/NT machine and created connection
>pool in weblogic server using IBM's ToolBox Type 4 Driver
>(com.ibm.as400.access.AS400JDBCDriver). I did this by placing a copy of
>jt400.jar in the NT machine and updating weblogic class path. Now i am
>able to insert and update the records in the table, but at very slow
>speed. It is taking nearly 30 to 50 seconds approx to get things done.
>Can any one help me to speed up the process.
>Comments on this method are greatly appriciated.

I have found that it takes this driver over 30 seconds to connect to my
AS/400 from the Windows NT machine where it runs.  You don't say what your
"30 to 50 seconds" covers.  If it's 30-50 seconds to connect and insert a
few records, then I'm not surprised.  If it's 30-50 seconds to insert each
record, then something is definitely wrong and you need to check your
connection pooling to see if it's actually working the way you expect.

| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.