Kayak nya gak pake connection pool dari app server nya deh... Tomcat khan gak ada connection pool... Jadi mungkin bukan karna kehabisan connection... Tapi justru mungkin karna kehabisan resource ato kena deadlock... Ato mungkin ada infinite loop dimana gitu? Coba periksa code bagian database access deh...
Adelwin Handoyo COTS (DS) Consultant, Financial Services Industry NCS Pte. Ltd. (Reg. No. 198101793G) A member of the Singapore Telecom Group 5 Ang Mo Kio St 62, NCS Hub, Singapore (569141) DID : (65) 6556 6785 Fax: (65) 6483 5420 Email ID : [email protected] Website: http://www.ncs.com.sg **** DISCLAIMER ***** This e-mail and any attachments thereto are intended for the sole use of the recipient(s) named above and may contain information that is confidential and/or proprietary to the NCS Group. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication, or dissemination in any form) by persons other than the intended recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender immediately and delete it. **** NCS Pte. Ltd. - Reg. No. 198101793G **** -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jecki Sent: Friday, December 12, 2008 9:28 AM To: [email protected] Subject: Re: [JUG-Indonesia] Connection Pool with jtds Driver Bagaimana cara anda memakai ConnectionPool? Apakah di-manage oleh application server (lookup lewat JNDI)? Atau di-manage oleh aplikasi anda sendiri? Pastikan bagian code yang memakai koneksi database ini memanggil fungsi Connection.close() untuk mengembalikan koneksi ke pool. Biasanya ini bagian yang amat sangat mungkin terlewat/tidak tepat. kira2 stepnya seperti code di bawah: Connection conn = null; try { conn = getConnectionFromAnyWhereYouLike(); // do database operation here } catch (AnyExceptionYouLikeToCatch e) { // do something with the exception } finally { // PENTING: taruh code untuk menutup koneksi di blok finally seperti ini if (conn != null) { try { conn.close(); } catch (SQLException e) { // log the exception or do any required action } } } 2008/12/12 Sandi Juniar <[email protected]>: > Saya sedang mengembangkan Aplikasi Web memakai Database SQL 2000 SP4, > untuk koneksinya pake Connection Pool dengan memakai Driver JTDS tetapi > ada kendala, setelah di deploy dan beberapa komputer konek ke Web > ternyata Web server mendadak menjadi ngehang alias no Response, Sudah > pernah di ganti Webserver menggunakan Apache Tomcat maupun > GlassFish/SJSAS tapi tetap juga No Response. > > I Have No Idea... > > Can You Help Me... > > Thank's in Advanced.. > Send instant messages to your online friends http://asia.messenger.yahoo.com > > -- Jecki Sumargo YM!: ballerina_1224 skype: ballerina_1224 ------------------------------------ Kalau mau keluar dari mailing list ini, caranya kirim sebuah email ke [email protected]. Jangan lupa, website JUG Indonesia adalah http://www.jug.or.id Yahoo! Groups Links
