On Sep 14, 2006, at 4:40 PM, Poul Møller Hansen wrote:
I have some troubles getting Sun Java Studio Creator & Sun Java
Application Server to work with
PostgreSQL.
Trying different syntaxes for the SQL statement (schema or no
schema) in the session bean
I get either the error: "No columns in table: pmh.tablename" or
"Cannot change transaction isolation level in the middle of a
transaction"
when trying to delete, insert or update rows. Selecting is ok.
The application works fine when using an Apache Derby database, so
the problem is related to PostgreSQL
I can see several postings on other mailing lists with the same
problem, but haven's found any solution.
Just because it works with Derby doesn't mean it's PostgreSQL's
fault. There's plenty of things that "work" in certain databases that
really shouldn't.
In any case, you might try asking on pgsql-jdbc, since there's more
java-heads over there. I'd also recommend turning query logging on so
you can see exactly what commands are being sent to the server.
--
Jim Nasby jimn@xxxxxxxxxxxxxxxx
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
