You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@juddi.apache.org by ks...@apache.org on 2007/10/05 22:46:07 UTC

svn commit: r582383 [3/5] - in /webservices/juddi/trunk/src/main: java/org/apache/juddi/datastore/jdbc/ java/org/apache/juddi/registry/ resources/juddi-sql/ resources/juddi-sql/daffodildb/ resources/juddi-sql/db2/ resources/juddi-sql/derby/ resources/j...

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelDocDescTable.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelDocDescTable.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelDocDescTable.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelDocDescTable.java Fri Oct  5 13:46:02 2007
@@ -23,6 +23,8 @@
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
 import org.apache.juddi.datatype.Description;
+import org.apache.juddi.registry.RegistryEngine;
+import org.apache.juddi.util.Config;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -35,14 +37,18 @@
   static String insertSQL = null;
   static String selectSQL = null;
   static String deleteSQL = null;
-
-  static {
+  static String tablePrefix = "";
+  
+  static
+  {
+   tablePrefix = Config.getStringProperty(
+       RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
     // buffer used to build SQL statements
     StringBuffer sql = null;
 
     // build insertSQL
     sql = new StringBuffer(150);
-    sql.append("INSERT INTO TMODEL_DOC_DESCR (");
+    sql.append("INSERT INTO ").append(tablePrefix).append("TMODEL_DOC_DESCR (");
     sql.append("TMODEL_KEY,");
     sql.append("TMODEL_DOC_DESCR_ID,");
     sql.append("LANG_CODE,");
@@ -56,14 +62,14 @@
     sql.append("LANG_CODE,");
     sql.append("DESCR, ");
     sql.append("TMODEL_DOC_DESCR_ID ");
-    sql.append("FROM TMODEL_DOC_DESCR ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL_DOC_DESCR ");
     sql.append("WHERE TMODEL_KEY=? ");
     sql.append("ORDER BY TMODEL_DOC_DESCR_ID");
     selectSQL = sql.toString();
 
     // build deleteSQL
     sql = new StringBuffer(100);
-    sql.append("DELETE FROM TMODEL_DOC_DESCR ");
+    sql.append("DELETE FROM ").append(tablePrefix).append("TMODEL_DOC_DESCR ");
     sql.append("WHERE TMODEL_KEY=?");
     deleteSQL = sql.toString();
   }
@@ -102,18 +108,20 @@
         statement.setString(3, desc.getLanguageCode());
         statement.setString(4, desc.getValue());
 
-        log.debug(
-          "insert into TMODEL_DOC_DESCR table:\n\n\t"
-            + insertSQL
-            + "\n\t TMODEL_KEY="
-            + tModelKey.toString()
-            + "\n\t TMODEL_DOC_DESCR_ID="
-            + descID
-            + "\n\t LANG_CODE="
-            + desc.getLanguageCode()
-            + "\n\t DESCR="
-            + desc.getValue()
-            + "\n");
+        if (log.isDebugEnabled()) {
+            log.debug(
+              "insert into " + tablePrefix + "TMODEL_DOC_DESCR table:\n\n\t"
+                + insertSQL
+                + "\n\t TMODEL_KEY="
+                + tModelKey.toString()
+                + "\n\t TMODEL_DOC_DESCR_ID="
+                + descID
+                + "\n\t LANG_CODE="
+                + desc.getLanguageCode()
+                + "\n\t DESCR="
+                + desc.getValue()
+                + "\n");
+        }
 
         statement.executeUpdate();
       }
@@ -150,13 +158,15 @@
       statement = connection.prepareStatement(selectSQL);
       statement.setString(1, tModelKey.toString());
 
+      if (log.isDebugEnabled()) {
       log.debug(
-        "select from TMODEL_DOC_DESCR table:\n\n\t"
+        "select from " + tablePrefix + "TMODEL_DOC_DESCR table:\n\n\t"
           + selectSQL
           + "\n\t TMODEL_KEY="
           + tModelKey.toString()
           + "\n\t TMODEL_DOC_DESCR_ID="
           + "\n");
+      }
 
       // execute the statement
       resultSet = statement.executeQuery();
@@ -202,12 +212,14 @@
       statement = connection.prepareStatement(deleteSQL);
       statement.setString(1, tModelKey.toString());
 
-      log.debug(
-        "delete from TMODEL_DOC_DESCR table:\n\n\t"
-          + deleteSQL
-          + "\n\t TMODEL_KEY="
-          + tModelKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "delete from " + tablePrefix + "TMODEL_DOC_DESCR table:\n\n\t"
+              + deleteSQL
+              + "\n\t TMODEL_KEY="
+              + tModelKey.toString()
+              + "\n");
+      }
 
       // execute
       statement.executeUpdate();

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelIdentifierTable.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelIdentifierTable.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelIdentifierTable.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelIdentifierTable.java Fri Oct  5 13:46:02 2007
@@ -23,6 +23,8 @@
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
 import org.apache.juddi.datatype.KeyedReference;
+import org.apache.juddi.registry.RegistryEngine;
+import org.apache.juddi.util.Config;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -35,14 +37,18 @@
   static String insertSQL = null;
   static String selectSQL = null;
   static String deleteSQL = null;
