Errors app.log

Support
#1
  1. Install tomcat/build directories from cuba-platform under my ubuntu server.
  2. Trying open http:(ip)/app/#! (show me UNEXCPECTED ERROR)

Pleasse help me to understand the errors.
Regards

app.log (35.6K)

#2

Hi,

The error states that tomcat can’t connect to the hsqldb. Did you start hsqldb manually and configured the cuba App to connect to it?

Copying just the tomcat directory will leave out the database part.

Bye
Mario

#3

Thanks Mario, could do you help me to understand how config cua pp to connect to it ,
I run manually :
$ java -cp hsqldb-2.2.9.jar org.hsqldb.server.Server --database.0 file:sales --dbname.0 xdb
Its running but still the message (unexpected error)

app.log (51.2K)

#4

Hi,

If you want to run HSQL for your project on production you can use in-process mode of HSQL server. In can be set up in context.xml on production server:


<Context>
    <!-- Database connection -->
    <Resource driverClassName="org.hsqldb.jdbc.JDBCDriver"
              maxActive="20"
              maxIdle="2"
              maxWait="5000"
              name="jdbc/CubaDS"
              password=""
              type="javax.sql.DataSource"
              url="jdbc:hsqldb:file:./db/ts;shutdown=true"
              username="sa"/>
    <!-- Switch off session serialization -->
    <Manager className="org.apache.catalina.session.PersistentManager"
             debug="0"
             distributable="false"
             saveOnRestart="false">
        <Store className="org.apache.catalina.session.FileStore"/>
    </Manager>
</Context>

Here you can specify path to database file. This mode must be used together with cuba.automaticDatabaseUpdate set to true.

Please not that HSQL is not recommended for production. I think you should consider using PostgreSQL or MySQL in your project.

#5

Dear Yuriy a lot of regards by your help.
I will be using PostgreSQL and now learning how deploy under Tomcat + HSQL.
One time i understand the Cuba Framework will be using and porting all my projects (the past 10 years from DNN ) to Cuba, i love this Cuba-platform.

Shure i will be sending more Questions to this Forum to advance asap when.
Kind regards
Juan Gomez

#6

Dear Yuriy, thanks i resolve with your help about url and copy my directory (scripts table, etc…) to server /bin/db thats all and successfully.

I begin to understand how deploy using postgreSQL in some days.
Before i will be trying to use REST API under my present test of HSQL and production server to consume REST and continue sending to this FORUM,
Kind regards