Thread: 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
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.
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
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
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.
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
Mike
It sounds like a bug, let me get something to you shortly to test.
Thanks!
On Tue, May 21, 2013 at 12:16 PM, Mike O'Toole <mike.otoole@outlook.com> wrote:
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.orgMike,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.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