<div dir="ltr">Hi, we just loaded images from MSSQL Image column via scripted SQL adapter and found no issue in transforming the value. M.<div><br></div><div><b>connector groovy search operation code fragment:</b></div><div>byte[] image;<br></div><div><div>image = ((it.Image==null || (it.Image).length>125000)? null : /*Base64.getEncoder().encode(*/it.Image/*)*/);</div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span></div></div><div><br></div><div><b>Resource XML:</b></div><div><br></div><div><div><xsd:element minOccurs="0" name="Image" type="xsd:base64Binary"></div><div> <xsd:annotation></div><div> <xsd:appinfo></div><div> <a:displayOrder>220</a:displayOrder></div><div> <ra:frameworkAttributeName>Image</ra:frameworkAttributeName></div><div> </xsd:appinfo></div><div> </xsd:annotation></div><div> </xsd:element></div></div><div><br></div><div>...</div><div><br></div><div><div><attribute></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> <ref>ri:Image</ref></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> <outbound></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> <strength>strong</strength></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> <source></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> <c:path>$focus/jpegPhoto</c:path></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> </source></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> </outbound></div><div><span class="gmail-Apple-tab-span" style="white-space:pre"> </span> </attribute></div></div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><table style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="2" style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray!important"><p><span style="font-size:14px;font-weight:bold">Martin Lízner</span><br>solution architect<br><br>gsm: [+420] 737 745 571<br>e-mail: <a href="mailto:martin.lizner@ami.cz" target="_blank">martin.lizner@ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;vertical-align:bottom;padding:0px;border:0px solid gray!important"><p>AMI Praha a.s.<br>Pláničkova 11<br>162 00 Praha 6<br>tel.: [+420] 274 783 239<br>web: <a href="http://www.ami.cz/" target="_blank">www.ami.cz</a></p></td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);padding:0px;border-top-width:0px!important;border-bottom-width:0px!important;border-left-width:0px!important;border-top-style:solid!important;border-bottom-style:solid!important;border-left-style:solid!important;border-top-color:gray!important;border-bottom-color:gray!important;border-left-color:gray!important"> </td><td style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"> </td><td style="color:rgb(0,0,0);font-family:Arial,sans-serif;font-size:11px;margin:8px;border:0px solid gray!important"><p><img src="http://www.ami.cz/images/podpis/ami_logo.gif" alt="" style="border:0px"></p></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="8" style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;border:0px solid gray!important"></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="8" style="color:rgb(128,128,128);font-family:Arial,sans-serif;font-size:11px;padding:0px;border:0px solid gray!important"><table style="font-family:Verdana,Arial,Helvetica,sans-serif;border-collapse:collapse;padding:0px;margin:0px;border-width:0px!important;border-style:solid!important;width:482px!important"><tbody><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="color:rgb(0,0,0);font-family:Verdana,Arial,Helvetica,sans-serif;font-size:10px;padding:0px;width:480px;border:0px solid gray!important"><br><a href="http://www.skyidentity.com/" target="_blank"><img src="http://www.ami.cz/images/podpis/AMI-podpis-Sky.png" alt="AMI Praha a.s." style="border:0px;width:480px!important;height:82px!important"></a></td></tr><tr style="padding:0px;margin:0px;border:0px solid gray!important"><td colspan="7" style="font-family:Arial,sans-serif;padding:0px;border:0px solid gray!important"><br></td></tr></tbody></table>Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za společnost AMI Praha a.s.<br>jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně písemnou formu.</td></tr></tbody></table></div><br></div></div></div></div></div></div></div></div></div>
<br><div class="gmail_quote">2017-01-08 16:54 GMT+01:00 Wojciech Staszewski <span dir="ltr"><<a href="mailto:wojciech.staszewski@diagnostyka.pl" target="_blank">wojciech.staszewski@diagnostyka.pl</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello!<br>
<br>
Anything about that? I stuck here... and this is something what I really need... :(<br>
<br>
Thank you!<br>
Best regards,<br>
WS<br>
<br>
Dnia sobota, 31 grudnia 2016 23:41:29 CET Wojciech Staszewski pisze:<br>
<div class="HOEnZb"><div class="h5">> Hi....<br>
><br>
> The image (binary) attribute in my ScriptedSQL resource drives me crazy...<br>
> What I did:<br>
><br>
> Custom schema extension:<br>
> <xsd:element name="stamp" type="xsd:base64Binary" minOccurs="0"><br>
> <xsd:annotation><br>
> <xsd:appinfo><br>
> <a:indexed>true</a:indexed><br>
> <a:displayName>User stamp</a:displayName><br>
> <a:displayOrder>370</a:<wbr>displayOrder><br>
> </xsd:appinfo><br>
> </xsd:annotation><br>
> </xsd:element><br>
><br>
> SchemaScript.groovy:<br>
> account.addAttributeInfo(<wbr>AttributeInfoBuilder.build("<wbr>userstamp", byte[].class));<br>
><br>
> SearchScript.groovy:<br>
> def stampquery = "select u.stamp from users u" + where;<br>
> row = sql.firstRow(stampquery);<br>
> stamp_blob = (oracle.sql.BLOB)row[0];<br>
> stamp = stamp_blob.getBinaryStream().<wbr>getBytes();<br>
><br>
> Midpoint GUI: My ScriptedSQL Resource->Accounts->Resource-><wbr>click on some user<br>
> I see the user stamp attribute, I can download it and open correctly in image viewer.<br>
><br>
> I made inbound mapping userstamp -> extension/stamp<br>
> but reconciliation gives me error:<br>
><br>
> ERROR (com.evolveum.midpoint.web.<wbr>component.progress.<wbr>ProgressReporter): Error executing changes.<br>
> com.evolveum.midpoint.util.<wbr>exception.SchemaException: Exception when translating PP({<a href="http://midpoint.evolveum.com/xml/ns/story/unix-1}stamp):[PPV(byte[]:byte[-1,-40,-1,-32,0,16,74,70,73,70,0,1,1,1,0,0,0,0,0,0,-1,-37,0,67,0,9,6,7,19,19,18,21,19,18,18,22,22,21,22,23,23,23,25,24,21,25,21,24,24,27,26,26,29,29,23,23,29,26,25,24,30,40,32,25,,." rel="noreferrer" target="_blank">http://midpoint.evolveum.<wbr>com/xml/ns/story/unix-1}stamp)<wbr>:[PPV(byte[]:byte[-1,-40,-1,-<wbr>32,0,16,74,70,73,70,0,1,1,1,0,<wbr>0,0,0,0,0,-1,-37,0,67,0,9,6,7,<wbr>19,19,18,21,19,18,18,22,22,21,<wbr>22,23,23,23,25,24,21,25,21,24,<wbr>24,27,26,26,29,29,23,23,29,26,<wbr>25,24,30,40,32,25,,.</a>.. 10849 bytes total])]: Can't extract value for saving from prism property value<br>
> PPV(byte[]:byte[-1,-40,-1,-32,<wbr>0,16,74,70,73,70,0,1,1,1,0,0,<wbr>0,0,0,0,-1,-37,0,67,0,9,6,7,<wbr>19,19,18,21,19,18,18,22,22,21,<wbr>22,23,23,23,25,24,21,25,21,24,<wbr>24,27,26,26,29,29,23,23,29,26,<wbr>25,24,30,40,32,25,,... 10849 bytes total])<br>
><br>
> ***** What attribute types should I use for image attribute? In schema extension is base64Binary, on resource byte[], I suspect is something wrong here ;( ******<br>
><br>
> I know, I'm workaholic...<br>
> Happy New Year!!!!<br>
> ______________________________<wbr>_________________<br>
> midPoint mailing list<br>
> <a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
> <a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/<wbr>mailman/listinfo/midpoint</a><br>
><br>
______________________________<wbr>_________________<br>
midPoint mailing list<br>
<a href="mailto:midPoint@lists.evolveum.com">midPoint@lists.evolveum.com</a><br>
<a href="http://lists.evolveum.com/mailman/listinfo/midpoint" rel="noreferrer" target="_blank">http://lists.evolveum.com/<wbr>mailman/listinfo/midpoint</a><br>
</div></div></blockquote></div><br></div>