Tue May 18 07:00:00 BST 1999

- Set the ImageViewer application to use transactions

Tue May 18 00:00:00 BST 1999

- Just after committing, I realised why internationalisation isn't

working. This is now fixed (in the Makefile).

stat =db.createStatement();

db.setAutoCommit(false);

lom = ((postgresql.Connection)db).getLargeObjectAPI();

try {

stat.executeUpdate("create table images (imgname name,imgoid oid)");

label.setText("Initialised database");

db.commit();

}catch(SQLExceptionex) {

label.setText(ex.toString());

}

stat =db.createStatement();

stat.executeUpdate("insert into images values ('"+name+"',"+oid+")");

db.commit();

ImageViewer.this.refreshList();

stat.executeUpdate("delete from images where imgname='"+currentImage+"'");

db.commit();

label.setText(currentImage+" deleted");

currentImage=null;

db.commit();

refreshList();

}catch(SQLExceptionex) {

label.setText(ex.toString());