X-Original-To: pgsql-jdbc-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id E6DAAD1B513; Wed, 10 Sep 2003 05:14:18 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 81047-01; Wed, 10 Sep 2003 02:13:47 -0300 (ADT) Received: from mail.xythos.com (unknown [206.14.210.116]) by svr1.postgresql.org (Postfix) with ESMTP id 67B54D1B50D; Wed, 10 Sep 2003 02:13:46 -0300 (ADT) Received: from ravms by mail.xythos.com with mail-ok (Exim 3.36 #3) id 19wxIV-0002rk-00; Wed, 10 Sep 2003 05:13:43 +0000 Received: from h-66-166-17-184.snvacaid.covad.net ([66.166.17.184] helo=xythos.com) by mail.xythos.com with asmtp (Exim 3.36 #3) id 19wxIU-0002rN-00; Wed, 10 Sep 2003 05:13:42 +0000 Message-ID: <3F5E7008.9050904@xythos.com> Date: Tue, 09 Sep 2003 17:27:52 -0700 From: Barry Lind User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.2.1) Gecko/20030225 X-Accept-Language: en-us, en MIME-Version: 1.0 To: floyds@4peakstech.com Cc: Pgsql-Sql , Pgsql-Jdbc , "Gregory S. Dodson" , Josh Wardle Subject: Re: contrib/ltree References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Envelope-To: floyds@4peakstech.com, pgsql-sql@postgresql.org, pgsql-jdbc@postgresql.org, greg@truckmaster.com, josh@truckmaster.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/98 X-Sequence-Number: 8241 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@4peakstech.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@4PeaksTech.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 >