db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r292796 - in /db/ddlutils/trunk: ./ src/doc/src/documentation/content/xdocs/ src/java/org/apache/ddlutils/platform/ src/test/org/apache/ddlutils/platform/
Date Fri, 30 Sep 2005 16:05:36 GMT
Author: tomdz
Date: Fri Sep 30 09:05:22 2005
New Revision: 292796

URL: http://svn.apache.org/viewcvs?rev=292796&view=rev
Log:
Incorporated suggestion of DDLUTILS-22 that in Db2 BOOLEAN and BIT should be mapped to SMALLINT
Added some more info to the release notes
Removed wholesite from the docs as this currently does not work with Forrest 0.7

Modified:
    db/ddlutils/trunk/ReleaseNotes.txt
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/database-support.xml
    db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/Db2Platform.java
    db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/TestDB2Platform.java

Modified: db/ddlutils/trunk/ReleaseNotes.txt
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/ReleaseNotes.txt?rev=292796&r1=292795&r2=292796&view=diff
==============================================================================
--- db/ddlutils/trunk/ReleaseNotes.txt (original)
+++ db/ddlutils/trunk/ReleaseNotes.txt Fri Sep 30 09:05:22 2005
@@ -3,4 +3,10 @@
 * Replaced 'commons-sql' with 'DdlUtils' in the doc and the build file
 * Package names have been changed from org.apache.commons.sql to org.apache.ddlutils
 * New mailing lists ddlutils-user@db.apache.org and ddlutils-dev@db.apache.org
