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 MongoDB™ User's Guide Release 6.1.0

Connecting using the JDBC Driver Manager

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 MongoDB Driver
    • What's new in this release?
    • Requirements
    • Migrating schema maps and native files to 6.1
    • Installing and setting up the driver
    • Driver and DataSource classes
    • Connection URL examples
      • No authentication
      • User ID and password
      • Kerberos authentication
      • LDAP authentication
      • TLS/SSL encryption
      • Replica set failover
      • MongoDB Atlas
      • Microsoft Azure Cosmos DB for MongoDB
      • Proxy server
    • Data types
      • Default mapping of columns with inconsistent native data types
      • getTypeInfo()
    • Mapping objects to tables
      • Normalized view
        • Nested complex types (normalized view)
      • Flattened view
      • Mixed view
        • Nested complex types (mixed view)
    • SQL escape sequences
      • Supported scalar functions
      • CAST_TO_NATIVE function escape
    • DataDirect tools
    • Troubleshooting
    • Additional information
    • Contacting Technical Support
  • Tutorials
    • Interactive SQL
    • Tableau
    • DbVisualizer
      • Adding a driver
      • Connecting and executing SQL statements
  • Configuring and connecting
    • Setting the classpath
    • Connecting using the JDBC Driver Manager
      • Passing the connection URL
      • Generating connection URLs with the Configuration Manager
      • Testing connections and queries
    • 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
    • Refreshing the relational map
    • Authentication
      • User ID and password authentication
      • LDAP authentication
      • Kerberos authentication
        • Kerberos authentication requirements
        • The JAAS login configuration file
    • Data Encryption
      • Configuring TLS/SSL Encryption
      • Configuring TLS/SSL Server Authentication
      • Configuring TLS/SSL Client Authentication
      • FIPS (Federal Information Processing Standard)
    • Proxy server
    • MongoDB Atlas clusters
    • Replica set failover for write operations
    • Performance considerations
  • Additional features and functionality
    • MongoDB sharding
    • Identifiers
    • MongoDB views
    • Local views
    • MinKey and MaxKey values
  • Connection property descriptions
    • ArrayNormalizationThreshold
    • AuthenticationDatabase
    • AuthenticationMethod
    • ColumnDiscoverySampleSize
    • CreateMap
    • CryptoProtocolVersion
    • DatabaseName
    • EnableDNSLookup
    • EncryptionMethod
    • FetchSize
    • FlattenArrayBase
    • HostNameInCertificate
    • ImportStatementPool
    • InitializationString
    • JSONColumns
    • KeyPassword
    • Keystore
    • KeystorePassword
    • KeywordConflictSuffix
    • LeadingUnderscoreReplacement
    • LegacyVirtualKeys
    • LogConfigFile
    • LoginConfigName
    • LoginTimeout
    • MaxPooledStatements
    • MinVarcharSize
    • NetworkMessageCompressors
    • Password
    • PortNumber
    • ProxyHost
    • ProxyPassword
    • ProxyPort
    • ProxyUser
    • QualifyNormalizedNames
    • ReadOnly
    • ReadPreference
    • RefreshSchema
    • RegisterStatementPoolMonitorMBean
    • ReplicaSetName
    • ResultMemorySize
    • SchemaFilter
    • SchemaFormat
    • SchemaMap
    • ServerName
    • ServicePrincipalName
    • SpecialCharBehavior
    • SpyAttributes
    • StringTruncationMethodForWrites
    • TimestampFormat
    • TransactionMode
    • Truststore
    • TruststorePassword
    • UppercaseIdentifiers
    • User
    • ValidateServerCertificate
    • VarcharThreshold
  • Supported SQL statements and extensions
    • Create View
    • Delete
    • Drop View
    • Insert
    • Refresh Map (EXT)
    • Reload Map (EXT)
    • Select
      • Select Clause
        • Aggregate Functions
        • From Clause
          • Outer Join Escape Sequences
          • 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
    • Update
    • 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
    • Custom function escapes
      • CAST_TO_NATIVE function escape
Table of Contents

Connecting using the JDBC Driver Manager

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
Print
  • Last Updated: March 11, 2022
  • 1 minute read
    • DataDirect Connectors
    • JDBC
    • MongoDB 6.1
    • Documentation

One way to connect to a service is through the JDBC DriverManager using the DriverManager.getConnection() method. As the following example shows, this method specifies a string containing a connection URL.

Connection conn = DriverManager.getConnection
  ("jdbc:datadirect:mongodb://myserver:27017;AuthenticationDatabase=mydb2;
         DatabaseName=mydb;user=jsmith;password=secret;");
Contents
  • Passing the connection URL
  • Generating connection URLs with the Configuration Manager
  • Testing connections and queries
TitleResults for “How to create a CRG?”Also Available inAlert