if (mode.compareTo("open")==0) {
db=Db4o.openFile(Db4o.newConfiguration(), db4oFileName);
db.ext().configure().updateDepth(5);
- System.out.println("DataBase Opened");
} else if (mode.compareTo("initialize")==0){
+ try {
new File(db4oFileName).delete();
db=Db4o.openFile(Db4o.newConfiguration(), db4oFileName);
db.ext().configure().updateDepth(5);
db.store(alfredoAcc);
db.commit();
System.out.println("DataBase Initialized");
+ } finally {
+ db.close();
+ }
+
}
}
public static ObjectContainer getContainer() {
return db;
}
- public static void close(){
- db.close();
- System.out.println("DataBase closed");
- }
+
/**
* This method finds all existing owners
*/
public Vector<Owner> getOwners() throws RemoteException,
Exception {
+ DB4oManager.openDatabase("open");
ObjectContainer db=DB4oManager.getContainer();
try {
Owner proto = new Owner(null,null);
- ObjectSet result = db.queryByExample(proto);
+ ObjectSet<Owner> result = db.queryByExample(proto);
Vector<Owner> owners=new Vector<Owner>();
while(result.hasNext())
owners.add((Owner)result.next());
return owners;
} finally {
- //db.close();
+ db.close();
}
}
public Vector<Account> getAccount(String usr, String pwd) throws RemoteException,
Exception {
+ DB4oManager.openDatabase("open");
ObjectContainer db=DB4oManager.getContainer();
try {
Account proto = new Account(usr,pwd, new Owner(null,null));
- ObjectSet result = db.queryByExample(proto);
+ ObjectSet<Account> result = db.queryByExample(proto);
Vector<Account> accounts=new Vector<Account>();
while(result.hasNext())
accounts.add((Account)result.next());
return accounts;
} finally {
- //db.close();
+ db.close();
}
}
public Vector<RuralHouse> getAllRuralHouses() throws RemoteException,
Exception {
+ DB4oManager.openDatabase("open");
ObjectContainer db=DB4oManager.getContainer();
try {
RuralHouse proto = new RuralHouse(0,null,null,null);
- ObjectSet result = db.queryByExample(proto);
+ ObjectSet<RuralHouse> result = db.queryByExample(proto);
Vector<RuralHouse> ruralHouses=new Vector<RuralHouse>();
while(result.hasNext())
ruralHouses.add((RuralHouse)result.next());
return ruralHouses;
} finally {
- //db.close();
+ db.close();
}
}
*/
public Offer createOffer(RuralHouse ruralHouse, Date firstDay, Date lastDay,
float price) throws RemoteException, Exception {
+ DB4oManager.openDatabase("open");
ObjectContainer db=DB4oManager.getContainer();
+ Offer o;
+ try {
RuralHouse proto = new RuralHouse(ruralHouse.getHouseNumber(), null,
ruralHouse.getDescription(), ruralHouse.getTown());
- ObjectSet result = db.queryByExample(proto);
+ ObjectSet<RuralHouse> result = db.queryByExample(proto);
RuralHouse rh=(RuralHouse)result.next();
- Offer o=rh.createOffer(firstDay, lastDay, price);
+ o=rh.createOffer(firstDay, lastDay, price);
db.store(o);
db.commit();
+ }
+ finally{
+ db.close();
+ }
return o;
}
public RuralHouse getRuralHouse(RuralHouse rh){
+
+ DB4oManager.openDatabase("open");
try {
ObjectContainer db=DB4oManager.getContainer();
RuralHouse proto = new RuralHouse(rh.getHouseNumber(), null,
rh.getDescription(), rh.getTown());
- ObjectSet result = db.queryByExample(proto);
+ ObjectSet<RuralHouse> result = db.queryByExample(proto);
return rh=(RuralHouse)result.next();
} catch (Exception exc) {
exc.printStackTrace();
return null;
}
- }
+ finally {
+ db.close();
+ }
+ }
public Booking createBooking(Offer offer, String clientTelephoneNumber)
throws OfferCanNotBeBooked {
+ DB4oManager.openDatabase("open");
try {
Booking b=null;
if (offer!=null) {
exc.printStackTrace();
return null;
}
+ finally {
+ db.close();
+ }
}
/**