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

[Ivan Gürtler]

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?

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/aerogear-dev/attachments/20150224/5b6b4160/attachment.html