Re: Sun Java Studio Creator and PostgreSQL

From: Jim Nasby <jim(at)nasby(dot)net>
To: Poul Møller Hansen <freebsd(at)pbnet(dot)dk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Sun Java Studio Creator and PostgreSQL
Date: 2006-09-22 03:43:44
Message-ID: E5C10636-E65A-49AC-9E97-B80817C76A54@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2006-09-22 03:50:20 Re: [GENERAL] Feature request (was psql: absolutes and toggles)
Previous Message mike 2006-09-22 03:42:27 Re: Select Cast Error