コード例 #1
0
 public JdbcSource helpCreateValidSource() {
   final JdbcSource result = factory.createJdbcSource();
   result.setName("This is a Valid Name With Trailing Spaces   "); // $NON-NLS-1$
   result.setDriverClass(CLASSES2[0]);
   // Set the URL to something valid
   result.setUrl("jdbc:oracle:thin:@slntds01:1521:ds01a"); // $NON-NLS-1$
   result.setDriverName(exactMatchDriver.getName());
   // Create the properties ...
   for (int i = 0; i < SOURCE_PROPERTY_NAMES.length; i++) {
     helpCreateProperty(result, SOURCE_PROPERTY_NAMES[i], SOURCE_PROPERTY_VALUES[i]);
   }
   helpIsValidJdbcSource(result, JdbcManagerImpl.VALID_SOURCE, IStatus.OK);
   return result;
 }
コード例 #2
0
 public void testExcelConnectingWithBadUrl() throws Exception {
   excelSource.setUrl("jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls)}"); // $NON-NLS-1$
   helpTestConnection(excelSource, null, false);
 }
コード例 #3
0
  /*
   * @see TestCase#setUp()
   */
  @Override
  protected void setUp() throws Exception {
    super.setUp();
    String jar_path =
        SmartTestDesignerSuite.getProjectPath("com.metamatrix.datadirect"); // $NON-NLS-1$

    JAR_FILES2 =
        new String[] {
          (new File(jar_path + "/MJbase.jar")).toURI().toURL().toString(), // $NON-NLS-1$
          (new File(jar_path + "/MJutil.jar")).toURI().toURL().toString(), // $NON-NLS-1$
          (new File(jar_path + "/MJoracle.jar")).toURI().toURL().toString() // $NON-NLS-1$
        };
    JAR_FILES_THAT_DONT_EXIST =
        new String[] {
          SmartTestDesignerSuite.getTestDataFile(getClass(), "/drivers").toURI().toURL().toString()
              + "MJbase.ZIP", //$NON-NLS-1$ //$NON-NLS-2$
          SmartTestDesignerSuite.getTestDataFile(getClass(), "/drivers").toURI().toURL().toString()
              + "MJutil.ZIP", //$NON-NLS-1$ //$NON-NLS-2$
          SmartTestDesignerSuite.getTestDataFile(getClass(), "/drivers").toURI().toURL().toString()
              + "MJoracle.ZIP" //$NON-NLS-1$ //$NON-NLS-2$
        };

    mgr = new JdbcDriverManagerForTesting();
    // mgr.start();
    sampleSource = factory.createJdbcSource();
    sampleDriver = factory.createJdbcDriver();

    // Create the source for the find method tests
    final String matchDriverName = "My Favorite Driver"; // $NON-NLS-1$
    final String matchDriverClass = CLASSES2[0];
    matchSource = factory.createJdbcSource();
    matchSource.setName("My Database"); // $NON-NLS-1$
    matchSource.setDriverName(matchDriverName);
    matchSource.setDriverClass(matchDriverClass);

    // Create a driver that the matchSource will only match by name
    nameMatchDriver = factory.createJdbcDriver();
    nameMatchDriver.setName(matchDriverName);
    nameMatchDriver.setPreferredDriverClassName(CLASSES3[0]);
    nameMatchDriver.getAvailableDriverClassNames().add(CLASSES3[0]);

    // Create a driver that the matchSource will only match by available driver
    availableClassMatchDriver = factory.createJdbcDriver();
    availableClassMatchDriver.setName(matchDriverName + " (no match)"); // $NON-NLS-1$
    availableClassMatchDriver.setPreferredDriverClassName(CLASSES2[2]);
    availableClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[0]);
    availableClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[1]);
    availableClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[2]);
    availableClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[3]);

    // Create a driver that the matchSource will only match by available driver
    preferredClassMatchDriver = factory.createJdbcDriver();
    preferredClassMatchDriver.setName(matchDriverName + " (no match)"); // $NON-NLS-1$
    preferredClassMatchDriver.setPreferredDriverClassName(matchDriverClass);
    preferredClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[0]);
    preferredClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[1]);
    preferredClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[2]);
    preferredClassMatchDriver.getAvailableDriverClassNames().add(CLASSES2[3]);

    // Create a driver that the matchSource will not match
    noMatchDriver = factory.createJdbcDriver();
    noMatchDriver.setName(matchDriverName + " (no match)"); // $NON-NLS-1$
    noMatchDriver.setPreferredDriverClassName(CLASSES3[0]);
    noMatchDriver.getAvailableDriverClassNames().add(CLASSES3[0]);

    // Create a driver that the matchSource will only match by available driver
    exactMatchDriver = factory.createJdbcDriver();
    exactMatchDriver.setName(matchDriverName);
    exactMatchDriver.setPreferredDriverClassName(matchDriverClass);
    exactMatchDriver.getAvailableDriverClassNames().add(CLASSES2[0]);
    exactMatchDriver.getAvailableDriverClassNames().add(CLASSES2[1]);
    exactMatchDriver.getAvailableDriverClassNames().add(CLASSES2[2]);
    exactMatchDriver.getAvailableDriverClassNames().add(CLASSES2[3]);
    exactMatchDriver.getJarFileUris().add(JAR_FILES2[0]);
    exactMatchDriver.getJarFileUris().add(JAR_FILES2[1]);
    exactMatchDriver.getJarFileUris().add(JAR_FILES2[2]);

    mgr.getJdbcDrivers().add(nameMatchDriver);
    mgr.getJdbcDrivers().add(availableClassMatchDriver);
    mgr.getJdbcDrivers().add(preferredClassMatchDriver);
    mgr.getJdbcDrivers().add(noMatchDriver);
    mgr.getJdbcDrivers().add(exactMatchDriver);

    metamatrixOracleDriver = factory.createJdbcDriver();
    metamatrixOracleDriver.setName("MetaMatrix JDBC for Oracle"); // $NON-NLS-1$
    metamatrixOracleDriver.getAvailableDriverClassNames().add(CLASSES2[0]);
    metamatrixOracleDriver.getAvailableDriverClassNames().add(CLASSES2[2]);
    metamatrixOracleDriver.setPreferredDriverClassName(CLASSES2[0]);
    metamatrixOracleDriver.getJarFileUris().add(JAR_FILES2[0]);
    metamatrixOracleDriver.getJarFileUris().add(JAR_FILES2[1]);
    metamatrixOracleDriver.getJarFileUris().add(JAR_FILES2[2]);

    excelDriver = factory.createJdbcDriver();
    excelDriver.setName("Microsoft Excel"); // $NON-NLS-1$
    excelDriver.getAvailableDriverClassNames().add(CLASSES3[0]);
    excelDriver.setPreferredDriverClassName(CLASSES3[0]);
    // excelDriver.getJarFileUris().add(JAR_FILES1[0]);
    mgr.getJdbcDrivers().add(excelDriver);
    excelSource = factory.createJdbcSource();
    excelSource.setName("Book1 (Excel)"); // $NON-NLS-1$
    excelSource.setDriverClass(CLASSES3[0]);
    excelSource.setDriverName("Microsoft Excel"); // $NON-NLS-1$
    excelSource.setUrl(
        "jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls)};dBQ=testdata/Book1.xls"); //$NON-NLS-1$

    mgr.start();
  }