JdbcUtils

Value Members

1. final def !=(arg0: AnyRef): Boolean

   Definition Classes

   AnyRef

2. final def !=(arg0: Any): Boolean

   Definition Classes

   Any

3. final def ##(): Int

   Definition Classes

   AnyRef → Any

4. final def ==(arg0: AnyRef): Boolean

   Definition Classes

   AnyRef

5. final def ==(arg0: Any): Boolean

   Definition Classes

   Any

6. final def asInstanceOf[T0]: T0

   Definition Classes

   Any

7. def clone(): AnyRef

   Attributes

   protected[java.lang]

   Definition Classes

   AnyRef

   Annotations

   @throws( ... )

8. def createConnectionFactory(url: String, properties: Properties): () ⇒ Connection

   Returns a factory for creating connections to the given JDBC URL.

   Returns a factory for creating connections to the given JDBC URL.

   url

   the JDBC url to connect to.

   properties

   JDBC connection properties.

9. def dropTable(conn: Connection, table: String): Unit

   Drops a table from the JDBC database.

10. final def eq(arg0: AnyRef): Boolean

    Definition Classes

    AnyRef

11. def equals(arg0: Any): Boolean

    Definition Classes

    AnyRef → Any

12. def finalize(): Unit

    Attributes

    protected[java.lang]

    Definition Classes

    AnyRef

    Annotations

    @throws( classOf[java.lang.Throwable] )

13. final def getClass(): Class[_]

    Definition Classes

    AnyRef → Any

14. def getCommonJDBCType(dt: DataType): Option[JdbcType]

    Retrieve standard jdbc types.

    Retrieve standard jdbc types.

    dt

    The datatype (e.g. org.apache.spark.sql.types.StringType)

    returns

    The default JdbcType for this DataType

15. def hashCode(): Int

    Definition Classes

    AnyRef → Any

16. def insertStatement(conn: Connection, table: String, rddSchema: StructType): PreparedStatement

    Returns a PreparedStatement that inserts a row into table via conn.

17. final def isInstanceOf[T0]: Boolean

    Definition Classes

    Any

18. def isTraceEnabled(): Boolean

    Attributes

    protected

    Definition Classes

    Logging

19. def log: Logger

    Attributes

    protected

    Definition Classes

    Logging

20. def logDebug(msg: ⇒ String, throwable: Throwable): Unit

    Attributes

    protected

    Definition Classes

    Logging

21. def logDebug(msg: ⇒ String): Unit

    Attributes

    protected

    Definition Classes

    Logging

22. def logError(msg: ⇒ String, throwable: Throwable): Unit

    Attributes

    protected

    Definition Classes

    Logging

23. def logError(msg: ⇒ String): Unit

    Attributes

    protected

    Definition Classes

    Logging

24. def logInfo(msg: ⇒ String, throwable: Throwable): Unit

    Attributes

    protected

    Definition Classes

    Logging

25. def logInfo(msg: ⇒ String): Unit

    Attributes

    protected

    Definition Classes

    Logging

26. def logName: String

    Attributes

    protected

    Definition Classes

    Logging

27. def logTrace(msg: ⇒ String, throwable: Throwable): Unit

    Attributes

    protected

    Definition Classes

    Logging

28. def logTrace(msg: ⇒ String): Unit

    Attributes

    protected

    Definition Classes

    Logging

29. def logWarning(msg: ⇒ String, throwable: Throwable): Unit

    Attributes

    protected

    Definition Classes

    Logging

30. def logWarning(msg: ⇒ String): Unit

    Attributes

    protected

    Definition Classes

    Logging

31. final def ne(arg0: AnyRef): Boolean

    Definition Classes

    AnyRef

32. final def notify(): Unit

    Definition Classes

    AnyRef

33. final def notifyAll(): Unit

    Definition Classes

    AnyRef

34. def savePartition(getConnection: () ⇒ Connection, table: String, iterator: Iterator[Row], rddSchema: StructType, nullTypes: Array[Int], batchSize: Int, dialect: JdbcDialect): Iterator[Byte]

    Saves a partition of a DataFrame to the JDBC database.

    Saves a partition of a DataFrame to the JDBC database. This is done in a single database transaction in order to avoid repeatedly inserting data as much as possible.

    It is still theoretically possible for rows in a DataFrame to be inserted into the database more than once if a stage somehow fails after the commit occurs but before the stage can return successfully.

    This is not a closure inside saveTable() because apparently cosmetic implementation changes elsewhere might easily render such a closure non-Serializable. Instead, we explicitly close over all variables that are used.

35. def saveTable(df: DataFrame, url: String, table: String, properties: Properties): Unit

    Saves the RDD to the database in a single transaction.

36. def schemaString(df: DataFrame, url: String): String

    Compute the schema string for this RDD.

37. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes

    AnyRef

38. def tableExists(conn: Connection, url: String, table: String): Boolean

    Returns true if the table already exists in the JDBC database.

39. def toString(): String

    Definition Classes

    AnyRef → Any

40. final def wait(): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

41. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )

42. final def wait(arg0: Long): Unit

    Definition Classes

    AnyRef

    Annotations

    @throws( ... )