Re: Using JDBC to connect to an external database
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: danp@xxxxxxxxxxxxx
- Date: Mon, 21 Feb 2011 22:36:25 +0100
There's probably others that know more about java than I do - but here's
what I would be looking into.
The mysql jdbc driver is nothing but a java class as well isn't it. Did you
look at simply loading that into the database and use it in a java stored
procedure ? I know you can do it with the oracle driver, so I think it's
rather safe to assume it can be done wiht any others as well.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Mon, Feb 21, 2011 at 10:20 PM, Dan Peacock <danp@xxxxxxxxxxxxx> wrote:
> Ok, I'm probably going to kick a hornets nest here, so please forgive me.
>
> I was wondering, why isn't there a way to use a jdbc driver from within the
> Oracle database to connect to an external database like, oh say, MySQL
> rather than using the ODBC gateway? I know that the ODBC gateway is an
> option (allegedly since I've not gotten it to work yet), but it strikes me
> as odd why, now that Oracle has control over such things, that it's not
> possible to use a JDBC driver in the database to get external data.
>
> Here's where this is all coming from:
>
> I've got an application that I want to integrate data from a third-party
> database (in this case a MySQL database) that I am contractually prohibited
> from pulling over all at once (long story). I just want to be able to join
> the external MySQL table just like it were a regular table. I understand
> the odbc gateway does this, but there are issues with performance.
>
>
> --
> Dan Peacock
> Enterprise Data Architect
> Auto-wares, Inc.
> danp@xxxxxxxxxxxxx
>
> Dare something great
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
