Problem with Oracle setup script #355
Description
I have been attempting to run the oracle set up script using the doc/sql/002_create_schema_oracle.sql file.
It is not possible to create the gs_resource table as Oracle does not have a bool type.
I tried changing this to a varchar2(5) but got this error when starting Mapstore:
ERROR 2024-06-14 11:58:12.685 ContextLoader.initWebApplicationContext() - Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'geostoreEntityManagerFactory' defined in URL [jar:file:/C:/Program%20Files/Apache%20Software%20Foundation/Tomcat%209.0/webapps/mapstore/WEB-INF/lib/geostore-persistence-2.1.0.jar!/applicationContext-geostoreDatasource.xml]: Invocation of init method failed; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: geostore] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: wrong column type encountered in column [advertised] in table [GEOSTORE.gs_resource]; found [varchar2 (Types#VARCHAR)], but expecting [bool default true (Types#BOOLEAN)]
How can I make this work in an Oracle DB?
Running on a Windows Server 2016
Tomcat v9.0.89
JVM v11.0.23+9
Mapstore v2024.01.01