db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r894556 - in /db/ddlutils/trunk/src: main/java/org/apache/ddlutils/ main/java/org/apache/ddlutils/alteration/ main/java/org/apache/ddlutils/platform/ main/java/org/apache/ddlutils/platform/derby/ main/java/org/apache/ddlutils/platform/mssql...
Date Wed, 30 Dec 2009 07:49:27 GMT
Author: tomdz
Date: Wed Dec 30 07:49:27 2009
New Revision: 894556

URL: http://svn.apache.org/viewvc?rev=894556&view=rev
Log:
Added equivalence for on delete/on update settings

Modified:
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/PlatformInfo.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/alteration/ModelComparator.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/JdbcModelReader.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/derby/DerbyPlatform.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
    db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/sapdb/SapDbPlatform.java
    db/ddlutils/trunk/src/test/java/org/apache/ddlutils/TestAgainstLiveDatabaseBase.java
    db/ddlutils/trunk/src/test/resources/jdbc.properties.db2
    db/ddlutils/trunk/src/test/resources/jdbc.properties.firebird
    db/ddlutils/trunk/src/test/resources/jdbc.properties.maxdb
    db/ddlutils/trunk/src/test/resources/jdbc.properties.oracle10
    db/ddlutils/trunk/src/test/resources/jdbc.properties.postgresql
    db/ddlutils/trunk/src/test/resources/jdbc.properties.sqlserver2005

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/PlatformInfo.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/PlatformInfo.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/PlatformInfo.java (original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/PlatformInfo.java Wed Dec 30 07:49:27
2009
@@ -24,6 +24,7 @@
 import java.util.Arrays;
 import java.util.HashMap;
 import java.util.HashSet;
+import java.util.Set;
 
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
@@ -180,6 +181,12 @@
     /** Contains the supported ON DELETE actions. */
     private HashSet _supportedOnDeleteActions = new HashSet();
 
+    /** Contains for each ON UPDATE action the list of equivalent actions. */
+    private HashMap _equivalentOnUpdateActions = new HashMap();
+
+    /** Contains for each ON DELETE action the list of equivalent actions. */
+    private HashMap _equivalentOnDeleteActions = new HashMap();
+
     /**
      * Creates a new platform info object.
      */
@@ -1276,4 +1283,92 @@
     {
         _defaultOnDeleteAction = defaultOnDeleteAction;
     }
+
+    /**
+     * Registers the given pair of ON UPDATE actions to be equivalent. Equivalent actions
will not
+     * cause a foreign key to be changed/recreated when altering a database.
+     * 
+     * @param actionA The first action
+     * @param actionB The second action
+     */
+    public void addEquivalentOnUpdateActions(CascadeActionEnum actionA, CascadeActionEnum
actionB)
+    {
+        if (!actionA.equals(actionB))
+        {
+            Set actionsEquivalentToActionA = (Set)_equivalentOnUpdateActions.get(actionA);
+            Set actionsEquivalentToActionB = (Set)_equivalentOnUpdateActions.get(actionB);
+
+            if (actionsEquivalentToActionA == null)
+            {
+                actionsEquivalentToActionA = new HashSet();
+                _equivalentOnUpdateActions.put(actionA, actionsEquivalentToActionA);
+            }
+            if (actionsEquivalentToActionB == null)
+            {
+                actionsEquivalentToActionB = new HashSet();
+                _equivalentOnUpdateActions.put(actionB, actionsEquivalentToActionB);
+            }
+            actionsEquivalentToActionA.add(actionB);
+            actionsEquivalentToActionB.add(actionA);
+        }
+    }
+
+    /**
+     * Determiones whether the two ON UPDATE actions are equivalent. Equivalent actions will
not
+     * cause a foreign key to be changed/recreated when altering a database.
+     * 
+     * @param actionA The first action
+     * @param actionB The second action
+     * @return <code>true</code> if the two actions are equivalent 
+     */
+    public boolean areEquivalentOnUpdateActions(CascadeActionEnum actionA, CascadeActionEnum
actionB)
+    {
+        Set actionsEquivalentToActionA = (Set)_equivalentOnUpdateActions.get(actionA);
+
+        return actionsEquivalentToActionA == null ? false : actionsEquivalentToActionA.contains(actionB);
+    }
+
+    /**
+     * Registers the given pair of ON DELETE actions to be equivalent. Equivalent actions
will not
+     * cause a foreign key to be changed/recreated when altering a database.
+     * 
+     * @param actionA The first action
+     * @param actionB The second action
+     */
+    public void addEquivalentOnDeleteActions(CascadeActionEnum actionA, CascadeActionEnum
actionB)
+    {
+        if (!actionA.equals(actionB))
+        {
+            Set actionsEquivalentToActionA = (Set)_equivalentOnDeleteActions.get(actionA);
+            Set actionsEquivalentToActionB = (Set)_equivalentOnDeleteActions.get(actionB);
+
+            if (actionsEquivalentToActionA == null)
+            {
+                actionsEquivalentToActionA = new HashSet();
+                _equivalentOnDeleteActions.put(actionA, actionsEquivalentToActionA);
+            }
+            if (actionsEquivalentToActionB == null)
+            {
+                actionsEquivalentToActionB = new HashSet();
+                _equivalentOnDeleteActions.put(actionB, actionsEquivalentToActionB);
+            }
+            actionsEquivalentToActionA.add(actionB);
+            actionsEquivalentToActionB.add(actionA);
+        }
+    }
+
+    /**
+     * Determiones whether the two ON DELETE actions are equivalent. Equivalent actions will
not
+     * cause a foreign key to be changed/recreated when altering a database.
+     * 
+     * @param actionA The first action
+     * @param actionB The second action
+     * @return <code>true</code> if the two actions are equivalent 
+     */
+    public boolean areEquivalentOnDeleteActions(CascadeActionEnum actionA, CascadeActionEnum
actionB)
+    {
+        Set actionsEquivalentToActionA = (Set)_equivalentOnDeleteActions.get(actionA);
+
+        return actionsEquivalentToActionA == null ? false : actionsEquivalentToActionA.contains(actionB);
+    }
 }

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/alteration/ModelComparator.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/alteration/ModelComparator.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/alteration/ModelComparator.java (original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/alteration/ModelComparator.java Wed
Dec 30 07:49:27 2009
@@ -373,6 +373,7 @@
         tableDefinitionChanges.addAll(checkForAddedColumns(sourceModel, sourceTable, intermediateModel,
intermediateTable, targetModel, targetTable));
         tableDefinitionChanges.addAll(checkForPrimaryKeyChanges(sourceModel, sourceTable,
intermediateModel, intermediateTable, targetModel, targetTable));
 
+        // TOOD: check for foreign key changes (on delete/on update)
         if (!tableDefinitionChanges.isEmpty())
         {
             if ((_tableDefCangePredicate == null) || _tableDefCangePredicate.areSupported(tmpTable,
tableDefinitionChanges))

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/JdbcModelReader.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/JdbcModelReader.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/JdbcModelReader.java (original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/JdbcModelReader.java Wed
Dec 30 07:49:27 2009
@@ -933,12 +933,11 @@
             CascadeActionEnum onUpdateAction = convertAction((Short)values.get("UPDATE_RULE"));
             CascadeActionEnum onDeleteAction = convertAction((Short)values.get("DELETE_RULE"));
 
-            // Some JDBC drivers lie and return actions that the DB not actually supports
-            if ((onUpdateAction == null) || !getPlatformInfo().isActionSupportedForOnUpdate(onUpdateAction))
+            if (onUpdateAction == null)
             {
                 onUpdateAction = getPlatformInfo().getDefaultOnUpdateAction();
             }
-            if ((onDeleteAction == null) || !getPlatformInfo().isActionSupportedForOnDelete(onDeleteAction))
+            if (onDeleteAction == null)
             {
                 onDeleteAction = getPlatformInfo().getDefaultOnDeleteAction();
             }

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/derby/DerbyPlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/derby/DerbyPlatform.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/derby/DerbyPlatform.java
(original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/derby/DerbyPlatform.java
Wed Dec 30 07:49:27 2009
@@ -64,8 +64,11 @@
         info.addNativeTypeMapping(Types.DOUBLE, "DOUBLE");
         info.addNativeTypeMapping(Types.FLOAT,  "DOUBLE", Types.DOUBLE);
         info.setSupportedOnUpdateActions(new CascadeActionEnum[] { CascadeActionEnum.NONE,
CascadeActionEnum.RESTRICT });
+        info.setDefaultOnUpdateAction(CascadeActionEnum.NONE);
+        info.addEquivalentOnUpdateActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
         info.setSupportedOnDeleteActions(new CascadeActionEnum[] { CascadeActionEnum.NONE,
CascadeActionEnum.RESTRICT,
                                                                    CascadeActionEnum.CASCADE,
CascadeActionEnum.SET_NULL });
+        info.setDefaultOnDeleteAction(CascadeActionEnum.NONE);
 
         setSqlBuilder(new DerbyBuilder(this));
         setModelReader(new DerbyModelReader(this));

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
(original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/mssql/MSSqlPlatform.java
Wed Dec 30 07:49:27 2009
@@ -77,7 +77,9 @@
         info.setIdentityColumnAutomaticallyRequired(true);
         info.setMultipleIdentityColumnsSupported(false);
         info.setSupportedOnUpdateActions(new CascadeActionEnum[] { CascadeActionEnum.CASCADE,
CascadeActionEnum.NONE });
+        info.addEquivalentOnUpdateActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
         info.setSupportedOnDeleteActions(new CascadeActionEnum[] { CascadeActionEnum.CASCADE,
CascadeActionEnum.NONE });
+        info.addEquivalentOnDeleteActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
 
         info.addNativeTypeMapping(Types.ARRAY,         "IMAGE",         Types.LONGVARBINARY);
         // BIGINT will be mapped back to BIGINT by the model reader 

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
(original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/oracle/Oracle8Platform.java
Wed Dec 30 07:49:27 2009
@@ -74,6 +74,7 @@
         info.setPrimaryKeyColumnAutomaticallyRequired(true);
         info.setSupportedOnUpdateActions(new CascadeActionEnum[] { CascadeActionEnum.NONE
});
         info.setSupportedOnDeleteActions(new CascadeActionEnum[] { CascadeActionEnum.CASCADE,
CascadeActionEnum.SET_NULL, CascadeActionEnum.NONE });
+        info.addEquivalentOnDeleteActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
 
         // Note that the back-mappings are partially done by the model reader, not the driver
         info.addNativeTypeMapping(Types.ARRAY,         "BLOB",             Types.BLOB);

Modified: db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/sapdb/SapDbPlatform.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/sapdb/SapDbPlatform.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/sapdb/SapDbPlatform.java
(original)
+++ db/ddlutils/trunk/src/main/java/org/apache/ddlutils/platform/sapdb/SapDbPlatform.java
Wed Dec 30 07:49:27 2009
@@ -67,9 +67,10 @@
         info.setMultipleIdentityColumnsSupported(false);
         info.setCommentPrefix("/*");
         info.setCommentSuffix("*/");
-        info.setSupportedOnUpdateActions(new CascadeActionEnum[] { CascadeActionEnum.NONE
});
-        info.setDefaultOnDeleteAction(CascadeActionEnum.RESTRICT);
         info.setSupportedOnDeleteActions(new CascadeActionEnum[] { CascadeActionEnum.CASCADE,
CascadeActionEnum.RESTRICT, CascadeActionEnum.SET_DEFAULT, CascadeActionEnum.SET_NULL, CascadeActionEnum.NONE
});
+        info.addEquivalentOnDeleteActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
+        info.setSupportedOnUpdateActions(new CascadeActionEnum[] { CascadeActionEnum.NONE
});
+        info.addEquivalentOnUpdateActions(CascadeActionEnum.NONE, CascadeActionEnum.RESTRICT);
 
         // BIGINT is also handled by the model reader
         // Unfortunately there is no way to distinguish between REAL, and FLOAT/DOUBLE when

Modified: db/ddlutils/trunk/src/test/java/org/apache/ddlutils/TestAgainstLiveDatabaseBase.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/java/org/apache/ddlutils/TestAgainstLiveDatabaseBase.java?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/java/org/apache/ddlutils/TestAgainstLiveDatabaseBase.java (original)
+++ db/ddlutils/trunk/src/test/java/org/apache/ddlutils/TestAgainstLiveDatabaseBase.java Wed
Dec 30 07:49:27 2009
@@ -53,7 +53,6 @@
 import org.apache.ddlutils.io.DataReader;
 import org.apache.ddlutils.io.DataToDatabaseSink;
 import org.apache.ddlutils.io.DatabaseIO;
-import org.apache.ddlutils.model.CascadeActionEnum;
 import org.apache.ddlutils.model.CloneHelper;
 import org.apache.ddlutils.model.Column;
 import org.apache.ddlutils.model.Database;
@@ -1312,35 +1311,12 @@
                          getPlatform().getSqlBuilder().shortenName(actual.getForeignTableName().toUpperCase(),
getSqlBuilder().getMaxTableNameLength()));
         }
 
-        CascadeActionEnum realExpectedOnUpdateAction = expected.getOnUpdate();
-        CascadeActionEnum realActualOnUpdateAction   = actual.getOnUpdate();
-
-        if (!getPlatformInfo().isActionSupportedForOnUpdate(realExpectedOnUpdateAction) ||
(realExpectedOnUpdateAction == CascadeActionEnum.NONE))
-        {
-            realExpectedOnUpdateAction = getPlatformInfo().getDefaultOnUpdateAction();
-        }
-        if (!getPlatformInfo().isActionSupportedForOnUpdate(realActualOnUpdateAction) ||
(realActualOnUpdateAction == CascadeActionEnum.NONE))
-        {
-            realActualOnUpdateAction = getPlatformInfo().getDefaultOnUpdateAction();
-        }
-        assertEquals("Not the same onUpdate setting in foreign key "+actual.getName()+".",
-                     realExpectedOnUpdateAction,
-                     realActualOnUpdateAction);
-
-        CascadeActionEnum realExpectedOnDeleteAction = expected.getOnDelete();
-        CascadeActionEnum realActualOnDeleteAction   = actual.getOnDelete();
-
-        if (!getPlatformInfo().isActionSupportedForOnDelete(realExpectedOnDeleteAction) ||
(realExpectedOnDeleteAction == CascadeActionEnum.NONE))
-        {
-            realExpectedOnDeleteAction = getPlatformInfo().getDefaultOnDeleteAction();
-        }
-        if (!getPlatformInfo().isActionSupportedForOnDelete(realActualOnDeleteAction) ||
(realActualOnDeleteAction == CascadeActionEnum.NONE))
-        {
-            realActualOnDeleteAction = getPlatformInfo().getDefaultOnDeleteAction();
-        }
-        assertEquals("Not the same onDelete setting in foreign key "+actual.getName()+".",
-                     realExpectedOnDeleteAction,
-                     realActualOnDeleteAction);
+        assertTrue("Not the same onUpdate setting in foreign key "+actual.getName()+": expected
= "+expected.getOnUpdate()+", actual = "+actual.getOnUpdate(),
+                   expected.getOnUpdate().equals(actual.getOnUpdate()) ||
+                   getPlatformInfo().areEquivalentOnUpdateActions(expected.getOnUpdate(),
actual.getOnUpdate()));
+        assertTrue("Not the same onDelete setting in foreign key "+actual.getName()+": expected
= "+expected.getOnDelete()+", actual = "+actual.getOnDelete(),
+                   expected.getOnDelete().equals(actual.getOnDelete()) ||
+                   getPlatformInfo().areEquivalentOnDeleteActions(expected.getOnDelete(),
actual.getOnDelete()));
 
         assertEquals("Not the same number of references in foreign key "+actual.getName()+".",
                      expected.getReferenceCount(),

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.db2
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.db2?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.db2 (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.db2 Wed Dec 30 07:49:27 2009
@@ -26,6 +26,6 @@
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 
 datasource.driverClassName=com.ibm.db2.jcc.DB2Driver
-datasource.url=jdbc:db2://192.168.129.134:50000/ddlutils
+datasource.url=jdbc:db2://192.168.129.133:50000/ddlutils
 datasource.username=ddlutils
 datasource.password=ddlutils

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.firebird
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.firebird?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.firebird (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.firebird Wed Dec 30 07:49:27 2009
@@ -29,7 +29,7 @@
 
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 datasource.driverClassName=org.firebirdsql.jdbc.FBDriver
-datasource.url=jdbc:firebirdsql://192.168.129.129/C:/Program Files/Firebird/Firebird_2_0/data/ddlutils.fdb
+datasource.url=jdbc:firebirdsql://192.168.129.133/C:/Program Files/Firebird/Firebird_2_0/data/ddlutils.fdb
 datasource.username=SYSDBA
 datasource.password=masterkey
 

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.maxdb
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.maxdb?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.maxdb (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.maxdb Wed Dec 30 07:49:27 2009
@@ -29,6 +29,6 @@
 
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 datasource.driverClassName=com.sap.dbtech.jdbc.DriverSapDB
-datasource.url=jdbc:sapdb://192.168.129.134/MAXDB1
+datasource.url=jdbc:sapdb://192.168.129.133/MAXDB1
 datasource.username=ddlutils
 datasource.password=ddlutils

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.oracle10
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.oracle10?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.oracle10 (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.oracle10 Wed Dec 30 07:49:27 2009
@@ -29,7 +29,7 @@
 
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 datasource.driverClassName=oracle.jdbc.driver.OracleDriver
-datasource.url=jdbc:oracle:thin:@192.168.129.134:1521:XE
+datasource.url=jdbc:oracle:thin:@192.168.129.133:1521:XE
 datasource.username=ddlutils
 datasource.password=ddlutils
 

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.postgresql
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.postgresql?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.postgresql (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.postgresql Wed Dec 30 07:49:27 2009
@@ -29,7 +29,7 @@
 
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 datasource.driverClassName=org.postgresql.Driver
-datasource.url=jdbc:postgresql://192.168.129.134/ddlutils
+datasource.url=jdbc:postgresql://192.168.129.133/ddlutils
 datasource.username=ddlutils
 datasource.password=ddlutils
 

Modified: db/ddlutils/trunk/src/test/resources/jdbc.properties.sqlserver2005
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/resources/jdbc.properties.sqlserver2005?rev=894556&r1=894555&r2=894556&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/resources/jdbc.properties.sqlserver2005 (original)
+++ db/ddlutils/trunk/src/test/resources/jdbc.properties.sqlserver2005 Wed Dec 30 07:49:27
2009
@@ -26,7 +26,7 @@
 datasource.class=org.apache.commons.dbcp.BasicDataSource
 
 datasource.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
-datasource.url=jdbc:sqlserver://192.168.129.134;databaseName=ddlutils;selectMethod=cursor
+datasource.url=jdbc:sqlserver://192.168.129.133;databaseName=ddlutils;selectMethod=cursor
 
 datasource.username=ddlutils
 datasource.password=ddlutils



Mime
View raw message