You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ddlutils-dev@db.apache.org by to...@apache.org on 2005/09/30 18:05:36 UTC
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/
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"+