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 $

      throw new IllegalStateException ("No connection set");
  }
  ResultSet result = null;
  try {
      if (loadPStmt == null ) {
    loadPStmt = new UniversalPrepStmt
        (dataSource, dbConnection, loadStatement);
      }
      setMapId (loadPStmt, 1);
      result = loadPStmt.executeQuery();
      // Remove current entries and then add loaded values

View Full Code Here

      if (!isNewMap) {
    /* First delete all existing values for that id in the
     * persistent store */
    try {
        if (deleteAllPStmt == null) {
      deleteAllPStmt = new UniversalPrepStmt 
          (dataSource, dbConnection, deleteAllStatement);
        }
        setMapId (deleteAllPStmt, 1);
        int hits = deleteAllPStmt.executeUpdate();
    } catch (SQLException exc) {

View Full Code Here

  try {
      if (updateList.size() == 0) {
    return;
      }
      if (updatePStmt == null) {
    updatePStmt = new UniversalPrepStmt
        (dataSource, dbConnection, updateStatement);
      }
      Iterator keys = updateList.iterator();
      while (keys.hasNext()) {
    final String key = (String)keys.next();

View Full Code Here

  try {
      if (deleteList.size() == 0) {
    return;
      }
      if (deletePStmt == null) {
    deletePStmt = new UniversalPrepStmt 
        (dataSource, dbConnection, deleteStatement);
      }
      Iterator keys = deleteList.iterator();
      while (keys.hasNext()) {
    final String key = (String)keys.next();

View Full Code Here

  try {
      if (insertList.size() == 0) {
    return;
      }
      if (insertPStmt == null) {
    insertPStmt = new UniversalPrepStmt
        (dataSource, dbConnection, insertStatement, 
         new String[] { mapColumnName, itemColumnName});
      }
      Iterator keys = insertList.iterator();
      while (keys.hasNext()) {

View Full Code Here

        Statement statement = null;
        int result = 0;
        try {
            if (hasParameters()) {
                PreparedStatement ps 
        = new UniversalPrepStmt (conn, sqlStatement);
                statement = ps;
                setParameters(ps);
                result = ps.executeUpdate();
            } else {
                statement = conn.createStatement();
                result = statement.executeUpdate(sqlStatement);
            }
            if (var != null) {

View Full Code Here

                logger.debug( "About to execute query: " + sqlStatement );
            }


            if (hasParameters()) {
                PreparedStatement ps 
        = new UniversalPrepStmt (conn, sqlStatement);
                statement = ps;
                setParameters(ps);
                rs = ps.executeQuery();
            } else {
                statement = conn.createStatement();
                rs = statement.executeQuery(sqlStatement);
            }

View Full Code Here

    }
  
    public void insertLobs() throws Exception {
  String xpdl = importXPDL("test1.xml");
  Object header = new HashMap(); 
  UniversalPrepStmt prepStmt = null;
  try {
      // clean up
      assertTrue(cleanup() == 0);
      //con.commit();
      // insert
      prepStmt = new UniversalPrepStmt
    (con, "INSERT INTO ProcessDefinition (" 
     + "DBId, PackageId, ProcessId, Xpdl, Header, Enabled) " 
     + "VALUES (?, ?, ?, ?, ?, 'T')");
      int offset = 1;
      prepStmt.setLong (offset++, 1000000);
      prepStmt.setString(offset++, "univPrepStmtPackage");
      prepStmt.setString(offset++, "univPrepStmtTest");
      /*
      prepStmt.setLargeString(offset++, null);
        prepStmt.setBinary(offset++, null);
       prepStmt.setLargeString(offset++, xpdl);
      prepStmt.setBinary(offset++, header);
      */
      prepStmt.setLargeString(offset++, null);
        prepStmt.setBinary(offset++, null);
      prepStmt.executeUpdate();
      //con.commit();
      // select
      offset = 1;
      prepStmt = new UniversalPrepStmt
    (con, "SELECT Header, Xpdl FROM ProcessDefinition " 
     + "WHERE DBId = 1000000");
      ResultSet rs = prepStmt.executeQuery();
      rs.next();
      if (!isOracle) {
    return;
      }
      Object blobObject = JDBCUtil.getBinary(rs, offset++);

View Full Code Here

                return idx.longValue();
            }
            // new finder, insert
            try {
                Connection con = ds.getConnection();
                UniversalPrepStmt prepStmt = null;
                long newIdx = EJBUtil.newPrimaryKey ("ActivityFinders");
                try {
                    prepStmt = new UniversalPrepStmt
                        (ds, con, "INSERT INTO ActivityFinders (DBId, LocData) " 
                         + "VALUES (?, ?)");
                    prepStmt.setLong(1, newIdx);
                    prepStmt.setBinary(2, finder);
                    prepStmt.executeUpdate();
                } finally {
                    JDBCUtil.closeAll (null, prepStmt, con);
                }
                finderByDBIdCache.put (new Long(newIdx), finder);
                dbIdByFinderCache.put (finder, new Long(newIdx));

View Full Code Here

    }


    public void updateLobs() throws Exception {
  String xpdl = importXPDL("test2.xml");
  Object header = new HashMap(); 
  UniversalPrepStmt prepStmt = null;
  try {
      prepStmt = new UniversalPrepStmt
    (con, "UPDATE ProcessDefinition SET " 
     + "PackageId = ?, ProcessId = ?, Xpdl = ?, Header = ? "
     + "WHERE DBId = ?");
      int offset = 1;
      prepStmt.setString(offset++, "updatedUnivPrepStmtPackage");
      prepStmt.setString(offset++, "updatedunivPrepStmtTest");
      prepStmt.setLargeString(offset++, xpdl);
      prepStmt.setBinary(offset++, header);
      prepStmt.setLong (offset++, 1000000);
      //prepStmt.setString(offset++, "univPrepStmtPackage");
      prepStmt.executeUpdate();
      //con.commit();
      assertTrue(cleanup() == 1);
   } catch (SQLException sqle) {
      sqle.printStackTrace();
  } finally {

View Full Code Here

0 1 2 3 4

TOP

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

de.danet.an.util.jellytags.UnivQueryTag

de.danet.an.util.jellytags.UnivUpdateTag

de.danet.an.util.log4j.EJBSinkEJB

de.danet.an.util.persistentmaps.JDBCPersistentMap

de.danet.an.workflow.assignment.StandardResourceAssignmentService

de.danet.an.workflow.clients.wfxml.ObserverRegistry

de.danet.an.workflow.ejbs.admin.ProcessDefinitionDirectoryEJB

de.danet.an.workflow.ejbs.admin.WorkflowEngineEJB

de.danet.an.workflow.ejbs.core.WfActivityEJB

de.danet.an.workflow.ejbs.core.WfProcessEJB

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.