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

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 _______________________________________________ aerogear-dev mailing list aerogear-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/aerogear-dev