CODEWITHSUNDEEP
javah2
sidshu
sidshu

Reputation: 333

TO_CHAR function not available in H2 database

I am using H2 database for integration test. The code is quiet old and is using JDBC queries instead.

While running tests i am getting the error below 

org.h2.jdbc.JdbcSQLException: Function "TO_CHAR" not found; SQL statement:

I can see that H2 does not implecitely supports TO_CHAR function. Is there any way to add a custom methor or should i think about moving to HSQL DB or any other database for testing purpose.

Upvotes: 4

Views: 5794

Answers (2)

Epicurist
Epicurist

Reputation: 923

Use the newer version 1.3.175. Since 2014-01-18 available with a TO_CHAR function.

Upvotes: 5

Thomas Mueller
Thomas Mueller

Reputation: 50097

You could try HSQLDB of course. I think it does support TO_CHAR.

Or you could write a user defined function in H2.

Upvotes: 0

Related Questions