Re: contrib/ltree

From: Barry Lind <blind(at)xythos(dot)com>
To: floyds(at)4peakstech(dot)com
Cc: Pgsql-Sql <pgsql-sql(at)postgresql(dot)org>, Pgsql-Jdbc <pgsql-jdbc(at)postgresql(dot)org>, "Gregory S(dot) Dodson" <greg(at)truckmaster(dot)com>, Josh Wardle <josh(at)truckmaster(dot)com>
Subject: Re: contrib/ltree
Date: 2003-09-10 00:27:52
Message-ID: 3F5E7008.9050904@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-sql

I would recommend using getString()/setString(). You will need to
marshall the data into the correct format, but you will at least be able
to get and set the values.

--Barry

floyds(at)4peakstech(dot)com wrote:
> how do i get jdbc to recognize the ltree type that comes with the
> contrib/ltree extension?
>
> This:
>
> Object object = resultSet.getObject(columnNumber);
>
> generates the following exception:
>
> Exception caused by: No class found for ltree
> at
> org.postgresql.jdbc1.AbstractJdbc1Connection.getObject(AbstractJdbc1Connecti
> on.java:693)
> at
> org.postgresql.jdbc2.AbstractJdbc2Connection.getObject(AbstractJdbc2Connecti
> on.java:117)
> at
> org.postgresql.jdbc2.AbstractJdbc2ResultSet.getObject(AbstractJdbc2ResultSet
> .java:147)
> ...
>
>
> Regards,
>
> Floyd Shackelford
> 4 Peaks Technology Group, Inc.
> VOICE: 334.735.9428
> FAX: 702.995.6462
> EMAIL: FloydS(at)4PeaksTech(dot)com
> ICQ #: 161371538
> PGP Key ID: 0x2E84F2F2
> PGP Fone available on request at private.fwshackelford.com
>
> Shackelford Motto: ACTA NON VERBA - Actions, not words
>
> Alabama State Motto: AUDEMUS JURA NOSTRA DEFENDERE - We Dare Defend Our
> Rights
>
> The Philosophy of Liberty: http://www.isil.org/resources/introduction.swf
>
> "We have allowed our constitutional republic to deteriorate into a virtually
> unchecked direct democracy. Today's political process is nothing more than a
> street fight between various groups seeking to vote themselves other
> people's money. Individual voters tend to support the candidate that
> promises them the most federal loot in whatever form, rather than the
> candidate who will uphold the rule of law." --Rep. Ron Paul
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Shilad Sen 2003-09-10 05:27:22 Strange encoding problems
Previous Message Paul Thomas 2003-09-09 18:01:15 Re: JBoss w/int8 primary keys in postgres ...

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2003-09-10 01:56:31 Re: [HACKERS] plpgsql doesn't coerce boolean expressions to boolean
Previous Message Roberto João Lopes Garcia 2003-09-09 21:56:58 Test, please ignore