| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: XA transaction -- Linux v Windows |
| Date: | 2014-07-30 20:52:38 |
| Message-ID: | 53D95B16.4060603@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On 7/30/2014 1:42 PM, Dennis Gesker wrote:
> I have an application running in Glassfish using the 9.3-1102 JDBC 41
> driver against pgsql 9.3. The install on Linux (Ubuntu) is installed
> using the default configuration. Everything runs smoothly.
>
> I installed pgsql 9.3 on my Windows 8.1 workstation (again default
> install) but I get errors similar to:
> ...
> Caused by: org.postgresql.util.PSQLException: ERROR: prepared
> transaction with identifier
> "4871251_BgAAAEfR84hkcmdXb3Jrc3RhdGlvbixzZXJ2ZXIsUDEwMA==_ZHJnV29ya3N0YXRpb24sc2VydmVyLFAxMDAsAQ=="
> does not exist
> [snip]
what is max_prepared_transactions on both servers?
test=# show max_prepared_transactions ;
max_prepared_transactions
---------------------------
0
(1 row)
I believe 0 disables server-side prepared transactions.
--
john r pierce 37N 122W
somewhere on the middle of the left coast
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gesker | 2014-07-30 21:15:10 | Re: XA transaction -- Linux v Windows |
| Previous Message | Dennis Gesker | 2014-07-30 20:42:52 | XA transaction -- Linux v Windows |