-
-  static {
+  static String tablePrefix = "";
+  
+  static
+  {
+   tablePrefix = Config.getStringProperty(
+       RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
     // buffer used to build SQL statements
     StringBuffer sql = null;
 
     // build insertSQL
     sql = new StringBuffer(150);
-    sql.append("INSERT INTO TMODEL_IDENTIFIER (");
+    sql.append("INSERT INTO ").append(tablePrefix).append("TMODEL_IDENTIFIER (");
     sql.append("TMODEL_KEY,");
     sql.append("IDENTIFIER_ID,");
     sql.append("TMODEL_KEY_REF,");
@@ -58,14 +64,14 @@
     sql.append("KEY_NAME,");
     sql.append("KEY_VALUE, ");
     sql.append("IDENTIFIER_ID ");
-    sql.append("FROM TMODEL_IDENTIFIER ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL_IDENTIFIER ");
     sql.append("WHERE TMODEL_KEY=? ");
     sql.append("ORDER BY IDENTIFIER_ID");
     selectSQL = sql.toString();
 
     // build deleteSQL
     sql = new StringBuffer(100);
-    sql.append("DELETE FROM TMODEL_IDENTIFIER ");
+    sql.append("DELETE FROM ").append(tablePrefix).append("TMODEL_IDENTIFIER ");
     sql.append("WHERE TMODEL_KEY=?");
     deleteSQL = sql.toString();
   }
@@ -108,20 +114,22 @@
         statement.setString(4, keyRef.getKeyName());
         statement.setString(5, keyRef.getKeyValue());
 
-        log.debug(
-          "insert into TMODEL_IDENTIFIER table:\n\n\t"
-            + insertSQL
-            + "\n\t BUSINESS_KEY="
-            + tModelKey.toString()
-            + "\n\t IDENTIFIER_ID="
-            + identifierID
-            + "\n\t TMODEL_KEY_REF="
-            + tModelKeyValue
-            + "\n\t KEY_NAME="
-            + keyRef.getKeyName()
-            + "\n\t KEY_VALUE="
-            + keyRef.getKeyValue()
-            + "\n");
+        if (log.isDebugEnabled()) {
+            log.debug(
+              "insert into " + tablePrefix + "TMODEL_IDENTIFIER table:\n\n\t"
+                + insertSQL
+                + "\n\t BUSINESS_KEY="
+                + tModelKey.toString()
+                + "\n\t IDENTIFIER_ID="
+                + identifierID
+                + "\n\t TMODEL_KEY_REF="
+                + tModelKeyValue
+                + "\n\t KEY_NAME="
+                + keyRef.getKeyName()
+                + "\n\t KEY_VALUE="
+                + keyRef.getKeyValue()
+                + "\n");
+        }
 
         // insert!
         statement.executeUpdate();
@@ -159,12 +167,14 @@
       statement = connection.prepareStatement(selectSQL);
       statement.setString(1, tModelKey.toString());
 
-      log.debug(
-        "select from TMODEL_IDENTIFIER table:\n\n\t"
-          + selectSQL
-          + "\n\t TMODEL_KEY="
-          + tModelKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "select from " + tablePrefix + "TMODEL_IDENTIFIER table:\n\n\t"
+              + selectSQL
+              + "\n\t TMODEL_KEY="
+              + tModelKey.toString()
+              + "\n");
+      }
 
       // execute the statement
       resultSet = statement.executeQuery();
@@ -211,12 +221,14 @@
       statement = connection.prepareStatement(deleteSQL);
       statement.setString(1, tModelKey.toString());
 
-      log.debug(
-        "delete from TMODEL_IDENTIFIER table:\n\n\t"
-          + deleteSQL
-          + "\n\t TMODEL_KEY="
-          + tModelKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "delete from " + tablePrefix + "TMODEL_IDENTIFIER table:\n\n\t"
+              + deleteSQL
+              + "\n\t TMODEL_KEY="
+              + tModelKey.toString()
+              + "\n");
+      }
 
       // execute
       statement.executeUpdate();

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoDescTable.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoDescTable.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoDescTable.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoDescTable.java Fri Oct  5 13:46:02 2007
@@ -23,6 +23,8 @@
 import org.apache.commons.logging.Log;
 import org.apache.commons.logging.LogFactory;
 import org.apache.juddi.datatype.Description;
+import org.apache.juddi.registry.RegistryEngine;
+import org.apache.juddi.util.Config;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -35,14 +37,18 @@
   static String insertSQL = null;
   static String selectSQL = null;
   static String deleteSQL = null;
-
-  static {
+  static String tablePrefix = "";
+  
+  static
+  {
+   tablePrefix = Config.getStringProperty(
+       RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
     // buffer used to build SQL statements
     StringBuffer sql = null;
 
     // build insertSQL
     sql = new StringBuffer(150);
-    sql.append("INSERT INTO TMODEL_INSTANCE_INFO_DESCR (");
+    sql.append("INSERT INTO ").append(tablePrefix).append("TMODEL_INSTANCE_INFO_DESCR (");
     sql.append("BINDING_KEY,");
     sql.append("TMODEL_INSTANCE_INFO_ID,");
     sql.append("TMODEL_INSTANCE_INFO_DESCR_ID,");
@@ -57,7 +63,7 @@
     sql.append("LANG_CODE,");
     sql.append("DESCR, ");
     sql.append("TMODEL_INSTANCE_INFO_DESCR_ID ");
-    sql.append("FROM TMODEL_INSTANCE_INFO_DESCR ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL_INSTANCE_INFO_DESCR ");
     sql.append("WHERE BINDING_KEY=? ");
     sql.append("AND TMODEL_INSTANCE_INFO_ID=? ");
     sql.append("ORDER BY TMODEL_INSTANCE_INFO_DESCR_ID");
@@ -65,7 +71,7 @@
 
     // build deleteSQL
     sql = new StringBuffer(100);
-    sql.append("DELETE FROM TMODEL_INSTANCE_INFO_DESCR ");
+    sql.append("DELETE FROM ").append(tablePrefix).append("TMODEL_INSTANCE_INFO_DESCR ");
     sql.append("WHERE BINDING_KEY=?");
     deleteSQL = sql.toString();
   }
@@ -106,20 +112,22 @@
         statement.setString(4, desc.getLanguageCode());
         statement.setString(5, desc.getValue());
 
-        log.debug(
-          "insert into TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
-            + insertSQL
-            + "\n\t BINDING_KEY="
-            + bindingKey.toString()
-            + "\n\t TMODEL_INSTANCE_INFO_ID="
-            + tModelInstanceInfoID
-            + "\n\t TMODEL_INSTANCE_INFO_DESCR_ID="
-            + descID
-            + "\n\t LANG_CODE="
-            + desc.getLanguageCode()
-            + "\n\t DESCR="
-            + desc.getValue()
-            + "\n");
+        if (log.isDebugEnabled()) {
+            log.debug(
+              "insert into " + tablePrefix + "TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
+                + insertSQL
+                + "\n\t BINDING_KEY="
+                + bindingKey.toString()
+                + "\n\t TMODEL_INSTANCE_INFO_ID="
+                + tModelInstanceInfoID
+                + "\n\t TMODEL_INSTANCE_INFO_DESCR_ID="
+                + descID
+                + "\n\t LANG_CODE="
+                + desc.getLanguageCode()
+                + "\n\t DESCR="
+                + desc.getValue()
+                + "\n");
+        }
 
         statement.executeUpdate();
       }
@@ -161,14 +169,16 @@
       statement.setString(1, bindingKey.toString());
       statement.setInt(2, tModelInstanceInfoID);
 
-      log.debug(
-        "select from TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
-          + selectSQL
-          + "\n\t BINDING_KEY="
-          + bindingKey.toString()
-          + "\n\t TMODEL_INSTANCE_INFO_ID="
-          + tModelInstanceInfoID
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "select from " + tablePrefix + "TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
+              + selectSQL
+              + "\n\t BINDING_KEY="
+              + bindingKey.toString()
+              + "\n\t TMODEL_INSTANCE_INFO_ID="
+              + tModelInstanceInfoID
+              + "\n");
+      }
 
       // execute the statement
       resultSet = statement.executeQuery();
