1 |
|
package org.apache.jcs.auxiliary.disk.jdbc.hsql; |
2 |
|
|
3 |
|
|
4 |
|
|
5 |
|
|
6 |
|
|
7 |
|
|
8 |
|
|
9 |
|
|
10 |
|
|
11 |
|
|
12 |
|
|
13 |
|
|
14 |
|
|
15 |
|
|
16 |
|
|
17 |
|
|
18 |
|
|
19 |
|
|
20 |
|
|
21 |
|
|
22 |
|
import java.sql.Connection; |
23 |
|
import java.sql.DriverManager; |
24 |
|
import java.sql.SQLException; |
25 |
|
import java.sql.Statement; |
26 |
|
import java.util.Collections; |
27 |
|
import java.util.HashSet; |
28 |
|
import java.util.Set; |
29 |
|
|
30 |
|
import org.apache.commons.logging.Log; |
31 |
|
import org.apache.commons.logging.LogFactory; |
32 |
|
import org.apache.jcs.auxiliary.AuxiliaryCache; |
33 |
|
import org.apache.jcs.auxiliary.AuxiliaryCacheAttributes; |
34 |
|
import org.apache.jcs.auxiliary.AuxiliaryCacheFactory; |
35 |
|
import org.apache.jcs.auxiliary.disk.jdbc.JDBCDiskCacheAttributes; |
36 |
|
import org.apache.jcs.auxiliary.disk.jdbc.JDBCDiskCacheManager; |
37 |
|
import org.apache.jcs.engine.behavior.ICompositeCacheManager; |
38 |
|
|
39 |
|
|
40 |
|
|
41 |
|
|
42 |
|
|
43 |
|
|
44 |
0 |
public class HSQLDiskCacheFactory |
45 |
|
implements AuxiliaryCacheFactory |
46 |
|
{ |
47 |
0 |
private final static Log log = LogFactory.getLog( HSQLDiskCacheFactory.class ); |
48 |
|
|
49 |
0 |
private String name = "HSQLDiskCacheFactory"; |
50 |
|
|
51 |
0 |
private Set databases = Collections.synchronizedSet( new HashSet() ); |
52 |
|
|
53 |
|
|
54 |
|
|
55 |
|
|
56 |
|
public AuxiliaryCache createCache( AuxiliaryCacheAttributes rawAttr, ICompositeCacheManager arg1 ) |
57 |
|
{ |
58 |
0 |
JDBCDiskCacheManager mgr = JDBCDiskCacheManager.getInstance( (JDBCDiskCacheAttributes) rawAttr ); |
59 |
|
try |
60 |
|
{ |
61 |
0 |
setupDatabase( (JDBCDiskCacheAttributes) rawAttr ); |
62 |
|
} |
63 |
0 |
catch ( Exception e ) |
64 |
|
{ |
65 |
|
|
66 |
0 |
log.error( "Problem setting up database.", e ); |
67 |
0 |
} |
68 |
0 |
return mgr.getCache( (JDBCDiskCacheAttributes) rawAttr ); |
69 |
|
} |
70 |
|
|
71 |
|
|
72 |
|
|
73 |
|
|
74 |
|
public void setName( String nameArg ) |
75 |
|
{ |
76 |
0 |
name = nameArg; |
77 |
0 |
} |
78 |
|
|
79 |
|
|
80 |
|
|
81 |
|
|
82 |
|
public String getName() |
83 |
|
{ |
84 |
0 |
return name; |
85 |
|
} |
86 |
|
|
87 |
|
|
88 |
|
|
89 |
|
|
90 |
|
|
91 |
|
|
92 |
|
|
93 |
|
|
94 |
|
protected void setupDatabase( JDBCDiskCacheAttributes attributes ) |
95 |
|
throws Exception |
96 |
|
{ |
97 |
0 |
if ( attributes == null ) |
98 |
|
{ |
99 |
0 |
throw new Exception( "The attributes are null." ); |
100 |
|
} |
101 |
|
|
102 |
|
|
103 |
0 |
String database = attributes.getUrl() + attributes.getDatabase(); |
104 |
|
|
105 |
0 |
if ( databases.contains( database ) ) |
106 |
|
{ |
107 |
0 |
if ( log.isInfoEnabled() ) |
108 |
|
{ |
109 |
0 |
log.info( "We already setup database [" + database + "]" ); |
110 |
|
} |
111 |
0 |
return; |
112 |
|
} |
113 |
|
|
114 |
|
|
115 |
0 |
System.setProperty( "hsqldb.cache_scale", "8" ); |
116 |
|
|
117 |
|
|
118 |
0 |
String driver = attributes.getDriverClassName(); |
119 |
|
|
120 |
0 |
String user = attributes.getUserName(); |
121 |
|
|
122 |
0 |
String password = attributes.getPassword(); |
123 |
|
|
124 |
0 |
new org.hsqldb.jdbcDriver(); |
125 |
|
try |
126 |
|
{ |
127 |
0 |
Class.forName( driver ).newInstance(); |
128 |
|
|
129 |
0 |
Connection cConn = DriverManager.getConnection( database, user, password ); |
130 |
|
|
131 |
0 |
setupTABLE( cConn, attributes.getTableName() ); |
132 |
|
|
133 |
0 |
if ( log.isInfoEnabled() ) |
134 |
|
{ |
135 |
0 |
log.info( "Finished setting up database [" + database + "]" ); |
136 |
|
} |
137 |
|
|
138 |
0 |
databases.add( database ); |
139 |
|
} |
140 |
0 |
catch ( Exception e ) |
141 |
|
{ |
142 |
0 |
log.error( "Fatal problem setting up the database.", e ); |
143 |
0 |
} |
144 |
0 |
} |
145 |
|
|
146 |
|
|
147 |
|
|
148 |
|
|
149 |
|
|
150 |
|
|
151 |
|
|
152 |
|
private void setupTABLE( Connection cConn, String tableName ) |
153 |
|
{ |
154 |
0 |
boolean newT = true; |
155 |
|
|
156 |
|
|
157 |
0 |
StringBuffer createSql = new StringBuffer(); |
158 |
0 |
createSql.append( "CREATE CACHED TABLE " + tableName ); |
159 |
0 |
createSql.append( "( " ); |
160 |
0 |
createSql.append( "CACHE_KEY VARCHAR(250) NOT NULL, " ); |
161 |
0 |
createSql.append( "REGION VARCHAR(250) NOT NULL, " ); |
162 |
0 |
createSql.append( "ELEMENT BINARY, " ); |
163 |
0 |
createSql.append( "CREATE_TIME DATE, " ); |
164 |
0 |
createSql.append( "CREATE_TIME_SECONDS BIGINT, " ); |
165 |
0 |
createSql.append( "MAX_LIFE_SECONDS BIGINT, " ); |
166 |
0 |
createSql.append( "SYSTEM_EXPIRE_TIME_SECONDS BIGINT, " ); |
167 |
0 |
createSql.append( "IS_ETERNAL CHAR(1), " ); |
168 |
0 |
createSql.append( "PRIMARY KEY (CACHE_KEY, REGION) " ); |
169 |
0 |
createSql.append( ");" ); |
170 |
|
|
171 |
0 |
Statement sStatement = null; |
172 |
|
try |
173 |
|
{ |
174 |
0 |
sStatement = cConn.createStatement(); |
175 |
|
} |
176 |
0 |
catch ( SQLException e ) |
177 |
|
{ |
178 |
0 |
log.error( "problem creating a statement.", e ); |
179 |
0 |
} |
180 |
|
|
181 |
|
try |
182 |
|
{ |
183 |
0 |
sStatement.executeQuery( createSql.toString() ); |
184 |
0 |
sStatement.close(); |
185 |
|
} |
186 |
0 |
catch ( SQLException e ) |
187 |
|
{ |
188 |
0 |
if ( e.toString().indexOf( "already exists" ) != -1 ) |
189 |
|
{ |
190 |
0 |
newT = false; |
191 |
0 |
} |
192 |
|
else |
193 |
|
{ |
194 |
0 |
log.error( "Problem creating table.", e ); |
195 |
|
} |
196 |
0 |
} |
197 |
|
|
198 |
|
|
199 |
0 |
String setupData[] = { "create index iKEY on " + tableName + " (CACHE_KEY, REGION)" }; |
200 |
|
|
201 |
0 |
if ( newT ) |
202 |
|
{ |
203 |
0 |
for ( int i = 1; i < setupData.length; i++ ) |
204 |
|
{ |
205 |
|
try |
206 |
|
{ |
207 |
0 |
sStatement.executeQuery( setupData[i] ); |
208 |
|
} |
209 |
0 |
catch ( SQLException e ) |
210 |
|
{ |
211 |
0 |
log.error( "Exception caught when creating index." + e ); |
212 |
0 |
} |
213 |
|
} |
214 |
|
} |
215 |
0 |
} |
216 |
|
} |