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;
}
public void testExcelConnectingWithBadUrl() throws Exception {
excelSource.setUrl("jdbc:odbc:Driver={MicroSoft Excel Driver (*.xls)}"); // $NON-NLS-1$
helpTestConnection(excelSource, null, false);
}
/*
* @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();
}