@@ -214,12 +224,14 @@
       statement = connection.prepareStatement(deleteSQL);
       statement.setString(1, bindingKey.toString());
 
-      log.debug(
-        "delete from TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
-          + deleteSQL
-          + "\n\t BINDING_KEY="
-          + bindingKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "delete from " + tablePrefix + "TMODEL_INSTANCE_INFO_DESCR table:\n\n\t"
+              + deleteSQL
+              + "\n\t BINDING_KEY="
+              + bindingKey.toString()
+              + "\n");
+      }
 
       // execute
       statement.executeUpdate();

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoTable.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoTable.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoTable.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelInstanceInfoTable.java Fri Oct  5 13:46:02 2007
@@ -26,6 +26,8 @@
 import org.apache.juddi.datatype.binding.InstanceDetails;
 import org.apache.juddi.datatype.binding.InstanceParms;
 import org.apache.juddi.datatype.binding.TModelInstanceInfo;
+import org.apache.juddi.registry.RegistryEngine;
+import org.apache.juddi.util.Config;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -38,14 +40,18 @@
   static String insertSQL = null;
   static String selectSQL = null;
   static String deleteSQL = null;
-
-  static {
+  static String tablePrefix = "";
+  
+  static
+  {
+   tablePrefix = Config.getStringProperty(
+       RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
     // buffer used to build SQL statements
     StringBuffer sql = null;
 
     // build insertSQL
     sql = new StringBuffer(150);
-    sql.append("INSERT INTO TMODEL_INSTANCE_INFO (");
+    sql.append("INSERT INTO ").append(tablePrefix).append("TMODEL_INSTANCE_INFO (");
     sql.append("BINDING_KEY,");
     sql.append("TMODEL_INSTANCE_INFO_ID,");
     sql.append("TMODEL_KEY, ");
@@ -61,14 +67,14 @@
     sql.append("OVERVIEW_URL,");
     sql.append("INSTANCE_PARMS, ");
     sql.append("TMODEL_INSTANCE_INFO_ID ");
-    sql.append("FROM TMODEL_INSTANCE_INFO ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL_INSTANCE_INFO ");
     sql.append("WHERE BINDING_KEY=? ");
     sql.append("ORDER BY TMODEL_INSTANCE_INFO_ID");
     selectSQL = sql.toString();
 
     // build deleteSQL
     sql = new StringBuffer(100);
-    sql.append("DELETE FROM TMODEL_INSTANCE_INFO ");
+    sql.append("DELETE FROM ").append(tablePrefix).append("TMODEL_INSTANCE_INFO ");
     sql.append("WHERE BINDING_KEY=?");
     deleteSQL = sql.toString();
   }
@@ -124,21 +130,23 @@
         statement.setString(3, tModelKey);
         statement.setString(4, overURL);
         statement.setString(5, instParms);
-
-        log.debug(
-          "insert into TMODEL_INSTANCE_INFO table:\n\n\t"
-            + insertSQL
-            + "\n\t BINDING_KEY="
-            + bindingKey.toString()
-            + "\n\t TMODEL_INSTANCE_INFO_ID="
-            + infoID
-            + "\n\t TMODEL_KEY="
-            + tModelKey
-            + "\n\t OVERVIEW_URL="
-            + overURL
-            + "\n\t INSTANCE_PARMS="
-            + instParms
-            + "\n");
+        
+        if (log.isDebugEnabled()) {
+            log.debug(
+              "insert into " + tablePrefix + "TMODEL_INSTANCE_INFO table:\n\n\t"
+                + insertSQL
+                + "\n\t BINDING_KEY="
+                + bindingKey.toString()
+                + "\n\t TMODEL_INSTANCE_INFO_ID="
+                + infoID
+                + "\n\t TMODEL_KEY="
+                + tModelKey
+                + "\n\t OVERVIEW_URL="
+                + overURL
+                + "\n\t INSTANCE_PARMS="
+                + instParms
+                + "\n");
+        }
 
         statement.executeUpdate();
       }
@@ -175,12 +183,14 @@
       statement = connection.prepareStatement(selectSQL);
       statement.setString(1, bindingKey.toString());
 
-      log.debug(
-        "select from TMODEL_INSTANCE_INFO table:\n\n\t"
-          + selectSQL
-          + "\n\t BINDING_KEY="
-          + bindingKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "select from " + tablePrefix + "TMODEL_INSTANCE_INFO table:\n\n\t"
+              + selectSQL
+              + "\n\t BINDING_KEY="
+              + bindingKey.toString()
+              + "\n");
+      }
 
       // execute the statement
       resultSet = statement.executeQuery();
@@ -257,12 +267,14 @@
       statement = connection.prepareStatement(deleteSQL);
       statement.setString(1, bindingKey.toString());
 
-      log.debug(
-        "delete from TMODEL_INSTANCE_INFO table:\n\n\t"
-          + deleteSQL
-          + "\n\t BINDING_KEY="
-          + bindingKey.toString()
-          + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(
+            "delete from " + tablePrefix + "TMODEL_INSTANCE_INFO table:\n\n\t"
+              + deleteSQL
+              + "\n\t BINDING_KEY="
+              + bindingKey.toString()
+              + "\n");
+      }
 
       // execute
       statement.executeUpdate();

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelTable.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelTable.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelTable.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/datastore/jdbc/TModelTable.java Fri Oct  5 13:46:02 2007
@@ -26,6 +26,8 @@
 import org.apache.juddi.datatype.Name;
 import org.apache.juddi.datatype.OverviewDoc;
 import org.apache.juddi.datatype.tmodel.TModel;
+import org.apache.juddi.registry.RegistryEngine;
+import org.apache.juddi.util.Config;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -41,15 +43,18 @@
   static String selectSQL = null;
   static String selectByPublisherSQL = null;
   static String verifyOwnershipSQL = null;
