private void dataPersistenceOfPR(String partitionClause) throws Exception {
Properties props = new Properties();
Connection conn = TestUtil.getConnection(props);
char fileSeparator = System.getProperty("file.separator").charAt(0);
GemFireCacheImpl cache = Misc.getGemFireCache();
Statement stmt = conn.createStatement();
if (cache.findDiskStore("TestPersistenceDiskStore") == null) {
String path = "." + fileSeparator + "test_dir";
File file = new File(path);
if (!file.mkdirs() && !file.isDirectory()) {
throw new DiskAccessException(
"Could not create directory for " + " default disk store : " + file.getAbsolutePath(),
(Region) null);
}
try {
Connection conn1;
conn1 = TestUtil.getConnection();
Statement stmt1 = conn1.createStatement();
stmt1.execute("Create DiskStore " + "TestPersistenceDiskStore" + "'" + path + "'");
conn1.close();
} catch (SQLException e) {
throw GemFireXDRuntimeException.newRuntimeException(null, e);
}
}
stmt.execute("create schema trade");
stmt.execute(
"create table trade.customers (cid int not null, cust_name varchar(100), tid int, "
+ "primary key (cid)) "
+ partitionClause
+ " PERSISTENT "
+ "'"
+ "TestPersistenceDiskStore"
+ "'");
PreparedStatement ps = conn.prepareStatement("insert into trade.customers values (?,?,?)");
for (int i = 1; i < 31; ++i) {
ps.setInt(1, i);
ps.setString(2, "name" + i);
ps.setInt(3, i);
ps.executeUpdate();
}
conn.close();
shutDown();
conn = TestUtil.getConnection();
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from trade.customers");
int expected = 465;
int actual = 0;
while (rs.next()) {
int val = rs.getInt(1);
actual += val;
}
assertEquals(expected, actual);
}
