wildfly and H2 in memory mode use linked table

[Luciene Garlet]

hello,

i'am use a wildfly 14 webserver and a h2 database in memory mode. Now I will create a "linked table" to an postgressql DB. Is this not possible when h2 is in memory mode and running on wildfly?

PostgresSQL Jar is added on wildfly modules and although in the war.

create command:

CREATE LINKED TABLE PgLink('java.sql.Driver','jdbc:postgresql://191.168.xxx.xxx/testdb','test','test','std_test')

exception which is thrown: org.h2.jdbc.JdbcSQLException: No suitable driver found for jdbc:postgresql

What i'am missing or is it not possible to create a link to postgres?

greeting Lucy

[Luciene Garlet]

[Luciene Garlet]

[Luciene Garlet]

[Luciene Garlet]

[Luciene Garlet]

[Luciene Garlet]

[Luciene Garlet]

[Noel Grandin]

you need to have the postgres jdbc driver jar on the classpath