Skip to Content
0
Former Member
Dec 06, 2006 at 03:22 PM

close JDBC connection

32 Views

<p>Dear Expert:</p><p>Now I develop web report, I use JDBC connect to database, after I call "viewer.processHttpRequest", should I need close the JDBC connection, my code is following:</p><p> ConnectionInfos connInfos = new ConnectionInfos();<br /> IConnectionInfo connInfo1 = new ConnectionInfo();<br /> connInfo1.setUserName("db2admin");<br /> connInfo1.setPassword("cry03stal");<br /> connInfos.add(connInfo1);<br /> CrystalReportViewer viewer = new CrystalReportViewer();<br /> viewer.setReportSource(reportSource);<br /> viewer.setEnableLogonPrompt(false); <br /> viewer.setDatabaseLogonInfos(connInfos); <br /> <br /> viewer.refresh();<br /> session.setAttribute("refreshed", "true"); <br /> <br /> viewer.setOwnPage(true);<br /> viewer.processHttpRequest(request, response, getServletConfig().getServletContext(), null);<br /></p><p>Should I close the JDBC connection? If it need, how to to do it?</p><p>Thanks so much for your help!</p><p>Steven</p>