protected void initializeSQL_Strings() {
        final String createCol = "creationtime";
        final String commonPreListener = " and (listenercnt = " + BackedSession.HTTP_SESSION_BINDING_LISTENER + " OR listenercnt = "
                                         + BackedSession.HTTP_SESSION_BINDING_AND_ACTIVATION_LISTENER
                                         + " ) and maxinactivetime >= 0 and (maxinactivetime < ((? - lastaccess) / 1000.0)))";//PK90548
        final String commonPreNoListener = " and (listenercnt = " + BackedSession.HTTP_SESSION_NO_LISTENER + " OR listenercnt = " + BackedSession.HTTP_SESSION_ACTIVATION_LISTENER
                                           + " ) and maxinactivetime >= 0 and (maxinactivetime < ((? - lastaccess) / 1000.0)))";//PK90548
        final String upBaseAcc = "update " + tableName + " set " + lastAccCol + " = ? ";

        remoteInvalAll = "update " + tableName + " set maxinactivetime = 0 where id = ? and propid = ? and appname = ? and maxinactivetime != 0";

        getOneNoUpdate = "select " + maxInactCol + "," + lastAccCol + ", " + appCol + " from " + tableName + " where id = ? and propid = ? for read only";
        getOneNoUpdateNonDB2 = "select " + maxInactCol + "," + lastAccCol + ", " + appCol + " from " + tableName + " where id = ? and propid = ?";

        upBase = "update " + tableName + " set ";
        asyncUpdate = upBaseAcc + " where id = ? and propid = ?  and appname = ?";
        optUpdate = upBaseAcc + " where id = ? and propid = ?  and appname = ? and " + lastAccCol + " = ? ";
        optUpdatePrimRow = upBaseAcc + " where id = ? and propid = ?  and appname = ? and " + lastAccCol + " = ? ";

        insNoProp = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL, NULL)";
        insForInval = "insert into " + tableName + " (" + idCol + "," + propCol + "," + appCol + "," + lastAccCol + "," + maxInactCol + ") values (?, ?, ?, ?, ?)";
        insSm = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL)";
        insMed = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, NULL)";
        insLg = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL, ?)";

        getProp = "select small, medium, large from  " + tableName + "  where id = ? and propid = ? and appname = ? for read only";

        //PK71265
        delPropall = "delete from  " + tableName + " where id = ? and propid <> id and appname = ?";

        getPropNotDB2 = "select small, medium, large from  " + tableName + "  where id = ? and propid = ? and appname = ?";

        delProp = "delete from " + tableName + " where id = ? and propid = ? and appname = ?";

        insSmProp = "insert into " + tableName + " (id, propid, small, appname) values (?, ?, ?, ?)";

        insMedProp = "insert into " + tableName + " (id, propid, medium, appname) values (?, ?, ?, ?)";

        insLgProp = "insert into " + tableName + " (id, propid, large, appname) values (?, ?, ?, ?)";

        selMed = "select medium from " + tableName;
        selLg = "select large from " + tableName;

        readLastAccess = "select " + lastAccCol + " from " + tableName + " where id = ? and propid = ? and appname = ?";

        selectForUpdate = "select " + lastAccCol + " from " + tableName + " where id = ? and propid = ? and appname = ? for update of lastaccess";
        delPrimaryRowInval = "delete from  " + tableName + " where id = ? and propid = id  and appname = ? and lastaccess = ?";

        readPrimitiveData = "select " + lastAccCol + ", " + createCol + " ," + maxInactCol + "," + userCol + "," + listenCol + " from " + tableName
                            + " where id = ? and propid = ? and appname = ?";
        readPrimitiveDataDb2 = readPrimitiveData + " for read only";
        delOne = "delete from " + tableName + " where id = ?  and appname = ?";
        selDelNoListener = "select id," + lastAccCol + ", " + createCol + " from  " + tableName + " where (appname = ? " + commonPreNoListener;
        selNukerString = "select id," + lastAccCol + ", " + createCol + "," + maxInactCol + "," + userCol + "," + listenCol + " from  " + tableName + " where ( appname = ? "
                         + commonPreListener;
    }
protected void initializeSQL_Strings ( ) { final String createCol = "creationtime" ; final String commonPreListener = " and (listenercnt = " + BackedSession . HTTP_SESSION_BINDING_LISTENER + " OR listenercnt = " + BackedSession . HTTP_SESSION_BINDING_AND_ACTIVATION_LISTENER + " ) and maxinactivetime >= 0 and (maxinactivetime < ((? - lastaccess) / 1000.0)))" ; final String commonPreNoListener = " and (listenercnt = " + BackedSession . HTTP_SESSION_NO_LISTENER + " OR listenercnt = " + BackedSession . HTTP_SESSION_ACTIVATION_LISTENER + " ) and maxinactivetime >= 0 and (maxinactivetime < ((? - lastaccess) / 1000.0)))" ; final String upBaseAcc = "update " + tableName + " set " + lastAccCol + " = ? " ; remoteInvalAll = "update " + tableName + " set maxinactivetime = 0 where id = ? and propid = ? and appname = ? and maxinactivetime != 0" ; getOneNoUpdate = "select " + maxInactCol + "," + lastAccCol + ", " + appCol + " from " + tableName + " where id = ? and propid = ? for read only" ; getOneNoUpdateNonDB2 = "select " + maxInactCol + "," + lastAccCol + ", " + appCol + " from " + tableName + " where id = ? and propid = ?" ; upBase = "update " + tableName + " set " ; asyncUpdate = upBaseAcc + " where id = ? and propid = ?  and appname = ?" ; optUpdate = upBaseAcc + " where id = ? and propid = ?  and appname = ? and " + lastAccCol + " = ? " ; optUpdatePrimRow = upBaseAcc + " where id = ? and propid = ?  and appname = ? and " + lastAccCol + " = ? " ; insNoProp = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL, NULL)" ; insForInval = "insert into " + tableName + " (" + idCol + "," + propCol + "," + appCol + "," + lastAccCol + "," + maxInactCol + ") values (?, ?, ?, ?, ?)" ; insSm = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL)" ; insMed = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, ?, NULL)" ; insLg = "insert into " + tableName + " (" + varList + ") values (?, ?, ?, ?, ?, ?, ?, ?, NULL, NULL, ?)" ; getProp = "select small, medium, large from  " + tableName + "  where id = ? and propid = ? and appname = ? for read only" ; delPropall = "delete from  " + tableName + " where id = ? and propid <> id and appname = ?" ; getPropNotDB2 = "select small, medium, large from  " + tableName + "  where id = ? and propid = ? and appname = ?" ; delProp = "delete from " + tableName + " where id = ? and propid = ? and appname = ?" ; insSmProp = "insert into " + tableName + " (id, propid, small, appname) values (?, ?, ?, ?)" ; insMedProp = "insert into " + tableName + " (id, propid, medium, appname) values (?, ?, ?, ?)" ; insLgProp = "insert into " + tableName + " (id, propid, large, appname) values (?, ?, ?, ?)" ; selMed = "select medium from " + tableName ; selLg = "select large from " + tableName ; readLastAccess = "select " + lastAccCol + " from " + tableName + " where id = ? and propid = ? and appname = ?" ; selectForUpdate = "select " + lastAccCol + " from " + tableName + " where id = ? and propid = ? and appname = ? for update of lastaccess" ; delPrimaryRowInval = "delete from  " + tableName + " where id = ? and propid = id  and appname = ? and lastaccess = ?" ; readPrimitiveData = "select " + lastAccCol + ", " + createCol + " ," + maxInactCol + "," + userCol + "," + listenCol + " from " + tableName + " where id = ? and propid = ? and appname = ?" ; readPrimitiveDataDb2 = readPrimitiveData + " for read only" ; delOne = "delete from " + tableName + " where id = ?  and appname = ?" ; selDelNoListener = "select id," + lastAccCol + ", " + createCol + " from  " + tableName + " where (appname = ? " + commonPreNoListener ; selNukerString = "select id," + lastAccCol + ", " + createCol + "," + maxInactCol + "," + userCol + "," + listenCol + " from  " + tableName + " where ( appname = ? " + commonPreListener ; }
/*
For 5.0 there can now be a unique datasource for each databasesessionContext/backedhashtable
Looks like tableName and other vars are always hardcoded in SessionConstants...
so strings can stay static
However, in AS400 environment, if these fields can be different in each bht then these
strings must no longer be static!!!