Examples of de.danet.an.util.UniversalPrepStmt

de.danet.an.util.UniversalPrepStmt

This class provides a wrapper that can handle special database requirements. Although suitable for all jdbc-driven database connections, special features of the following databases are supported: Oracle, SAPDB and Hypersonic. In addition, all set/get methods for non-primitives handle null values correctly.

Additional methods {@link #setBinary setBinary} and{@link #setInt(int,Integer) setInt(int, Integer)} {@link #setLargeString setLargeString} areprovided for convenience. @author @version $Revision: 2326 $

            PreparedStatement prepStmt = null;
            Connection con = null;
            ResultSet rs = null;
            try {
                con = ds.getConnection();
                prepStmt = new UniversalPrepStmt
                    (ds, con, "SELECT XPDL FROM XPDLARCHIVE WHERE DBID = ?");
                prepStmt.setLong(1, id);
                rs = prepStmt.executeQuery();
                if (!rs.next()) {
                    throw new IllegalArgumentException();

            PreparedStatement prepStmt = null;
            Connection con = null;
            ResultSet rs = null;
            try {
                con = ds.getConnection();
                prepStmt = new UniversalPrepStmt
                    (ds, con, "SELECT XPDLREF "
                     + "FROM PROCESSDEFINITION WHERE XPDLREF = ?");
                prepStmt.setLong(1, id);
                prepStmt.setMaxRows(1);
                rs = prepStmt.executeQuery();
                if (rs.next()) {
                    return;
                }
                rs.close();
                rs = null;
                prepStmt.close();
                prepStmt = null;
                prepStmt = new UniversalPrepStmt
                    (ds, con, "SELECT XPDLREF "
                     + "FROM PROCESS WHERE XPDLREF = ?");
                prepStmt.setLong(1, id);
                prepStmt.setMaxRows(1);
                rs = prepStmt.executeQuery();
                if (rs.next()) {
                    return;
                }
                rs.close();
                rs = null;
                prepStmt.close();
                prepStmt = null;
                prepStmt = new UniversalPrepStmt
                    (ds, con, "DELETE FROM XPDLARCHIVE WHERE DBID = ?");
                prepStmt.setLong(1, id);
                prepStmt.executeUpdate();
                archivedProcessDefinitionCache.remove (new Long(id));
            } finally {

Examples of de.danet.an.util.UniversalPrepStmt

Related Classes of de.danet.an.util.UniversalPrepStmt