Compilation error #78
Comments
|
And the |
|
HSQL seems to be broken. Can you use mysql? |
|
I'm awaiting a response from the cluster system admin at the moment, so thought to use HSQL meanwhile. I downloaded the most recent version from here, which comes pre-compiled; and with jars being accessible in the |
|
I don't think that would help. HSQL seems to be broken for this version Spring Boot. You might want to try H2 in memory database instead. |
|
Use H2 in memory database. In the pom.xml file add the following dependency: <dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.199</version>
</dependency>Create a file called application-h2.properties and add the following contents: In the application.properties, set the following property to: |
|
Thank you much for the quick response! I'm now running HSQL with the Engine In-Memory option, and while copying the url and Driver from these recent configurations. This gives me the error below:
|
|
Right. You will need to add the following dependency in the pom.xml file as you did for causal-web. <dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.199</version>
</dependency> |
|
Hello again, and apologies for the delay. Yes, all are set as you describe: the I'm not sure why HSQL still does not work, or if this means all is well? |
|
Another update: |
HSQL does not work. Please use H2 instead.
Yes. MySQL was never supposed to be installed on the cluster anyway. The database is where the jobs are stored. The job queue fetches the jobs stored in the database and execute them on the cluster. |
|
Now I understand- H2 is an alternative to HSQL! Apologies- thought that was a workaround to get HSQL to work. Will try and hope it works |
|
Many due thanks @kvb2univpitt Upon enough testing on the cluster, it seems best to just have the database on my machine (outside the cluster) as you suggested (I thought having everything on the cluster makes it easy to pass parameters to slurm, but I guess will worry about it a bit later). With Probably important: on this stand alone machine, I couldn't compile and run the I would be very appreciative if you could point where the error is coming from. Sincerely, |
|
Apologies a lot of these tickets came your way. I'm trying again, and it seems to work. I'm moving to the I don't know if it helps, but doing a pull request with the points on h2 and other dependencies discussed here added to the README. Please feel free to close this issue and accept/reject the PR as you see fits. Again, my due thanks for your help and patience. |
This was referenced Sep 2, 2019
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hello again,
I thought I make a new issue since this is not strictly a dependency problem. I hope you don't mind.
Now that all my dependencies are in place, I went ahead and downloaded a hqsldb for testing out. I set the options in the HypersqlDB Manager as per the default options in the
causal-web-1.3.7/src/main/resources/application-hsqldb.properties(figure below).Yet, no luck with actually running
java -jar target/causal-web-1.3.7.jar &> java.error.txt. I'm afraid I can't really understand why this one is failing (or, where to place the seemingly missinglog4j2configuration file). Would you kindly be able to help?Thank you in advance for any pointers you may be able to provide
The text was updated successfully, but these errors were encountered: