Step-by-step instructions on how to easily integrate and configure Connect for JDBC MongoDB driver 6.0 with JBoss EAP 6.4.0.
This is the latest from our tutorial rumble where our engineers put their heads together and thought of ways to help our customers succeed. Don't see the tutorial you need? Contact us and we will be glad to help.
The set up steps detailed and demonstrated below are for a Windows machine. The 4 main steps include:
While the focus is on MongoDB here, the same steps apply to any of the data sources that Connect for JDBC supports.
JBoss EAP 6.4.0 is the Enterprise version of JBoss AS Wildfly 7.5.0 (so internally most of its components are the same as JBoss AS 7.5.0 ). The configuration steps will also apply to JBoss AS Wildfly 7.5.0.
GENERAL SYNTAX/ FORMAT of the CLI command is as indicated below: /subsystem=datasources/jdbc-driver=DRIVER_NAME:add(driver-name=DRIVER_NAME,driver-module-name=MODULE_NAME,driver-xa-datasource-class-name=XA_DATASOURCE_CLASS_NAME)
Example: Connection URL: jdbc:datadirect:mongodb://<Machinename>:<port>;schemaDefinition=<User_Specified location>
Username and Password required to connect to the MongoDB database
The screenshot here shows that the schemaDefinition location is specified as C:\MongoJdbcSchema.
This will create the .map, .properties, .script, .config and .native files in location C:/ as shown in screenshot below with the suffix MongoJdbcSchema
You may choose to directly edit the standalone.xml directly to make changes to the datasource instead of using the Admin Console GUI
Screenshot of the standalone.xml below:
MongoDB connectivity via JDBC or ODBC is easier than ever with DataDirect JDBC and ODBC connectors for MongoDB. They provide fast SQL access to business critical data while also enabling you to access NoSQL data without additional server installations. Integrate your MongoDB data without having to duplicate data or flatten complex documents. Visit our information page to learn more or try it free for 15 days.
Jan is a Sr. Support Engineer at Progress. She is responsible for assisting Progress customers and application partners solve technical issues by providing efficient and effective technical support. She has background in the areas of Business Rules, Database Drivers, Business Process Management, Complex Event Processing.
Subscribe to get all the news, info and tutorials you need to build better business apps and sites
Copyright © 2019 Progress Software Corporation and/or its subsidiaries or affiliates.All Rights Reserved.
Progress, Telerik, Ipswitch, and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.