Skip to main contentSkip to search
Powered by Zoomin Software. For more details please contactZoomin
Progress DocumentationProgress Documentation
Progress Documentation
  • Home
  • Home
  • EnglishČeštinaDeutsch (Germany)Español (Spain)Français (France)Italiano (Italy)Português (Brasil)日本語Русский (Russia)中文 (简体) (China)中文 (繁體, 台灣) (Taiwan)ar-AR
  • Login

Progress DataDirect for JDBC for Apache Spark SQL User's Guide Release 6.0.1

Connecting from an Application

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
Table of Contents
  • Welcome to the Progress DataDirect for JDBC for Apache Spark SQL Driver
    • What's New in this Release?
    • Requirements
    • Data Source and Driver Classes
    • Connection URL
    • Version String Information
    • Connection Properties
    • Data Types
      • getTypeInfo
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Getting started
    • Data Source and Driver Classes
    • Setting the Classpath
    • Connecting with the JDBC Driver Manager
      • Connection URL
      • Testing the Connection
    • Connecting Using Data Sources
      • How Data Sources Are Implemented
      • Creating Data Sources
        • Example Data Source
      • Calling a Data Source in an Application
      • Testing a data source connection
  • Using the driver
    • Required permissions for Java SE with the standard Security Manager enabled
      • Permissions for establishing connections
      • Granting access to Java properties
      • Granting access to temporary files
      • Permissions for Kerberos Authentication
    • Connecting from an Application
      • Data Source and Driver Classes
      • Setting the Classpath
      • Connecting with the JDBC Driver Manager
        • Connection URL
        • Testing the Connection
      • Connecting Using Data Sources
        • How Data Sources Are Implemented
        • Creating Data Sources
          • Example Data Source
        • Calling a Data Source in an Application
        • Testing a data source connection
      • HTTP Mode
      • Interactive SQL for JDBC (JDBCISQL)
    • Using Connection Properties
      • Required Properties
      • User ID/Password Authentication Properties
      • Kerberos Authentication Properties
      • Data Encryption Properties
      • Data Type Handling Properties
      • HTTP Properties
      • Timeout Properties
      • Client Information Properties
      • Statement Pooling Properties
      • Proxy Server Properties
      • Additional Properties
    • Performance Considerations
    • Using Authentication
      • Using the AuthenticationMethod Property
      • Configuring User ID/Password Authentication
      • Configuring the Driver for Kerberos Authentication
        • Kerberos Authentication Requirements
        • The JAAS Login Configuration File
        • The krb5.conf File
        • Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
        • Obtaining a Kerberos Ticket Granting Ticket
        • Kerberos SASL-QOP
    • Data encryption
      • Configuring SSL encryption
      • Configuring SSL server authentication
      • Configuring SSL client authentication
      • FIPS (Federal Information Processing Standard)
    • Proxy server support
    • Using Client Information
      • How Databases Store Client Information
        • Storing Client Information
      • Returning client information
      • Returning MetaData About Client Information Locations
    • IP Addresses
    • Parameter metadata support
      • Insert, Update, and Delete Statements
      • Select Statements
    • ResultSet metadata support
    • Isolation Levels
    • Unicode support
    • Error Handling
    • Large Object Support
    • Rowset Support
    • Timeouts
    • Views
    • SQL Escape Sequences
    • Using Scrollable Cursors
    • Spark SQL Compatibility with Apache Hive
    • Stored Procedures
  • Connection Property Descriptions
    • AccountingInfo
    • ApplicationName
    • ArrayFetchSize
    • AuthenticationMethod
    • BinaryDescribeType
    • ClientHostName
    • ClientUser
    • ConnectionRetryCount
    • ConnectionRetryDelay
    • ConvertNull
    • CookieName
    • CryptoProtocolVersion
    • DatabaseName
    • EnableCookieAuthentication
    • EncryptionMethod
    • HostNameInCertificate
    • HTTPPath
    • ImportStatementPool
    • InitializationString
    • InsensitiveResultSetBufferSize
    • JavaDoubleToString
    • KeyPassword
    • KeyStore
    • KeyStorePassword
    • LoginTimeout
    • MaxBinarySize
    • MaxPooledStatements
    • Password
    • PortNumber
    • ProgramID
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • RegisterStatementPoolMonitorMBean
    • RemoveColumnQualifiers
    • ServerName
    • ServicePrincipalName
    • SpyAttributes
    • StringDescribeType
    • TransactionMode
    • TransportMode
    • TrustStore
    • TrustStorePassword
    • UseCurrentSchema
    • User
    • UserAgent
    • ValidateServerCertificate
  • Supported SQL Functionality
    • Data Definition Language
    • Column Name Qualification
    • From Clause
    • Group By Clause
    • Having Clause
    • Order By Clause
    • For Update Clause
    • Set Operators
    • Subqueries
    • SQL Expressions
      • Constants
      • Numeric Operators
      • Character Operator
      • Relational Operators
      • Logical Operators
      • Functions
  • Copyright
Table of Contents

Connecting from an Application

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: January 12, 2018
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • Apache Spark SQL 6.0
    • Documentation
Once the driver is installed and configured, you can connect to your database in either of the following ways:
  • Using the JDBC Driver Manager, by specifying the connection URL in the DriverManager.getConnection() method.
  • Creating a JDBC data source that can be accessed through the Java Naming Directory Interface (JNDI).
Contents
  • Data Source and Driver Classes
  • Setting the Classpath
  • Connecting with the JDBC Driver Manager
  • Connecting Using Data Sources
  • HTTP Mode
  • Interactive SQL for JDBC (JDBCISQL)
TitleResults for “How to create a CRG?”Also Available inAlert