-
+  static String tablePrefix = "";
+  
   static
   {
+   tablePrefix = Config.getStringProperty(
+       RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
     // buffer used to build SQL statements
     StringBuffer sql = null;
 
     // build insertSQL
     sql = new StringBuffer(150);
-    sql.append("INSERT INTO TMODEL (");
+    sql.append("INSERT INTO ").append(tablePrefix).append("TMODEL (");
     sql.append("TMODEL_KEY,");
     sql.append("AUTHORIZED_NAME,");
     sql.append("PUBLISHER_ID,");
@@ -63,13 +68,13 @@
 
     // build deleteSQL
     sql = new StringBuffer(100);
-    sql.append("DELETE FROM TMODEL ");
+    sql.append("DELETE FROM ").append(tablePrefix).append("TMODEL ");
     sql.append("WHERE TMODEL_KEY=?");
     deleteSQL = sql.toString();
 
     // build updateSQL
     sql = new StringBuffer(100);
-    sql.append("UPDATE TMODEL ");
+    sql.append("UPDATE ").append(tablePrefix).append("TMODEL ");
     sql.append("SET DELETED='true' ");
     sql.append("WHERE TMODEL_KEY=?");
     updateSQL = sql.toString();
@@ -83,7 +88,7 @@
     sql.append("LANG_CODE,");
     sql.append("OVERVIEW_URL,");
     sql.append("DELETED ");
-    sql.append("FROM TMODEL ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL ");
     sql.append("WHERE TMODEL_KEY=? ");
     sql.append("AND DELETED IS NULL");
     selectSQL = sql.toString();
@@ -93,7 +98,7 @@
     sql.append("SELECT ");
     sql.append("TMODEL_KEY,");
     sql.append("DELETED ");
-    sql.append("FROM TMODEL ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL ");
     sql.append("WHERE PUBLISHER_ID=? ");
     sql.append("AND DELETED IS NULL");
     selectByPublisherSQL = sql.toString();
@@ -101,7 +106,7 @@
     // build verifyOwnershipSQL
     sql = new StringBuffer(200);
     sql.append("SELECT * ");
-    sql.append("FROM TMODEL ");
+    sql.append("FROM ").append(tablePrefix).append("TMODEL ");
     sql.append("WHERE TMODEL_KEY=? ");
     sql.append("AND PUBLISHER_ID=? " );
     sql.append("AND DELETED IS NULL");
@@ -138,15 +143,17 @@
       statement.setString(7,overviewURL);
       statement.setTimestamp(8,timeStamp);
 
-      log.debug(insertSQL +
-        "\n\t TMODEL_KEY=" + tModel.getTModelKey().toString() +
-        "\n\t AUTHORIZED_NAME=" + tModel.getAuthorizedName() +
-        "\n\t PUBLISHER_ID=" + publisherID +
-        "\n\t OPERATOR=" + tModel.getOperator() +
-        "\n\t NAME=" + tModel.getName().getValue() +
-        "\n\t LANG_CODE=" + tModel.getName().getLanguageCode() +
-        "\n\t OVERVIEW_URL=" + overviewURL +
-        "\n\t LAST_UPDATE=" + timeStamp.getTime() + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(insertSQL +
+            "\n\t TMODEL_KEY=" + tModel.getTModelKey().toString() +
+            "\n\t AUTHORIZED_NAME=" + tModel.getAuthorizedName() +
+            "\n\t PUBLISHER_ID=" + publisherID +
+            "\n\t OPERATOR=" + tModel.getOperator() +
+            "\n\t NAME=" + tModel.getName().getValue() +
+            "\n\t LANG_CODE=" + tModel.getName().getLanguageCode() +
+            "\n\t OVERVIEW_URL=" + overviewURL +
+            "\n\t LAST_UPDATE=" + timeStamp.getTime() + "\n");
+      }
 
       // insert
       statement.executeUpdate();
@@ -178,8 +185,10 @@
       statement = connection.prepareStatement(deleteSQL);
       statement.setString(1,tModelKey.toString());
 
-      log.debug(deleteSQL +
-        "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(deleteSQL +
+            "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      }
 
       // execute
       statement.executeUpdate();
@@ -211,8 +220,10 @@
       statement = connection.prepareStatement(updateSQL);
       statement.setString(1,tModelKey.toString());
 
-      log.debug(updateSQL +
-        "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(updateSQL +
+            "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      }
 
       // execute
       statement.executeUpdate();
@@ -245,8 +256,10 @@
       statement = connection.prepareStatement(selectSQL);
       statement.setString(1,tModelKey.toString());
 
-      log.debug(selectSQL +
-        "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(selectSQL +
+            "\n\t TMODEL_KEY=" + tModelKey.toString() + "\n");
+      }
 
       resultSet = statement.executeQuery();
       if (resultSet.next())
@@ -300,8 +313,10 @@
       statement = connection.prepareStatement(selectByPublisherSQL);
       statement.setString(1,publisherID.toString());
 
-      log.debug(selectByPublisherSQL +
-        "\n\t PUBLISHER_ID=" + publisherID + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(selectByPublisherSQL +
+            "\n\t PUBLISHER_ID=" + publisherID + "\n");
+      }
 
       // execute the statement
       resultSet = statement.executeQuery();
@@ -345,9 +360,11 @@
       statement.setString(1,tModelKey);
       statement.setString(2,publisherID);
 
-      log.debug(verifyOwnershipSQL +
-        "\n\t TMODEL_KEY=" + tModelKey +
-        "\n\t PUBLISHER_ID=" + publisherID + "\n");
+      if (log.isDebugEnabled()) {
+          log.debug(verifyOwnershipSQL +
+            "\n\t TMODEL_KEY=" + tModelKey +
+            "\n\t PUBLISHER_ID=" + publisherID + "\n");
+      }
 
       resultSet = statement.executeQuery();
       if (resultSet.next())

Modified: webservices/juddi/trunk/src/main/java/org/apache/juddi/registry/RegistryEngine.java
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/java/org/apache/juddi/registry/RegistryEngine.java?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/java/org/apache/juddi/registry/RegistryEngine.java (original)
+++ webservices/juddi/trunk/src/main/java/org/apache/juddi/registry/RegistryEngine.java Fri Oct  5 13:46:02 2007
@@ -36,7 +36,6 @@
 import org.apache.juddi.util.Config;
 import org.apache.juddi.util.Loader;
 import org.apache.juddi.util.jdbc.ConnectionManager;
-import org.apache.log4j.lf5.util.StreamUtils;
 
 /**
  * @author Steve Viens (sviens@apache.org)
@@ -65,6 +64,7 @@
   public static final String PROPNAME_IS_CREATE_DATABASE = "juddi.isCreateDatabase";
   public static final String PROPNAME_DB_EXISTS_SQL = "juddi.databaseExistsSql";
   public static final String PROPNAME_SQL_FILES = "juddi.sqlFiles";
+  public static final String PROPNAME_TABLE_PREFIX = "juddi.tablePrefix";
   
   public static final String PROPNAME_JAVA_NAMING_FACTORY_INITIAL = "java.naming.factory.initial";
   public static final String PROPNAME_JAVA_NAMING_PROVIDER_URL = "java.naming.provider.url";
@@ -102,9 +102,10 @@
   public static final String DEFAULT_JDBC_URL = "jdbc:mysql://localhost/juddi";
   public static final String DEFAULT_JDBC_USERNAME = "juddi";
   public static final String DEFAULT_JDBC_PASSWORD = "juddi";
-  public static final Boolean DEFAULT_IS_CREATE_DATABASE = Boolean.TRUE;
+  public static final Boolean DEFAULT_IS_CREATE_DATABASE = Boolean.FALSE;
   public static final String DEFAULT_DB_EXISTS_SQL = "select * from BUSINESS_ENTITY";
   public static final String DEFAULT_SQL_FILES = "sql/derby/create_database.sql,sql/insert_publishers.sql";
+  public static final String DEFAULT_TABLE_PREFIX = "";
   
   public static final String DEFAULT_AUTH_CLASS_NAME = "org.apache.juddi.auth.DefaultAuthenticator";
   public static final String DEFAULT_DATASTORE_CLASS_NAME = "org.apache.juddi.datastore.jdbc.JDBCDataStore";
@@ -241,6 +242,9 @@
               RegistryEngine.PROPNAME_DB_EXISTS_SQL,RegistryEngine.DEFAULT_DB_EXISTS_SQL);
       String sqlFiles = Config.getStringProperty(
               RegistryEngine.PROPNAME_SQL_FILES,RegistryEngine.DEFAULT_SQL_FILES);
+      String tablePrefix = Config.getStringProperty(
+              RegistryEngine.PROPNAME_TABLE_PREFIX,RegistryEngine.DEFAULT_TABLE_PREFIX);
+      
       try {
           Connection conn = ConnectionManager.acquireConnection();
           boolean create = false;
@@ -248,7 +252,8 @@
           Statement st = conn.createStatement();
           ResultSet rs = null;
           try {
-             rs = st.executeQuery(dbExistsSql.trim());
+             dbExistsSql = dbExistsSql.trim().replaceAll("\\$\\{prefix}", tablePrefix);
+             rs = st.executeQuery(dbExistsSql);
              rs.close();
           } catch (SQLException e) {
              create = true;
@@ -261,23 +266,23 @@
           log.info("Initializing jUDDI database from listed sql files");
           String[] list = sqlFiles.split(",");
           for (int i=0; i<list.length; i++) {
-             executeSql(list[i].trim(), conn);
+             executeSql(list[i].trim(), conn, tablePrefix);
           }
       } catch (Exception e) {
           log.error("Could not create jUDDI database " + e.getMessage(), e);
       }
   }
   
-  public void executeSql(String resource, Connection conn) throws Exception 
-  {
+  public void executeSql(String resource, Connection conn, String tablePrefix) throws Exception 
+  { 
         InputStream is = Loader.getResourceAsStream(resource);
         if (is == null) {
             log.debug("Trying the classloader of the class itself. (workaround for maven2)");
             Loader loader = new Loader();
             is = loader.getResourceAsStreamFromClass(resource);
         }
-        byte[] bytes = StreamUtils.getBytes(is);
-        String sql = new String(bytes, "UTF-8");
+        String sql = getString(is);
+        sql = sql.replaceAll("\\$\\{prefix}", tablePrefix);
         is.close();
         String[] statements = sql.split(";");
         for (int i=0; i<statements.length;i++) {
@@ -298,6 +303,16 @@
             }
         }
     }
+  
+  public static String getString(InputStream in) throws IOException {
+      StringBuffer out = new StringBuffer();
+      byte[] b = new byte[4096];
+      for (int n; (n = in.read(b)) != -1;) {
+          out.append(new String(b, 0, n));
+      }
+      return out.toString();
+  }
+
 
   
 

Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
--- webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql (original)
+++ webservices/juddi/trunk/src/main/resources/juddi-sql/daffodildb/create_database.sql Fri Oct  5 13:46:02 2007
@@ -1,7 +1,7 @@
 /* Create database  */
 CREATE DATABASE juddi user daffodil password daffodil
 
-CREATE TABLE BUSINESS_ENTITY
+CREATE TABLE ${prefix}BUSINESS_ENTITY
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
@@ -11,7 +11,7 @@
   PRIMARY KEY (BUSINESS_KEY)
 )
 
-CREATE TABLE BUSINESS_DESCR
+CREATE TABLE ${prefix}BUSINESS_DESCR
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   BUSINESS_DESCR_ID INT NOT NULL,
@@ -19,10 +19,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,BUSINESS_DESCR_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE BUSINESS_CATEGORY
+CREATE TABLE ${prefix}BUSINESS_CATEGORY
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CATEGORY_ID INT NOT NULL,
@@ -31,12 +31,12 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,CATEGORY_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
 
 
-CREATE TABLE BUSINESS_IDENTIFIER
+CREATE TABLE ${prefix}BUSINESS_IDENTIFIER
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   IDENTIFIER_ID INT NOT NULL,
@@ -45,10 +45,10 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,IDENTIFIER_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE BUSINESS_NAME
+CREATE TABLE ${prefix}BUSINESS_NAME
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   BUSINESS_NAME_ID INT NOT NULL,
@@ -56,10 +56,10 @@
   NAME VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,BUSINESS_NAME_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE CONTACT
+CREATE TABLE ${prefix}CONTACT
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -67,10 +67,10 @@
   PERSON_NAME VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE CONTACT_DESCR
+CREATE TABLE ${prefix}CONTACT_DESCR
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -79,10 +79,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,CONTACT_DESCR_ID),
   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
+    REFERENCES ${prefix}CONTACT (BUSINESS_KEY,CONTACT_ID)
 )
 
