[CALUG] mssql oracle

[Hugh Brown]

On 2/14/06, william kelly <william.kelly.jr at gmail.com> wrote:
>
> I am looking for a solution to build reports via jasper reports that
> queries
> both oracle and mssql in a single query. i am unable to locate a single
> query that would allow data to be aggregated from both. any ideas? also im
> trying to use ireport to build my report.



I'm not a db expert, but I suspect this is only really possible if the mssql
and oracle db's were built identically in their table structure, data types,
etc.  I don't know if that is even truly possible.  You'd also have the
difficulty of creating your own db driver that connected to both db's and
then ran the query against them.  Otherwise, you'll have to open a db
connection to oracle, do the query, open a connection to mssql and do the
query and then aggregate your results.

I suspect that the single query against two distinct db's is a difficult
proposition (which would involve writing a custom data connection layer).

Hugh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://calug.com/pipermail/lug/attachments/20060215/76e8bdfb/attachment.html