Thread: Pg 7.4.2, jdbc 7.4, data type inet

Pg 7.4.2, jdbc 7.4, data type inet

From
"amo99@libero.it"
Date:
Hi,
I've tried following three drivers with postgresql v. 7.4.2:

  - pg74.213.jdbc3.jar
  - pg74.214.jdbc3.jar
  - pg74jdbc3-kmacclay.jar

All those drivers return null asking data of type inet.

The table structure is:

-----------------------------------------------------------------------------------------------------
psql-start
<db_name>=# \d host
                                             Table "public.host"
      Column       |            Type             |                         Modifiers
-------------------+-----------------------------+-----------------------------------------------------------
 id_host           | integer                     | not null default
nextval('public.host_id_host_seq'::text)
 address           | inet                        | not null
 nome              | character varying(60)       | not null
 descrizione       | character varying(500)      |
 data_assegnazione | timestamp without time zone | not null
Indexes: host_pkey primary key btree (id_host)
-----------------------------------------------------------------------------------------------------
psql-end

Driver pg73jdbc3.jar returns correct values.

Thanks




Re: Pg 7.4.2, jdbc 7.4, data type inet

From
Kris Jurka
Date:

On Fri, 18 Jun 2004, amo99@libero.it wrote:

> Hi,
> I've tried following three drivers with postgresql v. 7.4.2:
> All those drivers return null asking data of type inet.
>

Could you be more clear on how you want the results and how you are
calling them?  With the attached test case I see the following behavior in
different driver versions:

pg73jdbc3.jar
192.168.3.1
Exception in thread "main" No class found for inet
        at
org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connection.java:693)
        at
org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connection.java:117)
        at
org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet.java:147)
        at InetTest.main(InetTest.java:16)

pg74.214.jdbc3.jar
192.168.3.1
null


pgdev.302.jdbc3.jar
192.168.3.1
192.168.3.1

Kris Jurka

Attachment