Обсуждение: stringtype setting with PGXADataSource

Hello,

I am in the middle of a Oracle to Postgres migration and have some difficulty with properly configuring the XA driver.  I need to set the stringtype=unspecified property, but that seems to be ignored with the XA driver. It seems to work fine with the non-xa driver, but since I am in the middle of this conversion I need to be able to work with the Oracle and Postgres datasources within the same transaction.  

I am using the postgresql-9.2-1002.jdbc4 jar with Weblogic 10.3.  

Thanks, Mike

Thanks Dave,

I built from source but same issue.  Is there a change I can verify in the source to make sure I have the correct version?  Thanks, Mike  

---

From: pg@fastcrypt.com
Date: Tue, 21 May 2013 11:12:49 -0400
Subject: Re: [JDBC] stringtype setting with PGXADataSource
To: mike.otoole@outlook.com
CC: pgsql-jdbc@postgresql.org

Mike,

If you build the jar from source I think it should work. If it doesn't let me know. I want to release a version this week.

If you need me to build the driver, let me know and I'll send you a jar off list.

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca

On Tue, May 21, 2013 at 10:53 AM, Mike O'Toole <mike.otoole@outlook.com> wrote:

Hello,

I am in the middle of a Oracle to Postgres migration and have some difficulty with properly configuring the XA driver.  I need to set the stringtype=unspecified property, but that seems to be ignored with the XA driver. It seems to work fine with the non-xa driver, but since I am in the middle of this conversion I need to be able to work with the Oracle and Postgres datasources within the same transaction.  

I am using the postgresql-9.2-1002.jdbc4 jar with Weblogic 10.3.  

Thanks, Mike