Databases
StackOverflow2013
Postsdbo
POencode and decode base64 excpetion storing to sql server 2008 r2
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POencode and decode base64 excpetion storing to sql server 2008 r2
    primarykey
    data
    text
    <p>I have an android client, I want to send image from my android to my server, i convert the image to byte array, then they byte array to base64, i send the base64 string to server, i decode it in the server then stored it in my sql server 2008 r2.</p> <p><h3>my problem</h3>I can't store the string to my database then retrieve it correctly, I didn't get any exception and I get result but it seems it is the wrong result.</p> <p>i conclude that by doing this.</p> <p>1- i send the base64 from android to server and saved the string retrieved in a static variable. 2- i asked the server to retrive the static string, i get the image in the android back. 3- but when i asked the server to retrieve the image that i supposed i saved it in the database i got wrong image ,actullly i get result but this result can't be decoded again.</p> <p>I will tell you my code for insert and retrive the image in database, pleaes tell me what am i doing wrong,</p> <h3>Stored to database</h3> <pre><code>void uploadImage(String image) { Connection con = Database.getConnection(); CallableStatement callableStatement = null; try { callableStatement = con .prepareCall("{call insertRestaurantFoodImage(?,?)}"); ByteArrayInputStream b = new ByteArrayInputStream( stringImage.getBytes()); callableStatement.setInt(1, ID); ; callableStatement.setBinaryStream(2, b, stringImage.getBytes().length); callableStatement.executeUpdate(); } catch (SQLException e) { e.printStackTrace(); } } </code></pre> <p><strong>the stored procedure to insert the image is</strong> </p> <pre><code>ALTER PROCEDURE dbo.insertRestaurantFoodImage ( @restaurantFoodID INT, @image VARBINARY(MAX) ) AS BEGIN SET NOCOUNT ON UPDATE Food_Restaurant SET [image] = @image WHERE ID = @restaurantFoodID END </code></pre> <h3>Retrieve from database</h3> <pre><code>Connection con = Database.getConnection(); CallableStatement callableStatement = null; try { callableStatement = con .prepareCall("{call getRestaurantFoodImage(?,?)}"); callableStatement.setInt(1, getID()); callableStatement.registerOutParameter(2, java.sql.Types.VARBINARY); callableStatement.execute(); byte[] bytes = callableStatement.getBytes(2); image = new String(bytes); } catch (SQLException e) { e.printStackTrace(); } </code></pre> <p><strong>the stored procedure to retrive from database is :</strong></p> <pre><code>ALTER PROCEDURE dbo.getRestaurantFoodImage ( @foodRestaurantID INT, @image VARBINARY(MAX) OUTPUT ) AS BEGIN SET NOCOUNT ON SELECT @image = [image] FROM Food_Restaurant WHERE ID = @foodRestaurantID END </code></pre> <p><strong>maybe i talked too much, but in the previus question, a user told me that i have to not just put the code but i have to put my problem and what i am doing.</strong></p> <p>for those uses who asked me about how to encode and decode in android here is it:</p> <h3>encode</h3> <pre><code>private byte[] getBytesFromBitmap(Bitmap bitmap) { ByteArrayOutputStream stream = new ByteArrayOutputStream(); bitmap.compress(CompressFormat.PNG, 70, stream); return stream.toByteArray(); } private String getBase64(Bitmap bitmap) { String imgString = Base64.encodeToString(getBytesFromBitmap(bitmap), Base64.NO_WRAP); return imgString; } </code></pre> <h3>decode</h3> <pre><code>String retrievedBase63 = client2 .getBaseURI("restaurantFoods/OneFood/" + 5 + "/getImage"); //Log.d("image", image); byte[] decodedString = Base64.decode(retrievedBase63, Base64.DEFAULT); Bitmap decodedByte = BitmapFactory.decodeByteArray(decodedString, 0, decodedString.length); </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USSmolina Fezaphitsh
    1. USSmolina Fezaphitsh
    plurals
    1. PL
      singulars
      1. LTLinked
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POencode and decode base64 excpetion storing to sql server 2008 r2
      1. This table or related slice is empty.
      1. VTModeratorReview
    1. COusing jdbc on android is a bad idea ... it is better to made webservice for this ...
      singulars
      1. POencode and decode base64 excpetion storing to sql server 2008 r2
      1. USSelvin
    2. CO@Selvin I used jdbc in server buddy
      singulars
      1. POencode and decode base64 excpetion storing to sql server 2008 r2
      1. USSmolina Fezaphitsh
    3. CO@Selvin I am already useing REST Jersey web service, but i didn't tell u that.
      singulars
      1. POencode and decode base64 excpetion storing to sql server 2008 r2
      1. USSmolina Fezaphitsh
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload