org.eclipse.datatools.enablement.sybase.asa.catalog
Class SybaseASACatalogUtils
java.lang.Object
   org.eclipse.datatools.enablement.sybase.asa.catalog.SybaseASACatalogUtils
org.eclipse.datatools.enablement.sybase.asa.catalog.SybaseASACatalogUtils
- public class SybaseASACatalogUtils 
- extends java.lang.Object
 
| Method Summary | 
| static java.util.List | addOperationNamesToCatalog(java.sql.ResultSet storedProcs)
 | 
| static void | cleanupJDBCResouce(java.sql.ResultSet rs,
                   java.sql.Statement stmt)
 | 
| static java.lang.Object | findElement(java.util.Collection collection,
            java.lang.String name)
 | 
| static java.lang.Object | findElement(java.util.Collection collection,
            java.lang.String name,
            org.eclipse.emf.ecore.EClass metaclass)
 | 
| static PredefinedDataType | getASAPredefinedType(int width,
                     int scale,
                     java.lang.String typeName,
                     DatabaseDefinition databaseDefinition)
 | 
| static char | getCharValue(java.lang.String value)
 | 
| static java.util.List | getDBDatatypes(java.lang.String ctg,
               java.sql.Connection cnxn)
 | 
| static PredefinedDataType | getPredefinedRepresentation(DataType datatype)
 | 
| static java.util.List | getSpecifiedColumns(java.lang.String colListStr,
                    java.util.Collection columnList)
 | 
| static Domain | getSpecifiedUserDefinedDatatype(Database database,
                                java.lang.String typeName)
 | 
| static boolean | getSPMetaData(java.sql.Connection cxn,
              java.lang.String catalog,
              java.lang.String schema,
              java.lang.String spName)
 | 
| static java.sql.ResultSet | getStoredProcs(java.lang.String ctg_nm,
               java.lang.String sch_nm,
               java.lang.String proc_nm,
               java.sql.Connection cnxn)Return a ResultSet object representing the stored procedures on the
 database visible to this connection
 | 
| static java.sql.ResultSet | getTables(java.lang.String ctg_nm,
          java.lang.String sch_nm,
          java.lang.String table_nm,
          java.sql.Connection cnxn)Return a ResultSet object representing the stored procedures on the
 database visible to this connection
 | 
| static boolean | isBinaryType(DataType datatype)
 | 
| static boolean | isDateType(DataType datatype)
 | 
| static boolean | isNumericType(DataType datatype)
 | 
| static boolean | isStringType(DataType datatype)
 | 
| static boolean | isSystemDefault(java.lang.String defaultValue)
 | 
| static boolean | isTimeType(DataType datatype)
 | 
| static java.util.List | parseColumnList(java.lang.String columnListStr)
 | 
| static java.util.List | parseOrderList(java.lang.String orderListStr)Parse the order
 | 
| static void | parseView(ViewTable view,
          java.lang.String viewText)
 | 
| static java.lang.String | retrieveRoutineObjectCode(java.sql.Connection conn,
                          java.lang.String schemaName,
                          java.lang.String routineName)
 | 
| static java.lang.String | retrieveTriggerObjectCode(java.sql.Connection conn,
                          java.lang.String tableSchemaName,
                          java.lang.String tableName,
                          java.lang.String schemaName,
                          java.lang.String routineName)
 | 
 
| Methods inherited from class java.lang.Object | 
| equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait | 
 
SybaseASACatalogUtils
public SybaseASACatalogUtils()
getDBDatatypes
public static java.util.List getDBDatatypes(java.lang.String ctg,
                                            java.sql.Connection cnxn)
                                     throws java.sql.SQLException
- 
- Throws:
- java.sql.SQLException
 
getStoredProcs
public static java.sql.ResultSet getStoredProcs(java.lang.String ctg_nm,
                                                java.lang.String sch_nm,
                                                java.lang.String proc_nm,
                                                java.sql.Connection cnxn)
                                         throws java.sql.SQLException
