<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Feb 24, 2015 at 5:17 PM, Ivan Gürtler <span dir="ltr"><<a href="mailto:ivan.gurtler@ahead-itec.com" target="_blank">ivan.gurtler@ahead-itec.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div>Hi, </div><div><br></div><div>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 ... </div><div><br></div><div>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.</div><div><br></div><div>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?</div></div></blockquote><div><br></div><div>Ok, on last release (1.0.2) is was a byte array:</div><div>* <a href="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/api/src/main/java/org/jboss/aerogear/unifiedpush/api/iOSVariant.java#L40</a></div><div>* <a href="https://github.com/aerogear/aerogear-unifiedpush-server/blob/1.0.2/model/jpa/src/main/resources/META-INF/orm.xml#L66-L68">https://github.com/aerogear/aerogear-unifiedpush-server/blob/1.0.2/model/jpa/src/main/resources/META-INF/orm.xml#L66-L68</a><br></div><div><br></div><div>but yeah, in this branch it's a string:</div><div>* <a href="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/api/src/main/java/org/jboss/aerogear/unifiedpush/api/iOSVariant.java#L43</a><br></div><div>* <a href="https://github.com/qmx/aerogear-unified-push-server/blob/certificate_data_changes/model/jpa/src/main/resources/META-INF/orm.xml#L76-L78">https://github.com/qmx/aerogear-unified-push-server/blob/certificate_data_changes/model/jpa/src/main/resources/META-INF/orm.xml#L76-L78</a><br></div><div><br></div><div>I think there was a Postgres bug that lead us to that implementation:</div><div><a href="https://issues.jboss.org/browse/AGPUSH-1144">https://issues.jboss.org/browse/AGPUSH-1144</a><br></div><div><br></div><div>But now, since causes some fun on the ORCL side of things ;-(</div><div><br></div><div>Greetings</div><div> </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div><br></div><div>Thanks for help ...</div><div><br></div><br clear="all"><div><div><div dir="ltr"><div><span style="color:rgb(7,55,99)"><b>Mgr. Ivan Gürtler</b></span><br></div><span style="color:rgb(102,102,102)">Mobile software developer</span><br><br>AHEAD iTec, s.r.o., Botanická 554/68a,<br>602 00 Brno (Czech Republic)<br><br><a href="http://www.ahead-itec.com/" style="color:rgb(17,85,204)" target="_blank">www.ahead-itec.com</a> | <a href="https://www.twitter.com/AHEADiTec" style="color:rgb(17,85,204)" target="_blank">twitter</a> | mobile security solutions<br></div></div></div>
</div>
<br>_______________________________________________<br>
aerogear-dev mailing list<br>
<a href="mailto:aerogear-dev@lists.jboss.org">aerogear-dev@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/aerogear-dev" target="_blank">https://lists.jboss.org/mailman/listinfo/aerogear-dev</a><br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature">Matthias Wessendorf <br><br>blog: <a href="http://matthiaswessendorf.wordpress.com/" target="_blank">http://matthiaswessendorf.wordpress.com/</a><br>sessions: <a href="http://www.slideshare.net/mwessendorf" target="_blank">http://www.slideshare.net/mwessendorf</a><br>twitter: <a href="http://twitter.com/mwessendorf" target="_blank">http://twitter.com/mwessendorf</a></div>
</div></div>