// same case as above, only no changes are made to the node.
public void testDeleteNodeOutsideTransactionNodeInTransactionButNotChanged() {
Cloud cloud = getCloud();
Transaction t = cloud.getTransaction("bar11");
Node nodeInTransaction = t.getNode(newNode2);
// nodeInTransaction.setStringValue("title", "foo2");
{
// now delete the node
Node nodeOutTransaction = cloud.getNode(newNode2);
nodeOutTransaction.delete();
assertFalse(cloud.hasNode(newNode2));
}
try {
// make a relation to the (deleted) node, but in the transaction, where the node still
// exists.
// This demonstrate that there is an actual problem if the node ends up non-existing now.
Node url = t.getNodeManager("urls").createNode();
RelationManager rm = t.getRelationManager("news", "urls", "posrel");
Relation r = nodeInTransaction.createRelation(url, rm);
t.commit();
} catch (Exception e) {
// should not give exception. MMB-1680
log.error(e.getMessage(), e);
fail(e.getMessage());
}
assertTrue(cloud.hasNode(newNode2));
assertEquals(1, cloud.getNode(newNode2).countRelations());
}
protected void check() {
if (map == null) {
Connection connection = null;
Statement statement = null;
ResultSet results = null;
try {
connection = dataSource.getConnection();
statement = connection.createStatement();
long start = System.currentTimeMillis();
String s = getFindSql(identifier);
if (log.isTraceEnabled()) {
log.trace("About to execute " + s + " because ", new Exception());
}
results = statement.executeQuery(s);
ResultSetMetaData meta = results.getMetaData();
map = new HashMap<String, String>();
if (results.next()) {
for (int i = 1; i <= meta.getColumnCount(); i++) {
String value = org.mmbase.util.Casting.toString(results.getString(i));
map.put(meta.getColumnName(i).toLowerCase(), value);
}
}
long duration = (System.currentTimeMillis() - start);
if (duration > 500) {
log.warn("Executed " + s + " in " + duration + " ms");
} else if (duration > 100) {
log.debug("Executed " + s + " in " + duration + " ms");
} else {
log.trace("Executed " + s + " in " + duration + " ms");
}
} catch (Exception e) {
throw new RuntimeException(e.getMessage(), e);
} finally {
if (results != null)
try {
results.close();
} catch (Exception e) {
}
if (statement != null)
try {
statement.close();
} catch (Exception e) {
}
if (connection != null)
try {
connection.close();
} catch (Exception e) {
}
}
}
}
public void testDeleteNodeOutsideTransaction() {
Cloud cloud = getCloud();
Transaction t = cloud.getTransaction("bar11");
Node nodeInTransaction = t.getNode(newNode2);
nodeInTransaction.setStringValue("title", "foo2");
{
// now delete the node
Node nodeOutTransaction = cloud.getNode(newNode2);
nodeOutTransaction.delete();
assertFalse(cloud.hasNode(newNode2));
}
try {
t.commit();
} catch (Exception e) {
// should not give exception. MMB-1680
log.error(e.getMessage(), e);
fail(e.getMessage());
}
assertTrue(cloud.hasNode(newNode2));
}
CloseableIterator<JdbcEntry> getSqlCursor(final String sql) {
try {
long start = System.currentTimeMillis();
final Connection con = getDirectConnection();
log.debug("About to execute " + sql + " (" + directConnections + ")");
final Statement statement = con.createStatement();
final ResultSet results = statement.executeQuery(sql);
if (log.isDebugEnabled()) {
log.debug("Executed " + sql + " in " + (System.currentTimeMillis() - start) + " ms");
}
final ResultSetMetaData meta = results.getMetaData();
return new CloseableIterator<JdbcEntry>() {
boolean hasNext = results.isBeforeFirst();
int i = 0;
@Override
public boolean hasNext() {
return hasNext;
}
@Override
public JdbcEntry next() {
if (!hasNext) {
throw new NoSuchElementException();
}
try {
results.next();
hasNext = !results.isLast();
} catch (java.sql.SQLException sqe) {
log.error(sqe);
hasNext = false;
}
JdbcEntry entry = new JdbcEntry(meta, results, sql);
i++;
if (log.isServiceEnabled()) {
if (i % 100 == 0) {
log.service("jdbc cursor " + i + " (now at id=" + entry.getIdentifier() + ")");
} else if (log.isDebugEnabled()) {
log.trace("jdbc cursor " + i + " (now at id=" + entry.getIdentifier() + ")");
}
}
return entry;
}
@Override
public void remove() {
throw new UnsupportedOperationException();
}
@Override
public void close() {
log.debug("Closing " + con);
try {
if (results != null) results.close();
if (statement != null) statement.close();
if (con != null) con.close();
} catch (Exception e) {
log.error(e);
}
}
};
} catch (Exception e) {
throw new RuntimeException(e.getMessage(), e);
}
}