ijsql-devel

Re: [Ijsql-devel] Re: iJSQL list

[Jukka U. <juk...@vt...>]

Wed, 22 Nov 2000, Peter wrote:
> 
> 2)  The more relevant communication I was referring to was to have 2 
> (possibly more) connections open and do the data migration, cross-db query 
> ... between 2 db's.  This does not require XA if doing query (data mining 
> eetc.) and possibly only 1 commit on db "x" where an update may be desired.
> 
> This should be quite simple to accomplish - just have 2 connections open and 
> represent this in the Swing model via 2 root nodes (each node representing a 
> db).  I have not looked at the Swing model yet, have you?
> 

No,  I am not very familiar with any gui programming except servlets. But this
souds good way do it. And if we make 1 root node and represent these 
connections in first child nodes, it would be easy export this data as XML
document. Or it does not matter if there are 2 root nodes in user interface but 
why make two model to represent same thing.

> 
> Would this also be desired - show data from a DB as well as meta-data in a 
> tree control or the like ?
> 

I think this would be good thing with export data and meta-data as xml-document.

What do you think about cross-db query? Something graphical query like 
MS Query or own SQL-layer over db's sql or ...

- Jukka -

Re: [Ijsql-devel] Re: iJSQL list

[Jukka U. <juk...@vt...>]

Message Sun, 26 Nov 2000, Peter wrote:
> 
> I like the XML involvement, I have worked with it a bit, but not as much as 
> I would like - would you be using XML4J from IBM Alphaworks - it is really 
> quite good and free to distribute.
> 
> Depending on whether we use DOM or SAX, there are many options - SUN has 
> "JAX" as well, which is like SAX ... many options.
> 

I have worked little with XML4J and with Xerces also, but i think we can make
xml-parser like plugin. As far they use same DOM or SAX model this 
should be possible. I don't have make this kind of features but i have seem
some. 

Maybe first would be with XML4J and in version 2 we can xml-parser like 
plugin module.

> Exporting meta data, or extract data (queries ...) would be quite nice.
> 

I have done application which exports resultset to XML document with 
asp and I think should not be hard thing with java.


regards,

- Jukka -