[aerogear-dev] Aerogear Unifiedpush with oracle DB ... longer parameters problems

[Matthias Wessendorf]

perfect, thanks!

On Tue, Feb 24, 2015 at 5:46 PM, Ivan Gürtler <ivan.gurtler at ahead-itec.com>
wrote:

> yes, here it is ... https://issues.jboss.org/browse/AGPUSH-1297 .. is ok ?
>
> *Mgr. Ivan Gürtler*
> Mobile software developer
>
> AHEAD iTec, s.r.o., Botanická 554/68a,
> 602 00 Brno (Czech Republic)
>
> www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> | mobile
> security solutions
>
> 2015-02-24 17:33 GMT+01:00 Matthias Wessendorf <matzew at apache.org>:
>
>> Ivan, btw. can you create a JIRA ticket for this as well  ?
>>
>> Thanks for all the valuable feedback from you guys
>>
>> On Tue, Feb 24, 2015 at 5:29 PM, Matthias Wessendorf <matzew at apache.org>
>> wrote:
>>
>>>
>>>
>>> On Tue, Feb 24, 2015 at 5:17 PM, Ivan Gürtler <
>>> ivan.gurtler at ahead-itec.com> wrote:
>>>
>>>> Hi,
>>>>
>>>> we use aerogear with oracle ... when AG used parameter with length
>>>> longer than 4000 ... for example in table INSTALLATION and parameter
>>>> DEVICETOKEN ... or in master branch ... table IOSVARIANT and parameter
>>>> CERT_DATA .. it becomes problem because oracle has Varchar2 with max length
>>>> 4000 and when parameter is longer it needs LOB ...
>>>>
>>>> We changed in table INSTALLATION parameter DEVICETOKEN as
>>>> VARCHAR2(4000) ... it is temporary solution .. but in IOSVARIANT parameter
>>>> CERT_DATA has length 100000 and it is too large. In version 1.0.x
>>>> certificate was LOB and it was ok for oracle.
>>>>
>>>> Object with large length as CERT_DATA makes it impossible to support
>>>> oracle. Is it possible to keep database schema the way it would support
>>>> oracle??? Or do you have any idea how to support oracle with current schema?
>>>>
>>>
>>> Ok, on last release (1.0.2) is was a byte array:
>>> *
>>> https://github.com/aerogear/aerogear-unifiedpush-server/blob/1.0.2/model/api/src/main/java/org/jboss/aerogear/unifiedpush/api/iOSVariant.java#L40
>>> *
>>> https://github.com/aerogear/aerogear-unifiedpush-server/blob/1.0.2/model/jpa/src/main/resources/META-INF/orm.xml#L66-L68
>>>
>>> but yeah, in this branch it's a string:
>>> *
>>> https://github.com/qmx/aerogear-unified-push-server/blob/certificate_data_changes/model/api/src/main/java/org/jboss/aerogear/unifiedpush/api/iOSVariant.java#L43
>>> *
>>> https://github.com/qmx/aerogear-unified-push-server/blob/certificate_data_changes/model/jpa/src/main/resources/META-INF/orm.xml#L76-L78
>>>
>>> I think there was a Postgres bug that lead us to that implementation:
>>> https://issues.jboss.org/browse/AGPUSH-1144
>>>
>>> But now, since causes some fun on the ORCL side of things ;-(
>>>
>>> Greetings
>>>
>>>
>>>>
>>>> Thanks for help ...
>>>>
>>>>
>>>> *Mgr. Ivan Gürtler*
>>>> Mobile software developer
>>>>
>>>> AHEAD iTec, s.r.o., Botanická 554/68a,
>>>> 602 00 Brno (Czech Republic)
>>>>
>>>> www.ahead-itec.com | twitter <https://www.twitter.com/AHEADiTec> |
>>>> mobile security solutions
>>>>
>>>> _______________________________________________
>>>> aerogear-dev mailing list
>>>> aerogear-dev at lists.jboss.org
>>>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>>>
>>>
>>>
>>>
>>> --
>>> Matthias Wessendorf
>>>
>>> blog: http://matthiaswessendorf.wordpress.com/
>>> sessions: http://www.slideshare.net/mwessendorf
>>> twitter: http://twitter.com/mwessendorf
>>>
>>
>>
>>
>> --
>> Matthias Wessendorf
>>
>> blog: http://matthiaswessendorf.wordpress.com/
>> sessions: http://www.slideshare.net/mwessendorf
>> twitter: http://twitter.com/mwessendorf
>>
>> _______________________________________________
>> aerogear-dev mailing list
>> aerogear-dev at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>>
>
>
> _______________________________________________
> aerogear-dev mailing list
> aerogear-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/aerogear-dev
>



-- 
Matthias Wessendorf

blog: http://matthiaswessendorf.wordpress.com/
sessions: http://www.slideshare.net/mwessendorf
twitter: http://twitter.com/mwessendorf
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20150224/6bc2a160/attachment.html