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 [EMAIL PROTECTED] and [email protected]
-* 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"+
