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 P Knecht
CEO & Founder

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27


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
> --

Other related posts: