Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

[12:01:47 CST(-0600)] <EricDalquist> PostgreSQL requires that CLOBs be read inside of a TX

[12:02:09 CST(-0600)] <EricDalquist> so all of the read methods on JpaPortletDefinitionDao and JpaPortletEntityDao are annotated with @Transactional(readOnly=true)

[12:02:15 CST(-0600)] <EricDalquist> you could try removing that annotation

[12:02:18 CST(-0600)] <EricDalquist> and see what happens

[12:02:28 CST(-0600)] <EricDalquist> it could be that the read-only TX is simply too expensive on MSSQL

[12:02:42 CST(-0600)] <EricDalquist> which means we would have to do a little work to only have that TX functionality for postgres

[12:02:44 CST(-0600)] <EricDalquist> which is doable

[12:02:46 CST(-0600)] <EricDalquist> just annoying (tongue)

[12:03:04 CST(-0600)] <Arvids> but the strange thing is that I also ran MSSQL profiler and each commit executes in 0-1ms