Dear Thomas,
Any idea or input to solve this issue.
Thanks in advance
Best regards.
Le jeudi 19 novembre 2015 09:58:18 UTC+1, Gwendall Petit a écrit :
>
> Hi,
>
> SET @CODE_INSEE='44109';
>
> DROP TABLE IF EXISTS MY_SCHEMA.MY_TABLE;
> CREATE FORCE LINKED
> TABLE MY_SCHEMA.MY_TABLE ('org.orbisgis.postgis_jts_osgi.Driver',
> 'jdbc:postgresql_h2://.../db', 'dbname', 'login', 'pwd', '(SELECT * FROM
> SCHEMA_A.STUDY_TABLE WHERE COMMUNE_CODE_INSEE=' || @CODE_INSEE || ')');
>
> Returns the following error
>
> Syntax error in SQL statement "CREATE FORCE LINKED TABLE
> MY_SCHEMA.MY_TABLE ('org.orbisgis.postgis_jts_osgi.Driver',
> 'jdbc:postgresql_h2://.../db', 'dbname', 'login', 'pwd', '(SELECT * FROM
> SCHEMA_A.STUDY_TABLE WHERE COMMUNE_CODE_INSEE=' || @CODE_INSEE || ')')[*]";
> expected "string"; SQL statement:
> CREATE FORCE LINKED TABLE MY_SCHEMA.MY_TABLE
> ('org.orbisgis.postgis_jts_osgi.Driver', 'jdbc:postgresql_h2://.../db',
> 'dbname', 'login', 'pwd', '(SELECT * FROM SCHEMA_A.STUDY_TABLE WHERE
> COMMUNE_CODE_INSEE=' || @CODE_INSEE || ')') [42001-188] 42001/42001 (Aide)
> org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE FORCE
> LINKED TABLE MY_SCHEMA.MY_TABLE ('org.orbisgis.postgis_jts_osgi.Driver',
> 'jdbc:postgresql_h2://.../db', 'dbname', 'login', 'pwd', '(SELECT * FROM
> SCHEMA_A.STUDY_TABLE WHERE COMMUNE_CODE_INSEE=' || @CODE_INSEE || ')')[*]";
> expected "string"; SQL statement:
> CREATE FORCE LINKED TABLE MY_SCHEMA.MY_TABLE
> ('org.orbisgis.postgis_jts_osgi.Driver', 'jdbc:postgresql_h2://.../db',
> 'dbname', 'login', 'pwd', '(SELECT * FROM SCHEMA_A.STUDY_TABLE WHERE
> COMMUNE_CODE_INSEE=' || @CODE_INSEE || ')') [42001-188]
>
> Regards,
>
> Gwendall (OrbisGIS and H2GIS Team)
>
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
