| <HTML> |
| <BODY BGCOLOR="white"> |
| <PRE> |
| <FONT color="green">001</FONT> /*<a name="line.1"></a> |
| <FONT color="green">002</FONT> * Licensed to the Apache Software Foundation (ASF) under one<a name="line.2"></a> |
| <FONT color="green">003</FONT> * or more contributor license agreements. See the NOTICE file<a name="line.3"></a> |
| <FONT color="green">004</FONT> * distributed with this work for additional information<a name="line.4"></a> |
| <FONT color="green">005</FONT> * regarding copyright ownership. The ASF licenses this file<a name="line.5"></a> |
| <FONT color="green">006</FONT> * to you under the Apache License, Version 2.0 (the "License");<a name="line.6"></a> |
| <FONT color="green">007</FONT> * you may not use this file except in compliance with the License.<a name="line.7"></a> |
| <FONT color="green">008</FONT> * You may obtain a copy of the License at<a name="line.8"></a> |
| <FONT color="green">009</FONT> *<a name="line.9"></a> |
| <FONT color="green">010</FONT> * http://www.apache.org/licenses/LICENSE-2.0<a name="line.10"></a> |
| <FONT color="green">011</FONT> *<a name="line.11"></a> |
| <FONT color="green">012</FONT> * Unless required by applicable law or agreed to in writing, software<a name="line.12"></a> |
| <FONT color="green">013</FONT> * distributed under the License is distributed on an "AS IS" BASIS,<a name="line.13"></a> |
| <FONT color="green">014</FONT> * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.<a name="line.14"></a> |
| <FONT color="green">015</FONT> * See the License for the specific language governing permissions and<a name="line.15"></a> |
| <FONT color="green">016</FONT> * limitations under the License.<a name="line.16"></a> |
| <FONT color="green">017</FONT> */<a name="line.17"></a> |
| <FONT color="green">018</FONT> /*<a name="line.18"></a> |
| <FONT color="green">019</FONT> * $Id: DefaultConnectionPool.java 468638 2006-10-28 06:52:06Z minchau $<a name="line.19"></a> |
| <FONT color="green">020</FONT> */<a name="line.20"></a> |
| <FONT color="green">021</FONT> package org.apache.xalan.lib.sql;<a name="line.21"></a> |
| <FONT color="green">022</FONT> <a name="line.22"></a> |
| <FONT color="green">023</FONT> import java.sql.Connection;<a name="line.23"></a> |
| <FONT color="green">024</FONT> import java.sql.DatabaseMetaData;<a name="line.24"></a> |
| <FONT color="green">025</FONT> import java.sql.Driver;<a name="line.25"></a> |
| <FONT color="green">026</FONT> import java.sql.DriverManager;<a name="line.26"></a> |
| <FONT color="green">027</FONT> import java.sql.SQLException;<a name="line.27"></a> |
| <FONT color="green">028</FONT> import java.util.Enumeration;<a name="line.28"></a> |
| <FONT color="green">029</FONT> import java.util.Iterator;<a name="line.29"></a> |
| <FONT color="green">030</FONT> import java.util.Properties;<a name="line.30"></a> |
| <FONT color="green">031</FONT> import java.util.Vector;<a name="line.31"></a> |
| <FONT color="green">032</FONT> <a name="line.32"></a> |
| <FONT color="green">033</FONT> import org.apache.xalan.res.XSLMessages;<a name="line.33"></a> |
| <FONT color="green">034</FONT> import org.apache.xalan.res.XSLTErrorResources;<a name="line.34"></a> |
| <FONT color="green">035</FONT> <a name="line.35"></a> |
| <FONT color="green">036</FONT> /**<a name="line.36"></a> |
| <FONT color="green">037</FONT> * For internal connectiones, i.e. Connection information supplies in the<a name="line.37"></a> |
| <FONT color="green">038</FONT> * Stylesheet. The Default Connection Pool will be used.<a name="line.38"></a> |
| <FONT color="green">039</FONT> */<a name="line.39"></a> |
| <FONT color="green">040</FONT> public class DefaultConnectionPool implements ConnectionPool<a name="line.40"></a> |
| <FONT color="green">041</FONT> {<a name="line.41"></a> |
| <FONT color="green">042</FONT> /**<a name="line.42"></a> |
| <FONT color="green">043</FONT> * A placeholder thast will keep the driver loaded<a name="line.43"></a> |
| <FONT color="green">044</FONT> * between calls.<a name="line.44"></a> |
| <FONT color="green">045</FONT> */<a name="line.45"></a> |
| <FONT color="green">046</FONT> private Driver m_Driver = null;<a name="line.46"></a> |
| <FONT color="green">047</FONT> /**<a name="line.47"></a> |
| <FONT color="green">048</FONT> */<a name="line.48"></a> |
| <FONT color="green">049</FONT> private static final boolean DEBUG = false;<a name="line.49"></a> |
| <FONT color="green">050</FONT> <a name="line.50"></a> |
| <FONT color="green">051</FONT> /**<a name="line.51"></a> |
| <FONT color="green">052</FONT> * The basic information to make a JDBC Connection<a name="line.52"></a> |
| <FONT color="green">053</FONT> */<a name="line.53"></a> |
| <FONT color="green">054</FONT> private String m_driver = new String("");<a name="line.54"></a> |
| <FONT color="green">055</FONT> /**<a name="line.55"></a> |
| <FONT color="green">056</FONT> */<a name="line.56"></a> |
| <FONT color="green">057</FONT> private String m_url = new String("");<a name="line.57"></a> |
| <FONT color="green">058</FONT> <a name="line.58"></a> |
| <FONT color="green">059</FONT> <a name="line.59"></a> |
| <FONT color="green">060</FONT> /**<a name="line.60"></a> |
| <FONT color="green">061</FONT> * The mimimum size of the connection pool, if the<a name="line.61"></a> |
| <FONT color="green">062</FONT> * number of available connections falls below this<a name="line.62"></a> |
| <FONT color="green">063</FONT> * mark, min connections will be allocated. The Connection<a name="line.63"></a> |
| <FONT color="green">064</FONT> * Pool will always be somewhere between MinSize and MinSize*2<a name="line.64"></a> |
| <FONT color="green">065</FONT> */<a name="line.65"></a> |
| <FONT color="green">066</FONT> private int m_PoolMinSize = 1;<a name="line.66"></a> |
| <FONT color="green">067</FONT> <a name="line.67"></a> |
| <FONT color="green">068</FONT> <a name="line.68"></a> |
| <FONT color="green">069</FONT> /**<a name="line.69"></a> |
| <FONT color="green">070</FONT> * Always implement the properties mechinism, if the Password<a name="line.70"></a> |
| <FONT color="green">071</FONT> * or Username is set seperatly then we will add them to the<a name="line.71"></a> |
| <FONT color="green">072</FONT> * property manually.<a name="line.72"></a> |
| <FONT color="green">073</FONT> */<a name="line.73"></a> |
| <FONT color="green">074</FONT> private Properties m_ConnectionProtocol = new Properties();<a name="line.74"></a> |
| <FONT color="green">075</FONT> <a name="line.75"></a> |
| <FONT color="green">076</FONT> /**<a name="line.76"></a> |
| <FONT color="green">077</FONT> * Storage for the PooledConnections<a name="line.77"></a> |
| <FONT color="green">078</FONT> */<a name="line.78"></a> |
| <FONT color="green">079</FONT> private Vector m_pool = new Vector();<a name="line.79"></a> |
| <FONT color="green">080</FONT> <a name="line.80"></a> |
| <FONT color="green">081</FONT> /**<a name="line.81"></a> |
| <FONT color="green">082</FONT> * Are we active ??<a name="line.82"></a> |
| <FONT color="green">083</FONT> */<a name="line.83"></a> |
| <FONT color="green">084</FONT> private boolean m_IsActive = false;<a name="line.84"></a> |
| <FONT color="green">085</FONT> <a name="line.85"></a> |
| <FONT color="green">086</FONT> /**<a name="line.86"></a> |
| <FONT color="green">087</FONT> */<a name="line.87"></a> |
| <FONT color="green">088</FONT> public DefaultConnectionPool( ) {}<a name="line.88"></a> |
| <FONT color="green">089</FONT> <a name="line.89"></a> |
| <FONT color="green">090</FONT> <a name="line.90"></a> |
| <FONT color="green">091</FONT> /**<a name="line.91"></a> |
| <FONT color="green">092</FONT> * Return our current Active state<a name="line.92"></a> |
| <FONT color="green">093</FONT> *<a name="line.93"></a> |
| <FONT color="green">094</FONT> */<a name="line.94"></a> |
| <FONT color="green">095</FONT> public boolean isEnabled( )<a name="line.95"></a> |
| <FONT color="green">096</FONT> {<a name="line.96"></a> |
| <FONT color="green">097</FONT> return m_IsActive;<a name="line.97"></a> |
| <FONT color="green">098</FONT> }<a name="line.98"></a> |
| <FONT color="green">099</FONT> <a name="line.99"></a> |
| <FONT color="green">100</FONT> /**<a name="line.100"></a> |
| <FONT color="green">101</FONT> * Set the driver call to be used to create connections<a name="line.101"></a> |
| <FONT color="green">102</FONT> * @param d<a name="line.102"></a> |
| <FONT color="green">103</FONT> *<a name="line.103"></a> |
| <FONT color="green">104</FONT> */<a name="line.104"></a> |
| <FONT color="green">105</FONT> public void setDriver( String d )<a name="line.105"></a> |
| <FONT color="green">106</FONT> {<a name="line.106"></a> |
| <FONT color="green">107</FONT> m_driver = d;<a name="line.107"></a> |
| <FONT color="green">108</FONT> }<a name="line.108"></a> |
| <FONT color="green">109</FONT> <a name="line.109"></a> |
| <FONT color="green">110</FONT> /**<a name="line.110"></a> |
| <FONT color="green">111</FONT> * Set the url used to connect to the database<a name="line.111"></a> |
| <FONT color="green">112</FONT> * @param url<a name="line.112"></a> |
| <FONT color="green">113</FONT> *<a name="line.113"></a> |
| <FONT color="green">114</FONT> */<a name="line.114"></a> |
| <FONT color="green">115</FONT> public void setURL( String url )<a name="line.115"></a> |
| <FONT color="green">116</FONT> {<a name="line.116"></a> |
| <FONT color="green">117</FONT> m_url = url;<a name="line.117"></a> |
| <FONT color="green">118</FONT> }<a name="line.118"></a> |
| <FONT color="green">119</FONT> <a name="line.119"></a> |
| <FONT color="green">120</FONT> /**<a name="line.120"></a> |
| <FONT color="green">121</FONT> * Go through the connection pool and release any connections<a name="line.121"></a> |
| <FONT color="green">122</FONT> * that are not InUse;<a name="line.122"></a> |
| <FONT color="green">123</FONT> *<a name="line.123"></a> |
| <FONT color="green">124</FONT> */<a name="line.124"></a> |
| <FONT color="green">125</FONT> public void freeUnused( )<a name="line.125"></a> |
| <FONT color="green">126</FONT> {<a name="line.126"></a> |
| <FONT color="green">127</FONT> // Iterate over the entire pool closing the<a name="line.127"></a> |
| <FONT color="green">128</FONT> // JDBC Connections.<a name="line.128"></a> |
| <FONT color="green">129</FONT> Iterator i = m_pool.iterator();<a name="line.129"></a> |
| <FONT color="green">130</FONT> while(i.hasNext())<a name="line.130"></a> |
| <FONT color="green">131</FONT> {<a name="line.131"></a> |
| <FONT color="green">132</FONT> PooledConnection pcon =<a name="line.132"></a> |
| <FONT color="green">133</FONT> (PooledConnection) i.next();<a name="line.133"></a> |
| <FONT color="green">134</FONT> <a name="line.134"></a> |
| <FONT color="green">135</FONT> // If the PooledConnection is not in use, close it<a name="line.135"></a> |
| <FONT color="green">136</FONT> if ( pcon.inUse() == false )<a name="line.136"></a> |
| <FONT color="green">137</FONT> {<a name="line.137"></a> |
| <FONT color="green">138</FONT> if (DEBUG)<a name="line.138"></a> |
| <FONT color="green">139</FONT> {<a name="line.139"></a> |
| <FONT color="green">140</FONT> System.err.println("Closing JDBC Connection ");<a name="line.140"></a> |
| <FONT color="green">141</FONT> }<a name="line.141"></a> |
| <FONT color="green">142</FONT> <a name="line.142"></a> |
| <FONT color="green">143</FONT> pcon.close();<a name="line.143"></a> |
| <FONT color="green">144</FONT> i.remove(); <a name="line.144"></a> |
| <FONT color="green">145</FONT> }<a name="line.145"></a> |
| <FONT color="green">146</FONT> }<a name="line.146"></a> |
| <FONT color="green">147</FONT> <a name="line.147"></a> |
| <FONT color="green">148</FONT> }<a name="line.148"></a> |
| <FONT color="green">149</FONT> <a name="line.149"></a> |
| <FONT color="green">150</FONT> /**<a name="line.150"></a> |
| <FONT color="green">151</FONT> * Is our ConnectionPool have any connections that are still in Use ??<a name="line.151"></a> |
| <FONT color="green">152</FONT> *<a name="line.152"></a> |
| <FONT color="green">153</FONT> */<a name="line.153"></a> |
| <FONT color="green">154</FONT> public boolean hasActiveConnections( )<a name="line.154"></a> |
| <FONT color="green">155</FONT> {<a name="line.155"></a> |
| <FONT color="green">156</FONT> return (m_pool.size() > 0);<a name="line.156"></a> |
| <FONT color="green">157</FONT> }<a name="line.157"></a> |
| <FONT color="green">158</FONT> <a name="line.158"></a> |
| <FONT color="green">159</FONT> <a name="line.159"></a> |
| <FONT color="green">160</FONT> /**<a name="line.160"></a> |
| <FONT color="green">161</FONT> * Set the password in the property set.<a name="line.161"></a> |
| <FONT color="green">162</FONT> * @param p<a name="line.162"></a> |
| <FONT color="green">163</FONT> *<a name="line.163"></a> |
| <FONT color="green">164</FONT> */<a name="line.164"></a> |
| <FONT color="green">165</FONT> public void setPassword( String p )<a name="line.165"></a> |
| <FONT color="green">166</FONT> {<a name="line.166"></a> |
| <FONT color="green">167</FONT> m_ConnectionProtocol.put("password", p);<a name="line.167"></a> |
| <FONT color="green">168</FONT> }<a name="line.168"></a> |
| <FONT color="green">169</FONT> <a name="line.169"></a> |
| <FONT color="green">170</FONT> /**<a name="line.170"></a> |
| <FONT color="green">171</FONT> * Set the user name in the property set<a name="line.171"></a> |
| <FONT color="green">172</FONT> * @param u<a name="line.172"></a> |
| <FONT color="green">173</FONT> *<a name="line.173"></a> |
| <FONT color="green">174</FONT> */<a name="line.174"></a> |
| <FONT color="green">175</FONT> public void setUser( String u )<a name="line.175"></a> |
| <FONT color="green">176</FONT> {<a name="line.176"></a> |
| <FONT color="green">177</FONT> m_ConnectionProtocol.put("user", u);<a name="line.177"></a> |
| <FONT color="green">178</FONT> }<a name="line.178"></a> |
| <FONT color="green">179</FONT> <a name="line.179"></a> |
| <FONT color="green">180</FONT> /**<a name="line.180"></a> |
| <FONT color="green">181</FONT> * The Protocol string is used to pass in other connection<a name="line.181"></a> |
| <FONT color="green">182</FONT> * properties. A properties file is a general purpose container<a name="line.182"></a> |
| <FONT color="green">183</FONT> *<a name="line.183"></a> |
| <FONT color="green">184</FONT> * @param p<a name="line.184"></a> |
| <FONT color="green">185</FONT> *<a name="line.185"></a> |
| <FONT color="green">186</FONT> */<a name="line.186"></a> |
| <FONT color="green">187</FONT> public void setProtocol( Properties p )<a name="line.187"></a> |
| <FONT color="green">188</FONT> {<a name="line.188"></a> |
| <FONT color="green">189</FONT> Enumeration e = p.keys();<a name="line.189"></a> |
| <FONT color="green">190</FONT> while (e.hasMoreElements())<a name="line.190"></a> |
| <FONT color="green">191</FONT> {<a name="line.191"></a> |
| <FONT color="green">192</FONT> String key = (String) e.nextElement();<a name="line.192"></a> |
| <FONT color="green">193</FONT> m_ConnectionProtocol.put(key, p.getProperty(key));<a name="line.193"></a> |
| <FONT color="green">194</FONT> }<a name="line.194"></a> |
| <FONT color="green">195</FONT> }<a name="line.195"></a> |
| <FONT color="green">196</FONT> <a name="line.196"></a> |
| <FONT color="green">197</FONT> <a name="line.197"></a> |
| <FONT color="green">198</FONT> /**<a name="line.198"></a> |
| <FONT color="green">199</FONT> * Override the current number of connections to keep in the pool. This<a name="line.199"></a> |
| <FONT color="green">200</FONT> * setting will only have effect on a new pool or when a new connection<a name="line.200"></a> |
| <FONT color="green">201</FONT> * is requested and there is less connections that this setting.<a name="line.201"></a> |
| <FONT color="green">202</FONT> * @param n<a name="line.202"></a> |
| <FONT color="green">203</FONT> *<a name="line.203"></a> |
| <FONT color="green">204</FONT> */<a name="line.204"></a> |
| <FONT color="green">205</FONT> public void setMinConnections( int n )<a name="line.205"></a> |
| <FONT color="green">206</FONT> {<a name="line.206"></a> |
| <FONT color="green">207</FONT> m_PoolMinSize = n;<a name="line.207"></a> |
| <FONT color="green">208</FONT> }<a name="line.208"></a> |
| <FONT color="green">209</FONT> <a name="line.209"></a> |
| <FONT color="green">210</FONT> /**<a name="line.210"></a> |
| <FONT color="green">211</FONT> * Try to aquire a new connection, if it succeeds then return<a name="line.211"></a> |
| <FONT color="green">212</FONT> * true, else return false.<a name="line.212"></a> |
| <FONT color="green">213</FONT> * Note: This method will cause the connection pool to be built.<a name="line.213"></a> |
| <FONT color="green">214</FONT> *<a name="line.214"></a> |
| <FONT color="green">215</FONT> */<a name="line.215"></a> |
| <FONT color="green">216</FONT> public boolean testConnection( )<a name="line.216"></a> |
| <FONT color="green">217</FONT> {<a name="line.217"></a> |
| <FONT color="green">218</FONT> try<a name="line.218"></a> |
| <FONT color="green">219</FONT> {<a name="line.219"></a> |
| <FONT color="green">220</FONT> if (DEBUG)<a name="line.220"></a> |
| <FONT color="green">221</FONT> {<a name="line.221"></a> |
| <FONT color="green">222</FONT> System.out.println("Testing Connection");<a name="line.222"></a> |
| <FONT color="green">223</FONT> }<a name="line.223"></a> |
| <FONT color="green">224</FONT> <a name="line.224"></a> |
| <FONT color="green">225</FONT> Connection conn = getConnection();<a name="line.225"></a> |
| <FONT color="green">226</FONT> <a name="line.226"></a> |
| <FONT color="green">227</FONT> if (DEBUG)<a name="line.227"></a> |
| <FONT color="green">228</FONT> {<a name="line.228"></a> |
| <FONT color="green">229</FONT> DatabaseMetaData dma = conn.getMetaData();<a name="line.229"></a> |
| <FONT color="green">230</FONT> <a name="line.230"></a> |
| <FONT color="green">231</FONT> System.out.println("\nConnected to " + dma.getURL());<a name="line.231"></a> |
| <FONT color="green">232</FONT> System.out.println("Driver " + dma.getDriverName());<a name="line.232"></a> |
| <FONT color="green">233</FONT> System.out.println("Version " + dma.getDriverVersion());<a name="line.233"></a> |
| <FONT color="green">234</FONT> System.out.println("");<a name="line.234"></a> |
| <FONT color="green">235</FONT> }<a name="line.235"></a> |
| <FONT color="green">236</FONT> <a name="line.236"></a> |
| <FONT color="green">237</FONT> if (conn == null) return false;<a name="line.237"></a> |
| <FONT color="green">238</FONT> <a name="line.238"></a> |
| <FONT color="green">239</FONT> releaseConnection(conn);<a name="line.239"></a> |
| <FONT color="green">240</FONT> <a name="line.240"></a> |
| <FONT color="green">241</FONT> if (DEBUG)<a name="line.241"></a> |
| <FONT color="green">242</FONT> {<a name="line.242"></a> |
| <FONT color="green">243</FONT> System.out.println("Testing Connection, SUCCESS");<a name="line.243"></a> |
| <FONT color="green">244</FONT> }<a name="line.244"></a> |
| <FONT color="green">245</FONT> <a name="line.245"></a> |
| <FONT color="green">246</FONT> return true;<a name="line.246"></a> |
| <FONT color="green">247</FONT> }<a name="line.247"></a> |
| <FONT color="green">248</FONT> catch(Exception e)<a name="line.248"></a> |
| <FONT color="green">249</FONT> {<a name="line.249"></a> |
| <FONT color="green">250</FONT> if (DEBUG)<a name="line.250"></a> |
| <FONT color="green">251</FONT> {<a name="line.251"></a> |
| <FONT color="green">252</FONT> System.out.println("Testing Connection, FAILED");<a name="line.252"></a> |
| <FONT color="green">253</FONT> e.printStackTrace();<a name="line.253"></a> |
| <FONT color="green">254</FONT> }<a name="line.254"></a> |
| <FONT color="green">255</FONT> <a name="line.255"></a> |
| <FONT color="green">256</FONT> return false;<a name="line.256"></a> |
| <FONT color="green">257</FONT> }<a name="line.257"></a> |
| <FONT color="green">258</FONT> <a name="line.258"></a> |
| <FONT color="green">259</FONT> }<a name="line.259"></a> |
| <FONT color="green">260</FONT> <a name="line.260"></a> |
| <FONT color="green">261</FONT> <a name="line.261"></a> |
| <FONT color="green">262</FONT> // Find an available connection<a name="line.262"></a> |
| <FONT color="green">263</FONT> /**<a name="line.263"></a> |
| <FONT color="green">264</FONT> * @return Connection<a name="line.264"></a> |
| <FONT color="green">265</FONT> * @throws SQLException<a name="line.265"></a> |
| <FONT color="green">266</FONT> * @throws IllegalArgumentException<a name="line.266"></a> |
| <FONT color="green">267</FONT> */<a name="line.267"></a> |
| <FONT color="green">268</FONT> public synchronized Connection getConnection( )throws IllegalArgumentException, SQLException<a name="line.268"></a> |
| <FONT color="green">269</FONT> {<a name="line.269"></a> |
| <FONT color="green">270</FONT> <a name="line.270"></a> |
| <FONT color="green">271</FONT> PooledConnection pcon = null;<a name="line.271"></a> |
| <FONT color="green">272</FONT> <a name="line.272"></a> |
| <FONT color="green">273</FONT> // We will fill up the pool any time it is less than the<a name="line.273"></a> |
| <FONT color="green">274</FONT> // Minimum. THis could be cause by the enableing and disabling<a name="line.274"></a> |
| <FONT color="green">275</FONT> // or the pool.<a name="line.275"></a> |
| <FONT color="green">276</FONT> //<a name="line.276"></a> |
| <FONT color="green">277</FONT> if ( m_pool.size() < m_PoolMinSize ) { initializePool(); }<a name="line.277"></a> |
| <FONT color="green">278</FONT> <a name="line.278"></a> |
| <FONT color="green">279</FONT> // find a connection not in use<a name="line.279"></a> |
| <FONT color="green">280</FONT> for ( int x = 0; x < m_pool.size(); x++ )<a name="line.280"></a> |
| <FONT color="green">281</FONT> {<a name="line.281"></a> |
| <FONT color="green">282</FONT> <a name="line.282"></a> |
| <FONT color="green">283</FONT> pcon = (PooledConnection) m_pool.elementAt(x);<a name="line.283"></a> |
| <FONT color="green">284</FONT> <a name="line.284"></a> |
| <FONT color="green">285</FONT> // Check to see if the Connection is in use<a name="line.285"></a> |
| <FONT color="green">286</FONT> if ( pcon.inUse() == false )<a name="line.286"></a> |
| <FONT color="green">287</FONT> {<a name="line.287"></a> |
| <FONT color="green">288</FONT> // Mark it as in use<a name="line.288"></a> |
| <FONT color="green">289</FONT> pcon.setInUse(true);<a name="line.289"></a> |
| <FONT color="green">290</FONT> // return the JDBC Connection stored in the<a name="line.290"></a> |
| <FONT color="green">291</FONT> // PooledConnection object<a name="line.291"></a> |
| <FONT color="green">292</FONT> return pcon.getConnection();<a name="line.292"></a> |
| <FONT color="green">293</FONT> }<a name="line.293"></a> |
| <FONT color="green">294</FONT> }<a name="line.294"></a> |
| <FONT color="green">295</FONT> <a name="line.295"></a> |
| <FONT color="green">296</FONT> // Could not find a free connection,<a name="line.296"></a> |
| <FONT color="green">297</FONT> // create and add a new one<a name="line.297"></a> |
| <FONT color="green">298</FONT> <a name="line.298"></a> |
| <FONT color="green">299</FONT> // Create a new JDBC Connection<a name="line.299"></a> |
| <FONT color="green">300</FONT> Connection con = createConnection();<a name="line.300"></a> |
| <FONT color="green">301</FONT> <a name="line.301"></a> |
| <FONT color="green">302</FONT> // Create a new PooledConnection, passing it the JDBC<a name="line.302"></a> |
| <FONT color="green">303</FONT> // Connection<a name="line.303"></a> |
| <FONT color="green">304</FONT> pcon = new PooledConnection(con);<a name="line.304"></a> |
| <FONT color="green">305</FONT> <a name="line.305"></a> |
| <FONT color="green">306</FONT> // Mark the connection as in use<a name="line.306"></a> |
| <FONT color="green">307</FONT> pcon.setInUse(true);<a name="line.307"></a> |
| <FONT color="green">308</FONT> <a name="line.308"></a> |
| <FONT color="green">309</FONT> // Add the new PooledConnection object to the pool<a name="line.309"></a> |
| <FONT color="green">310</FONT> m_pool.addElement(pcon);<a name="line.310"></a> |
| <FONT color="green">311</FONT> <a name="line.311"></a> |
| <FONT color="green">312</FONT> // return the new Connection<a name="line.312"></a> |
| <FONT color="green">313</FONT> return pcon.getConnection();<a name="line.313"></a> |
| <FONT color="green">314</FONT> }<a name="line.314"></a> |
| <FONT color="green">315</FONT> <a name="line.315"></a> |
| <FONT color="green">316</FONT> /**<a name="line.316"></a> |
| <FONT color="green">317</FONT> * @param con<a name="line.317"></a> |
| <FONT color="green">318</FONT> *<a name="line.318"></a> |
| <FONT color="green">319</FONT> * @throws SQLException<a name="line.319"></a> |
| <FONT color="green">320</FONT> */<a name="line.320"></a> |
| <FONT color="green">321</FONT> public synchronized void releaseConnection( Connection con )throws SQLException<a name="line.321"></a> |
| <FONT color="green">322</FONT> {<a name="line.322"></a> |
| <FONT color="green">323</FONT> <a name="line.323"></a> |
| <FONT color="green">324</FONT> // find the PooledConnection Object<a name="line.324"></a> |
| <FONT color="green">325</FONT> for ( int x = 0; x < m_pool.size(); x++ )<a name="line.325"></a> |
| <FONT color="green">326</FONT> {<a name="line.326"></a> |
| <FONT color="green">327</FONT> <a name="line.327"></a> |
| <FONT color="green">328</FONT> PooledConnection pcon =<a name="line.328"></a> |
| <FONT color="green">329</FONT> (PooledConnection) m_pool.elementAt(x);<a name="line.329"></a> |
| <FONT color="green">330</FONT> <a name="line.330"></a> |
| <FONT color="green">331</FONT> // Check for correct Connection<a name="line.331"></a> |
| <FONT color="green">332</FONT> if ( pcon.getConnection() == con )<a name="line.332"></a> |
| <FONT color="green">333</FONT> {<a name="line.333"></a> |
| <FONT color="green">334</FONT> if (DEBUG)<a name="line.334"></a> |
| <FONT color="green">335</FONT> {<a name="line.335"></a> |
| <FONT color="green">336</FONT> System.out.println("Releasing Connection " + x);<a name="line.336"></a> |
| <FONT color="green">337</FONT> }<a name="line.337"></a> |
| <FONT color="green">338</FONT> <a name="line.338"></a> |
| <FONT color="green">339</FONT> if (! isEnabled())<a name="line.339"></a> |
| <FONT color="green">340</FONT> {<a name="line.340"></a> |
| <FONT color="green">341</FONT> con.close();<a name="line.341"></a> |
| <FONT color="green">342</FONT> m_pool.removeElementAt(x);<a name="line.342"></a> |
| <FONT color="green">343</FONT> if (DEBUG)<a name="line.343"></a> |
| <FONT color="green">344</FONT> {<a name="line.344"></a> |
| <FONT color="green">345</FONT> System.out.println("-->Inactive Pool, Closing connection");<a name="line.345"></a> |
| <FONT color="green">346</FONT> }<a name="line.346"></a> |
| <FONT color="green">347</FONT> <a name="line.347"></a> |
| <FONT color="green">348</FONT> }<a name="line.348"></a> |
| <FONT color="green">349</FONT> else<a name="line.349"></a> |
| <FONT color="green">350</FONT> {<a name="line.350"></a> |
| <FONT color="green">351</FONT> // Set it's inuse attribute to false, which<a name="line.351"></a> |
| <FONT color="green">352</FONT> // releases it for use<a name="line.352"></a> |
| <FONT color="green">353</FONT> pcon.setInUse(false);<a name="line.353"></a> |
| <FONT color="green">354</FONT> }<a name="line.354"></a> |
| <FONT color="green">355</FONT> <a name="line.355"></a> |
| <FONT color="green">356</FONT> break;<a name="line.356"></a> |
| <FONT color="green">357</FONT> }<a name="line.357"></a> |
| <FONT color="green">358</FONT> }<a name="line.358"></a> |
| <FONT color="green">359</FONT> }<a name="line.359"></a> |
| <FONT color="green">360</FONT> <a name="line.360"></a> |
| <FONT color="green">361</FONT> <a name="line.361"></a> |
| <FONT color="green">362</FONT> /**<a name="line.362"></a> |
| <FONT color="green">363</FONT> * @param con<a name="line.363"></a> |
| <FONT color="green">364</FONT> *<a name="line.364"></a> |
| <FONT color="green">365</FONT> * @throws SQLException<a name="line.365"></a> |
| <FONT color="green">366</FONT> */<a name="line.366"></a> |
| <FONT color="green">367</FONT> public synchronized void releaseConnectionOnError( Connection con )throws SQLException<a name="line.367"></a> |
| <FONT color="green">368</FONT> {<a name="line.368"></a> |
| <FONT color="green">369</FONT> <a name="line.369"></a> |
| <FONT color="green">370</FONT> // find the PooledConnection Object<a name="line.370"></a> |
| <FONT color="green">371</FONT> for ( int x = 0; x < m_pool.size(); x++ )<a name="line.371"></a> |
| <FONT color="green">372</FONT> {<a name="line.372"></a> |
| <FONT color="green">373</FONT> <a name="line.373"></a> |
| <FONT color="green">374</FONT> PooledConnection pcon =<a name="line.374"></a> |
| <FONT color="green">375</FONT> (PooledConnection) m_pool.elementAt(x);<a name="line.375"></a> |
| <FONT color="green">376</FONT> <a name="line.376"></a> |
| <FONT color="green">377</FONT> // Check for correct Connection<a name="line.377"></a> |
| <FONT color="green">378</FONT> if ( pcon.getConnection() == con )<a name="line.378"></a> |
| <FONT color="green">379</FONT> {<a name="line.379"></a> |
| <FONT color="green">380</FONT> if (DEBUG)<a name="line.380"></a> |
| <FONT color="green">381</FONT> {<a name="line.381"></a> |
| <FONT color="green">382</FONT> System.out.println("Releasing Connection On Error" + x);<a name="line.382"></a> |
| <FONT color="green">383</FONT> }<a name="line.383"></a> |
| <FONT color="green">384</FONT> <a name="line.384"></a> |
| <FONT color="green">385</FONT> con.close();<a name="line.385"></a> |
| <FONT color="green">386</FONT> m_pool.removeElementAt(x);<a name="line.386"></a> |
| <FONT color="green">387</FONT> if (DEBUG)<a name="line.387"></a> |
| <FONT color="green">388</FONT> {<a name="line.388"></a> |
| <FONT color="green">389</FONT> System.out.println("-->Inactive Pool, Closing connection");<a name="line.389"></a> |
| <FONT color="green">390</FONT> }<a name="line.390"></a> |
| <FONT color="green">391</FONT> break;<a name="line.391"></a> |
| <FONT color="green">392</FONT> }<a name="line.392"></a> |
| <FONT color="green">393</FONT> }<a name="line.393"></a> |
| <FONT color="green">394</FONT> }<a name="line.394"></a> |
| <FONT color="green">395</FONT> <a name="line.395"></a> |
| <FONT color="green">396</FONT> <a name="line.396"></a> |
| <FONT color="green">397</FONT> /**<a name="line.397"></a> |
| <FONT color="green">398</FONT> *<a name="line.398"></a> |
| <FONT color="green">399</FONT> * @throws SQLException<a name="line.399"></a> |
| <FONT color="green">400</FONT> */<a name="line.400"></a> |
| <FONT color="green">401</FONT> private Connection createConnection( )throws SQLException<a name="line.401"></a> |
| <FONT color="green">402</FONT> {<a name="line.402"></a> |
| <FONT color="green">403</FONT> Connection con = null;<a name="line.403"></a> |
| <FONT color="green">404</FONT> <a name="line.404"></a> |
| <FONT color="green">405</FONT> // Create a Connection directly from the Driver that was loaded<a name="line.405"></a> |
| <FONT color="green">406</FONT> // with the context class loader. This is to support JDK1.4<a name="line.406"></a> |
| <FONT color="green">407</FONT> con = m_Driver.connect(m_url, m_ConnectionProtocol );<a name="line.407"></a> |
| <FONT color="green">408</FONT> <a name="line.408"></a> |
| <FONT color="green">409</FONT> return con;<a name="line.409"></a> |
| <FONT color="green">410</FONT> }<a name="line.410"></a> |
| <FONT color="green">411</FONT> <a name="line.411"></a> |
| <FONT color="green">412</FONT> // Initialize the pool<a name="line.412"></a> |
| <FONT color="green">413</FONT> /**<a name="line.413"></a> |
| <FONT color="green">414</FONT> *<a name="line.414"></a> |
| <FONT color="green">415</FONT> * @throws IllegalArgumentException<a name="line.415"></a> |
| <FONT color="green">416</FONT> * @throws SQLException<a name="line.416"></a> |
| <FONT color="green">417</FONT> */<a name="line.417"></a> |
| <FONT color="green">418</FONT> public synchronized void initializePool( )throws IllegalArgumentException, SQLException<a name="line.418"></a> |
| <FONT color="green">419</FONT> {<a name="line.419"></a> |
| <FONT color="green">420</FONT> <a name="line.420"></a> |
| <FONT color="green">421</FONT> // Check our initial values<a name="line.421"></a> |
| <FONT color="green">422</FONT> if ( m_driver == null )<a name="line.422"></a> |
| <FONT color="green">423</FONT> {<a name="line.423"></a> |
| <FONT color="green">424</FONT> throw new IllegalArgumentException(XSLMessages.createMessage(XSLTErrorResources.ER_NO_DRIVER_NAME_SPECIFIED, null));<a name="line.424"></a> |
| <FONT color="green">425</FONT> // "No Driver Name Specified!");<a name="line.425"></a> |
| <FONT color="green">426</FONT> }<a name="line.426"></a> |
| <FONT color="green">427</FONT> <a name="line.427"></a> |
| <FONT color="green">428</FONT> if ( m_url == null )<a name="line.428"></a> |
| <FONT color="green">429</FONT> {<a name="line.429"></a> |
| <FONT color="green">430</FONT> throw new IllegalArgumentException(XSLMessages.createMessage(XSLTErrorResources.ER_NO_URL_SPECIFIED, null));<a name="line.430"></a> |
| <FONT color="green">431</FONT> // "No URL Specified!");<a name="line.431"></a> |
| <FONT color="green">432</FONT> }<a name="line.432"></a> |
| <FONT color="green">433</FONT> <a name="line.433"></a> |
| <FONT color="green">434</FONT> if ( m_PoolMinSize < 1 )<a name="line.434"></a> |
| <FONT color="green">435</FONT> {<a name="line.435"></a> |
| <FONT color="green">436</FONT> throw new IllegalArgumentException(XSLMessages.createMessage(XSLTErrorResources.ER_POOLSIZE_LESS_THAN_ONE, null));<a name="line.436"></a> |
| <FONT color="green">437</FONT> // "Pool size is less than 1!");<a name="line.437"></a> |
| <FONT color="green">438</FONT> }<a name="line.438"></a> |
| <FONT color="green">439</FONT> <a name="line.439"></a> |
| <FONT color="green">440</FONT> // Create the Connections<a name="line.440"></a> |
| <FONT color="green">441</FONT> // Load the Driver class file<a name="line.441"></a> |
| <FONT color="green">442</FONT> <a name="line.442"></a> |
| <FONT color="green">443</FONT> try<a name="line.443"></a> |
| <FONT color="green">444</FONT> {<a name="line.444"></a> |
| <FONT color="green">445</FONT> // We have also had problems with drivers unloading<a name="line.445"></a> |
| <FONT color="green">446</FONT> // load an instance that will get freed with the class.<a name="line.446"></a> |
| <FONT color="green">447</FONT> m_Driver = (Driver) ObjectFactory.newInstance(<a name="line.447"></a> |
| <FONT color="green">448</FONT> m_driver, ObjectFactory.findClassLoader(), true);<a name="line.448"></a> |
| <FONT color="green">449</FONT> <a name="line.449"></a> |
| <FONT color="green">450</FONT> // Register the Driver that was loaded with the Context Classloader<a name="line.450"></a> |
| <FONT color="green">451</FONT> // but we will ask for connections directly from the Driver<a name="line.451"></a> |
| <FONT color="green">452</FONT> // instance<a name="line.452"></a> |
| <FONT color="green">453</FONT> DriverManager.registerDriver(m_Driver);<a name="line.453"></a> |
| <FONT color="green">454</FONT> }<a name="line.454"></a> |
| <FONT color="green">455</FONT> catch(ObjectFactory.ConfigurationError e)<a name="line.455"></a> |
| <FONT color="green">456</FONT> {<a name="line.456"></a> |
| <FONT color="green">457</FONT> throw new IllegalArgumentException(XSLMessages.createMessage(XSLTErrorResources.ER_INVALID_DRIVER_NAME, null));<a name="line.457"></a> |
| <FONT color="green">458</FONT> // "Invalid Driver Name Specified!");<a name="line.458"></a> |
| <FONT color="green">459</FONT> }<a name="line.459"></a> |
| <FONT color="green">460</FONT> catch(Exception e)<a name="line.460"></a> |
| <FONT color="green">461</FONT> {<a name="line.461"></a> |
| <FONT color="green">462</FONT> throw new IllegalArgumentException(XSLMessages.createMessage(XSLTErrorResources.ER_INVALID_DRIVER_NAME, null));<a name="line.462"></a> |
| <FONT color="green">463</FONT> }<a name="line.463"></a> |
| <FONT color="green">464</FONT> <a name="line.464"></a> |
| <FONT color="green">465</FONT> // IF we are not active, don't actuall build a pool yet<a name="line.465"></a> |
| <FONT color="green">466</FONT> // Just set up the driver and periphal items.<a name="line.466"></a> |
| <FONT color="green">467</FONT> if ( !m_IsActive) return;<a name="line.467"></a> |
| <FONT color="green">468</FONT> <a name="line.468"></a> |
| <FONT color="green">469</FONT> // Create Connections based on the size member<a name="line.469"></a> |
| <FONT color="green">470</FONT> do<a name="line.470"></a> |
| <FONT color="green">471</FONT> {<a name="line.471"></a> |
| <FONT color="green">472</FONT> <a name="line.472"></a> |
| <FONT color="green">473</FONT> Connection con = createConnection();<a name="line.473"></a> |
| <FONT color="green">474</FONT> <a name="line.474"></a> |
| <FONT color="green">475</FONT> if ( con != null )<a name="line.475"></a> |
| <FONT color="green">476</FONT> {<a name="line.476"></a> |
| <FONT color="green">477</FONT> <a name="line.477"></a> |
| <FONT color="green">478</FONT> // Create a PooledConnection to encapsulate the<a name="line.478"></a> |
| <FONT color="green">479</FONT> // real JDBC Connection<a name="line.479"></a> |
| <FONT color="green">480</FONT> PooledConnection pcon = new PooledConnection(con);<a name="line.480"></a> |
| <FONT color="green">481</FONT> <a name="line.481"></a> |
| <FONT color="green">482</FONT> // Add the Connection the pool.<a name="line.482"></a> |
| <FONT color="green">483</FONT> addConnection(pcon);<a name="line.483"></a> |
| <FONT color="green">484</FONT> <a name="line.484"></a> |
| <FONT color="green">485</FONT> if (DEBUG) System.out.println("Adding DB Connection to the Pool");<a name="line.485"></a> |
| <FONT color="green">486</FONT> }<a name="line.486"></a> |
| <FONT color="green">487</FONT> }<a name="line.487"></a> |
| <FONT color="green">488</FONT> while (m_pool.size() < m_PoolMinSize);<a name="line.488"></a> |
| <FONT color="green">489</FONT> }<a name="line.489"></a> |
| <FONT color="green">490</FONT> <a name="line.490"></a> |
| <FONT color="green">491</FONT> // Adds the PooledConnection to the pool<a name="line.491"></a> |
| <FONT color="green">492</FONT> /**<a name="line.492"></a> |
| <FONT color="green">493</FONT> * @param value<a name="line.493"></a> |
| <FONT color="green">494</FONT> *<a name="line.494"></a> |
| <FONT color="green">495</FONT> */<a name="line.495"></a> |
| <FONT color="green">496</FONT> private void addConnection( PooledConnection value )<a name="line.496"></a> |
| <FONT color="green">497</FONT> {<a name="line.497"></a> |
| <FONT color="green">498</FONT> // Add the PooledConnection Object to the vector<a name="line.498"></a> |
| <FONT color="green">499</FONT> m_pool.addElement(value);<a name="line.499"></a> |
| <FONT color="green">500</FONT> }<a name="line.500"></a> |
| <FONT color="green">501</FONT> <a name="line.501"></a> |
| <FONT color="green">502</FONT> <a name="line.502"></a> |
| <FONT color="green">503</FONT> /**<a name="line.503"></a> |
| <FONT color="green">504</FONT> *<a name="line.504"></a> |
| <FONT color="green">505</FONT> * @throws Throwable<a name="line.505"></a> |
| <FONT color="green">506</FONT> */<a name="line.506"></a> |
| <FONT color="green">507</FONT> protected void finalize( )throws Throwable<a name="line.507"></a> |
| <FONT color="green">508</FONT> {<a name="line.508"></a> |
| <FONT color="green">509</FONT> if (DEBUG)<a name="line.509"></a> |
| <FONT color="green">510</FONT> {<a name="line.510"></a> |
| <FONT color="green">511</FONT> System.out.println("In Default Connection Pool, Finalize");<a name="line.511"></a> |
| <FONT color="green">512</FONT> }<a name="line.512"></a> |
| <FONT color="green">513</FONT> <a name="line.513"></a> |
| <FONT color="green">514</FONT> // Iterate over the entire pool closing the<a name="line.514"></a> |
| <FONT color="green">515</FONT> // JDBC Connections.<a name="line.515"></a> |
| <FONT color="green">516</FONT> for ( int x = 0; x < m_pool.size(); x++ )<a name="line.516"></a> |
| <FONT color="green">517</FONT> {<a name="line.517"></a> |
| <FONT color="green">518</FONT> <a name="line.518"></a> |
| <FONT color="green">519</FONT> if (DEBUG)<a name="line.519"></a> |
| <FONT color="green">520</FONT> {<a name="line.520"></a> |
| <FONT color="green">521</FONT> System.out.println("Closing JDBC Connection " + x);<a name="line.521"></a> |
| <FONT color="green">522</FONT> }<a name="line.522"></a> |
| <FONT color="green">523</FONT> <a name="line.523"></a> |
| <FONT color="green">524</FONT> PooledConnection pcon =<a name="line.524"></a> |
| <FONT color="green">525</FONT> (PooledConnection) m_pool.elementAt(x);<a name="line.525"></a> |
| <FONT color="green">526</FONT> <a name="line.526"></a> |
| <FONT color="green">527</FONT> // If the PooledConnection is not in use, close it<a name="line.527"></a> |
| <FONT color="green">528</FONT> if ( pcon.inUse() == false ) { pcon.close(); }<a name="line.528"></a> |
| <FONT color="green">529</FONT> else<a name="line.529"></a> |
| <FONT color="green">530</FONT> {<a name="line.530"></a> |
| <FONT color="green">531</FONT> if (DEBUG)<a name="line.531"></a> |
| <FONT color="green">532</FONT> {<a name="line.532"></a> |
| <FONT color="green">533</FONT> System.out.println("--> Force close");<a name="line.533"></a> |
| <FONT color="green">534</FONT> }<a name="line.534"></a> |
| <FONT color="green">535</FONT> <a name="line.535"></a> |
| <FONT color="green">536</FONT> // If it still in use, sleep for 30 seconds and<a name="line.536"></a> |
| <FONT color="green">537</FONT> // force close.<a name="line.537"></a> |
| <FONT color="green">538</FONT> try<a name="line.538"></a> |
| <FONT color="green">539</FONT> {<a name="line.539"></a> |
| <FONT color="green">540</FONT> java.lang.Thread.sleep(30000);<a name="line.540"></a> |
| <FONT color="green">541</FONT> pcon.close();<a name="line.541"></a> |
| <FONT color="green">542</FONT> }<a name="line.542"></a> |
| <FONT color="green">543</FONT> catch (InterruptedException ie)<a name="line.543"></a> |
| <FONT color="green">544</FONT> {<a name="line.544"></a> |
| <FONT color="green">545</FONT> if (DEBUG) System.err.println(ie.getMessage());<a name="line.545"></a> |
| <FONT color="green">546</FONT> }<a name="line.546"></a> |
| <FONT color="green">547</FONT> }<a name="line.547"></a> |
| <FONT color="green">548</FONT> }<a name="line.548"></a> |
| <FONT color="green">549</FONT> <a name="line.549"></a> |
| <FONT color="green">550</FONT> if (DEBUG)<a name="line.550"></a> |
| <FONT color="green">551</FONT> {<a name="line.551"></a> |
| <FONT color="green">552</FONT> System.out.println("Exit Default Connection Pool, Finalize");<a name="line.552"></a> |
| <FONT color="green">553</FONT> }<a name="line.553"></a> |
| <FONT color="green">554</FONT> <a name="line.554"></a> |
| <FONT color="green">555</FONT> super.finalize();<a name="line.555"></a> |
| <FONT color="green">556</FONT> }<a name="line.556"></a> |
| <FONT color="green">557</FONT> <a name="line.557"></a> |
| <FONT color="green">558</FONT> /**<a name="line.558"></a> |
| <FONT color="green">559</FONT> * The Pool can be Enabled and Disabled. Disabling the pool<a name="line.559"></a> |
| <FONT color="green">560</FONT> * closes all the outstanding Unused connections and any new<a name="line.560"></a> |
| <FONT color="green">561</FONT> * connections will be closed upon release.<a name="line.561"></a> |
| <FONT color="green">562</FONT> *<a name="line.562"></a> |
| <FONT color="green">563</FONT> * @param flag Control the Connection Pool.<a name="line.563"></a> |
| <FONT color="green">564</FONT> * If it is enabled then Connections will actuall be held<a name="line.564"></a> |
| <FONT color="green">565</FONT> * around. If disabled then all unused connections will be instantly<a name="line.565"></a> |
| <FONT color="green">566</FONT> * closed and as connections are released they are closed and removed<a name="line.566"></a> |
| <FONT color="green">567</FONT> * from the pool.<a name="line.567"></a> |
| <FONT color="green">568</FONT> *<a name="line.568"></a> |
| <FONT color="green">569</FONT> *<a name="line.569"></a> |
| <FONT color="green">570</FONT> */<a name="line.570"></a> |
| <FONT color="green">571</FONT> public void setPoolEnabled( boolean flag )<a name="line.571"></a> |
| <FONT color="green">572</FONT> {<a name="line.572"></a> |
| <FONT color="green">573</FONT> m_IsActive = flag;<a name="line.573"></a> |
| <FONT color="green">574</FONT> if ( ! flag )<a name="line.574"></a> |
| <FONT color="green">575</FONT> freeUnused();<a name="line.575"></a> |
| <FONT color="green">576</FONT> }<a name="line.576"></a> |
| <FONT color="green">577</FONT> <a name="line.577"></a> |
| <FONT color="green">578</FONT> }<a name="line.578"></a> |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| </PRE> |
| </BODY> |
| </HTML> |