Re: [Squirrel-sql-develop] Plugin to Support Multiple Source Querying

[Andreas O. <cpt...@gm...>]

Hi Ramon,

from my point of view this plugin would be very useful. I use SQuirreL 
for querying different types of databases and sometimes it would be very 
useful if I could interconnect the results from queries to different 
types of databases. What kind of restrictions would there be for the 
data sources that would be combined into the virtual data source? Due to 
the lack for JDBC drivers for some of my datasources the possibility of 
using ODBC connections would be very important. The disadvantages of 
using the JDBC to ODBC bridge have been thoroughly discussed in the 
SQuirreL mailing-lists, but sometimes there is no other possibility.

Do you have plans to make those virtual datasource available for 
application server data sources as well? Using your solution as a 
javax.sql.DataSource would create great opportunities.

Looking forward to what might develop from your ideas.

If I could be of any kind of help I'd be happy to help developing.

Especially I could provide help testing for

  * Oracle
  * MySQL
  * MS SQL
  * different ODBC datasources (e.g. Aspentech InfoPlus.21, MS Access
    databases)

Also I could work on translating to german if that might be needed.

Hope to hear from you soon.

Kind regards

Andreas Oswald

Am 08.05.2012 17:46, schrieb Lawrence, Ramon:
> Hello,
>
>
>
> I am working on a plugin to allow a SQuirreL user to query multiple
> sources in one query.  I would like to see if there is interest in such
> a plugin and if so, the code review and development process to follow.
>
>
>
> Plugin details available at:
>
> http://people.ok.ubc.ca/rlawrenc/MultipleSourcePlugin_for_SQuirreL.pdf
>
>
>
> Thank you for your time.
>
>
>
> --
>
> Dr. Ramon Lawrence
>
> Associate Professor, Computer Science
>
> University of British Columbia Okanagan
>
> Kelowna, British Columbia, Canada
>
> ram...@ub...
>
> http://people.ok.ubc.ca/rlawrenc/
>
>
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> Squirrel-sql-develop mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-develop