- Return a ResultSet object representing the stored procedures on the
 database visible to this connection
 
- 
- Returns:
- java.sql.ResultSet - the stored procedures
- Throws:
- java.sql.SQLException
 
addOperationNamesToCatalog
public static java.util.List addOperationNamesToCatalog(java.sql.ResultSet storedProcs)
                                                 throws java.sql.SQLException
- 
- Throws:
- java.sql.SQLException
 
getTables
public static java.sql.ResultSet getTables(java.lang.String ctg_nm,
                                           java.lang.String sch_nm,
                                           java.lang.String table_nm,
                                           java.sql.Connection cnxn)
                                    throws java.sql.SQLException
- Return a ResultSet object representing the stored procedures on the
 database visible to this connection
 
- 
- Returns:
- java.sql.ResultSet - the stored procedures
- Throws:
- java.sql.SQLException
 
getSPMetaData
public static boolean getSPMetaData(java.sql.Connection cxn,
                                    java.lang.String catalog,
                                    java.lang.String schema,
                                    java.lang.String spName)
- 
 
retrieveRoutineObjectCode
public static java.lang.String retrieveRoutineObjectCode(java.sql.Connection conn,
                                                         java.lang.String schemaName,
                                                         java.lang.String routineName)
                                                  throws java.sql.SQLException
- 
- Throws:
- java.sql.SQLException
 
retrieveTriggerObjectCode
public static java.lang.String retrieveTriggerObjectCode(java.sql.Connection conn,
                                                         java.lang.String tableSchemaName,
                                                         java.lang.String tableName,
                                                         java.lang.String schemaName,
                                                         java.lang.String routineName)
                                                  throws java.sql.SQLException
- 
- Throws:
- java.sql.SQLException
 
cleanupJDBCResouce
public static void cleanupJDBCResouce(java.sql.ResultSet rs,
                                      java.sql.Statement stmt)
- 
 
findElement
public static java.lang.Object findElement(java.util.Collection collection,
                                           java.lang.String name)
- 
 
findElement
public static java.lang.Object findElement(java.util.Collection collection,
                                           java.lang.String name,
                                           org.eclipse.emf.ecore.EClass metaclass)
- 
 
getSpecifiedColumns
public static java.util.List getSpecifiedColumns(java.lang.String colListStr,
                                                 java.util.Collection columnList)
- 
 
parseColumnList
public static java.util.List parseColumnList(java.lang.String columnListStr)
- 
 
getCharValue
public static char getCharValue(java.lang.String value)
- 
 
getASAPredefinedType
public static PredefinedDataType getASAPredefinedType(int width,
                                                      int scale,
                                                      java.lang.String typeName,
                                                      DatabaseDefinition databaseDefinition)
                                               throws java.sql.SQLException
- 
- Throws:
- java.sql.SQLException
 
isSystemDefault
public static boolean isSystemDefault(java.lang.String defaultValue)
- 
 
getSpecifiedUserDefinedDatatype
public static Domain getSpecifiedUserDefinedDatatype(Database database,
                                                     java.lang.String typeName)
- 
 
parseView
public static void parseView(ViewTable view,
                             java.lang.String viewText)
- 
 
parseOrderList
public static java.util.List parseOrderList(java.lang.String orderListStr)
- Parse the order
 
- 
- Parameters:
- orderListStr-
- Returns:
 
getPredefinedRepresentation
public static PredefinedDataType getPredefinedRepresentation(DataType datatype)
- 
 
isNumericType
public static boolean isNumericType(DataType datatype)
- 
 
isStringType
public static boolean isStringType(DataType datatype)
- 
 
isTimeType
public static boolean isTimeType(DataType datatype)
- 
 
isDateType
public static boolean isDateType(DataType datatype)
- 
 
isBinaryType
public static boolean isBinaryType(DataType datatype)
-