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 -