- Added new getReservedKeywords() method to the Database class

pborissow · pborissow · commit 4610335707be · 2023-12-19T12:54:02.000Z
git-svn-id: svn://192.168.0.80/JavaXT/javaxt-core@1563 2c7b0aa6-e0b2-3c4e-bb4a-8b65b6c465ff
diff --git a/src/javaxt/sql/Database.java b/src/javaxt/sql/Database.java
@@ -902,7 +902,19 @@ public static String[] getCatalogs(Connection conn){
   //**************************************************************************
   //** getReservedKeywords
   //**************************************************************************
-  /**  Used to retrieve a list of reserved keywords for a given database.
+  /** Returns a list of reserved keywords for the current database.
+   */
+    public String[] getReservedKeywords() throws Exception {
+        try(Connection conn = this.getConnection()){
+            return getReservedKeywords(conn);
+        }
+    }
+
+
+  //**************************************************************************
+  //** getReservedKeywords
+  //**************************************************************************
+  /** Returns a list of reserved keywords for a given database.
    */
     public static String[] getReservedKeywords(Connection conn){
         Database database = conn.getDatabase();
@@ -1152,12 +1164,12 @@ public Database clone(){
         "CROSS","CURRENT_DATE","CURRENT_TIME","CURRENT_TIMESTAMP","CURRENT_USER",
         "DISTINCT","EXCEPT","EXISTS","FALSE","FETCH","FILTER","FOR","FOREIGN",
         "FROM","FULL","GROUP","GROUPS","HAVING","IF","ILIKE","IN","INNER",
-        "INTERSECT","INTERSECTS","INTERVAL","IS","JOIN","LEADING","LEFT","LIKE",
+        "INTERSECT","INTERSECTS","INTERVAL","IS","JOIN","KEY","LEADING","LEFT","LIKE",
         "LIMIT","LOCALTIME","LOCALTIMESTAMP","MINUS","NATURAL","NOT","NULL","OFFSET",
         "ON","OR","ORDER","OVER","PARTITION","PRIMARY","QUALIFY","RANGE","REGEXP",
         "RIGHT","ROW","_ROWID_","ROWNUM","ROWS","SELECT","SYSDATE","SYSTIME",
         "SYSTIMESTAMP","TABLE","TODAY","TOP","TRAILING","TRUE","UNION","UNIQUE",
-        "VALUES","WHERE","WINDOW","WITH"
+        "VALUE","VALUES","WHERE","WINDOW","WITH","YEAR"
     };
 
 
