Re: ora2pg - Java Message Service (JMS) Type

From: Julien Rouhaud <julien(dot)rouhaud(at)dalibo(dot)com>
To: Joanna Xu <Joanna(dot)Xu(at)amdocs(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: ora2pg - Java Message Service (JMS) Type
Date: 2016-12-12 18:31:43
Message-ID: 20161212183143.GG14194@nol.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Dec 12, 2016 at 04:15:59PM +0000, Joanna Xu wrote:
> On Fri, Dec 11, 2016 12:43 PM, Julien Rouhaud wrote:
> >>I forwarded your mail to the author, since he's not on this mailing-list. This issue should be fixed with commit >>https://github.com/darold/ora2pg/commit/2c22d377e9f90fa6fa83cfe1fbead9eb3396a0f3.
>
> >>If this bugfix is not enough or if you find other issues, could you report them directly on github (https://github.com/darold/ora2pg/issues)?
> Hi Julien,
> Thanks for looking into the issue.
>
> I tried and updated "Ora2Pg.pm" with the change suggested in https://github.com/darold/ora2pg/commit/2c22d377e9f90fa6fa83cfe1fbead9eb3396a0f3 (add "|TYPE" in the following line) but encountered the same issue "ERROR: type "aq$_jms_text_message" while import the content of the output.sql into PostgreSQL database.
>
> [kll0199:/u01/app/oracle/ora2pg-17.6/lib] egrep "has_limitation" Ora2Pg.pm | egrep -v "has_limitation ="
>
> if (!$self->{is_mysql} && !$has_limitation && ($arr_type[$i] =~ /TABLE|SEQUENCE|VIEW|TRIGGER|TYPE/)) {
>
> At this point, I guess the issue occurred for that particular type "aq$_jms_text_message". So the key question would be : does Postgres database support "aq$_jms_text_message" type? If postgres does not support this type, it will error out. I would need confirmation on this please.
>

Unfortunately I have no idea what's "aq$_jms_text_message" type, but I don't
see any reason why it couldn't be migrated to PostgreSQL. It really seems that
ora2pg miss to migrate this type for some reason, so you should open an issue
on https://github.com/darold/ora2pg/issues. The author will have a better
answer than me on your problem.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dylan Luong 2016-12-13 01:46:45 Re: Install pgAudit extension
Previous Message Joanna Xu 2016-12-12 16:15:59 Re: ora2pg - Java Message Service (JMS) Type