DB2 - Websphere 6.1 - java 1.5

I'm trying to implement something that I'm afraid is going to slow my application down, but wanted to see if there was a good way to do this.

The database is already built and being used by more people then just me, so changing the database structure or tables is a last resort.

I have an application that needs to read and modify tables in two different schemas. The tables in the two schemas are identical. One represents work in progress while the other represents production data.

So I would like to have the same DAO flip flop between schemas.

My concern is that because I access my DAO statically I'm going to have to synchronize the methods inside so that users don't connect to the wrong schema.

So in the Manager Class I haev

Then in the DAO


This works with just one user, but I'm worried that it's going to cause problems.

Has anyone had to do something like this?

I could just double the number of classes that I'm using and create separate objects for each table in each schema, but I'd really like to avoid having to do that.

How about having two instances of the DAO:

public final class DateSensitiveDAO extends BaseDAO {
//more code
private static final DateSensitiveDAO _instance = new DateSensitiveDAO(cfgFileNonWip);
private static final DateSensitiveDAO _wipInstance = new DateSensitiveDAO(cfgFileWip);

private DateSensitiveDAO(String cfgfile) {
//initilaize
}

public static final DateSensitiveDAO getWipInstance(){
return _wipInstance;
}

public static final DateSensitiveDAO getInstance(){
return _instance;
}

//more code
}


---
please rate

I like it. Wish I would have thought of it myself.