Android Question DBRequestManager and BLOB

gerardguerin

Member
Licensed User
Longtime User
HI,

Somebody have a working sample of sending a Sqlite field blob with DBRequestManager, I can send and receive all type but not blob :-(

My code look like that:

B4X:
      dim BlobBuffer() as byte

       Cursor1.Position = 1
       ref_id= Cursor1.GetString("ref_id")
       BlobBuffer = Cursor1.GetBlob("PDFdata")
      
       Dim cmd As DBCommand
       cmd.Initialize
       cmd.Name = "save_blob"  
       cmd.Parameters = Array As Object(ref_id,BlobBuffer)      
       reqManager.ExecuteCommand(cmd,"save_blob")

Thank in advance
 

gerardguerin

Member
Licensed User
Longtime User
Yes but the server respond : com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'PDFdata' at row 1

The coluum have the same name local and remote, the PDF file in the table have 663kb
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…