You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@qpid.apache.org by VERMEULEN Olivier <Ol...@murex.com> on 2018/06/26 11:33:03 UTC
[Broker-J] JDBC configuration store with Oracle
Hello,
I have a problem with the 'JDBC' configuration store when using Oracle.
In this mode the Broker creates a table named 'QPID_CONFIGURED_OBJECT_HIERARCHY'.
The problem is that this name is already 32 characters long while Oracle (before version 12c R2) has a limit of 30 characters.
Would it be possible to shorten the name of the table? enough to also be able to use the table name prefix feature...
Thanks,
Olivier
*******************************
This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
Re: [Broker-J] JDBC configuration store with Oracle
Posted by Oleksandr Rudyy <or...@gmail.com>.
Hi Olivier,
I attached a patch reducing the sizes of jdbc configuration store
table names to JIRA QPID-8214.
I only tested it against Derby and MariaDB. I do hope it should work
with Oracle as well.
Kind Regards,
Alex
On 27 June 2018 at 13:32, VERMEULEN Olivier <Ol...@murex.com> wrote:
> Thanks Alex.
> QPID-8214 created.
>
> Olivier
>
> -----Original Message-----
> From: Oleksandr Rudyy <or...@gmail.com>
> Sent: mercredi 27 juin 2018 12:04
> To: users@qpid.apache.org
> Subject: Re: [Broker-J] JDBC configuration store with Oracle
>
> Hi Olivier,
>
> Please raise an improvement JIRA about it. I'll try to look into it.
>
> Kind Regards,
> Alex
>
> On 26 June 2018 at 12:33, VERMEULEN Olivier <Ol...@murex.com> wrote:
>> Hello,
>>
>> I have a problem with the 'JDBC' configuration store when using Oracle.
>> In this mode the Broker creates a table named 'QPID_CONFIGURED_OBJECT_HIERARCHY'.
>> The problem is that this name is already 32 characters long while Oracle (before version 12c R2) has a limit of 30 characters.
>> Would it be possible to shorten the name of the table? enough to also be able to use the table name prefix feature...
>>
>> Thanks,
>> Olivier
>>
>> *******************************
>>
>> This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org For additional commands, e-mail: users-help@qpid.apache.org
>
> *******************************
>
> This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org
> For additional commands, e-mail: users-help@qpid.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org
For additional commands, e-mail: users-help@qpid.apache.org
RE: [Broker-J] JDBC configuration store with Oracle
Posted by VERMEULEN Olivier <Ol...@murex.com>.
Thanks Alex.
QPID-8214 created.
Olivier
-----Original Message-----
From: Oleksandr Rudyy <or...@gmail.com>
Sent: mercredi 27 juin 2018 12:04
To: users@qpid.apache.org
Subject: Re: [Broker-J] JDBC configuration store with Oracle
Hi Olivier,
Please raise an improvement JIRA about it. I'll try to look into it.
Kind Regards,
Alex
On 26 June 2018 at 12:33, VERMEULEN Olivier <Ol...@murex.com> wrote:
> Hello,
>
> I have a problem with the 'JDBC' configuration store when using Oracle.
> In this mode the Broker creates a table named 'QPID_CONFIGURED_OBJECT_HIERARCHY'.
> The problem is that this name is already 32 characters long while Oracle (before version 12c R2) has a limit of 30 characters.
> Would it be possible to shorten the name of the table? enough to also be able to use the table name prefix feature...
>
> Thanks,
> Olivier
>
> *******************************
>
> This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org For additional commands, e-mail: users-help@qpid.apache.org
*******************************
This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org
For additional commands, e-mail: users-help@qpid.apache.org
Re: [Broker-J] JDBC configuration store with Oracle
Posted by Oleksandr Rudyy <or...@gmail.com>.
Hi Olivier,
Please raise an improvement JIRA about it. I'll try to look into it.
Kind Regards,
Alex
On 26 June 2018 at 12:33, VERMEULEN Olivier <Ol...@murex.com> wrote:
> Hello,
>
> I have a problem with the 'JDBC' configuration store when using Oracle.
> In this mode the Broker creates a table named 'QPID_CONFIGURED_OBJECT_HIERARCHY'.
> The problem is that this name is already 32 characters long while Oracle (before version 12c R2) has a limit of 30 characters.
> Would it be possible to shorten the name of the table? enough to also be able to use the table name prefix feature...
>
> Thanks,
> Olivier
>
> *******************************
>
> This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intended recipient you are not authorised to distribute, copy or use this e-mail or any attachment to it. Murex cannot guarantee that it is virus free and accepts no responsibility for any loss or damage arising from its use. If you have received this e-mail in error please notify immediately the sender and delete the original email received, any attachments and all copies from your system.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@qpid.apache.org
For additional commands, e-mail: users-help@qpid.apache.org