Package net.sourceforge.squirrel_sql.fw.sql

Examples of net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo


   * @throws SQLException
   */
  public static int getColumnType(ISQLConnection con, ITableInfo ti, int column) throws SQLException
  {
    TableColumnInfo[] infoArr = con.getSQLMetaData().getColumnInfo(ti);
    TableColumnInfo colInfo = infoArr[column];
    return colInfo.getDataType();
  }
View Full Code Here


  {
    TableColumnInfo[] infoArr = con.getSQLMetaData().getColumnInfo(ti);
    int[] result = new int[infoArr.length];
    for (int i = 0; i < result.length; i++)
    {
      TableColumnInfo colInfo = infoArr[i];
      result[i] = colInfo.getDataType();
    }
    return result;
  }
View Full Code Here

      // column info from the SQL database meta data.
      return;
    }
    for (int colIdx = 0; colIdx < colInfoArr.length; colIdx++)
    {
      TableColumnInfo colInfo = colInfoArr[colIdx];
      IDatabaseObjectInfo selectedDestObj = prov.getDestSelectedDatabaseObject();
      String schema = selectedDestObj.getSimpleName();
      String catalog = selectedDestObj.getCatalogName();
      String tableName = getQualifiedObjectName(
         destSession, catalog, schema, TEST_TABLE_NAME, DialectFactory.DEST_TYPE);

      StringBuilder sql = new StringBuilder("CREATE TABLE ");
      sql.append(tableName);
      sql.append(" ( ");
      sql.append(colInfo.getColumnName());
      sql.append(" CHAR(10) )");
      boolean cascade = DialectFactory.isFrontBase(destSession.getMetaData());
      try
      {
        dropTable(TEST_TABLE_NAME, schema, catalog, destSession, cascade, DialectFactory.DEST_TYPE);
        DBUtil.executeUpdate(con, sql.toString(), false);
      } catch (SQLException e)
      {
        String message = getMessage("DBUtil.mappingErrorKeyword", new String[]
          { ti.getSimpleName(), colInfo.getColumnName() });
        log.error(message, e);
        throw new MappingException(message);
      } finally
      {
        dropTable(tableName, schema, catalog, destSession, cascade, DialectFactory.DEST_TYPE);
View Full Code Here

    }
   
    private void testBigintColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getBigintColumnInfo(md, true);
        testColType(md, toDb, column);
    }   
View Full Code Here

    }   

    private void testBinaryColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getBinaryColumnInfo(md, true);
        // This is for brute force detection of columns whose column size is 0
        ResultSet rs = getColLengthResult();
        testColType(md, toDb, column, rs);
    }   
View Full Code Here

    }   
   
    private void testBlobColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getBlobColumnInfo(md, true);
        //This is for brute force detection of BLOB/CLOB lengths if necessary
        ResultSet rs = getColLengthResult();
        testColType(md, toDb, column, rs);
    }   
View Full Code Here

    }   

    private void testClobColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getClobColumnInfo(md, true);
        // This is for brute force detection of BLOB/CLOB lengths if necessary
        ResultSet rs = getColLengthResult();
        testColType(md, toDb, column, rs);       
    }   
View Full Code Here

   
    private void testDateColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getDateColumnInfo(md, true);
        testColType(md, toDb, column);
    }   
View Full Code Here

    private void testLongVarcharColType(String fromDb, String toDb)
        throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column =
            FwTestUtil.getLongVarcharColumnInfo(md, true, Integer.MAX_VALUE);
        testColType(md, toDb, column);
    }       
View Full Code Here

    }       
   
    private void testVarcharColType(String fromDb, String toDb) throws Exception
    {
        ISQLDatabaseMetaData md = FwTestUtil.getEasyMockSQLMetaData(fromDb, null);
        TableColumnInfo column = FwTestUtil.getVarcharColumnInfo(md, true, 2000);
        testColType(md, toDb, column);
    }   
View Full Code Here

TOP

Related Classes of net.sourceforge.squirrel_sql.fw.sql.TableColumnInfo

Copyright © 2018 www.massapicom. All rights reserved.
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.