SQL intervals?

From: "Andy Kriger" <akriger(at)greaterthanone(dot)com>
To: "Pgsql-Jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: SQL intervals?
Date: 2003-03-21 17:29:22
Message-ID: OJEFIHHAALOBKKJEOMBDCEAJDNAA.akriger@greaterthanone.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Is there any way to retrieve a SQL interval type using JDBC?

When I try I get...
No class found for interval
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)
at com.gto.db.TableMapProcessor.process(TableMapProcessor.java:38)
at com.gto.db.SqlProcessor.executeQuery(SqlProcessor.java:73)
at com.gto.db.SqlProcessor.executeQuery(SqlProcessor.java:40)
at _web._timetest__jsp._jspService(_timetest__jsp.java:31)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at
com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:312)
at
com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at
com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272
)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:536)

I'm using driver version 107. Any chance this can be fixed in a future
driver version?

thx
andy

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-03-21 20:46:54 Re: SQL intervals?
Previous Message David Hooker 2003-03-20 17:46:41 Re: Problem with updateRow()