Guest User

NotSerializableException

a guest
Jul 5th, 2016
51
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. class Upserter(internalURL: String, internalUser: String, internalPassword: String) extends Serializable{
  2. lazy val internalConnection = DriverManager.getConnection(internalURL, internalUser, internalPassword)
  3. def upsert(primarykey: String, bookmark: String, db: String, table: String) = {
  4. val statement = internalConnection.createStatement()
  5. val upsertQuery = "INSERT INTO ..."
  6. val resultSet = statement.executeQuery(upsertQuery)
  7. internalConnection.close()
  8. }
  9. }
  10.  
  11. val PKsAffectedDF: DataFrame = ...
  12. val upserter = new Upserter(internalURL, internalUser, internalPassword)
  13. PKsAffectedDF.map { x => upserter.upsert(x(0).toString(),x(1).toString(),dataSource.db,dataSource.table) }
Add Comment
Please, Sign In to add comment