Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- object SimpleApp extends App{
- Class.forName("com.mysql.jdbc.Driver")
- val jdbcUsername = "root"
- val jdbcPassword = "mysqladmin"
- val jdbcHostname = "XXXXXXX"
- val jdbcPort = 3306
- val jdbcDatabase ="XXXXXX"
- val ImgPath = new File("C:\Users\ezswapr\IdeaProjects\DataStructure\org.priyaranjan.ds\src\output\" + "Desert.jpg")
- val fileinput = new FileInputStream(ImgPath)
- val reader =new InputStreamReader(fileinput,"UTF-8") // Converting byte sream to character stream of UTF-8
- val jdbcUrl = s"jdbc:mysql://${jdbcHostname}:${jdbcPort}/${jdbcDatabase}?user=${jdbcUsername}&password=${jdbcPassword}"
- val connection = DriverManager.getConnection(jdbcUrl, jdbcUsername, jdbcPassword)
- val stmt = connection.createStatement();
- val sql= s""" create table test_blob (data mediumtext) DEFAULT CHARSET=utf8"""
- stmt.executeUpdate(sql)
- val ps= connection.prepareStatement("insert into test_blob(data) values(?);")
- ps.setCharacterStream(1,reader)
- ps.execute()
- connection.isClosed()
- }
- Exception in thread "main" java.sql.SQLException: Incorrect string value: 'xF0x94x91xA9xEFxBF...' for column 'data' at row 1
- at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
- at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
- at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:116)
- at com.mysql.cj.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1867)
- at com.mysql.cj.jdbc.PreparedStatement.execute(PreparedStatement.java:1155)
- at SimpleApp$.delayedEndpoint$SimpleApp$1(SarojCode.scala:74)
- at SimpleApp$delayedInit$body.apply(SarojCode.scala:18)
- at scala.Function0$class.apply$mcV$sp(Function0.scala:34)
- at scala.runtime.AbstractFunction0.apply$mcV$sp(AbstractFunction0.scala:12)
- at scala.App$$anonfun$main$1.apply(App.scala:76)
- at scala.App$$anonfun$main$1.apply(App.scala:76)
- at scala.collection.immutable.List.foreach(List.scala:381)
- at scala.collection.generic.TraversableForwarder$class.foreach(TraversableForwarder.scala:35)
- at scala.App$class.main(App.scala:76)
- at SimpleApp$.main(SarojCode.scala:18)
- at SimpleApp.main(SarojCode.scala)
Add Comment
Please, Sign In to add comment