Testing with H2

User 7910dcb734

30-12-2015 15:39:12

I'm trying to set up some integration tests for our software platform. Ideally we could use H2, which provides an in-memory database that matches SQL standards.


http://www.h2database.com/html/main.html


Unfortunately, JChem doesn't appear very happy when try to create a new ChemAxon table:


org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; Unknown or not supported database type: H2; nested exception is java.sql.SQLException: Unknown or not supported database type: H2

Obviously H2 is not a supported database type and isn't claimed to be, but I wonder if anyone has had any luck getting this working? (We're also behind on updating to the latest version of JChem, but perhaps the newer versions have some support?)

ChemAxon abe887c64e

04-01-2016 08:06:56

Hi Brendan,


You are right, we only support databases listed here. Unfortunately, H2 was not supported in past versions, and - at the moment - is not planned to be supported.in the future.


Krisztina