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@xxxxxxxxxxxxxxxx > EnterpriseDB http://enterprisedb.com 512.569.9461 (cell) > > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend
