Hi! I'm having a big problem: I can't run any application with WebRatio. I installed in a Ubuntu x64 system following this guide: http://www.webratio.com/learn/article/WebRatio-Installation-Guide
Everything works fine: WebRatio starts, Tomcat is working (I checked http://localhost:8080/). But the problem is every time I press the "generate and run" button, my browser opens and throw me this error:
____________________________________________________________________________
An error occurred
Table/View 'APP.POST' does not exist.
Occurred on:
Details:
-
[pwu1] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
-
could not execute query using iterate
-
Table/View 'APP.POST' does not exist.
Suggestions:
-
Refresh the database(s) and run the 'Find Model Problems' command on the domain model
-
Check the database Runtime properties (if defined)
-
Run the 'Generate Selection' command on the accessed page/operation
____________________________________________________________________________
And the only component my site view has is one homepage with a list of existent posts.
I think maybe the problem is when I set up Tomcat, because ./startup.sh shows this message:
Using CATALINA_BASE: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat
Using CATALINA_HOME: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat
Using CATALINA_TMPDIR: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat/bin/bootstrap.jar
So I add the next line to the top of catalina.sh:
JAVA_HOME=/usr/lib/jvm/java-7-openjdk-amd64/bin
I relaunch the ./startup.sh:
Using CATALINA_BASE: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat
Using CATALINA_HOME: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat
Using CATALINA_TMPDIR: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat/temp
Using JRE_HOME: /usr/lib/jvm/java-7-openjdk-amd64/bin
Using CLASSPATH: /opt/WebRatio_Personal_7.2.x64bit.Linux/Tomcat/bin/bootstrap.jar
But when I press the "generate and run" button, I get the same previous error (Table/View 'APP.POST' does not exist.). So, how can I found the database in order to check if it really exists?? How can I solve this??
Extra info: I did a simple ER model and I syncronized it, so it should exist.