Re: [JDBC] Regarding GSoc Application

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