-CREATE TABLE ADDRESS
+CREATE TABLE ${prefix}ADDRESS
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -92,10 +92,10 @@
   TMODEL_KEY VARCHAR(41) ,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID),
   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
+    REFERENCES ${prefix}CONTACT (BUSINESS_KEY,CONTACT_ID)
 )
 
-CREATE TABLE ADDRESS_LINE
+CREATE TABLE ${prefix}ADDRESS_LINE
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -106,10 +106,10 @@
   KEY_VALUE VARCHAR(255) ,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID,ADDRESS_LINE_ID),
   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
-    REFERENCES ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
+    REFERENCES ${prefix}ADDRESS (BUSINESS_KEY,CONTACT_ID,ADDRESS_ID)
 )
 
-CREATE TABLE EMAIL
+CREATE TABLE ${prefix}EMAIL
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -118,10 +118,10 @@
   EMAIL_ADDRESS VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,EMAIL_ID),
   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
+    REFERENCES ${prefix}CONTACT (BUSINESS_KEY,CONTACT_ID)
 )
 
-CREATE TABLE PHONE
+CREATE TABLE ${prefix}PHONE
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   CONTACT_ID INT NOT NULL,
@@ -130,10 +130,10 @@
   PHONE_NUMBER VARCHAR(50) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,CONTACT_ID,PHONE_ID),
   FOREIGN KEY (BUSINESS_KEY,CONTACT_ID)
