RE: Slide DB2 pureXML Adapter

[Michael Oliver <ol...@alariussystems.com>]

Rafael,
 
This looks very interesting, I will get right on it.
 
Michael Oliver
Cell: 518-378-6154
Skype: MikeOliverAZ
Phone:702-866-9034
 

  _____  

From: racoss@gmail.com [mailto:racoss@gmail.com] On Behalf Of Rafael Slide
Developer
Sent: Thursday, February 22, 2007 6:31 PM
To: slide-user@jakarta.apache.org; slide-dev@jakarta.apache.org
Cc: Zeus
Subject: RE: Slide DB2 pureXML Adapter


Hi Mike,


> I would love to review the adapter and commit that to the project, 
> and I would add my own Derby adapter.
Thanks Mike for reviewing it.

Here it is (attached below)!   I hope you like it. 

This DB2 pureXML v9 adapter is an enhancement to the existing DB2 v8.1
adapter.  This simplifies the database schema and allows you to store XML
documents in an XML column.

In this zip file you will find the following files: 
   slide/build.xml
       This is the ant build configuration file
   slide/ConfiguringPureXMLAdapter.rtf
       This is a readme file that describes what's new with this adapter and
how to configure it.   How do we go about updating Slides web pages with
this configuration information?  Can we add a section to this URL:
http://jakarta.apache.org/slide/howto-j2eestore.html ?
   slide/db2purexml-stores-1.0.jar
       This contains the adapter classes.
   slide/domain.xml
        This is a sample slide configuration file for the DB2 pureXML
adapter.
   slide/PUREXMLSP.html
       This is javadoc for the Stored Procedures used by the adapter.
   slide/dbsetup/DB2XMLFUNCTIONS.jar
       This is a DB2 stored procedure used to update xml documents.  Here is
an article describing this SP:
 
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0605singh/
<http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0605singh/
> 
       This only includes the class files.  The source can be found from the
above.
   slide/dbsetup/PUREXMLSP.jar
       This jar contains the SP used by the DB2 pureXML adapter.  This
includes the source and class files.
   slide/dbsetup/setup.db2
       This is a db2 sql script to create and configure the database and
create all the necessary database objects.
   slide/com/ibm/db2/purexml
       This contains the source for the DB2 pureXML adapater.

This adapter works with the free version of DB2 v9, DB2 Express-C:
     http://www-306.ibm.com/software/data/db2/udb/db2express/

We have run the four test lists (functional, bind, deltaV, DASL) and we get
about the same results as you do from the other relational adapters.  There
were a couple of places where we got differences but that was expected due
to the different implementation. 

Please let me know what you think and if we need to fix/enhance anything.

regards,
<><><><><><><><><><><><><><><><><><><> 
Rafael