Examples of net.helipilot50.stocktrade.genericdbms.CloseTolerantStatement$StatementInfo

Package net.helipilot50.stocktrade.genericdbms

Examples of net.helipilot50.stocktrade.genericdbms.CloseTolerantStatement$StatementInfo

net.helipilot50.stocktrade.framework.UsageException

DBStatements in Forte exist in single-threaded partitions, and can maintain their values across transactions. In Java, a PreparedStatement is single-threaded (as evidenced by the fact it stores the variables for that thread) and cannot exist across a transaction boundary, as the commit (especially in Spring) calls connection.close() which removes all the statements.

This class solved both of these problems by maintaining enough state to be able to re-create a statement if it's created by a different thread or exists on a closed connection. This means that if the pattern in Forte is:

 conn = myDataSource.getConnection(); statement1 = conn.createStatement(someSQL1); statement2 = conn.createStatement(someSQL2); begin transaction statement1.execute(); end transaction begin transaction statement1.execute(); end transaction

then this should still work in Java

Debugging note: This class provides some level of tracing into the execution of dynamic SQL statements. To used it, set one of the following levels of tracing:

Level set	Effect
CloseTolerantStatement.info log4j level trc:db:2:1	Traces all instances of the execute methods (execute, executeQuery, etc) including parameters
CloseTolerantStatement.debug log4j level trc:db:2:50	Traces all setter and execute methods

@author tfaulkes

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateFloat(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateDouble(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateLong(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateBoolean(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateShort(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

        if (resultSet instanceof CachedRowSet) {
          CachedRowSet cachedRowSet = (CachedRowSet) resultSet;
          try {
            cachedRowSet.updateString(pColOrdinal, pValue);
          } catch (SQLException e) {
            UsageException errorVar = new UsageException(e.getMessage(), net.helipilot50.stocktrade.framework.Constants.SP_ER_USER, net.helipilot50.stocktrade.framework.Constants.SP_ER_PARAMETERERROR, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
          }
        }
      }

View Full Code Here

     * and is a hint to the underlying JDBC driver only.
     * @param pRows The maximum number of rows for this dataset
     */
    public void setMaxRows(int pRows) {
      if (pRows < 0) {
        UsageException err = new UsageException("pRows must be > 0 in call to DBDataSet.setMaxRows");
        ErrorMgr.addError(err);
        throw err;
      }
      this.maxRows = pRows;
      if (this.statement != null) {

View Full Code Here

        //PM:19/2/08 setting the name uses the naming strategy
        try {
            ObjectName objectName  = SystemAgent.getStrategy().getObjectName(this, pValue.toString());
            this.setObjectName(objectName);
        } catch (MalformedObjectNameException e) {
            UsageException errorVar = new UsageException("Cannot set SystemAgent name to: " + pValue, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
        } catch (NullPointerException e) {
            UsageException errorVar = new UsageException("Cannot set SystemAgent name to: " + pValue, e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
        }


        this.agentInfo.setAgentName(pValue.toString());

View Full Code Here

        try {
            ObjectName objectName  = SystemAgent.getStrategy().getObjectName(this, System.getProperty(PropertiesMgr.cENVIRONMENT_NAME));
            this.setObjectName(objectName);


        } catch (MalformedObjectNameException e) {
            UsageException errorVar = new UsageException("Cannot create EnvironmentAgent", e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
        } catch (NullPointerException e) {
            UsageException errorVar = new UsageException("Cannot create EnvironmentAgent", e);
            ErrorMgr.addError(errorVar);
            throw errorVar;
        }


        this.setNameAsString(System.getProperty("EnvName"));

View Full Code Here

                comp.getParent().setPreferredSize(null);
            }
            invalidateLayout(comp.getParent());
        }
        else {
            UsageException errorVar = new UsageException("constraints must be an instance of grid bag constraints or grid cell");
            ErrorMgr.addError(errorVar);
            throw errorVar;
        }
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of net.helipilot50.stocktrade.genericdbms.CloseTolerantStatement$StatementInfo

com.google.gwt.user.client.ui.Label

net.helipilot50.stocktrade.displayproject.actions.ArrayColumnTitle

net.helipilot50.stocktrade.displayproject.actions.BottomMargin

net.helipilot50.stocktrade.displayproject.actions.Caption

net.helipilot50.stocktrade.displayproject.actions.CharacterTemplate

net.helipilot50.stocktrade.displayproject.actions.ColumnList

net.helipilot50.stocktrade.displayproject.actions.ElementList

net.helipilot50.stocktrade.displayproject.actions.Enabled

net.helipilot50.stocktrade.displayproject.actions.FieldWidgetGravity

net.helipilot50.stocktrade.displayproject.actions.FloatOverText

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.