-    REFERENCES CONTACT (BUSINESS_KEY,CONTACT_ID)
+    REFERENCES ${prefix}CONTACT (BUSINESS_KEY,CONTACT_ID)
 )
 
-CREATE TABLE DISCOVERY_URL
+CREATE TABLE ${prefix}DISCOVERY_URL
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   DISCOVERY_URL_ID INT NOT NULL,
@@ -141,20 +141,20 @@
   URL VARCHAR(255) NOT NULL,
   PRIMARY KEY (BUSINESS_KEY,DISCOVERY_URL_ID),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE BUSINESS_SERVICE
+CREATE TABLE ${prefix}BUSINESS_SERVICE
 (
   BUSINESS_KEY VARCHAR(41) NOT NULL,
   SERVICE_KEY VARCHAR(41) NOT NULL,
   LAST_UPDATE TIMESTAMP NOT NULL,
   PRIMARY KEY (SERVICE_KEY),
   FOREIGN KEY (BUSINESS_KEY)
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY)
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY)
 )
 
-CREATE TABLE SERVICE_DESCR
+CREATE TABLE ${prefix}SERVICE_DESCR
 (
   SERVICE_KEY VARCHAR(41) NOT NULL,
   SERVICE_DESCR_ID INT NOT NULL,
@@ -162,10 +162,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (SERVICE_KEY,SERVICE_DESCR_ID),
   FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
+    REFERENCES ${prefix}BUSINESS_SERVICE (SERVICE_KEY)
 )
 
-CREATE TABLE SERVICE_CATEGORY
+CREATE TABLE ${prefix}SERVICE_CATEGORY
 (
   SERVICE_KEY VARCHAR(41) NOT NULL,
   CATEGORY_ID INT NOT NULL,
@@ -174,10 +174,10 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (SERVICE_KEY,CATEGORY_ID),
   FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
+    REFERENCES ${prefix}BUSINESS_SERVICE (SERVICE_KEY)
 )
 
-CREATE TABLE SERVICE_NAME
+CREATE TABLE ${prefix}SERVICE_NAME
 (
   SERVICE_KEY VARCHAR(41) NOT NULL,
   SERVICE_NAME_ID INT NOT NULL,
@@ -185,10 +185,10 @@
   NAME VARCHAR(255) NOT NULL,
   PRIMARY KEY (SERVICE_KEY,SERVICE_NAME_ID),
   FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
+    REFERENCES ${prefix}BUSINESS_SERVICE (SERVICE_KEY)
 )
 
-CREATE TABLE BINDING_TEMPLATE
+CREATE TABLE ${prefix}BINDING_TEMPLATE
 (
   SERVICE_KEY VARCHAR(41) NOT NULL,
   BINDING_KEY VARCHAR(41) NOT NULL,
@@ -198,10 +198,10 @@
   LAST_UPDATE TIMESTAMP NOT NULL,
   PRIMARY KEY (BINDING_KEY),
   FOREIGN KEY (SERVICE_KEY)
-    REFERENCES BUSINESS_SERVICE (SERVICE_KEY)
+    REFERENCES ${prefix}BUSINESS_SERVICE (SERVICE_KEY)
 )
 
-CREATE TABLE BINDING_CATEGORY
+CREATE TABLE ${prefix}BINDING_CATEGORY
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   CATEGORY_ID INT NOT NULL,
@@ -210,10 +210,10 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (BINDING_KEY,CATEGORY_ID),
   FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
+    REFERENCES ${prefix}BINDING_TEMPLATE (BINDING_KEY)
 )
 
-CREATE TABLE BINDING_DESCR
+CREATE TABLE ${prefix}BINDING_DESCR
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   BINDING_DESCR_ID INT NOT NULL,
@@ -221,10 +221,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BINDING_KEY,BINDING_DESCR_ID),
   FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
+    REFERENCES ${prefix}BINDING_TEMPLATE (BINDING_KEY)
 )
 
-CREATE TABLE TMODEL_INSTANCE_INFO
+CREATE TABLE ${prefix}TMODEL_INSTANCE_INFO
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
@@ -233,10 +233,10 @@
   INSTANCE_PARMS VARCHAR(255) ,
   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID),
   FOREIGN KEY (BINDING_KEY)
-    REFERENCES BINDING_TEMPLATE (BINDING_KEY)
+    REFERENCES ${prefix}BINDING_TEMPLATE (BINDING_KEY)
 )
 
-CREATE TABLE TMODEL_INSTANCE_INFO_DESCR
+CREATE TABLE ${prefix}TMODEL_INSTANCE_INFO_DESCR
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
@@ -245,10 +245,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,TMODEL_INSTANCE_INFO_DESCR_ID),
   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
+    REFERENCES ${prefix}TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
 )
 
-CREATE TABLE INSTANCE_DETAILS_DESCR
+CREATE TABLE ${prefix}INSTANCE_DETAILS_DESCR
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
@@ -257,10 +257,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DESCR_ID),
   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
+    REFERENCES ${prefix}TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
 )
 
-CREATE TABLE INSTANCE_DETAILS_DOC_DESCR
+CREATE TABLE ${prefix}INSTANCE_DETAILS_DOC_DESCR
 (
   BINDING_KEY VARCHAR(41) NOT NULL,
   TMODEL_INSTANCE_INFO_ID INT NOT NULL,
@@ -269,10 +269,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID,INSTANCE_DETAILS_DOC_DESCR_ID),
   FOREIGN KEY (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
-    REFERENCES TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
+    REFERENCES ${prefix}TMODEL_INSTANCE_INFO (BINDING_KEY,TMODEL_INSTANCE_INFO_ID)
 )
 
-CREATE TABLE TMODEL
+CREATE TABLE ${prefix}TMODEL
 (
   TMODEL_KEY VARCHAR(41) NOT NULL,
   AUTHORIZED_NAME VARCHAR(255) NOT NULL,
@@ -286,7 +286,7 @@
   PRIMARY KEY (TMODEL_KEY)
 )
 
