Re: Sun Java Studio Creator and PostgreSQL

Hello Poul,
take a look to thread:
http://forum.sun.com/jive/thread.jspa?forumID=123&threadID=101711

It works for me !!! :o))

Mike

Jim Nasby ha scritto:

> 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)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend