[Pljava-dev] Possible to override default type mappings?

Hello,

In order to use a pre-existing Java library which works with specialized
implementations of the basic SQL types (varchar, int, etc.), I am trying
to override the default type mappings for these types to use our
specialized classes instead of java.lang.String, java.lang.Integer, etc.

Is this possible? I keep getting an error:

test_db=# select indexOf('ABC', 'A');
ERROR: No java type mapping installed for "test.character"

I have used SQLJ to install my jar with a deployment descriptor which
adds the type mappings and creates my "indexOf(varchar, varchar)" function:

select sqlj.add_type_mapping('int', 'test.integer');
select sqlj.add_type_mapping('varchar', 'test.character');

create function indexOf(varchar, varchar) returns int
as 'test.character.indexOf(test.character, test.character)'
language java;

There are no errors at this stage and it looks as though the type
mappings were set up correctly:

test_db=# select * from sqlj.typemap_entry;
mapid | javaname | sqlname
-------+----------------+--------------------
46 | test.integer | pg_catalog.int4
47 | test.character | pg_catalog.varchar

I also use sqlj.set_classpath to set my classpath to my installed jar,
which reports no error.

I am testing with PL/Java version 1.3.0 on SUSE Linux 10, PG 8.1.3
(though I will need to support this configuration with PG 8.1.4 on
multiple Linux distros).

Thanks in advance for any help.

Regards,
Eric Faulhaber