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

Re: [JDBC] Regarding GSoc Application

From: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Dave Cramer <pg(at)fastcrypt(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:25:58
Message-ID: CAOeZVieUiksGhFFGK_HYdZhCEH13Q7OpOJ0o2Wph-XUbkQYm2w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
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.

Atri
-- 
Regards,

Atri
l'apprenant

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2012-04-09 17:30:43
Subject: Revisiting extract(epoch from timestamp)
Previous:From: Andrew DunstanDate: 2012-04-09 17:19:31
Subject: Re: why was the VAR 'optind' never changed in initdb?

pgsql-jdbc by date

Next:From: Merlin MoncureDate: 2012-04-09 18:10:05
Subject: Re: [JDBC] Regarding GSoc Application
Previous:From: Kevin GrittnerDate: 2012-04-09 17:19:10
Subject: Re: [JDBC] Regarding GSoc Application

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