-CREATE TABLE TMODEL_DESCR
+CREATE TABLE ${prefix}TMODEL_DESCR
 (
   TMODEL_KEY VARCHAR(41) NOT NULL,
   TMODEL_DESCR_ID INT NOT NULL,
@@ -294,10 +294,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (TMODEL_KEY,TMODEL_DESCR_ID),
   FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
+    REFERENCES ${prefix}TMODEL (TMODEL_KEY)
 )
 
-CREATE TABLE TMODEL_CATEGORY
+CREATE TABLE ${prefix}TMODEL_CATEGORY
 (
   TMODEL_KEY VARCHAR(41) NOT NULL,
   CATEGORY_ID INT NOT NULL,
@@ -306,10 +306,10 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (TMODEL_KEY,CATEGORY_ID),
   FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
+    REFERENCES ${prefix}TMODEL (TMODEL_KEY)
 )
 
-CREATE TABLE TMODEL_IDENTIFIER
+CREATE TABLE ${prefix}TMODEL_IDENTIFIER
 (
   TMODEL_KEY VARCHAR(41) NOT NULL,
   IDENTIFIER_ID INT NOT NULL,
@@ -318,10 +318,10 @@
   KEY_VALUE VARCHAR(255) NOT NULL,
   PRIMARY KEY (TMODEL_KEY,IDENTIFIER_ID),
   FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
+    REFERENCES ${prefix}TMODEL (TMODEL_KEY)
 )
 
-CREATE TABLE TMODEL_DOC_DESCR
+CREATE TABLE ${prefix}TMODEL_DOC_DESCR
 (
   TMODEL_KEY VARCHAR(41) NOT NULL,
   TMODEL_DOC_DESCR_ID INT NOT NULL,
@@ -329,10 +329,10 @@
   DESCR VARCHAR(255) NOT NULL,
   PRIMARY KEY (TMODEL_KEY,TMODEL_DOC_DESCR_ID),
   FOREIGN KEY (TMODEL_KEY)
-    REFERENCES TMODEL (TMODEL_KEY)
+    REFERENCES ${prefix}TMODEL (TMODEL_KEY)
 )
 
-CREATE TABLE PUBLISHER_ASSERTION
+CREATE TABLE ${prefix}PUBLISHER_ASSERTION
 (
   FROM_KEY VARCHAR(41) NOT NULL,
   TO_KEY VARCHAR(41) NOT NULL,
@@ -342,12 +342,12 @@
   FROM_CHECK VARCHAR(5) NOT NULL,
   TO_CHECK VARCHAR(5) NOT NULL,
   FOREIGN KEY (FROM_KEY) 
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY),
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY),
   FOREIGN KEY (TO_KEY) 
-    REFERENCES BUSINESS_ENTITY (BUSINESS_KEY) 
+    REFERENCES ${prefix}BUSINESS_ENTITY (BUSINESS_KEY) 
 )
 
-CREATE TABLE PUBLISHER
+CREATE TABLE ${prefix}PUBLISHER
 (
   PUBLISHER_ID VARCHAR(20) NOT NULL,
   PUBLISHER_NAME VARCHAR(255) NOT NULL,
@@ -361,7 +361,7 @@
   PRIMARY KEY (PUBLISHER_ID)
 )
 
