Thread: SQL intervals?

SQL intervals?

From
"Andy Kriger"
Date:
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


Re: SQL intervals?

From
Barry Lind
Date:
Andy,

getString() should work.

--Barry


Andy Kriger wrote:
> 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
>
>
> ---------------------------(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
>