RE: DB2/400 for EntityBeans(CMP)

["Clapham, Paul" <pclapham@xxxxxxxxxxxxx>]

>               I have been trying to use DB2/400 for EntityBeans(CMP). I
installed
>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.
>
>Bye,
>Vijay.
>___________________________________________________________________________
__________

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.

PC2
+---
| 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
+---