Passing Connection URLs
- Last Updated: December 15, 2016
- 1 minute read
- DataDirect Connectors
- JDBC
- MongoDB 6.0
- Documentation
This section shows the correct format for specifying a connection URL.
Syntax
jdbc:datadirect:mongodb://host:port;
DatabaseName=database;SchemaMap=schema;[property=value[;...]]
where:
- host
- specifies the name or the IP address of the server to which you want to connect.
- port
- specifies the port number of the server listener. The
default is
27017.
- DatabaseName
- specifies the name of the database to which you want to connect. This value is used as the default qualifier for unqualified table names in SQL queries. Required for User/ID password authentication.
Important: This value is case-insensitive if you have access
privileges to query the list of databases on the server. If you do not have access,
this value is case-sensitive.
- SchemaMap
- specifies the fully qualified path of the configuration file where the relational map of native data is written. The driver looks for this file when connecting to a MongoDB server. If the file does not exist, the driver creates one. See SchemaMap for further details.
- property=value
- specifies connection property settings. Multiple properties are separated by a semi-colon. For more information on connection properties, see Using Connection Properties.
This example shows how to establish a connection to a MongoDB data store with user ID/password authentication:
Connection conn = DriverManager.getConnection
("jdbc:datadirect:mongodb://MyServer:27017;DatabaseName=Test;
SchemaMap=C:\\Users\\MyUserProfile\\AppData\\Local\\Progress\\DataDirect\\MongoDB_Schema\\MyServer.config;
UserName=admin;Password=adminpass");