Re: [Pljava-dev] built, now how to install?

On 1/15/2016 7:24 AM, Chapman Flack wrote:
>> test failed
>> >with what appear to be character encoding errors. my test server was
>> >running en_US.UTF8, while I suspect this production site uses
>> >POSIX/SQLASCII...
> If the server is SQL_ASCII and the only failing test was the
> UnicodeRoundTripTest, then PL/Java is working and that's as good
> as it's going to get. That particular test doesn't even have a
> definable meaning when the server encoding is SQL_ASCII.

whale...

I re-initdb'd my test vm with POSIX/C locale, and when I load the
examples.jar, I get...

CONTEXT: SQL statement "CREATE OR REPLACE FUNCTION
javatest.complex_send(javatest.complex) RETURNS bytea LANGUAGE java
IMMUTABLE RETURNS NULL ON NULL INPUT AS
'UDT[org.postgresql.pljava.example.annotation.ComplexScalar] SEND'"
ERROR: requested character too large for encoding: 256

all the other functions load, just that last one fails. this is the
same error production showed me a screenshot of when they ran the
examples. of course, since this fails, the whole sqlj.install_jar()
fails because hte transaction rollsback.

unluckily, the main application using this database /requires/ POSIX
collation for obscure and historic reasons. its all USASCII data
anyways. I believe they used a CREATE DATABASE ... ENCODING
'SQL_ASCII' on a cluster that was initdb'd with UTF8 for equally
historic reasons (this config is a prototype, 12 hour time zone
differences, and path of least resistance).

--
john r pierce, recycling bits in santa cruz

_______________________________________________
Pljava-dev mailing list
Pljava-dev(at)lists(dot)pgfoundry(dot)org
http://lists.pgfoundry.org/mailman/listinfo/pljava-dev