You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by to...@apache.org on 2009/12/30 08:49:27 UTC
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...
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