Author: cmailleux
Date: Thu Jul 12 17:20:52 2007
New Revision: 17970

URL: https://svndev.jahia.net/websvn/listing.php?sc=3D1&rev=3D17970&repname=
=3Djahia
Log:
Port of commit [17214] [17215] Missing DB for URLKeys

Added:
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema=
-index.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/hypersonic/jahia-schema-index.sql
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-inde=
x.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/mssql/jahia-schema-index.sql
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-i=
ndex.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/mysql-tx/jahia-schema-index.sql
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-inde=
x.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/mysql/jahia-schema-index.sql
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-ind=
ex.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/oracle/jahia-schema-index.sql
    trunk/core/src/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema=
-index.sql
      - copied unchanged from r17214, branches/JAHIA-5-0-SP-BRANCH/core/src=
/webapp/WEB-INF/var/db/sql/schema/postgresql/jahia-schema-index.sql
Modified:
    trunk/core/src/java/org/jahia/admin/database/DatabaseScripts.java
    trunk/core/src/java/org/jahia/bin/JahiaConfigurationWizard.java
    trunk/core/src/java/org/jahia/hibernate/model/JahiaLink.java

Modified: trunk/core/src/java/org/jahia/admin/database/DatabaseScripts.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/java/o=
rg/jahia/admin/database/DatabaseScripts.java&rev=3D17970&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- trunk/core/src/java/org/jahia/admin/database/DatabaseScripts.java (orig=
inal)
+++ trunk/core/src/java/org/jahia/admin/database/DatabaseScripts.java Thu J=
ul 12 17:20:52 2007
@@ -29,15 +29,12 @@
 import java.io.FileInputStream;
 import java.io.FileReader;
 import java.io.IOException;
-import java.util.Enumeration;
-import java.util.HashMap;
-import java.util.Properties;
-import java.util.Vector;
 =

 import javax.servlet.ServletContext;
 =

 import org.jahia.bin.Jahia;
-import java.util.ArrayList;
+
+import java.util.*;
 import java.io.FilenameFilter;
 import org.jahia.utils.PathResolver;
 =

@@ -251,9 +248,19 @@
                 }
             }
         });
-
+        List indexFiles =3D new ArrayList();
         for (int i=3D0; i < schemaFiles.length; i++) {
-            ArrayList curFileSQL =3D getScriptFileStatements(schemaFiles[i=
]);
+            File sqlFile =3D schemaFiles[i];
+            if(sqlFile.getName().endsWith("index.sql")) {
+                indexFiles.add(sqlFile);
+            } else {
+                ArrayList curFileSQL =3D getScriptFileStatements(sqlFile);
+                result.addAll(curFileSQL);
+            }
+        }
+        for (int i =3D 0; i < indexFiles.size(); i++) {
+            File indexFile =3D (File) indexFiles.get(i);
+            ArrayList curFileSQL =3D getScriptFileStatements(indexFile);
             result.addAll(curFileSQL);
         }
         return result;

Modified: trunk/core/src/java/org/jahia/bin/JahiaConfigurationWizard.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/java/o=
rg/jahia/bin/JahiaConfigurationWizard.java&rev=3D17970&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- trunk/core/src/java/org/jahia/bin/JahiaConfigurationWizard.java (origin=
al)
+++ trunk/core/src/java/org/jahia/bin/JahiaConfigurationWizard.java Thu Jul=
 12 17:20:52 2007
@@ -1600,10 +1600,13 @@
                 // first let's check if it is a DROP TABLE query, if it is,
                 // we will just fail silently.
                 String upperCaseLine =3D line.toUpperCase().trim();
-                if (!upperCaseLine.startsWith("DROP TABLE") && !upperCaseL=
ine.startsWith("ALTER TABLE")) {
+                if (!upperCaseLine.startsWith("DROP") && !upperCaseLine.st=
artsWith("ALTER TABLE")
+                    && !upperCaseLine.startsWith("CREATE INDEX")) {
                     logger.error("Error while trying to execute query : " =
+ line + " from script " + script.toString());
                     // continue to propagate the exception upwards.
                     throw e;
+                } else {
+                    logger.warn("Error while trying to execute query : " +=
 line + " from script " + script.toString());
                 }
             }
         }

Modified: trunk/core/src/java/org/jahia/hibernate/model/JahiaLink.java
URL: https://svndev.jahia.net/websvn/diff.php?path=3D/trunk/core/src/java/o=
rg/jahia/hibernate/model/JahiaLink.java&rev=3D17970&repname=3Djahia
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D
--- trunk/core/src/java/org/jahia/hibernate/model/JahiaLink.java (original)
+++ trunk/core/src/java/org/jahia/hibernate/model/JahiaLink.java Thu Jul 12=
 17:20:52 2007
@@ -119,7 +119,7 @@
 =

     /**
      * @hibernate.property column=3D"left_oid"
-     * length=3D"255"
+     * length=3D"100"
      */
     public String getLeftOid() {
         return this.leftOid;
@@ -131,7 +131,7 @@
 =

     /**
      * @hibernate.property column=3D"right_oid"
-     * length=3D"255"
+     * length=3D"100"
      */
     public String getRightOid() {
         return this.rightOid;
@@ -143,7 +143,7 @@
 =

     /**
      * @hibernate.property column=3D"type"
-     * length=3D"255"
+     * length=3D"100"
      */
     public String getType() {
         return this.type;

_______________________________________________
cvs_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/cvs_list

Reply via email to