Re: [JDBC] Regarding GSoc Application

On Mon, Apr 9, 2012 at 11:40 PM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> 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

I agree,this should be the correct path.

Atri
--
Regards,

Atri
l'apprenant