Hi Predrag,
When upgrading MATLAB, changes in compatibility or configuration can sometimes lead to issues with connecting to databases using JDBC. Here are some steps you can take to troubleshoot and resolve the issue with the Database Explorer in MATLAB 2015a:
1. Verify JDBC Driver Compatibility:
- Ensure that the JDBC driver you are using is compatible with MATLAB 2015a. Check the driver version against the MATLAB documentation to confirm compatibility.
- Download the latest MySQL JDBC driver (Connector/J) from the [MySQL website](https://dev.mysql.com/downloads/connector/j/).
2. Configure the JDBC Driver:
- Make sure the JDBC driver is correctly added to the MATLAB Java class path. You can do this by navigating to "Home > Environment > Set Path" in MATLAB and adding the path to the `.jar` file of the MySQL JDBC driver.
3. Check Database Explorer Configuration:
- Open the Database Explorer app in MATLAB.
- Ensure that you have correctly configured the connection settings with the appropriate JDBC driver, database URL, username, and password.
- The database URL typically looks like: `jdbc:mysql://hostname:port/databasename`.
4. Firewall and Network Settings:
- Verify that there are no firewall rules blocking the connection to the remote MySQL server.
- Ensure that the MySQL server allows connections from the IP address of the machine running MATLAB.
5. Enable JDBC Logging:
- Enabling logging can help diagnose connection issues. You can enable logging by setting Java system properties for the JDBC driver. This is typically done in the MATLAB startup script or through Java properties configuration.
6. MATLAB and Java Version Compatibility:
- Ensure that the MATLAB version is compatible with the Java version required by your JDBC driver. MATLAB 2015a uses Java 7, so make sure the JDBC driver supports this Java version.
Hope this helps.
