Is postgresql 8.xx jdbc support SCROLL_SENSITIVE?

From: Hengki Suhartoyo <hengman03(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is postgresql 8.xx jdbc support SCROLL_SENSITIVE?
Date: 2005-05-19 04:37:17
Message-ID: 20050519043718.15497.qmail@web54305.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all

I have problem with my jdbc program, my java program
can't use TYPE_SCROLL_SENSITIVE.
But I need Sensitive scrollable result.

Can anybody help me?

this is my java test program,

/*
* testRS.java
*
* Created on May 16, 2005, 9:48 PM
*/

import java.sql.*;
public class testRS {

public testRS() {
}

public static void main(String[] args) {
String url =
"jdbc:postgresql://localhost/testDB";
try{
Class.forName("org.postgresql.Driver");


Connection conn =
DriverManager.getConnection(url,"user","xxxxxx");


System.out.println(conn.getMetaData().getDriverName());

System.out.println(conn.getMetaData().getDriverVersion());

if
(conn.getMetaData().supportsResultSetConcurrency(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE))
{
System.out.println("Insensitive
scrollable result sets are supported");
}
if
(conn.getMetaData().supportsResultSetConcurrency(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE))
{
System.out.println("Sensitive
scrollable result sets are supported");
}

} catch(SQLException e) {

System.err.println("-----SQLException-----");
System.err.println("SQLState: " +
e.getSQLState());
System.err.println("Message: " + e.getMessage());
System.err.println("Vendor: " + e.getErrorCode());

} catch(ClassNotFoundException ce) {

System.out.println(ce.getMessage());
}

}

}

And the result always like this:

PostgreSQL Native Driver
PostgreSQL 8.1devel JDBC3 with SSL (build 400)
Insensitive scrollable result sets are supported

Thank You


__________________________________
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/resources/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2005-05-19 04:59:14 Re: Is postgresql 8.xx jdbc support SCROLL_SENSITIVE?
Previous Message Alvaro Herrera 2005-05-19 03:32:40 Re: numeric precision when raising one numeric to another.