agora inbox for pljava-dev@postgresql.org
help / color / mirror / Atom feedSubject: [Pljava-dev] PL/Java 1.3.beta released.
Date: Mon, 15 May 2006 10:23:28 +0200
Message-ID: <003901c677f8$d88000a0$1e03a8c0@fhrbek> (raw)
References: <44673B92.9030109@tada.se>
Hi Thomas,
I have 2 comments to the new beta version of pljava.
The first one is about compilation problems on my platform (RedHat Linux 9.0):
[root at devlin2 org.postgresql.pljava]# make
make[1]: Entering directory `/home/fhrbek/eclipse/workspace/org.postgresql.pljava/build/classes/pljava'
/home/fhrbek/eclipse/workspace/org.postgresql.pljava/src/java/pljava/Makefile:37: *** commands commence before first target. Stop.
make[1]: Leaving directory `/home/fhrbek/eclipse/workspace/org.postgresql.pljava/build/classes/pljava'
make: *** [pljava_all] Error 2
The problem is in org.postgresql.pljava/src/java/pljava/Makefile at following lines
JNI_CLASSES := \
org.postgresql.pljava.internal.Backend \
org.postgresql.pljava.internal.SPI \
org.postgresql.pljava.internal.AclId \
org.postgresql.pljava.internal.ErrorData \
org.postgresql.pljava.internal.Oid \
org.postgresql.pljava.internal.ExecutionPlan \
org.postgresql.pljava.internal.JavaWrapper \
org.postgresql.pljava.internal.LargeObject \
org.postgresql.pljava.internal.PgSavepoint \
org.postgresql.pljava.internal.Portal \
org.postgresql.pljava.internal.Relation \
org.postgresql.pljava.internal.Session \
org.postgresql.pljava.internal.SubXactListener \
org.postgresql.pljava.internal.TriggerData \
org.postgresql.pljava.internal.Tuple \
org.postgresql.pljava.internal.TupleDesc \
org.postgresql.pljava.internal.XactListener \
org.postgresql.pljava.jdbc.Invocation \
org.postgresql.pljava.jdbc.SingleRowReader \
org.postgresql.pljava.jdbc.SQLInputFromChunk \
org.postgresql.pljava.jdbc.SQLOutputToChunk \
org.postgresql.pljava.jdbc.SQLInputFromTuple \
org.postgresql.pljava.jdbc.SQLOutputToTuple
I modified it in this way:
INTPKG := org.postgresql.pljava.internal
JDBCPKG := org.postgresql.pljava.jdbc
JNI_CLASSES := \
$(INTPKG).Backend \
$(INTPKG).SPI \
$(INTPKG).AclId \
$(INTPKG).ErrorData \
$(INTPKG).Oid \
$(INTPKG).ExecutionPlan \
$(INTPKG).JavaWrapper \
$(INTPKG).LargeObject \
$(INTPKG).PgSavepoint \
$(INTPKG).Portal \
$(INTPKG).Relation \
$(INTPKG).Session \
$(INTPKG).SubXactListener \
$(INTPKG).TriggerData \
$(INTPKG).Tuple \
$(INTPKG).TupleDesc \
$(INTPKG).XactListener \
$(JDBCPKG).Invocation \
$(JDBCPKG).SingleRowReader \
$(JDBCPKG).SQLInputFromChunk \
$(JDBCPKG).SQLOutputToChunk \
$(JDBCPKG).SQLInputFromTuple \
$(JDBCPKG).SQLOutputToTuple
and now it works.
Should I commit this change, or is there any other solution?
The second comment is about an improvement in the pljava deployer.
If an error occurs during pljava installation (e.g. no pljava.so/dll), a piece of unfinished pljava system may remain in the database. Then it is impossible to retry unless you drop all those objects manually, which might be inconvenient, especially for beginners. I put the installation process into a transaction which seems to solve all this.
The only problem was dropping the pljava and pljavau languages when uninstalling pljava - this piece of code is in a try-catch block where any exception is ignored. If it fails inside a transaction, any following command fails due to "current transaction is aborted" error. I solved this by using either a savepoint (if available), or a transaction rollback (if savepoints are not available; this workaround required the dropSQLSchema method to be the first one called in the transaction).
If you like the above described modifications, I will commit them into CVS so that you could see the changes.
Regards,
Filip
----- Original Message -----
From: "Thomas Hallgren" <thomas at tada.se>
To: "Pljava-Dev at Gborg.Postgresql.Org" <pljava-dev at gborg.postgresql.org>
Sent: Sunday, May 14, 2006 4:15 PM
Subject: [Pljava-dev] PL/Java 1.3.beta released.
> This release is about type mapping and the creation of new types in
> PL/Java. An extensive effort has gone into making the PL/Java type
> system extremely flexible. Not only can you map arbitrary SQL data types
> to java classes. You can also create new scalar types completely in Java.
>
> The new type system also handles domains, arrays, and pseudo types like
> "any", anyelement, and anyarray.
>
> The new release can be picked from the PL/Java download page at
> http://wiki.tada.se/display/pljava/Download+Page.
>
> The final release is planned for end of May. If you have any known
> issues or problems with PL/Java, please report them now. All testing
> that is done on this beta release will help improve the quality of
> PL/Java so please start pounding on it.
>
> Kind Regards,
> Thomas Hallgren
>
> _______________________________________________
> Pljava-dev mailing list
> Pljava-dev at gborg.postgresql.org
> http://gborg.postgresql.org/mailman/listinfo/pljava-dev
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pljava-dev/attachments/20060515/c6ff7d67/attachment.html;
view thread (3+ messages) latest in thread
Message-ID: <003901c677f8$d88000a0$1e03a8c0@fhrbek>
Permalink: ../003901c677f8$d88000a0$1e03a8c0@fhrbek/
Also on: postgresql.org/message-id/003901c677f8$d88000a0$1e03a8c0@fhrbek
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pljava-dev@postgresql.org
Subject: Re: [Pljava-dev] PL/Java 1.3.beta released.
In-Reply-To: <003901c677f8$d88000a0$1e03a8c0@fhrbek>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox