blob: 38eed101095c20cf42643abc61f33948f489ede1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
|
// **********************************************************************
//
// Copyright (c) 2003-2008 ZeroC, Inc. All rights reserved.
//
// This copy of Ice is licensed to you under the terms described in the
// ICE_LICENSE file included in this distribution.
//
// **********************************************************************
class ConnectionPool
{
public
ConnectionPool(Ice.Logger logger, String url, String username, String password, int numConnections)
throws java.sql.SQLException
{
_logger = logger;
_url = url;
_username = username;
_password = password;
_nconnections = numConnections;
while(numConnections-- > 0)
{
_connections.add(java.sql.DriverManager.getConnection (url, username, password));
}
}
public synchronized void
destroy()
{
_destroyed = true;
while(_connections.size() != _nconnections)
{
try
{
wait();
}
catch(InterruptedException e)
{
}
}
while(_connections.isEmpty())
{
java.sql.Connection conn = _connections.removeFirst();
try
{
conn.close();
}
catch(java.sql.SQLException e)
{
}
}
}
public synchronized java.sql.Connection
acquire()
{
while(_connections.isEmpty() && !_destroyed)
{
try
{
wait();
}
catch(InterruptedException e)
{
}
}
if(_destroyed)
{
return null;
}
java.sql.Connection conn = _connections.removeFirst();
try
{
boolean closed = conn.isClosed();
if(closed)
{
_logger.warning("ConnectionPool: lost connection to database");
conn = null;
}
}
catch(java.sql.SQLException e)
{
java.io.StringWriter sw = new java.io.StringWriter();
java.io.PrintWriter pw = new java.io.PrintWriter(sw);
e.printStackTrace(pw);
pw.flush();
_logger.warning("ConnectionPool: lost connection to database:\n" + sw.toString());
conn = null;
}
// If the connection has been closed, or is otherwise invalid
// re-establish the connection.
while(conn == null)
{
_logger.trace("ConnectionPool", "establishing new database connection");
try
{
conn = java.sql.DriverManager.getConnection (_url, _username, _password);
}
catch(java.sql.SQLException e)
{
java.io.StringWriter sw = new java.io.StringWriter();
java.io.PrintWriter pw = new java.io.PrintWriter(sw);
e.printStackTrace(pw);
pw.flush();
_logger.warning("ConnectionPool: database connection failed:\n" + sw.toString());
}
}
return conn;
}
public synchronized void
release(java.sql.Connection connection)
{
if(connection != null)
{
_connections.add(connection);
notifyAll();
}
}
Ice.Logger _logger;
private String _url;
private String _username;
private String _password;
private java.util.LinkedList<java.sql.Connection> _connections = new java.util.LinkedList<java.sql.Connection>();
private boolean _destroyed = false;
private int _nconnections;
}
|
