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

Re: [HACKERS] Regarding GSoc Application

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [HACKERS] Regarding GSoc Application
Date: 2012-04-11 04:29:58
Message-ID: 4F8508C6.5090305@hogranch.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
On 04/10/12 8:41 PM, Atri Sharma wrote:
> I agree,the only need of Pl/Java that is apparent here is the need of the
> Java internals(JDK et al).If we set them up independently,then,we can have
> the FDW wrapping JDBC directly through JNI.JNI would call pure Java
> functions to connect to the JDBC.

PL/Java also provides for passing SQL arguments in various data types 
to/from your java code.    not usinig pl/java would mean you'd have to 
reinvent all those wheels, they exist now in a standard mannner, why not 
use them?

as I see it, your proposal could be implemented as a set of pljava 
functions callable from SQL that would in turn invoke JDBC to connect to 
and fetch data from your foreign database, then return it to the calling 
SQL procedure, much as dblink does now for pg to pg database links.



-- 
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


In response to

Responses

pgsql-hackers by date

Next:From: Atri SharmaDate: 2012-04-11 04:36:40
Subject: Re: [HACKERS] Regarding GSoc Application
Previous:From: Atri SharmaDate: 2012-04-11 03:41:10
Subject: Re: [JDBC] Regarding GSoc Application

pgsql-jdbc by date

Next:From: Atri SharmaDate: 2012-04-11 04:36:40
Subject: Re: [HACKERS] Regarding GSoc Application
Previous:From: Atri SharmaDate: 2012-04-11 03:41:10
Subject: Re: [JDBC] Regarding GSoc Application

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