Can't add image to mysql database

Question

I want to add an image to the database.But nothing happens.There is a connection to the database.

     AssetManager assManager = getApplicationContext().getAssets();
      AssetFileDescriptor assetFileDescriptor = assManager.openFd("k.jpeg");
      FileDescriptor fileDescriptor = assetFileDescriptor.getFileDescriptor();



      String newPath = path.toString();

        Bitmap bitmap = BitmapFactory.decodeStream(ims);

        imageView.setImageBitmap(bitmap);

      ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
      bitmap.compress(Bitmap.CompressFormat.PNG, 0, byteArrayOutputStream);
      byte[] bytesImage = byteArrayOutputStream.toByteArray();

      String encodedImage = Base64.encodeToString(bytesImage, Base64.DEFAULT);
      PreparedStatement preparedStatement = connection.prepareStatement("INSERT INTO photo(id) VALUES (?)");
      FileInputStream  fin = new FileInputStream(fileDescriptor);
                preparedStatement.setBinaryStream(1, fin);

      //Executing the statement
      preparedStatement.executeUpdate()

writes an error com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xC5\x01\xB4\xBF\x0D\x00...' for column 'id' at row

Prefer preparedStatement.executeUpdate(); and then close preparedStatement — g00se
– g00se, Commented Sep 28, 2022 at 16:38
so I also tried it, it doesn’t work anyway, the image is not added — dsdsa sadsa
– dsdsa sadsa, Commented Sep 28, 2022 at 16:52
yes my problem is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect string value: '\xE8\x1A\x11\xBE\x0D\x00...' for column 'id' at row 1 — dsdsa sadsa
– dsdsa sadsa, Commented Sep 28, 2022 at 19:08
Hang on a minute, your query shows that you're attempting to set the ID column value. That is not the imsge itself — g00se
– g00se, Commented Sep 28, 2022 at 19:47

M Naufal Helmi · Accepted Answer · 2022-09-28 16:48:54Z

2

maybe you forget to set connection.

if your connection that's real have not been made.

You can connect to a database using the getConnection() method of the DriverManager class.

Connect to the MySQL database by passing the MySQL URL which is jdbc:mysql://localhost/sampleDB (where sampleDB is the database name), username and password as parameters to the getConnection() method.

String mysqlUrl = "jdbc:mysql://localhost/sampleDB";
Connection con = DriverManager.getConnection(mysqlUrl, "root", "password")

semoga code ini bisa membantu anda

answered Sep 28, 2022 at 16:48

M Naufal Helmi

1051 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

dsdsa sadsa Over a year ago

I connected to the database but I can't add an image

M Naufal Helmi Over a year ago

tutorialspoint.com/how-to-insert-images-in-database-using-jdbc. you can follow this link dude

Collectives™ on Stack Overflow

Can't add image to mysql database

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related