Guest User

Untitled

a guest
Feb 6th, 2018
101
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.31 KB | None | 0 0
  1. object SimpleApp extends App{
  2.  
  3. Class.forName("com.mysql.jdbc.Driver")
  4. val jdbcUsername = "root"
  5. val jdbcPassword = "mysqladmin"
  6. val jdbcHostname = "XXXXXXX"
  7. val jdbcPort = 3306
  8. val jdbcDatabase ="XXXXXX"
  9.  
  10. val ImgPath = new File("C:\Users\ezswapr\IdeaProjects\DataStructure\org.priyaranjan.ds\src\output\" + "Desert.jpg")
  11. val fileinput = new FileInputStream(ImgPath)
  12. val reader =new InputStreamReader(fileinput,"UTF-8") // Converting byte sream to character stream of UTF-8
  13.  
  14.  
  15. val jdbcUrl = s"jdbc:mysql://${jdbcHostname}:${jdbcPort}/${jdbcDatabase}?user=${jdbcUsername}&password=${jdbcPassword}"
  16. val connection = DriverManager.getConnection(jdbcUrl, jdbcUsername, jdbcPassword)
  17. val stmt = connection.createStatement();
  18. val sql= s""" create table test_blob (data mediumtext) DEFAULT CHARSET=utf8"""
  19. stmt.executeUpdate(sql)
  20.  
  21. val ps= connection.prepareStatement("insert into test_blob(data) values(?);")
  22. ps.setCharacterStream(1,reader)
  23. ps.execute()
  24. connection.isClosed()
  25. }
  26.  
  27. Exception in thread "main" java.sql.SQLException: Incorrect string value: 'xF0x94x91xA9xEFxBF...' for column 'data' at row 1
  28. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
  29. at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  30. at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:116)
  31. at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1867)
  32. at com.mysql.cj.jdbc.PreparedStatement.execute(PreparedStatement.java:1155)
  33. at SimpleApp$.delayedEndpoint$SimpleApp$1(SarojCode.scala:74)
  34. at SimpleApp$delayedInit$body.apply(SarojCode.scala:18)
  35. at scala.Function0$class.apply$mcV$sp(Function0.scala:34)
  36. at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
  37. at scala.App$$anonfun$main$1.apply(App.scala:76)
  38. at scala.App$$anonfun$main$1.apply(App.scala:76)
  39. at scala.collection.immutable.List.foreach(List.scala:381)
  40. at scala.collection.generic.TraversableForwarder$class.foreach(TraversableForwarder.scala:35)
  41. at scala.App$class.main(App.scala:76)
  42. at SimpleApp$.main(SarojCode.scala:18)
  43. at SimpleApp.main(SarojCode.scala)
Add Comment
Please, Sign In to add comment