has anyone ever programmed a URcap that is communicating directly to a MySQL database ? I mean specifcally the jdbc.driver from mysql package.
I have been seraching the internet space, but so far haven t found anybody talking about this ?
With the jdbc.driver I opened the dependency-hell …
and went back to sql4automation
modifying Embed-Dependency (mentioned here) it is working with current mysql-connector-java (8.0.19) tested on ursim 5.6
<Import-Package> com.ur.urcap.api*; mysql*;resolution:=optional,com.google.protobuf.*;resolution:=optional,com.mchange.*;resolution:=optional,org.jboss.resource.*;resolution:=optional,org.slf4j*;resolution:=optional, * </Import-Package> <Embed-Dependency> !mysql, !org.osgi.core, !com.ur.urcap.api, *; scope=compile|runtime </Embed-Dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.19</version> </dependency>
and tested on a real robot
Thank you @m.nagel , we did exactly as you wrote and the part for the mysql connector issue was fixed.