I am trying to create a Universe Designer connection to Apache Derby. I have the Derby server running on localhost:1527 and I can see the database using Eclipse Data Tools and query it. But, when I attempt to create a connection using Universe Designer, I see the "Derby" option under "Connection"->"New", but when I go to test the connection, I get the following error:
CS: Java Class not found in classpath : org.apache.derby.jdbc.EmbeddedDriver
I thought in order for a client to connect to Derby, it is supposed to use the derbynet.jar . How do I get this working?
Do I need to drop a jar file somewhere? I don't see a driver connections option and it looks like from the manual that the drivers are supposed to be "already" installed.
I am using Universe Designer 18.104.22.1682