•  Welcome to the Progress DataDirect for JDBC for Jira Driver: Version 6.0.0
  • What's new in this release?
  • Quick start
  • Requirements
  • Version string information
  • Driver and DataSource classes
  • Connection URL
  • Connection properties
  • Introduction to the Jira Data Model
  • Mapping objects to tables
  •  Data types
    • getTypeInfo()
  • DataDirect Tools
  • Troubleshooting
  • Contacting Technical Support
•  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
  •  Connecting from an application
    • Setting the classpath
    •  Connecting using the JDBC Driver Manager
      • Passing the 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
  • Connecting through a proxy server
  • IP addresses
  • Performance considerations
  •  Data encryption
    • Configuring SSL encryption
    • Configuring SSL server authentication
    • Configuring SSL client authentication
  • Enabling Debug Record Mode
  • Isolation levels
  •  SQL Escape Sequences
    • Supported Scalar Functions
  • Statement Pooling
  • Connection Pooling
•  Connection property descriptions
  • ConvertNull
  • CryptoProtocolVersion
  • DebugRecord
  • FetchSize
  • HostNameInCertificate
  • ImportStatementPool
  • InsensitiveResultSetBufferSize
  • JDBCBehavior
  • KeyPassword
  • KeyStore
  • KeyStorePassword
  • LogConfigFile
  • LoginTimeout
  • MaxPooledStatements
  • Password
  • PortNumber
  • ProxyHost
  • ProxyPassword
  • ProxyPort
  • ProxyUser
  • ReadAhead
  • RegisterStatementPoolMonitorMBean
  • ServerName
  • SpyAttributes
  • StmtCallLimit
  • StmtCallLimitBehavior
  • TrustStore
  • TrustStorePassword
  • User
  • ValidateServerCertificate
  • WSFetchSize
  • WSPoolSize
  • WSRetryCount
  • WSTimeout
•  Supported SQL statements and extensions
  • Alter Session (EXT)
  •  Select
    •  Select clause
      • Aggregate functions
      •  From clause
        • Join in a From clause
        • Subquery in a From clause
      • Where clause
      • Group By clause
      • Having clause
      • Union operator
      • Intersect operator
      • Except and Minus operators
      • Order By clause
      • Limit clause
  •  SQL expressions
    • Column names
    •  Literals
      • Character string literals
      • Numeric literals
      • Binary literals
      • Date/Time literals
      • Integer literals
    •  Operators
      • Unary operator
      • Binary operator
      • Arithmetic operators
      • Concatenation operator
      • Comparison operators
      • Logical operators
      • Operator precedence
    • Functions
    • Conditions
  •  Subqueries
    • IN predicate
    • EXISTS predicate
    • UNIQUE predicate
    • Correlated subqueries
• Copyright
•  Glossary
  • authentication
  • bulk load
  • client authentication
  • client load balancing
  • connection pooling
  • connection retry
  • connection URL
  • DataDirect Connection Pool Manager
  • DataDirect DB2 Package Manager
  • DataDirect Spy
  • DataDirect Test
  • data source
  • Driver Manager
  • failover
  • index
  • isolation level
  • J2EE
  • JDBC data source
  • JNDI
  • JTA
  • Kerberos
  • load balancing
  • locking level
  • NTLM authentication
  • OS authentication
  • reauthentication
  • resource adapter
  • Secure Socket Layer
  • SSL client and server authentication
  • Unicode
  • user ID and password authentication
• Copyright