Examples of de.danet.an.util.UniversalPrepStmt$SaveColumn

de.danet.an.util.UniversalPrepStmt
This class is used to cache the column value so that the deferDelegee can call the respective method to set the column value again.

      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$SaveColumn

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.