-* Documentation is now in Forrest format (http://forrest.apache.org)
+* Documentation is now in Forrest format (http://forrest.apache.org) using Forrest 0.7
+* JIRA for the project has been created at http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10731
+* Ant tasks have been revamped to be more user-friendly
+* DdlUtils now can import data from XML files into the database
+* Large scale restructuring of the SqlBuilder part into a platform and a sql builer part
+* Simplification of the public API (eg. see the "Api Usage" documentation part)
+* Update and fix of the Javadoc

Modified: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/database-support.xml
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/database-support.xml?rev=292796&r1=292795&r2=292796&view=diff
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/database-support.xml (original)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/database-support.xml Fri Sep
30 09:05:22 2005
@@ -610,7 +610,8 @@
       <p>
         The DdlUtils support for <a href="ext:db2">IBM DB2</a> is based upon
version <strong>7</strong>.
         The datatypes and SQL elements in DB2 are described in the
-        <a href="ext:db2/manual">DB2 SQL Reference V7</a>.
+        <a href="ext:db2/manual">DB2 SQL Reference V7</a>. Some specifics related
to the JDBC driver and
+        suggested typemappings can also be found <a href="ext:db2/jdbc-mappings">here</a>.
       </p>
       <table>
         <tr>
@@ -669,7 +670,7 @@
         </tr>
         <tr>
           <td>BIT</td>
-          <td>CHAR FOR BIT DATA</td>
+          <td>SMALLINT</td>
           <td>DB2 has no native boolean type</td>
         </tr>
         <tr>
@@ -679,7 +680,7 @@
         </tr>
         <tr>
           <td>BOOLEAN</td>
-          <td>CHAR FOR BIT DATA</td>
+          <td>SMALLINT</td>
           <td>DB2 has no native boolean type</td>
         </tr>
         <tr>
@@ -719,7 +720,7 @@
         </tr>
         <tr>
           <td>FLOAT</td>
-          <td>FLOAT</td>
+          <td>REAL</td>
           <td></td>
         </tr>
         <tr>

Modified: db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml?rev=292796&r1=292795&r2=292796&view=diff
==============================================================================
--- db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml (original)
+++ db/ddlutils/trunk/src/doc/src/documentation/content/xdocs/site.xml Fri Sep 30 09:05:22
2005
@@ -53,12 +53,12 @@
     <api-usage label="Using the API" href="api-usage.html" description="How to use DdlUtils
in your code"/>
     <javadoc label="Javadoc" href="ext:ddlutils/javadoc" description="The API documentation"/>
   </documentation>
-
+<!-- 
   <all label="Whole site">
     <all_site label="Full HTML" href="wholesite.html"/>
     <all_sitePDF label="Full PDF" href="wholesite.pdf"/>
   </all>
-
+-->
   <external-refs>
     <ddlutils>
       <jira href="http://issues.apache.org/jira/secure/BrowseProject.jspa?id=10731"/>
@@ -96,6 +96,7 @@
     </cloudscape>
     <db2 href="http://www-130.ibm.com/developerworks/db2/">
       <manual href="ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2s0e70.pdf"/>
+      <jdbc-mappings href="http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/ad/rjvjdata.htm#jvregou"/>
     </db2>
     <derby href="http://incubator.apache.org/derby/">
       <manual href="manuals/reference/sqlj02.html#Reference+Manual"/>

Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/Db2Platform.java
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/Db2Platform.java?rev=292796&r1=292795&r2=292796&view=diff
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/Db2Platform.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/Db2Platform.java Fri Sep 30 09:05:22
2005
@@ -59,7 +59,8 @@
         // the BINARY types are also handled by Db2Builder.getSqlType(Column)
         info.addNativeTypeMapping(Types.ARRAY,         "BLOB");
         info.addNativeTypeMapping(Types.BINARY,        "CHAR");
-        info.addNativeTypeMapping(Types.BIT,           "CHAR FOR BIT DATA");
+        info.addNativeTypeMapping(Types.BIT,           "SMALLINT");
+        info.addNativeTypeMapping(Types.FLOAT,         "REAL");
         info.addNativeTypeMapping(Types.JAVA_OBJECT,   "BLOB");
         info.addNativeTypeMapping(Types.LONGVARBINARY, "LONG VARCHAR FOR BIT DATA");
         info.addNativeTypeMapping(Types.LONGVARCHAR,   "LONG VARCHAR");
@@ -68,7 +69,7 @@
         info.addNativeTypeMapping(Types.STRUCT,        "BLOB");
         info.addNativeTypeMapping(Types.TINYINT,       "SMALLINT");
         info.addNativeTypeMapping(Types.VARBINARY,     "VARCHAR");
-        info.addNativeTypeMapping("BOOLEAN", "CHAR FOR BIT DATA");
+        info.addNativeTypeMapping("BOOLEAN", "SMALLINT");
 
         setSqlBuilder(new Db2Builder(info));
     }

Modified: db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/TestDB2Platform.java
URL: http://svn.apache.org/viewcvs/db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/TestDB2Platform.java?rev=292796&r1=292795&r2=292796&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/TestDB2Platform.java (original)
+++ db/ddlutils/trunk/src/test/org/apache/ddlutils/platform/TestDB2Platform.java Fri Sep 30
09:05:22 2005
@@ -47,9 +47,9 @@
             "    \"COL_ARRAY\"         BLOB,\n"+
             "    \"COL_BIGINT\"        BIGINT,\n"+
             "    \"COL_BINARY\"        CHAR(254) FOR BIT DATA,\n"+
-            "    \"COL_BIT\"           CHAR FOR BIT DATA,\n"+
+            "    \"COL_BIT\"           SMALLINT,\n"+
             "    \"COL_BLOB\"          BLOB,\n"+
-            "    \"COL_BOOLEAN\"       CHAR FOR BIT DATA,\n"+
+            "    \"COL_BOOLEAN\"       SMALLINT,\n"+
             "    \"COL_CHAR\"          CHAR(15),\n"+
             "    \"COL_CLOB\"          CLOB,\n"+
             "    \"COL_DATALINK\"      DATALINK,\n"+
@@ -58,7 +58,7 @@
             "    \"COL_DECIM_NOSCALE\" DECIMAL(15,0),\n"+       // only 18 characters allowed
for identifiers
             "    \"COL_DISTINCT\"      DISTINCT,\n"+
             "    \"COL_DOUBLE\"        DOUBLE,\n"+
-            "    \"COL_FLOAT\"         FLOAT,\n"+
+            "    \"COL_FLOAT\"         REAL,\n"+
             "    \"COL_INTEGER\"       INTEGER,\n"+
             "    \"COL_JAVA_OBJECT\"   BLOB,\n"+
             "    \"COL_LONGVARBINARY\" LONG VARCHAR FOR BIT DATA,\n"+



Mime
View raw message