Need some help on a ERROR 500 (Wisemapping+Postgresql)
lyp...@gmail.com
- Debian 8 Jessie
- PostgreSQL 9.4 (on a remote server)
- java version "1.8.0_101"
- wisemapping 4.0.3
- my install directory is /opt/wisemapping
- my ip address is 192.168.2.130
I have all table from the wisemapping postgres/create-database.sql file in my PostgreSQL Database ; my db is ready.
I downloaded the JDBC42 driver (for PostgreSQL and JDK 8) from here : https://jdbc.postgresql.org/download.html
I putted this driver in lib/ext
I modified the webapps/wisemapping/WEB-INF/app.properties file by commenting HSQL and uncommenting Postgres section. It looks like this :
database.url=jdbc:postgresql://192.168.2.100:5432/wisemapping
database.driver=org.postgresql.Driver
database.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect
OK so I think all is good for running Wisemapping, so I launch it with ./start.sh.
I can accept to the web server at 192.168.2.130/wisemapping but I have this error and I don't understand it because I have no clue with Java.
HTTP ERROR 500
Problem accessing /wisemapping/. Reason:
Server Error
Caused by:
org.apache.jasper.JasperException: PWC6033: Error in Javac compilation for JSP
PWC6199: Generated servlet error:
The type java.io.ObjectInputStream cannot be resolved. It is indirectly referenced from required .class files
lyp...@gmail.com
lyp...@gmail.com
Problem solved :Be careful of Java JDK version.
wisemapoing v4.0.3 doesn't work with Java JDK 7, 8u101, 8u102.
For wisemapping v4.0.3 Java JDK 8u45 work well.
In addition, the create-schema.sql in the config/database/postgres directory doesn't work well. The tables are not created in the right order (there is reference to table before this table is created). Moreover you use a table called "user" and it cause trouble for postgresql because USER is a reserved name.
In other word, this software is designed to be used with mysql.