Thread: Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin

Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin

From
"Thomas Hallgren"
Date:
The Pl/Java project that I'm working on is progressing quite nicely. The
beta release that I just uploaded to GBorg at
http://gborg.postgresql.org/project/pljava/projdisplay.php has most of the
functionality that I have intended for the first stable release. If you are
interested, please take a look at the readme file and the user guide.

http://gborg.postgresql.org/project/pljava/genpage.php?readme
http://gborg.postgresql.org/project/pljava/genpage.php?userguide

Regards,

Thomas Hallgren



Re: Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin

From
Dave Cramer
Date:
Thomas,

Do you have a feature list, and or a roadmap where you want to take
this?

Have you any ideas for supporting jdbc calls from within the java
function?

Dave
On Tue, 2004-01-27 at 15:42, Thomas Hallgren wrote:
> The Pl/Java project that I'm working on is progressing quite nicely. The
> beta release that I just uploaded to GBorg at
> http://gborg.postgresql.org/project/pljava/projdisplay.php has most of the
> functionality that I have intended for the first stable release. If you are
> interested, please take a look at the readme file and the user guide.
>
> http://gborg.postgresql.org/project/pljava/genpage.php?readme
> http://gborg.postgresql.org/project/pljava/genpage.php?userguide
>
> Regards,
>
> Thomas Hallgren
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


Re: Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin

From
"Thomas Hallgren"
Date:
> Thomas,
>
> Do you have a feature list, and or a roadmap where you want to take
> this?

I'm planning on writing a roadmap. At present, I'm logging tasks that I feel
should be implemented in the task list of the project. If you go here:
http://gborg.postgresql.org/project/pljava/task/tasklist.php and search for
"Not closed", you get a fairly good idea of the near future.

Long term, it depends a bit on what kind of reception the project will have.
My objective is to eventually have it accepted and included in PostgreSQL.
Don't know the best route to get there though. Any advice is appreciated :-)

The project also have a "Feature requests" mechanism where I encourage
anyone with interest to add things they think would benefit the project.

>
> Have you any ideas for supporting jdbc calls from within the java
> function?
>
I do indeed. Most of the things you do with Pl/Java is done using JDBC calls
from within java. The JDBC driver maps the calls to SPI. As I browse the
user doc's I realize I actually missed the section regarding this support
(will add promptly). Some of the samples in the download (SPIActions.java)
shows how it's done though.

In essence, there's a default connection available using:

    Connection conn =
DriverManager.getConnection("jdbc:default:connection");

From there on, you can prepare and execute statements, and use ResultSet's.
Just like with any JDBC driver. The only thing not implemented yet is
meta-data.

In fact, much of the management routines (install_jar, replace_jar, etc.) is
written in Java using the JDBC interfaces.

Regards,

Thomas Hallgren