Re: Sun Java Studio Creator and PostgreSQL

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@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)