Re: "create type" custom types not supported by JDBC

Thanks for the pointer Kris.
It's now working.

For the sake of anybody trying the same, here's what I did ...

In the database:-
create type couk_cleverthinking_gwappo_db_Money as (local_value
numeric(11,2),mnemonic char(3), exchange_rate numeric(9,5),base_value
numeric(11,2));
CREATE TABLE prices (price couk_cleverthinking_gwappo_db_Money);
insert into prices values(ROW(100,'PHP',.943,0.94));
select * from prices;
price
----------------------
(100.00,PHP,0.943,0.94)

My Custom class is:-
public class Money extends PGobject implements SQLData, Serializable{
public Money() {
setType("couk_cleverthinking_gwappo_db_money");
}
public Money(String _value) {
setType("couk_cleverthinking_gwappo_db_money");
... stuff ...
}
... stuff ...
}

To use it I do :-
Connection conn = DriverManager.getConnection(url, userName,
password);
((PGConnection)
conn).addDataType("couk_cleverthinking_gwappo_db_money",Class.forName("couk.cleverthinking.gwappo.db.Money"));
Money m2 = new Money("(100,USD,0.534,0.53)");
PreparedStatement pst;
pst = conn.prepareStatement("insert into prices values(?)");
pst.setObject(1,m2);

I do have a follow up question about how this might all work in a JPA
layer (Oracle Toplink). That's another post :-)

Many thanks

Kris Jurka wrote:
> On Sat, 1 Dec 2007, Kris Jurka wrote:
>>> Poking around the source code of AbstractJdbc2Connection it looks
>>> like this functionality isn't support. Perhaps an "Unsupported
>>> feature" error would be more helpful than a ClassCastException.
> I've put a fix for this into CVS.