I'm working with the text KNIME Essentials. At the beginning of Section 2, one is to install the BIRT Sample database to work through the examples. I have found two (2) copies of the BirtSample.jar file: one having a size of 508,055 bytes, the other having a size of 535,088 bytes. I believe that the former is the one to be used with KNIME Essentials; however, the latter is found in folder C:\Program Files\KNIME_2.11.3\plugins\org.eclipse.birt.report.data.oda.sampledb_4.4.2.v201410272105\db\BirtSample.jar. (I am currently at version 2.12.0 of KNIME.)
1. If anyone knows which copy should be used, or whether it matters, I would like to know.
2. While I have the copies of BirtSample.jar on my machine, the Example Workflow is not finding the JAR file.
a. The code in the "path --> JDBC Connection" node (a Java Edit Variable node) is
// Enter your code here:
out_DerbyJ = "jdbc:derby://localhost:1527/" + v_database;
b. The Flow Variables of the "path --> JDBC Connection" node are
- Derby JDBC connection = <blank>
- database location = BirtSample
- knime.workspace = C:\Users\<username>\knime-workspace
c. The Database URL value in the "collect customers" node (a Database Looping node) is "jdbc:derby://localhost:1527/BirtSample", which is to what the "out_DerbyJ" variable would be set by the code snippet.
These conditions generate three questions
- Where should the BirtSample.jar file be placed so that it can be found? The Database Reader node, Database Looping node, and Database Table Connector nodes all report "Invalid URL in settings," but I don't know where to put the JAR file so that it is found.
- In the code snippet above, how is v_database assigned? There is a flow variable "database location" that is assigned to the Java Field v_database, but I don't see the source of the value for v_database.
- The output variable of the "path --> JDBC connector" (a Java Edit Variable node) is connected to the input, flow variable port of the "collect customers" node (a Database Looping node), and the node shows the value of the URL as what would be assigned to the out_DerbyJ Java variable (jdbc:derby://localhost:1527/BirtSample). However, looking at the Flow Variables in the "collect customers" node, the "Derby JDBC connection" is selected in the pull down menu for the database variable, but there is no value in correspoinding the text box. How does the out_DerbyJ value appear in the "Database URL" configuration field?
Asdie: I have not attached the workflow as I don't know if this is permitted by the copyright on KNIME Essentials. If anyone can definitively state whether attaching the workflow is permitted, I'll act accordingly.
Thanks.
Scott K. Starry