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

Re: [JDBC] Regarding GSoc Application

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>, Dave Cramer <pg(at)fastcrypt(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 18:10:05
Message-ID: CAHyXU0z5GapvK96pB7sLg=p2uqRAeRe_uimsQJHv+3G6kjqM4g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
On Mon, Apr 9, 2012 at 12:25 PM, Atri Sharma <atri(dot)jiit(at)gmail(dot)com> wrote:
> On Mon, Apr 9, 2012 at 10:15 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>> On 04/09/2012 12:14 PM, Dave Cramer wrote:
>>> So I'm confused, once they link a file to an FDW can't you just read
>>> it with an normal select ?
>>>
>>> What additional functionality will this provide ?
>>>
>>
>>
>>
>> I'm confused about what you're confused about. Surely this won't be linking
>> files to an FDW, but foreign DBMS tables, in anything you can access via
>> JDBC. 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;
>>
>>
>> cheers
>>
>> andrew
>
> Hi Andrew,
>
> Thanks for going through my proposal and commenting on it.
>
> I think you have hit the nail on the head.We will be connecting the
> foreign DBMS tables.The main aim of the project is to wrap JDBC so we
> can connect to anything that can be reached through a JDBC URL.
>
> I am considering two paths for doing this:
> The first one takes the help of the SPI(Server Programming Interface)
> and the second one directly connects through Pl/Java and JNI(Java
> Native Interface).
>
> Please let me know your further comments and also,please advise me on
> how to proceed further.

I think the best way to go is as planned.  Step one is to get pl/java
installed and attempt a minimal set of functions that can connect to
and gather data from an external source...let's start with pl/java
'hello world' and go from there.  Once done it's time to start
thinking about how the java internals will look like -- we can crib
from dblink for that though.

merlin

In response to

Responses

pgsql-hackers by date

Next:From: Atri SharmaDate: 2012-04-09 18:11:51
Subject: Re: [JDBC] Regarding GSoc Application
Previous:From: Tom LaneDate: 2012-04-09 18:04:10
Subject: Re: Revisiting extract(epoch from timestamp)

pgsql-jdbc by date

Next:From: Atri SharmaDate: 2012-04-09 18:11:51
Subject: Re: [JDBC] Regarding GSoc Application
Previous:From: Atri SharmaDate: 2012-04-09 17:25:58
Subject: Re: [JDBC] Regarding GSoc Application

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