Java Doc for StoredProcedure.java in  » Database-JDBC-Connection-Pool » sequoia-2.10.9 » org » continuent » sequoia » controller » requests » Java Source Code / Java DocumentationJava Source Code and Java Documentation

Java Source Code / Java Documentation 1.  6.0 JDK Core 2.  6.0 JDK Modules 3.  6.0 JDK Modules com.sun 4.  6.0 JDK Modules com.sun.java 5.  6.0 JDK Modules sun 6.  6.0 JDK Platform 7.  Ajax 8.  Apache Harmony Java SE 9.  Aspect oriented 10.  Authentication Authorization 11.  Blogger System 12.  Build 13.  Byte Code 14.  Cache 15.  Chart 16.  Chat 17.  Code Analyzer 18.  Collaboration 19.  Content Management System 20.  Database Client 21.  Database DBMS 22.  Database JDBC Connection Pool 23.  Database ORM 24.  Development 25.  EJB Server geronimo 26.  EJB Server GlassFish 27.  EJB Server JBoss 4.2.1 28.  EJB Server resin 3.1.5 29.  ERP CRM Financial 30.  ESB 31.  Forum 32.  GIS 33.  Graphic Library 34.  Groupware 35.  HTML Parser 36.  IDE 37.  IDE Eclipse 38.  IDE Netbeans 39.  Installer 40.  Internationalization Localization 41.  Inversion of Control 42.  Issue Tracking 43.  J2EE 44.  JBoss 45.  JMS 46.  JMX 47.  Library 48.  Mail Clients 49.  Net 50.  Parser 51.  PDF 52.  Portal 53.  Profiler 54.  Project Management 55.  Report 56.  RSS RDF 57.  Rule Engine 58.  Science 59.  Scripting 60.  Search Engine 61.  Security 62.  Sevlet Container 63.  Source Control 64.  Swing Library 65.  Template Engine 66.  Test Coverage 67.  Testing 68.  UML 69.  Web Crawler 70.  Web Framework 71.  Web Mail 72.  Web Server 73.  Web Services 74.  Web Services apache cxf 2.0.1 75.  Web Services AXIS2 76.  Wiki Engine 77.  Workflow Engines 78.  XML 79.  XML UI Java Java Tutorial Java Open Source Jar File Download Java Articles Java Products Java by API Photoshop Tutorials Maya Tutorials Flash Tutorials 3ds-Max Tutorials Illustrator Tutorials GIMP Tutorials C# / C Sharp C# / CSharp Tutorial C# / CSharp Open Source ASP.Net ASP.NET Tutorial JavaScript DHTML JavaScript Tutorial JavaScript Reference HTML / CSS HTML CSS Reference C / ANSI-C C Tutorial C++ C++ Tutorial Ruby PHP Python Python Tutorial Python Open Source SQL Server / T-SQL SQL Server / T-SQL Tutorial Oracle PL / SQL Oracle PL/SQL Tutorial PostgreSQL SQL / MySQL MySQL Tutorial VB.Net VB.Net Tutorial Flash / Flex / ActionScript VBA / Excel / Access / Word XML XML Tutorial Microsoft Office PowerPoint 2007 Tutorial Microsoft Office Excel 2007 Tutorial Microsoft Office Word 2007 Tutorial

