Android Question Encode Base64 with StringUtils

[dhernandez]

Good morning colleagues forum ...
I have an Image already stored in my phone's sqlite as blob field.
I want to remove it and pass it to another database (remote MySQL), but here I read that to remove it had to encrypt it to Base64, then what and when I code my application running. I make this:

Sub Copiar_Local_a_MySQL
Dim GetImagen() As Byte
    Dim NombreImagen As String
    Dim SU As StringUtils
    Dim ImagenCod As Int
CURSOR1=SQL1.ExecQuery("SELECT * FROM Imagen")
        For i =0 To CURSOR1.ColumnCount -1
            CURSOR1.Position = i
            NombreImagen=CURSOR1.GetString("OCR_I")
            GetImagen=CURSOR1.GetBlob("FotoEvidnc")
            ImagenCod=SU.EncodeBase64(GetImagen)
ExecuteRemoteQuery("INSERT INTO evidenciaext(ORC_I, FotoEvidencia) VALUES ('"& NombreImagen &"', '"& ImagenCod &"')",LISTA_INSPECCION)

Next 
         
End Sub

How to correct this??

Sorry, my English is not very good

Sorry... this my error...

LogCat connected to: emulator-5554
** Activity (main) Create, isFirst = true **


** Activity (main) Resume **


80


main_copiar_local_a_mysql (B4A line: 705)


Observacioness=CURSOR1.GetString("Observaciones")
android.database.CursorIndexOutOfBoundsException: Index 8 requested, with a size of 8


    at android.database.AbstractCursor.checkPosition(AbstractCursor.java:424)
    at android.database.AbstractWindowedCursor.checkPosition(AbstractWindowedCursor.java:136)
    at android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:50)
    at anywheresoftware.b4a.sql.SQL$CursorWrapper.GetString(SQL.java:355)
    at b4a.example.main._copiar_local_a_mysql(main.java:1638)
    at b4a.example.main._btnguardarinfo_click(main.java:1308)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:525)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:169)
    at anywheresoftware.b4a.BA.raiseEvent2(BA.java:157)
    at anywheresoftware.b4a.BA.raiseEvent(BA.java:153)
    at anywheresoftware.b4a.objects.ViewWrapper$1.onClick(ViewWrapper.java:63)
    at android.view.View.performClick(View.java:4240)
    at android.view.View$PerformClick.run(View.java:17721)
    at android.os.Handler.handleCallback(Handler.java:730)
    at android.os.Handler.dispatchMessage(Handler.java:92)
    at android.os.Looper.loop(Looper.java:137)
    at android.app.ActivityThread.main(ActivityThread.java:5103)
    at java.lang.reflect.Method.invokeNative(Native Method)
    at java.lang.reflect.Method.invoke(Method.java:525)
    at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:737)
    at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:553)
    at dalvik.system.NativeStart.main(Native Method)
startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


startService: class anywheresoftware.b4a.samples.httputils2.httputils2service


sending message to waiting queue of uninitialized activity (submitjob)


sending message to waiting queue of uninitialized activity (submitjob)


sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)


sending message to waiting queue of uninitialized activity (submitjob)


sending message to waiting queue of uninitialized activity (submitjob)
sending message to waiting queue of uninitialized activity (submitjob)
** Service (httputils2service) Create **


** Service (httputils2service) Start **


** Service (httputils2service) Start **


** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **
** Service (httputils2service) Start **


** Service (httputils2service) Start **
** Activity (main) Create, isFirst = true **


** Activity (main) Resume **


main_copiar_local_a_mysql (B4A line: 738)


ImagenCod=SU.EncodeBase64(GetImagen)
java.lang.NumberFormatException: Invalid hex double:/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAIBAQEBAQIBAQECAgICAgQDAgICAgUEBAMEBgUGBgYFBgYGBwkIBgcJBwYGCAsICQoKCgoKBggLDAsKDAkKCgr/2wBDAQICAgICAgUDAwUKBwYHCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgr/wAARCAHgAoADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD8H6KKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooAKKKKAPbf+Ccn/J6Xg//ALiP/pvua/Uevy4/4Jyf8npeD/8AuI/+m+5r9R6ACiiigAooooAKKKKAPEv+CjP/ACZZ4x/7h3/pxtq/Liv1H/4KM/8AJlnjH/uHf+nG2r8uKACiiigAooooA/RD/h0f+zV/0PHjf/wY2f8A8iUf8Oj/ANmr/oePG/8A4MbP/wCRK+pKKAPkD4i/sj/DT9g/wVe/tX/CDXNb1HxD4W8v+z7PxHcQzWUn2mRbOTzEhiic4jncrh1wwUnIBB8t/wCHuH7Sv/Qj+CP/AAXXn/yXX1J/wUZ/5Ms8Y/8AcO/9ONtX5cUAfUf/AA9w/aV/6EfwR/4Lrz/5Lo/4e4ftK/8AQj+CP/Bdef8AyXXy5RQB9R/8PcP2lf8AoR/BH/guvP8A5Lo/4e4ftK/9CP4I/wDBdef/ACXXy5RQB9R/8PcP2lf+hH8Ef+C68/8Akuj/AIe4ftK/9CP4I/8ABdef/JdfLlFAH1/8N/2uPiV+3h40s/2UPi9oeiad4e8U+Z/aF54ctpob2P7NG95H5bzSyoMyW6Bso2VLAYJBHqP/AA6P/Zq/6Hjxv/4MbP8A+RK+XP8AgnJ/yel4P/7iP/pvua/UegD5b/4dH/s1f9Dx43/8GNn/APIlH/Do/wDZq/6Hjxv/AODGz/8AkSvqSigD5b/4dH/s1f8AQ8eN/wDwY2f/AMiUf8Oj/wBmr/oePG//AIMbP/5Er6kooA+W/wDh0f8As1f9Dx43/wDBjZ//ACJR/wAOj/2av+h48b/+DGz/APkSvqSigD5A+Iv7I/w0/YP8FXv7V/wg1zW9R8Q+FvL/ALPs/EdxDNZSfaZFs5PMSGKJziOdyuHXDBScgEHy3/h7h+0r/wBCP4I/8F15/wDJdfUn/BRn/kyzxj/3Dv8A0421flxQB9R/8PcP2lf+hH8Ef+C68/8Akuj/AIe4ftK/9CP4I/8ABdef/JdfLlFAH1H/AMPcP2lf+hH8Ef8AguvP/kuj/h7h+0r/ANCP4I/8F15/8l18uUUAfUf/AA9w/aV/6EfwR/4Lrz/5Lo/4e4ftK/8AQj+CP/Bdef8AyXXy5RQB9f8Aw3/a4+JX7eHjSz/ZQ+L2h6Jp3h7xT5n9oXnhy2mhvY/s0b3kflvNLKgzJboGyjZUsBgkEeo/8Oj/ANmr/oePG/8A4MbP/wCRK+XP+Ccn/J6Xg/8A7iP/AKb7mv1HoA+W/wDh0f


Message longer than Log limit (4000). Message was truncated.

 

[Erel]

ImageCod should be a string not an Int.

 

[dhernandez]

Thnks Erel...