Go The simplest application of the DBCP connection pool (for Oracle database)

http://blog.csdn.net/iihero/article/details/8254107

http://www.programgo.com/article/81693457907/

Given the question of DBCP directly for the JDBC connection, I made one of the simplest examples. All resources come from the Internet. It doesn't need a web container, it's a simple console app.

Resources:
Http://apache.etoak.com//commons/pool/binaries/commons-pool-1.5.6-bin.zip
Http://labs.renren.com/apache-mirror//commons/dbcp/binaries/commons-dbcp-1.4-bin.zip
Http://download.java.net/maven/1/javaee/jars/javaee-api-5.jar
Of course, there are ojdbc14.jar for Oracle JDBC (for oracle9i and above)

Project file: put it here. http://dl.iteye.com/topics/download/210279f0-f752-37a6-969f-d58ba13cc394

Database connection Information:
Jdbc:oracle:thin:scott/[email Protected]:1521:ora92
SEAN-M700 is the hostname and ora92 is the instance ID of the Oracle database. I don't have an Oracle database installed on my machine, using a oracle9.2 copy of a long-ago, reinstalling the instance and the corresponding service.

The source code is as follows: Borrow the Buddha, the source code is also obtained from the Internet. (http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/doc/basicdatasourceexample.java?revision=1100136& View=markup)

[Java]View PlainCopyprint?

2. /*
4. //
6. *//Here's a simple example of the Basicdatasource.
8. 34//
10. 35
12. 36//
14. PNS//Note that this example are very similiar to the Poolingdriver
16. //Example.
18. 39
20. 40//
22. Compile this example and you ll want:
24. Commons-pool-1.5.6.jar//*
26. //* Commons-dbcp-1.3.jar (JDK 1.4-1.5) or commons-dbcp-1.4 (JDK 1.6+)
28. * J2ee.jar (for the javax.sql classes)
30. Classpath//In your.
32. 46//
34. A/To run this example, you ll want:
36. //* Commons-pool-1.5.6.jar
38. //* Commons-dbcp-1.3.jar (JDK 1.4-1.5) or commons-dbcp-1.4 (JDK 1.6+)
40. /* J2ee.jar (for the javax.sql classes)
42. Wuyi//* The classes for your (underlying) JDBC driver
44. //In your classpath.
46. 53//
48. Wu//Invoke the class using the arguments:
50. * The connect string for your underlying JDBC driver
52. +/* The query you ' d like to execute
54. //You'll also want to ensure your underlying JDBC driver
56. +//IS registered. can use the "jdbc.drivers"
58. A.
60. 60//
62. Example//For:
64. //java-djdbc.drivers=oracle.jdbc.driver.oracledriver \
66. +//-classpath Commons-pool-1.5.6.jar:commons-dbcp-1.4.jar:j2ee.jar:oracle-jdbc.jar:. \
68. //Poolingdatasourceexample
70. +//"Jdbc:oracle:thin:scott/[email Protected]:1521:mysid"
72. //"SELECT * from DUAL"
74. */
76. /*
78. The Oracle connection URL for the thin client-side driver Ojdbc14.jar have the following format:
80. jdbc:oracle:thin:[user/password]@[host][:p Ort]:sid
82. jdbc:oracle:thin:[user/password]@//[host][:p Ort]/sid
86. User-the login user name defined in the Oracle server.
90. password-the password for the login user.
94. Host-the host name where Oracle server is running.
96. Default is 127.0.0.1-the IP address of localhost.
100. Port-the port number where Oracle is listening for connection.
102. Default is 1521.
106. Sid-system ID of the Oracle server database instance.
108. SID is a required value. By default, Oracle Database 10g Express
110. Edition creates one database instance called XE.
112. */
116. Import Org.apache.commons.dbcp.BasicDataSource;
118. Import javax.sql.*;
120. Import java.sql.*;
124. Public class Testdatasource
126. {
130. /**  
132. * @param args
134. */
136. public static void Main (string[] args)
138. {
140. System.out.println ("Setting up data source.");
142. String url = "Jdbc:oracle:thin:scott/[email protected]:1521:ora92";
144. DataSource DataSource = setupdatasource (URL);
146. System.out.println ("done ...");
150. //Now, we can use JDBC DataSource as we normally would.
152. //    
154. Connection conn = null;
156. Statement stmt = null;
158. ResultSet rset = null;
162. try {
164. System.out.println ("Creating connection.");
166. conn = Datasource.getconnection ();
168. System.out.println ("Creating statement.");
170. stmt = Conn.createstatement ();
172. SYSTEM.OUT.PRINTLN ("executing statement.");
174. RSet = Stmt.executequery ("Select 1 from DUAL");
176. System.out.println ("Results:");
178. int numcols = Rset.getmetadata (). getColumnCount ();
180. While (Rset.next ()) {
182. For (int i=1;i<=numcols;i++) {
184. System.out.print ("\ T" + rset.getstring (i));
186. }
188. System.out.println ("");
190. }
192. } catch (SQLException e) {
194. E.printstacktrace ();
196. } finally {
198. try { if (rset! = null) rset.close ();} catch (Exception e) {}
200. try { if (stmt! = null) stmt.close ();} catch (Exception e) {}
202. try { if (conn! = null) conn.close ();} catch (Exception e) {}
204. }
206. }
210. public static DataSource Setupdatasource (String connecturi) {
212. Basicdatasource ds = new Basicdatasource ();
214. Ds.setdriverclassname ("Oracle.jdbc.driver.OracleDriver");
216. Ds.setusername ("Scott");
218. Ds.setpassword ("Tiger");
220. Ds.seturl (Connecturi);
222. return DS;
224. }
228. public static void Printdatasourcestats (DataSource ds) {
230. Basicdatasource BDS = (basicdatasource) DS;
232. System.out.println ("numactive:" + bds.getnumactive ());
234. System.out.println ("numidle:" + bds.getnumidle ());
236. }
240. public static void Shutdowndatasource (DataSource ds) throws SQLException {
242. Basicdatasource BDS = (basicdatasource) DS;
244. Bds.close ();
246. }
250. }

However, it is necessary to note that the DBCP connection pool is the most unsuitable for production environments in several open source connection pools, and there are often dead connections. and Cp30 and Proxool are good choices. DBCP is used to assess the development environment, or is more convenient.

Go The simplest application of the DBCP connection pool (for Oracle database)