org.eclipse.datatools.sqltools.sql.util
Class ParameterUtil
java.lang.Object
org.eclipse.datatools.sqltools.sql.util.ParameterUtil
public class ParameterUtil
- extends java.lang.Object
- Author:
- Hui Cao
Method Summary |
static org.eclipse.datatools.sqltools.core.dbitem.ParameterDescriptor[] |
getParameterDescriptors(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.sql.Connection connection,
int type,
org.eclipse.datatools.sqltools.core.ProcIdentifier proc)
Returns the ParameterDescriptors of a procedural object. |
static java.util.Map |
getSPParamDefaultValues(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
Parse the given sp definition and returns the parameter name/default value pairs. |
static java.util.HashMap |
getSPParams(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
Parse the given sp definition and returns the parameter name/IASTSQLParam pairs. |
static java.util.Map |
getSPParamTypeNameMapFromParser(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
|
Methods inherited from class java.lang.Object |
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
ParameterUtil
public ParameterUtil()
getSPParamDefaultValues
public static java.util.Map getSPParamDefaultValues(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
- Parse the given sp definition and returns the parameter name/default value pairs.
- Parameters:
profileName
- used to determine the db typesp
- the sp definition
- Returns:
getSPParamTypeNameMapFromParser
public static java.util.Map getSPParamTypeNameMapFromParser(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
getSPParams
public static java.util.HashMap getSPParams(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.lang.String sp)
- Parse the given sp definition and returns the parameter name/IASTSQLParam pairs.
- Parameters:
databaseIdentifier
- used to determine the db typesp
- the sp definition
- Returns:
getParameterDescriptors
public static org.eclipse.datatools.sqltools.core.dbitem.ParameterDescriptor[] getParameterDescriptors(org.eclipse.datatools.sqltools.core.DatabaseIdentifier databaseIdentifier,
java.sql.Connection connection,
int type,
org.eclipse.datatools.sqltools.core.ProcIdentifier proc)
throws java.sql.SQLException
- Returns the ParameterDescriptors of a procedural object. Although we can get ParameterMode from catalog loader,
its limited parameter type ( compared with JDBC ) and lack of nullablity and default value support force us to use this JDBC approach.
- Parameters:
con
- type
- runstring
-
- Returns:
- @throws SQLException
- Throws:
java.sql.SQLException