Skip site navigation (1) Skip section navigation (2)

Re: [JDBC] Regarding GSoc Application

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>, "Dave Cramer" <pg(at)fastcrypt(dot)com>
Cc: "Atri Sharma" <atri(dot)jiit(at)gmail(dot)com>, "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "Pg Hackers" <pgsql-hackers(at)postgresql(dot)org>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: [JDBC] Regarding GSoc Application
Date: 2012-04-09 17:19:10
Message-ID: 4F82D3BE0200002500046CE1@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
Dave Cramer <pg(at)fastcrypt(dot)com> wrote: 
> Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
 
>> All you'll need on the postgres side is the relevant JDBC driver,
>> so you'd have instant access via standard select queries to
>> anything you can get a JDBC driver to talk to. That seems to me
>> something worth having.
>>
>> I imagine it would look rather like this:
>>
>>   CREATE FOREIGN DATA WRAPPER foodb HANDLER pljava_jdbc_handler
>>   OPTIONS (driver 'jdbc.foodb.org');
>>   CREATE SERVER myfoodb FOREIGN DATA WRAPPER foodb OPTIONS(host
>>   '1.2.3.4', user 'foouser', password 'foopw');
>>   CREATE FOREIGN TABLE footbl (id int, data text) SERVER myfoodb;
>>   SELECT * from footbl;
>>
> Well this is certainly more explanation than we have so far.
> 
> Is this the intended use case ?
 
That is how I've understood it from the discussion I've seen -- an
FDW to connect to JDBC so that you can wrap anything accessible from
JDBC. The use of pl/Java seems to be the easiest way to get there.
 
-Kevin

In response to

pgsql-hackers by date

Next:From: Andrew DunstanDate: 2012-04-09 17:19:31
Subject: Re: why was the VAR 'optind' never changed in initdb?
Previous:From: Dave CramerDate: 2012-04-09 17:07:00
Subject: Re: [JDBC] Regarding GSoc Application

pgsql-jdbc by date

Next:From: Atri SharmaDate: 2012-04-09 17:25:58
Subject: Re: [JDBC] Regarding GSoc Application
Previous:From: Dave CramerDate: 2012-04-09 17:07:00
Subject: Re: [JDBC] Regarding GSoc Application

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group