Home > Archive > PostgreSQL JDBC > April 2005 > getTransactionIsolation() causes SQLException - unrecognized configuration parameter xactisolevel









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author getTransactionIsolation() causes SQLException - unrecognized configuration parameter xactisolevel
Paul Marchant

2005-04-04, 8:05 pm

Setup: Postgres 8.0.1 & postgresql-8.0-310.jdbc3.jar

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

try {
Class.forName("org.postgresql.Driver");
} catch (ClassNotFoundExcept
ion 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. getTransactionIsolat
ion() = " +
con. getTransactionIsolat
ion());
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. setTransactionIsolat
ion()

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. getTransactionIsolat
ion() is
halting my progress.

Any help would be greatly appreciated.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Paul Marchant

2005-04-05, 8:06 pm

Thanks for the suggestions. I ran your code and it was a driver issue
after all. Eclipse was somehow finding a 7.3 version of driver on my
system. I have since expunged any files possible of causing the
conflict.

---------------------------(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

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com