-CREATE TABLE AUTH_TOKEN
+CREATE TABLE ${prefix}AUTH_TOKEN
 (
   AUTH_TOKEN VARCHAR(51) NOT NULL,
   PUBLISHER_ID VARCHAR(20) NOT NULL,
@@ -373,327 +373,327 @@
   PRIMARY KEY (AUTH_TOKEN)
 )
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','Administrator','admin','jUDDI.org','uddi-org:types','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UDDItypes',CURTIMESTAMP())
 
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','UDDI Type Taxonomy')
  
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'en','Taxonomy used to categorize Service Descriptions.')
  
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
  
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384','Administrator','admin','jUDDI.org','unspsc-org:unspsc:3-1','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC31',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','Product Taxonomy: UNSPSC (Version 3.1)')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'en','This tModel defines the UNSPSC product taxonomy.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:DB77450D-9FA8-45D4-A7BC-04411D14E384',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634','Administrator','admin','jUDDI.org','unspsc-org:unspsc','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#UNSPSC',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','Product Taxonomy: UNSPSC (Version 7.3)')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'en','This tModel defines Version 7.3 of the UNSPSC product taxonomy.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:CD153257-086A-4237-B336-6BDCBDCC6634',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','Checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2','Administrator','admin','jUDDI.org','ntis-gov:naics:1997','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#NAICS',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','Business Taxonomy: NAICS(1997 Release)')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'en','This tModel defines the NAICS industry taxonomy.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:C0B9FE13-179F-413D-8A5B-5004DB8E5BB2',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88','Administrator','admin','jUDDI.org','uddi-org:iso-ch:3166-1999','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#ISO3166',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','ISO 3166-1:1997 and 3166-2:1998. Codes for names of countries and their subdivisions. Part 1: Country codes. Part 2:Country subdivision codes. Update newsletters include ISO 3166-1 V-1 (1998-02-05), V-2 (1999-10-01), ISO 3166-2 I-1 (1998)')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'en','Taxonomy used to categorize entries by geographic location.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4E49A8D6-D5A2-4FC2-93A0-0411D8D19E88',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4','Administrator','admin','jUDDI.org','uddi-org:general_keywords','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#GenKW',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','Special taxonomy consisting of namespace identifiers and the keywords associated with the namespaces')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'en','This tModel defines an unidentified taxonomy.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:A035A07C-F362-44DD-8F95-E2B134BF43B4',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9','Administrator','admin','jUDDI.org','uddi-org:owningBusiness','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#owningBusiness',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','A pointer to a businessEntity that owns the tagged data.')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'en','This tModel indicates the businessEntity that published or owns the tagged tModel. Used with tModels to establish an "owned" relationship with a registered businessEntity.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4064C064-6D14-4F35-8953-9652106476A9',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03','Administrator','admin','jUDDI.org','uddi-org:relationships','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Relationships',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','Starter set classifications of businessEntity relationships')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'en','This tModel is used to describe business relationships. Used in the publisher assertion messages.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:807A2C6A-EE22-470D-ADC7-E0424A337C03',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','relationship')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55','Administrator','admin','jUDDI.org','uddi-org:operators','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Operators',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','Taxonomy for categorizing the businessEntity of an operator of a registry.')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'en','This checked value set is used to identify UDDI operators.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','categorization')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:327A56F0-3299-4461-BC23-5CD513E95C55',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E','Administrator','admin','jUDDI.org','uddi-org:isReplacedBy','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#IsReplacedBy',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','An identifier system used to point (using UDDI keys) to the tModel (or businessEntity) that is the logical replacement for the one in which isReplacedBy is used')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'en','This is a checked value set.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:E59AE320-77A5-11D5-B898-0004AC49CC1E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','checked')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823','Administrator','admin','jUDDI.org','dnb-com:D-U-N-S','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#D-U-N-S',SYSDATE)
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','Dun chr(38) Bradstreet D-U-N-S® Number')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'en','This tModel is used for the Dun chr(38) Bradstreet D-U-N-S® Number identifier.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:8609C81E-EE1F-4D5A-B202-3EB13AD01823',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier')
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039','Administrator','admin','jUDDI.org','thomasregister-com:supplierID','http://www.uddi.org/taxonomies/UDDI_Taxonomy_tModels.htm#Thomas',CURTIMESTAMP())
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','Thomas Registry Suppliers')
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'en','This tModel is used for the Thomas Register supplier identifier codes.')
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:B1B1BAF5-2329-43E6-AE13-BA8E97195039',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','identifier')
  
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457','Administrator','admin','jUDDI.org','uddi-org:wsdl:types','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#wsdlTypes',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','WSDL Type Category System');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'en','The WSDL Entity Type tModel uses a number of UDDI entities to represent the various entities within a WSDL document.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:6E090AFA-33E5-36EB-81B7-1CA18373F457',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824','Administrator','admin','jUDDI.org','uddi-org:xml:namespace','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlNamespace',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A category system used to indicate namespaces');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'en','A namespace provides necessary qualifying information about a technical concept or model. The XML Namespace tModel provides a mechanism to associate a namespace with a UDDI entity.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:D01987D1-AB2E-3013-9BE2-2A66EB99D824',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6','Administrator','admin','jUDDI.org','uddi-org:xml:localName','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#xmlLocalName',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','A category system used to indicate XML local names');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'en','The XML Local Name tModel provides a mechanism to indicate the name attribute for the uddi:businessService.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','unchecked');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:2EC65201-9109-3919-9BEC-C9DBEFCACCF6',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E','Administrator','admin','jUDDI.org','uddi-org:wsdl:portTypeReference','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#portTypeReference',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','A category system used to reference a wsdl:portType tModel');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'en','The WSDL portType Reference category system provides a mechanism to indicate that a UDDI entity has a relationship with a certain wsdl:portType tModel.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:082B0851-25D8-303C-B332-F24A6D53E38E',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E','Administrator','admin','jUDDI.org','uddi-org:protocol:soap','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#soap',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','A tModel that represents the SOAP 1.1 protocol');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'en','The SOAP Protocol tModel can be used to indicate that a Web service supports the SOAP 1.1 protocol.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:AA254698-93DE-3870-8DF3-A5C075D64A0E',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794','Administrator','admin','jUDDI.org','uddi-org:protocol:http','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#http',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','A tModel that represents the HTTP protocol');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'en','The HTTP Protocol tModel can be used to indicate that a Web service supports the HTTP protocol.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:6E10B91B-BABC-3442-B8FC-5A3C8FDE0794',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','protocol');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:protocol','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#protocol',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','Category system used to describe the protocol supported by a wsdl:binding.');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'en','The Protocol Categorization tModel provides a mechanism to capture this protocol information in the UDDI binding tModel.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:4DC74177-7806-34D9-AECD-33C57DC3A865',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099','Administrator','admin','jUDDI.org','uddi-org:wsdl:categorization:transport','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#transport',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','Category system used to describe the transport supported by a wsdl:binding.');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'en','The Transport Categorization tModel provides a mechanism to capture transport information in the UDDI binding tModel which allows a user to search for bindings that implement a specific transport protocol.');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','categorization');
 
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:E5C43936-86E4-37BF-8196-1D04B35C0099',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','uddi-org:types','checked');
 
 
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212','Administrator','admin','jUDDI.org','uddi-org:wsdl:address','http://www.oasis-open.org/committees/uddi-spec/doc/tn/uddi-spec-tc-tn-wsdl-v2.htm#Address',CURTIMESTAMP());
 
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','A tModel used to indicate the WSDL address option.');
 
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AD61DE98-4DB8-31B2-A299-A2373DC97212',0,'en','The WSDL Address tModel provides A mechanism to indicate that the endpoint address should be obtained from a WSDL document.');
 
 -- ** http transport **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36','Administrator','admin','jUDDI.org','uddi-org:http','http://www.uddi.org/taxonomies/UDDI_CoreOther_tModels.htm#overHTTP',CURTIMESTAMP());
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'en','An HTTP or web browser-based web service');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:68DE9E80-AD09-469D-8A37-088422BFBC36',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','tModelType','transport');
 
 -- ** uddi inquiry **
-INSERT INTO TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
+INSERT INTO ${prefix}TMODEL (TMODEL_KEY,AUTHORIZED_NAME,PUBLISHER_ID,OPERATOR,NAME,OVERVIEW_URL,LAST_UPDATE)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B','Administrator','admin','jUDDI.org','uddi-org:inquiry_v2','http://www.uddi.org/wsdl/inquire_v2.wsdl',CURTIMESTAMP());
-INSERT INTO TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DESCR (TMODEL_KEY,TMODEL_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','UDDI Inquiry API Version 2 - Core Specification');
-INSERT INTO TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
+INSERT INTO ${prefix}TMODEL_DOC_DESCR (TMODEL_KEY,TMODEL_DOC_DESCR_ID,LANG_CODE,DESCR)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'en','This tModel defines the inquiry API calls for interacting with a V2 UDDI node.');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',0,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','specification');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',1,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','xmlSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',2,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','soapSpec');
-INSERT INTO TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
+INSERT INTO ${prefix}TMODEL_CATEGORY (TMODEL_KEY,CATEGORY_ID,TMODEL_KEY_REF,KEY_NAME,KEY_VALUE)
 VALUES ('uuid:AC104DCC-D623-452F-88A7-F8ACD94D9B2B',3,'uuid:C1ACF26D-9672-4404-9D70-39B756E62AB4','types','wsdlSpec');
 
 

Modified: webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql
URL: http://svn.apache.org/viewvc/webservices/juddi/trunk/src/main/resources/juddi-sql/db2/create_database.sql?rev=582383&r1=582382&r2=582383&view=diff
==============================================================================
Binary files - no diff available.



---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-cvs-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-cvs-help@ws.apache.org