Re: Postgres JDBC-hibernate Problem

Thanks Craig,

We were able to make the necessary adjustments to the way Hibernate manages
the data types differently in version 4.1.6, so we got pass this error. Now
we have to tackle the a problem with the hibernate 4.1.6 batcher process no
longer allowing us to ingest data into the database. We are getting the
"nested transactions not supported error", even though the java developers
are telling me that they have only a single commit at the end of their
logical transaction.

Caused by: org.hibernate.TransactionException: nested transactions not
supported
at
org.hibernate.engine.transaction.spi.AbstractTransactionImpl.begin(AbstractT
ransactionImpl.java:152)
at
org.hibernate.internal.SessionImpl.beginTransaction(SessionImpl.java:1396)
at
im.app.empl.service.ingest.EmployeeWriter.handleEmployeeSegment(EmployeeWrit
er.java:309)
at
im.app.empl.service.ingest.EmployeeWriter$3.onEvent(EmployeeWriter.java:116)
at
im.app.empl.service.ingest.EmployeeWriter$3.onEvent(EmployeeWriter.java:113)
at
org.bushe.swing.event.ThreadSafeEventService.publish(ThreadSafeEventService.
java:971)
... 5 more

-----Original Message-----
From: pgsql-bugs-owner(at)postgresql(dot)org
[mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of Craig Ringer
Sent: Monday, September 17, 2012 12:39 AM
To: Freddie Burgess
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] Postgres JDBC-hibernate Problem

On 09/12/2012 12:18 AM, Freddie Burgess wrote:
> We have upgraded from PostgreSQL 8.4.3 to PostgreSQL 9.1.4 and we are
> getting the following errors when attempting to auto-gen schema DDL.

You've changed quite a bit at once, so it's a bit hard to narrow down.

Does the error occur when you run with the new PgJDBC and PostGIS libraries
against the *old* database server?

What about if you run with the old libraries against the new database
server? This might not work for other reasons, but is worth trying. If it
works, that suggests a regression in PgJDBC or PostGIS's client library.

--
Craig Ringer

--
Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org) To make changes
to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs