Thread: "No class found for inet"
I'm using the PostgreSQL 7.1.1 JDBC2 Enterprise driver, compiled
myself on Solaris 8 with the 1.3 JDK.
I'm trying to access a column of the PostgreSQL datatype 'inet'.
When my program gets to the 'inet' field:
rs.getObject(3);
it fails with the exception "no class found for inet".
Does the JDBC driver support all PostgreSQL data types?
--
Larry Mulcahy lmulcahy@qip.qwest.net
PGP public key at:
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x2C4C5A03
No, the driver wouldn't be able to handle inet type. This is postgres specific, and isn't supported by the JDBC spec. Dave ----- Original Message ----- From: "Larry Mulcahy" <lmulcahy@qip.qwest.net> To: <pgsql-jdbc@postgresql.org> Sent: Wednesday, May 30, 2001 1:22 PM Subject: [JDBC] "No class found for inet" > I'm using the PostgreSQL 7.1.1 JDBC2 Enterprise driver, compiled > myself on Solaris 8 with the 1.3 JDK. > > I'm trying to access a column of the PostgreSQL datatype 'inet'. > When my program gets to the 'inet' field: > > rs.getObject(3); > > it fails with the exception "no class found for inet". > Does the JDBC driver support all PostgreSQL data types? > > -- > Larry Mulcahy lmulcahy@qip.qwest.net > PGP public key at: > http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x2C4C5A03 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
Weird, I tried using rs.getString() instead of rs.getObject() and
it seems to be working OK now.
Dave Cramer wrote:
>
> No, the driver wouldn't be able to handle inet type.
>
> This is postgres specific, and isn't supported by the JDBC spec.
>
> Dave
> ----- Original Message -----
> From: "Larry Mulcahy" <lmulcahy@qip.qwest.net>
> To: <pgsql-jdbc@postgresql.org>
> Sent: Wednesday, May 30, 2001 1:22 PM
> Subject: [JDBC] "No class found for inet"
>
> > I'm using the PostgreSQL 7.1.1 JDBC2 Enterprise driver, compiled
> > myself on Solaris 8 with the 1.3 JDK.
> >
> > I'm trying to access a column of the PostgreSQL datatype 'inet'.
> > When my program gets to the 'inet' field:
> >
> > rs.getObject(3);
> >
> > it fails with the exception "no class found for inet".
> > Does the JDBC driver support all PostgreSQL data types?
--
Larry Mulcahy lmulcahy@qip.qwest.net
PGP public key at:
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x2C4C5A03
> Weird, I tried using rs.getString() instead of rs.getObject() and > it seems to be working OK now. Well, sort of. It is a string now and not a real IP address, but that may be fine for you. PostgreSQL transfers fields to clients as character strings. > > Dave Cramer wrote: > > > > No, the driver wouldn't be able to handle inet type. > > > > This is postgres specific, and isn't supported by the JDBC spec. > > > > Dave > > ----- Original Message ----- > > From: "Larry Mulcahy" <lmulcahy@qip.qwest.net> > > To: <pgsql-jdbc@postgresql.org> > > Sent: Wednesday, May 30, 2001 1:22 PM > > Subject: [JDBC] "No class found for inet" > > > > > I'm using the PostgreSQL 7.1.1 JDBC2 Enterprise driver, compiled > > > myself on Solaris 8 with the 1.3 JDK. > > > > > > I'm trying to access a column of the PostgreSQL datatype 'inet'. > > > When my program gets to the 'inet' field: > > > > > > rs.getObject(3); > > > > > > it fails with the exception "no class found for inet". > > > Does the JDBC driver support all PostgreSQL data types? > > -- > Larry Mulcahy lmulcahy@qip.qwest.net > PGP public key at: > http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x2C4C5A03 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026