Skip to Content
0
Dec 14, 2022 at 08:43 AM

Create connection to in memory H2 database in Integration Suite fails

247 Views Last edit Dec 14, 2022 at 09:02 AM 2 rev

I'd like to create a In Memory H2 database in the Integration Suite. Therefor I uploaded the h2-Jar in the Resources Section of the iFlow and made the connection as follows:

.....

import org.h2.Driver

def Message processData(Message message) {

...

Class.forName("org.h2.Driver").newInstance()

Connection conn = DriverManager.getConnection("jdbc:h2:mem:test")

I get the following error:

java.sql.SQLException: No suitable driver found for jdbc:h2:mem:

The driver is definitely there otherwise I'd get a ClassNotFoundException.

When I try uploading whatever driver in the JDBC material I get the error:

Deploy artifact failed with error: (deployJdbcDriver)Failed to deploy jdbc driver null for tenant

Only Oracle, DB2 and MSSQL seem to be supported there.

How can I establish a connection to a In Memory H2 database? On my local machine it works flawlessly.