getTransactionIsolation() causes SQLException - unrecognized configuration parameter xactisolevel

Поиск
Список
Период
Сортировка
От Paul Marchant
Тема getTransactionIsolation() causes SQLException - unrecognized configuration parameter xactisolevel
Дата
Msg-id 10c02a2505040416043f1e2ab1@mail.gmail.com
обсуждение исходный текст
Ответы Re: getTransactionIsolation() causes SQLException - unrecognized  (Kris Jurka <books@ejurka.com>)
Re: getTransactionIsolation() causes SQLException - unrecognized  (Oliver Jowett <oliver@opencloud.com>)
Re: getTransactionIsolation() causes SQLException - unrecognized configuration parameter xactisolevel  (Paul Marchant <pmarchant@gmail.com>)
Список pgsql-jdbc
Setup: Postgres 8.0.1 & postgresql-8.0-310.jdbc3.jar

The following code:
---------------------------

try {
    Class.forName("org.postgresql.Driver");
} catch (ClassNotFoundException e) {
    System.out.println(e);
}

String url = "jdbc:postgresql://dbserver/test";
Properties p = new Properties();
p.setProperty("user", "test");
p.setProperty("password", "test");

Connection con;
try {
    con = DriverManager.getConnection(url, p);
    System.out.println("con.getTransactionIsolation() = " +
con.getTransactionIsolation());
    con.close();
} catch (SQLException e) {
  System.out.println(e);
}

Produces this:
---------------------
java.sql.SQLException: ERROR:  unrecognized configuration parameter
"xactisolevel"

I've tried:
------------
1.) configuring the default_transaction_isolation parameter in postgresql.conf
2.) setting it programattically via con.setTransactionIsolation()

and now I'm stuck.  I really don't care what the transaction isolation
level is.  I'm trying to use Postgres 8.0 as a backend database for
Hibernate and org.postgresql.Driver.getTransactionIsolation() is
halting my progress.

Any help would be greatly appreciated.

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Kris Jurka
Дата:
Сообщение: Re: JDBC and transactions
Следующее
От: "Benjamin W. Fisher"
Дата:
Сообщение: JBuilder Question