From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
Subject: | pg_locks.transaction field type |
Date: | 2005-08-18 03:05:25 |
Message-ID: | de0ttl$l7g$1@news.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-jdbc |
I have a method in my rmi server that takes a query and returns an
Object[][]. I had this query:
SELECT (select relname from pg_catalog.pg_class where relfilenode =
relation) as relname, * FROM pg_locks;
After upgrading from 7.4 to 8.0 I was getting this problem:
WARNING: Servlet.service() for servlet jsp threw exception
java.rmi.UnmarshalException: error unmarshalling return; nested
exception is:
java.lang.ClassNotFoundException: org.postgresql.util.PGobject
(no security manager: RMI class loader disabled)
The problem seems to be the "transaction" field. It looks like a number
type, but I can't really tell because "\d pg_catalog" doesn't work in psql.
So what's the difference between 7.4.7 and 8.0.3? Is it that 7.4.7
never returned anything in the transaction field? Is it a jdbc bug that
is returning the answer as org.postgresql.util.PGobject instead of some
kind of Number?
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-08-18 03:27:33 | Re: [JDBC] pg_locks.transaction field type |
Previous Message | Premsun Choltanwanich | 2005-08-18 02:56:49 | How to secure PostgreSQL Data for distribute? |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Jowett | 2005-08-18 03:27:33 | Re: [JDBC] pg_locks.transaction field type |
Previous Message | Oliver Jowett | 2005-08-17 23:49:39 | Re: java.sql.SQLException: ERROR: canceling query due to user |