Java Source Code / Java Documentation » Database JDBC Connection Pool » sequoia 2.10.9 » org.continuent.sequoia.controller.requests   Source Cross Reference   Class Diagram   Java Document (Java Doc)   java.lang.Object    org.continuent.sequoia.controller.requests.AbstractRequest       org.continuent.sequoia.controller.requests.StoredProcedure StoredProcedure public class StoredProcedure extends AbstractRequest (Code) StoredProcedure is encodes a stored procedure call. It can have the following syntax: {call <procedure-name>[<arg1>,<arg2>, ...]} {?=call <procedure-name>[<arg1>,<arg2>, ...]} For more information See Also:   org.continuent.sequoia.driver.CallableStatement author:    Emmanuel Cecchet version:    1.0 Field Summary protected  boolean altersAggregateList      protected  boolean altersDatabaseCatalog      protected  boolean altersDatabaseSchema      protected  boolean altersMetadataCache      protected  boolean altersQueryResultCache      protected  boolean altersSomething      protected  boolean altersStoredProcedureList      protected  boolean altersUserDefinedTypes      protected  boolean altersUsers      protected  int nbOfParameters      protected  String procedureKey      protected transient  DatabaseProcedureSemantic semantic      Constructor Summary public   StoredProcedure(String sqlQuery, boolean escapeProcessing, int timeout, String lineSeparator)      Creates a new StoredProcedure instance. Method Summary public  boolean altersAggregateList()      public  boolean altersDatabaseCatalog()      public  boolean altersDatabaseSchema()      public  boolean altersMetadataCache()      public  boolean altersQueryResultCache()      public  boolean altersSomething()      public  boolean altersStoredProcedureList()      public  boolean altersUserDefinedTypes()      public  boolean altersUsers()      public  void cloneParsing(AbstractRequest request)      public  void copyNamedAndOutParameters(StoredProcedure otherProc)      Copy (simple assignment, no object cloning so be sure to not modify the original object else you expose yourself to nasty side effects) named parameter values and names ; and out parameter values and indexes of this stored procedure call. public  List getNamedParameterNames()      Returns the named parameter names or none if this stored procedure call has no named parameter. public  Object getNamedParameterValue(String name)      Returns the the value of a named parameter. final public  int getNbOfParameters()      Returns the nbOfParameters value. public  List getOutParameterIndexes()      Returns the list of out parameter indexes (null if none). public  Object getOutParameterValue(Object idx)      Returns the the value of an out parameter. public  String getParsingResultsAsString()      public  String getProcedureKey()      public  String getProcedureName()      Returns the stored procedure name. public  DatabaseProcedureSemantic getSemantic()      Returns the semantic value. public  boolean mightBlock()      Tests if this request might block. public  boolean needsMacroProcessing()      public  void parse(DatabaseSchema schema, int granularity, boolean isCaseSensitive)      Just get the stored procedure name. public  void setBlocking(boolean blocking)      Sets if this request might block. public synchronized  void setNamedParameterName(String paramName)      Set a named parameter name on this stored procedure call. public synchronized  void setNamedParameterValue(String paramName, Object val)      Set a named parameter on this stored procedure call. public synchronized  void setOutParameterIndex(int paramIdx)      Set an out parameter index on this stored procedure call. public synchronized  void setOutParameterValue(Object paramIdx, Object val)      Set an out parameter value on this stored procedure call. Field Detail altersAggregateList protected boolean altersAggregateList(Code) altersDatabaseCatalog protected boolean altersDatabaseCatalog(Code) altersDatabaseSchema protected boolean altersDatabaseSchema(Code) altersMetadataCache protected boolean altersMetadataCache(Code) altersQueryResultCache protected boolean altersQueryResultCache(Code) altersSomething protected boolean altersSomething(Code) altersStoredProcedureList protected boolean altersStoredProcedureList(Code) altersUserDefinedTypes protected boolean altersUserDefinedTypes(Code) altersUsers protected boolean altersUsers(Code) nbOfParameters protected int nbOfParameters(Code) Number of parameters of the stored procedure procedureKey protected String procedureKey(Code) semantic protected transient DatabaseProcedureSemantic semantic(Code) Constructor Detail StoredProcedure public StoredProcedure(String sqlQuery, boolean escapeProcessing, int timeout, String lineSeparator)(Code) Creates a new StoredProcedure instance. Parameters:   sqlQuery - the SQL request Parameters:   escapeProcessing - should the driver to escape processing beforesending to the database ? Parameters:   timeout - an int value Parameters:   lineSeparator - the line separator used in the query Method Detail altersAggregateList public boolean altersAggregateList()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersAggregateList altersDatabaseCatalog public boolean altersDatabaseCatalog()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersDatabaseCatalog altersDatabaseSchema public boolean altersDatabaseSchema()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersDatabaseSchema altersMetadataCache public boolean altersMetadataCache()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersMetadataCache altersQueryResultCache public boolean altersQueryResultCache()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersQueryResultCache altersSomething public boolean altersSomething()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersSomething altersStoredProcedureList public boolean altersStoredProcedureList()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersStoredProcedureList altersUserDefinedTypes public boolean altersUserDefinedTypes()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersUserDefinedTypes altersUsers public boolean altersUsers()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.altersUsers cloneParsing public void cloneParsing(AbstractRequest request)(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.cloneParsing(org.continuent.sequoia.controller.requests.AbstractRequest) copyNamedAndOutParameters public void copyNamedAndOutParameters(StoredProcedure otherProc)(Code) Copy (simple assignment, no object cloning so be sure to not modify the original object else you expose yourself to nasty side effects) named parameter values and names ; and out parameter values and indexes of this stored procedure call. Parameters:   otherProc - the other stored procedure that has the result to copyinto this object getNamedParameterNames public List getNamedParameterNames()(Code) Returns the named parameter names or none if this stored procedure call has no named parameter. Returns the namedParameterNames. getNamedParameterValue public Object getNamedParameterValue(String name)(Code) Returns the the value of a named parameter. Parameters:   name - parameter name Returns the named parameter value. getNbOfParameters final public int getNbOfParameters()(Code) Returns the nbOfParameters value. Returns the nbOfParameters. getOutParameterIndexes public List getOutParameterIndexes()(Code) Returns the list of out parameter indexes (null if none). Returns the outParameterIndexes. getOutParameterValue public Object getOutParameterValue(Object idx)(Code) Returns the the value of an out parameter. Parameters:   idx - parameter index Returns the out parameter value. getParsingResultsAsString public String getParsingResultsAsString()(Code) See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.getParsingResultsAsString getProcedureKey public String getProcedureKey()(Code) Get the stored procedure key the stored procedure key See Also:   DatabaseProcedure.buildKey(Stringint) getProcedureName public String getProcedureName()(Code) Returns the stored procedure name. the stored procedure name getSemantic public DatabaseProcedureSemantic getSemantic()(Code) Returns the semantic value. Returns the semantic. mightBlock public boolean mightBlock()(Code) Tests if this request might block. true if this request might block needsMacroProcessing public boolean needsMacroProcessing()(Code) false See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.needsMacroProcessing parse public void parse(DatabaseSchema schema, int granularity, boolean isCaseSensitive) throws SQLException(Code) Just get the stored procedure name. See Also:   org.continuent.sequoia.controller.requests.AbstractRequest.parse(org.continuent.sequoia.common.sql.schema.DatabaseSchemaintboolean) setBlocking public void setBlocking(boolean blocking)(Code) Sets if this request might block. Parameters:   blocking - a boolean value setNamedParameterName public synchronized void setNamedParameterName(String paramName)(Code) Set a named parameter name on this stored procedure call. Parameters:   paramName - name of the parameter setNamedParameterValue public synchronized void setNamedParameterValue(String paramName, Object val)(Code) Set a named parameter on this stored procedure call. Parameters:   paramName - name of the parameter Parameters:   val - named parameter value setOutParameterIndex public synchronized void setOutParameterIndex(int paramIdx)(Code) Set an out parameter index on this stored procedure call. Parameters:   paramIdx - index of the parameter setOutParameterValue public synchronized void setOutParameterValue(Object paramIdx, Object val)(Code) Set an out parameter value on this stored procedure call. Parameters:   paramIdx - index of the parameter Parameters:   val - value of the parameter Fields inherited from org.continuent.sequoia.controller.requests.AbstractRequest protected transient int cacheable(Code)(Java Doc) protected String cursorName(Code)(Java Doc) protected boolean disabledTableExistenceCheck(Code)(Java Doc) protected transient long endTime(Code)(Java Doc) protected boolean escapeProcessing(Code)(Java Doc) protected int fetchSize(Code)(Java Doc) protected long id(Code)(Java Doc) protected boolean isAutoCommit(Code)(Java Doc) protected transient boolean isParsed(Code)(Java Doc) protected boolean isReadOnly(Code)(Java Doc) protected transient long logId(Code)(Java Doc) protected String login(Code)(Java Doc) protected int maxRows(Code)(Java Doc) protected String preparedStatementParameters(Code)(Java Doc) int requestType(Code)(Java Doc) protected boolean requiresConnectionFlush(Code)(Java Doc) protected boolean requiresConnectionPoolFlush(Code)(Java Doc) protected String sqlQueryOrTemplate(Code)(Java Doc) protected transient long startTime(Code)(Java Doc) protected int timeoutInSeconds(Code)(Java Doc) protected long transactionId(Code)(Java Doc) protected int transactionIsolation(Code)(Java Doc) protected transient String uniqueKey(Code)(Java Doc) protected SortedSet writeLockedTables(Code)(Java Doc) Methods inherited from org.continuent.sequoia.controller.requests.AbstractRequest protected void addDependingTables(DatabaseSchema schema, SortedSet lockedTables)(Code)(Java Doc) abstract public boolean altersAggregateList()(Code)(Java Doc) abstract public boolean altersDatabaseCatalog()(Code)(Java Doc) abstract public boolean altersDatabaseSchema()(Code)(Java Doc) abstract public boolean altersMetadataCache()(Code)(Java Doc) abstract public boolean altersQueryResultCache()(Code)(Java Doc) abstract public boolean altersSomething()(Code)(Java Doc) abstract public boolean altersStoredProcedureList()(Code)(Java Doc) abstract public boolean altersUserDefinedTypes()(Code)(Java Doc) abstract public boolean altersUsers()(Code)(Java Doc) abstract public void cloneParsing(AbstractRequest request)(Code)(Java Doc) public void debug()(Code)(Java Doc) public boolean equals(Object other)(Code)(Java Doc) public int getCacheAbility()(Code)(Java Doc) public String getClientIpAddress()(Code)(Java Doc) public String getCursorName()(Code)(Java Doc) public long getEndTime()(Code)(Java Doc) public boolean getEscapeProcessing()(Code)(Java Doc) public long getExecTimeInMs()(Code)(Java Doc) public int getFetchSize()(Code)(Java Doc) public long getId()(Code)(Java Doc) public String getLineSeparator()(Code)(Java Doc) final public long getLogId()(Code)(Java Doc) public String getLogin()(Code)(Java Doc) public boolean getMacrosAreProcessed()(Code)(Java Doc) public int getMaxRows()(Code)(Java Doc) public String getParsingResultsAsString()(Code)(Java Doc) final public long getPersistentConnectionId()(Code)(Java Doc) public String getPreparedStatementParameters()(Code)(Java Doc) public boolean getRetrieveSQLWarnings()(Code)(Java Doc) public String getSqlOrTemplate()(Code)(Java Doc) public String getSqlShortForm(int nbOfCharacters)(Code)(Java Doc) public long getStartTime()(Code)(Java Doc) public int getTimeout()(Code)(Java Doc) public long getTransactionId()(Code)(Java Doc) public int getTransactionIsolation()(Code)(Java Doc) public String getType()(Code)(Java Doc) public String getUniqueKey()(Code)(Java Doc) public SortedSet getWriteLockedDatabaseTables()(Code)(Java Doc) public int hashCode()(Code)(Java Doc) final public boolean isAlter()(Code)(Java Doc) public boolean isAutoCommit()(Code)(Java Doc) final public boolean isCreate()(Code)(Java Doc) final public boolean isDelete()(Code)(Java Doc) final public boolean isDrop()(Code)(Java Doc) final public boolean isInsert()(Code)(Java Doc) final public boolean isLazyTransactionStart()(Code)(Java Doc) public boolean isParsed()(Code)(Java Doc) final public boolean isPersistentConnection()(Code)(Java Doc) public boolean isReadOnly()(Code)(Java Doc) final public boolean isSelect()(Code)(Java Doc) final public boolean isUpdate()(Code)(Java Doc) abstract public boolean needsMacroProcessing()(Code)(Java Doc) abstract public void parse(DatabaseSchema schema, int granularity, boolean isCaseSensitive) throws SQLException(Code)(Java Doc) public boolean requiresConnectionFlush()(Code)(Java Doc) public boolean requiresConnectionPoolFlush()(Code)(Java Doc) public void setCacheAbility(int cacheAbility)(Code)(Java Doc) public void setClientIpAddress(String clientIpAddress)(Code)(Java Doc) public void setCursorName(String cursorName)(Code)(Java Doc) public void setEndTime(long endTime)(Code)(Java Doc) public void setFetchSize(int fetchSize)(Code)(Java Doc) public void setId(long id)(Code)(Java Doc) public void setIsAutoCommit(boolean isAutoCommit)(Code)(Java Doc) public void setIsLazyTransactionStart(boolean isLazyStart)(Code)(Java Doc) public void setIsReadOnly(boolean isReadOnly)(Code)(Java Doc) final public void setLineSeparator(String lineSeparator)(Code)(Java Doc) final public void setLogId(long logId)(Code)(Java Doc) public void setLogin(String login)(Code)(Java Doc) public void setMacrosAreProcessed(boolean macrosAreProcessed)(Code)(Java Doc) public void setMaxRows(int rows)(Code)(Java Doc) final public void setPersistentConnection(boolean persistentConnection)(Code)(Java Doc) final public void setPersistentConnectionId(long persistentConnectionId)(Code)(Java Doc) public void setPreparedStatementParameters(String params)(Code)(Java Doc) public void setRetrieveSQLWarnings(boolean isRetrieveSQLWarnings)(Code)(Java Doc) public void setSqlOrTemplate(String sql)(Code)(Java Doc) public void setStartTime(long startTime)(Code)(Java Doc) public void setTimeout(int timeout)(Code)(Java Doc) public void setTransactionId(long id)(Code)(Java Doc) public void setTransactionIsolation(int isolationLevel)(Code)(Java Doc) public boolean tableExistenceCheckIsDisabled()(Code)(Java Doc) public String toDebugString()(Code)(Java Doc) public String toShortDebugString()(Code)(Java Doc) public String toString()(Code)(Java Doc) public String toStringShortForm(int nbOfCharacters)(Code)(Java Doc) public String trimCarriageReturnAndTabs()(Code)(Java Doc) Methods inherited from java.lang.Object native protected Object clone() throws CloneNotSupportedException(Code)(Java Doc) public boolean equals(Object obj)(Code)(Java Doc) protected void finalize() throws Throwable(Code)(Java Doc) final native public Class getClass()(Code)(Java Doc) native public int hashCode()(Code)(Java Doc) final native public void notify()(Code)(Java Doc) final native public void notifyAll()(Code)(Java Doc) public String toString()(Code)(Java Doc) final native public void wait(long timeout) throws InterruptedException(Code)(Java Doc) final public void wait(long timeout, int nanos) throws InterruptedException(Code)(Java Doc) final public void wait() throws InterruptedException(Code)(Java Doc)