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/
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. |