You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@empire-db.apache.org by fr...@apache.org on 2011/04/08 12:08:13 UTC

svn commit: r1090180 - /incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java

Author: francisdb
Date: Fri Apr  8 10:08:13 2011
New Revision: 1090180

URL: http://svn.apache.org/viewvc?rev=1090180&view=rev
Log:
EMPIREDB-104 Create DDL Script on MSSQL should state not CREATE DATABASE if already exist

Modified:
    incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java

Modified: incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java
URL: http://svn.apache.org/viewvc/incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java?rev=1090180&r1=1090179&r2=1090180&view=diff
==============================================================================
--- incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java (original)
+++ incubator/empire-db/trunk/empire-db/src/main/java/org/apache/empire/db/sqlserver/DBDatabaseDriverMSSQL.java Fri Apr  8 10:08:13 2011
@@ -466,7 +466,7 @@ public class DBDatabaseDriverMSSQL exten
                 return error(Errors.InvalidProperty, "databaseName");
             // Create Database
             script.addStmt("USE master");
-            script.addStmt("CREATE DATABASE " + databaseName);
+            script.addStmt("IF NOT EXISTS(SELECT * FROM sys.databases WHERE name = '" + databaseName + "') CREATE DATABASE " + databaseName);
             script.addStmt("USE " + databaseName);
             script.addStmt("SET DATEFORMAT ymd");
             // Sequence Table