|
From: <man...@us...> - 2011-06-10 11:21:18
|
Revision: 6303
http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6303&view=rev
Author: manningr
Date: 2011-06-10 11:21:11 +0000 (Fri, 10 Jun 2011)
Log Message:
-----------
More tests for proper identification of Dialects.
Modified Paths:
--------------
trunk/sql12/fw/src/test/java/net/sourceforge/squirrel_sql/fw/dialects/DialectFactoryTest.java
Modified: trunk/sql12/fw/src/test/java/net/sourceforge/squirrel_sql/fw/dialects/DialectFactoryTest.java
===================================================================
--- trunk/sql12/fw/src/test/java/net/sourceforge/squirrel_sql/fw/dialects/DialectFactoryTest.java 2011-06-10 03:17:47 UTC (rev 6302)
+++ trunk/sql12/fw/src/test/java/net/sourceforge/squirrel_sql/fw/dialects/DialectFactoryTest.java 2011-06-10 11:21:11 UTC (rev 6303)
@@ -57,6 +57,10 @@
// Actual values reported by vendor JDBC drivers
+ private static final String AXION_PRODUCT_NAME = "AxionDB";
+
+ private static final String AXION_PRODUCT_VERSION = "1.0M3-dev";
+
private static final String DB2_PRODUCT_NAME = "DB2/LINUX";
private static final String DB2_PRODUCT_VERSION = "SQL09050";
@@ -64,7 +68,23 @@
private static final String DERBY_PRODUCT_NAME = "Apache Derby";
private static final String DERBY_PRODUCT_VERSION = "10.6.2.1 - (999685)";
+
+ private static final String FIREBIRD_PRODUCT_NAME = "Firebird 2.11LI-V2.1.3.18185 Firebird 2.1/tcp (dell-devpc)/P10";
+ private static final String FIREBIRD_PRODUCT_VERSION = "4.2.9";
+
+ private static final String FRONTBASE_PRODUCT_NAME = "FrontBase";
+
+ private static final String FRONTBASE_PRODUCT_VERSION = "4.2.9";
+
+ private static final String HSQL_PRODUCT_NAME = "HSQL Database Engine";
+
+ private static final String HSQL_PRODUCT_VERSION = "1.8.0";
+
+ private static final String H2_PRODUCT_NAME = "H2";
+
+ private static final String H2_PRODUCT_VERSION = "1.0.65 (2008-01-18)";
+
private static final String INFORMIX_PRODUCT_NAME = "Informix Dynamic Server";
private static final String INFORMIX_PRODUCT_VERSION = "10.00.UC6E";
@@ -85,6 +105,12 @@
private static final String MYSQL5_PRODUCT_VERSION = "5.1.41-3ubuntu12.10";
+ private static final String ORACLE_PRODUCT_NAME = "Oracle";
+
+ private static final String ORACLE_PRODUCT_VERSION =
+ "Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - " +
+ "Productio With the Partitioning, OLAP, Data Mining and Real Application Testing options";
+
private static final String POINTBASE_PRODUCT_NAME = "PointBase";
private static final String POINTBASE_PRODUCT_VERSION = "5.1 ECF build 300";
@@ -93,6 +119,16 @@
private static final String POSTGRESQL_PRODUCT_VERSION = "8.3.1";
+ private static final String PROGRESS_PRODUCT_NAME = "OpenEdge RDBMS";
+
+ private static final String PROGRESS_PRODUCT_VERSION = "10.1C";
+
+ private static final String SYBASE_PRODUCT_NAME = "Adaptive Server Enterprise";
+
+ private static final String SYBASE_PRODUCT_VERSION =
+ "Adaptive Server Enterprise/15.0.2/EBF 15654 " +
+ "ESD#4/P/Linux Intel/Linux 2.4.21-47.ELsmp i686/ase1502/2528/32-bit/FBO/Sat Apr 5 05:18:42 2008";
+
@Before
public void setUp() throws Exception
{
@@ -354,6 +390,15 @@
}
@Test
+ public void testGetDialectForAxion() throws SQLException
+ {
+ final String productName = AXION_PRODUCT_NAME;
+ final String productVersion = AXION_PRODUCT_VERSION;
+ final String expectedDialectClassname = AxionDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
+ @Test
public void testGetDialectForDb2() throws SQLException
{
final String productName = DB2_PRODUCT_NAME;
@@ -370,8 +415,45 @@
final String expectedDialectClassname = DerbyDialectExt.class.getName();
testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
}
+
+ @Test
+ public void testGetDialectForFirebird() throws SQLException
+ {
+ final String productName = FIREBIRD_PRODUCT_NAME;
+ final String productVersion = FIREBIRD_PRODUCT_VERSION;
+ final String expectedDialectClassname = FirebirdDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
@Test
+ public void testGetDialectForFrontbase() throws SQLException
+ {
+ final String productName = FRONTBASE_PRODUCT_NAME;
+ final String productVersion = FRONTBASE_PRODUCT_VERSION;
+ final String expectedDialectClassname = FrontBaseDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
+ @Test
+ public void testGetDialectForHsql() throws SQLException
+ {
+ final String productName = HSQL_PRODUCT_NAME;
+ final String productVersion = HSQL_PRODUCT_VERSION;
+ final String expectedDialectClassname = HSQLDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
+ @Test
+ public void testGetDialectForH2() throws SQLException
+ {
+ final String productName = H2_PRODUCT_NAME;
+ final String productVersion = H2_PRODUCT_VERSION;
+ final String expectedDialectClassname = H2DialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
+ @Test
public void testGetDialectForIngres() throws SQLException
{
final String productName = INGRES_PRODUCT_NAME;
@@ -415,6 +497,24 @@
final String expectedDialectClassname = MySQL5DialectExt.class.getName();
testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
}
+
+ @Test
+ public void testGetDialectForOracle() throws SQLException
+ {
+ final String productName = ORACLE_PRODUCT_NAME;
+ final String productVersion = ORACLE_PRODUCT_VERSION;
+ final String expectedDialectClassname = OracleDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
+ @Test
+ public void testGetDialectForPointbase() throws SQLException
+ {
+ final String productName = POINTBASE_PRODUCT_NAME;
+ final String productVersion = POINTBASE_PRODUCT_VERSION;
+ final String expectedDialectClassname = PointbaseDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
@Test
public void testGetDialectForPostgreSQL() throws SQLException
@@ -426,13 +526,23 @@
}
@Test
- public void testGetDialectForPointbase() throws SQLException
+ public void testGetDialectForProgress() throws SQLException
{
- final String productName = POINTBASE_PRODUCT_NAME;
- final String productVersion = POINTBASE_PRODUCT_VERSION;
- final String expectedDialectClassname = PointbaseDialectExt.class.getName();
+ final String productName = PROGRESS_PRODUCT_NAME;
+ final String productVersion = PROGRESS_PRODUCT_VERSION;
+ final String expectedDialectClassname = ProgressDialectExt.class.getName();
testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
}
+
+ @Test
+ public void testGetDialectForSybase() throws SQLException
+ {
+ final String productName = SYBASE_PRODUCT_NAME;
+ final String productVersion = SYBASE_PRODUCT_VERSION;
+ final String expectedDialectClassname = SybaseDialectExt.class.getName();
+ testGetDialectForDatabase(productName, productVersion, expectedDialectClassname);
+ }
+
@Test(expected = UserCancelledOperationException.class)
public void testGetDialect_ShowDialog_UserCancelled() throws UserCancelledOperationException
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
