> 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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.