Apache SparkSQL

webMethods BigData Driver for Apache SparkSQL

DataSource

Transaction Type DataSource Class
NO_TRANSACTION, LOCAL_TRANSACTION 
com.wm.jdbcx.sparksql.SparkSQLDataSource

Other Properties

Specify the parameters in the Other Properties field:

Parameter Description
transactionmode To enable LOCAL_TRANSACTION connection: 
transactionmode=ignore

Required Connection Property Fields

Driver Name Server Name User Password Database Name Port Number Network Protocol
webMethods BigData Driver for Apache SparkSQL No No No No No No

For more information about limitations, see Limitations.

Limitations

Driver Database/

Adapter IS Operating System/

Platform Affected

Limitation Description
webMethods BigData Driver for Apache SparkSQL Apache SparkSQL This driver does not support:
  1. Services: StoredProcedure, StoredProcedureWithSignature, UpdateSQL, BatchInsertSQL, BatchUpdateSQL, DeleteSQL
  2. Notifications: InsertNotifications, UpdateNotifications, DeleteNotifications, StoredProcedureNotifications, StoredProcedureNotificationsWithSignature, and OrderedNotifications
  3. XA_TRANSACTION connections