I have a vmware image which I use to test ddlutils stuff (with almost all databases present). Although I think writing a new adapter for every database is kind of cumbersome, so we probably need to have a look at that, especially when alternatives exist that can do this job for us :)
Mvgr, Martin Antoine Levy-Lambert wrote: > Hello Zeus, > > I am not sure whether I can test the adapter because I do not know how I > could gain access to a DB2 database. (Do they only run on IBM mainframes > ?). I am working on Mac with OSX. > > I should have a look at your code. If it looks good, I can check it in. > Is it in a bugzilla issue ? I have had a quick look at my list of issues > and did not find it. > > Best regards, > > Antoine > > On Feb 25, 2007, at 4:27 PM, Zeus Courtois wrote: > >> Hi Antoine, >> >> I submitted a new adapter last Wednesday, that was developed in >> conjunction with a colleague, Rafael Coss. >> >> This adapter uses the XML capabilities of DB2 v9, as you may already >> know: DB2 has the capability of defining the datatype of a >> database-column as XML. Just as you would define it to be VARCHAR or >> INTEGER. >> >> The adapter is somewhat a combination of the existing DB2 v8 adapter >> and the File Store adapter, where the metadata is formed into an XML >> doc and stored in DB2. >> >> The advantage of this is that the database schema was reduced from 15 >> tables to only 2!!! Where one table stores the metadata and the other >> stores the actual documents. >> >> Moreover, not all documents are stored as BLOBs as before. Now XML >> documents--determined by the mimetype--will be stored as XML! >> >> The advantage is that the metadata and the XML documents may now be >> queried through XQueries (W3C Standard) and SQL/XML which is on its >> way to becoming a standard. >> >> The XML documents may also be indexed to make queries run faster >> taking advantage of IBM DB2 performance, robustness and reliability. >> >> The adapter also has a major enhancement: You can expose documents >> through WebDAV. >> Ex: If you had documents stored in a certain table other than the >> SLIDE Default Table, then through the use of a store procedure (which >> was provided) you can create the metadata and make it point to that >> file. The file will not be moved from your original table! You can >> now view it through the explorer or any WebDAV enabled application. >> You may also modify the exposed file and save it back! >> >> I provided a README file with more details. >> >> Do you think this can be a part of SLIDE adapters? Would you like to >> test it? >> >> Let me know what you think, >> >> Thanks, >> >> Zeus Courtois. >> >> >> >> >> Looking for earth-friendly autos? >> Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center. > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
