User Defined Types -- Using inet/cdr from JDBC ?

Поиск
Список
Период
Сортировка
От j.random.programmer
Тема User Defined Types -- Using inet/cdr from JDBC ?
Дата
Msg-id 214064.66714.qm@web32001.mail.mud.yahoo.com
обсуждение исходный текст
Список pgsql-jdbc
Hi all:

I have recently released my O/R mapping tool (molly)
at:

www.mollypages.org/dbo

Currently, this tool does not support any postgres
specific types.
So, when doing the O/R mapping, if the JDBC Meta Data
returns:
  java.sql.Types.OTHER (1111),
the O/R tool gives up and says:
----
Exception in thread "main" java.sql.SQLException: This
framework does not understand/support columns of this
type. [java.sql.Type: 1111]
-----

Ok so far, so good (or bad). But now I do have a need
to use:

1) inet, cdr types
2) point, circle etc types

Suppose, I have:

  create table test (my_ip_address  inet);

Looking over the JDBC docs, I see that I may to say
something
like (in java):

1    ResultSet rs = stmt.executeQuery("select * from
test");
2    Map map = new HashMap();
3    map.put("inet", foo.class);  //string -> user
defined class
4    rs.next();
5    Object o = rs.getObject(1, map);

The  program does not get too far. I get:

  Exception in thread "main"
org.postgresql.util.PSQLException:
    Method
org.postgresql.jdbc3.Jdbc3ResultSet.getObjectImpl(int,Map)
     is not yet implemented.

Any comments on the current/future ability to use
inet/cdr
types in this way ? I'm guessing I can instead use
PGpoint etc., but
what about inet/cdr ?

Best regards,
--j





____________________________________________________________________________________Ready for the edge of your seat?
Check out tonight's top picks on Yahoo! TV.
http://tv.yahoo.com/

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: ttvvaa
Дата:
Сообщение: JDBC COPY error encoding
Следующее
От: David Goodenough
Дата:
Сообщение: Support for ResultSetMetaData.getTableName