Creating a JDBC Data Source
Create a JDBC data source to connect from your Java application. Creating a JDBC data source based on the CData JDBC Driver consists of three basic steps:
- Add the driver JAR to the classpath:
The JAR is located in the lib subfolder of the installation directory. Note that the .lic file must be located in the same folder as the JAR.
- Provide the driver class:
cdata.jdbc.XXX
- Provide the JDBC URL. For example:
jdbc:XXX:dataSource=C:\\mydb
The URL must start with "jdbc:XXX:" and can include any of the connection properties in name-value pairs separated with semicolons.