<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:garamond,new york,times,serif;font-size:12pt">i dont know but i feel ur code have some problem , because freeconnection method ur invoking or not i am not sure.<br>try something like this everywhere ur hitting database<br><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"><br><font size="4">DBConnectionManager manager = .......<br>Connection conn = manager.getConnection();<br></font><font size="4"><span style="font-family: garamond,new york,times,serif;">try{</span><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"><!---</span><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"> your jdbc
code goes here</span></font></span></font><font size="4"><br><br>--><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;">}catch(.....){</span><br style="font-family: garamond,new york,times,serif;"><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;">}</span><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;">finally{</span><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"> try{</span><br style="font-family: garamond,new york,times,serif;"><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"> }catch(....){</span><br
style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"> conn.close();</span><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;"> }</span><br style="font-family: garamond,new york,times,serif;"><br style="font-family: garamond,new york,times,serif;"><span style="font-family: garamond,new york,times,serif;">}</span><br style="font-family: garamond,new york,times,serif;"></font><div style="font-family: garamond,new york,times,serif;"><font size="4"> <br><br>if not closed here i dont think it will closed anyway<br></font></div><br>Regards <br>Fairoz Sharif <br>9945066287 <br> <br> <br> <br><span style="color: rgb(0, 255, 255);">May God Bless this Planet , </span><br style="color: rgb(0, 255, 255);"><span
style="color: rgb(0, 255, 255);">Spread Peace And Love every where </span><br style="color: rgb(0, 255, 255);"><span style="color: rgb(0, 255, 255);">Thank You .</span><div><br></div><div style="font-family: garamond,new york,times,serif; font-size: 12pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;"><font size="2" face="Tahoma"><hr size="1"><b><span style="font-weight: bold;">From:</span></b> Karthik Nanjangude <karthik.nanjangude@xius-bcgi.com><br><b><span style="font-weight: bold;">To:</span></b> "jboss-user@lists.jboss.org" <jboss-user@lists.jboss.org><br><b><span style="font-weight: bold;">Sent:</span></b> Friday, 12 June, 2009 3:55:09 PM<br><b><span style="font-weight: bold;">Subject:</span></b> [jboss-user] JDBC Connection close every 15 ...:( plz<br></font><br>
<style>
<!--
_filtered {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;color:windowtext;}
_filtered {margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">Hi</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">We are facing Connection used up every 15 minutes on </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">We suspect the jboss server is not releasing the JDBC
connection </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">on using the close() method</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">JBOSS 4.2.1 or 4.2.3</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">JDK1.5.x</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">O/s Linux Redhat</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">Jdbc jar : ojdbc14.jar</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">Or am I missing any thing ?</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">Please some body help me </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">The code is as shown below</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">//Oracle-ds.xml</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><local-tx-datasource></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><jndi-name>jdbc/OrclVOISE5000</jndi-name></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><connection-url>jdbc:oracle:thin:@172.16.18.22:1521:GTS22</connection-url></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><driver-class>oracle.jdbc.driver.OracleDriver</driver-class></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><user-name>tt_VOISE50</user-name></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><password>tt_VOISE50</password></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><min-pool-size>20</min-pool-size></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><max-pool-size>80</max-pool-size></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><blocking-timeout-millis>500</blocking-timeout-millis></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><idle-timeout-minutes>1</idle-timeout-minutes></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><track-statements>false</track-statements></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><metadata></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"><type-mapping>Oracle10g</type-mapping></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"></metadata></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"></local-tx-datasource></span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">// global Declared Variables</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">DataSource ODS = null;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;">WrappedConnection WCP = null;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">//Singleton
Pattern</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">public
static synchronized public DBConnectionManager getInstance() throws Exception {</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">
if (instance == null) {</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">
instance = new DBConnectionManager();</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">
}</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">
return instance;</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">}</span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 8pt; font-family: Verdana; color: black;"> </span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 8pt; font-family: Verdana; color: black;"> </span></font></p>
<p class="MsoNormal" style=""><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">//Constructer </span></font><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"></span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">private
DBConnectionManager() throws Exception {</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> String DSNAME =
InfinetUtility.getProperty("DSNAME").trim();</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> System.out.println("DATASOURCE
JNDI NAME :===>|"+DSNAME+"|<=====");</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> InitialContext ic
= null;</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> try {</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> ic =
new InitialContext();</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> ODS =
(javax.sql.DataSource) ic.lookup(DSNAME);</span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;"> } catch
(NamingException e) { e.printStackTrace();} </span></font></p>
<p class="MsoNormal"><font size="1" color="black" face="Verdana"><span style="font-size: 7pt; font-family: Verdana; color: black;">}</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">//fetch connection</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">public synchronized Connection getConnection(){</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> Connection conn = null;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> Connection underlyingConn = null;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> OracleConnection connection= null;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> try {</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> conn = ODS.getConnection();</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> WCP = (WrappedConnection)conn;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> underlyingConn =
WCP.getUnderlyingConnection();</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> conn =
(OracleConnection)underlyingConn;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> } catch (SQLException sqlex) {</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">
System.out.println("<<<<<<<<<<< NO
CONNECTION>>>>>>>>>>>>" +
sqlex.getMessage()</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> } </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> return conn;</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">}</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">//Connection close</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">public void freeConnection(Connection con) {</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> System.out.println("RELEASING THE
USED CONNECTION TO POOL");</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> try {</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> con.close();</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> }catch (Exception e) {</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">
e,printStackTrace();</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;"> } </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 7pt; font-family: Verdana;">}</span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
<p class="MsoNormal"><font size="1" face="Verdana"><span style="font-size: 8pt; font-family: Verdana;"> </span></font></p>
</div>
</div></div></div><br>
<!--3--><hr size=1></hr> Explore and discover exciting holidays and getaways with Yahoo! India Travel <a href="http://in.rd.yahoo.com/tagline_Travel_1/*http://in.travel.yahoo.com/"> Click here!</a></body></html>