Data conversion error MULTIPOLYGON about h2gis HOT 7 CLOSED

All right, the problem seems to be resolved.
The issue was not coming from SRID but from H2GIS version.
In NM v4.0.2 we are using H2GIS v2.1.120 while the H2GIS web client is based on v2.1.214

So with @nicolas-f we updated (manually) the NM version to v2.1.214 and it works ! We will have to update the release ...

from h2gis.

One of the two PRJ file was not recognized

The error was:

Values of types "GEOMETRY(MULTIPOLYGON, 0)" and "GEOMETRY(MULTIPOLYGON Z, 2154)" are not comparable; SQL statement:
CREATE TABLE pblm_intersection AS SELECT st_intersection(a.THE_GEOM, b.THE_GEOM) AS THE_GEOM
   FROM RAIL_BUFF_D4 a, PBLM_Z1 b
   WHERE a.THE_GEOM && b.the_geom AND st_intersects(a.THE_GEOM , b.THE_GEOM) [90110-214] 90110/90110 [(Aide)](https://h2database.com/javadoc/org/h2/api/ErrorCode.html#c90110)
org.h2.jdbc.JdbcSQLSyntaxErrorException: Values of types "GEOMETRY(MULTIPOLYGON, 0)" and "GEOMETRY(MULTIPOLYGON Z, 2154)" are not comparable; SQL statement:
CREATE TABLE pblm_intersection AS SELECT st_intersection(a.THE_GEOM, b.THE_GEOM) AS THE_GEOM
   FROM RAIL_BUFF_D4 a, PBLM_Z1 b

from h2gis.

I don't know if it is related but
H2GIS 2.2 use CTS 1.7 but NoiseModelling 4.0.2 use CTS 1.6

from h2gis.

Hum, it's on the export, but in my db, both are in 2154

Don't mind with the table name which is different

from h2gis.

The PRJ file RAIL_BUFF_D4 doesn't contain any EPSG code so H2GIS is not able to find a SRID.

from h2gis.

Thanks Erwan. I reupladed the files here : data_pblm.zip

The PRJ are the same. But the problem remains in H2GIS db.
@nicolas-f just told me that the problem is resolved if I use H2GIS clien (https://github.com/orbisgis/h2gis/releases/download/v2.2.0/h2gis-2.2.0-bin.zip) instead of the NM db. So I will try

from h2gis.

ok super ;-)

from h2gis.