RE: Something useful(maybe)

["James & Sue Ann Birchfield" <jsrbirch at home.com>]

I will spend a little more time with it later and include examples of
output and incorporate your suggestions.  I like the idea of
contributing, but I have a pretty tight time table and don't
want to commit to something I can't keep up, but I will
think about it.  But I will definitely at least make available
any thing I caome up with that might be interesting...
=====================================
James Birchfield
Chief Technology Officer
jmbirchfield at proteus-technologies.com
http://www.proteus-technologies.com
=====================================

-----Original Message-----
From: owner-xmlblaster-devel at xmlBlaster.org
[mailto:owner-xmlblaster-devel at xmlBlaster.org]On Behalf Of Marcel Ruff
Sent: Saturday, February 19, 2000 6:00 AM
To: xmlBlaster Developer
Subject: Re: Something useful(maybe)


Hi,

i am impressed, this could be the RDBMS access framework we need
in xmlBlaster!

Are you willing to contribute this into

  org.xmlBlaster.engine.persistence.jdbc

package?

You would get cvs write access for this.
Please drop me a note.

Some comments:

- The con.login("XmlDBAdapter", "some", qos);
  code in XmlDBAdapterWorker shouldn't be done
  for every query again,
  you should use the existing connection from
  XmlDBAdapter.java to send the results.

- We would need a flag to tell XmlDBAdapter.java
  if the query results are sent directly back to the client
  (PtP style) or are published for everybody (Pub/Sub style).

- Can you provide an example of a RDBMS table, and how
  it looks like in your resulting XML message?


Thanks for your feedback

Marcel
James & Sue Ann Birchfield wrote:
>
> In playing with xmlBlaster more and more, I put
> together something today that I thought others
> might find useful.  It is a generic xml based
> Databse adapter that plugs into xmlBlaster.
> Using xml to describe the query, including
> db url, user, and password, the adapter can
> query any type of db.  It transforms the
> resultset into an xml document as well
> with a full description block and
> passes it back to the client that requested.
>
> It is still rough, I have only put a couple of hours into it.
> If anyone wants to make it better, feel free.
>
> I am attaching it as a jar file contains 4
> source files.
>
> =====================================
> James Birchfield
> Chief Technology Officer
> jmbirchfield at proteus-technologies.com
> http://www.proteus-technologies.com
> =====================================
>
>   ------------------------------------------------------------------------
>                        Name: xmldbadapter.jar
>    xmldbadapter.jar    Type: Java Archive (application/java-archive)
>                    Encoding: base64

--
Marcel Ruff
ruff at swand.lake.de
http://www.lake.de/home/lake/swand/
http://www.xmlBlaster.org