HA-JDBC / Discussion / Help: CLOB not properly supported in h2 dialect?

CLOB not properly supported in h2 dialect?

Forum: Help

Creator: Bartosz Baziński

Created: 2013-01-28

Updated: 2013-01-30

Bartosz Baziński - 2013-01-28

Hello,
We tried to use HA-JDBC in scaling out our H2 database, as it looks really great, but we noticed problems with tables that contain CLOB fields. The stack trace is in link below, could you suggest any solutions?
Cheers,
Bartek

http://pastebin.com/6MV04hZP

Last edit: Bartosz Baziński 2013-01-28

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Ferraro - 2013-01-28

I just pushed a fix for this issue to master:
https://github.com/ha-jdbc/ha-jdbc/commit/5c4820ce102752ea13e916e4851edf7e978e5353

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Bartosz Baziński - 2013-01-29

Paul, thanks for fast reaction! Cluster is working now when there are no rows with null value in CLOB fields. With a null value in any field we get the following exception:

http://pastebin.com/raw.php?i=MzMEzXAD

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Paul Ferraro - 2013-01-29

OK - I found the issue and pushed a fix to master:
https://github.com/ha-jdbc/ha-jdbc/commit/a36d4ebb8320b81ace6195903fb0e15a191d9773
https://github.com/ha-jdbc/ha-jdbc/commit/1c78c208dba144f40a6262bf5d3c6aa55a64390a

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Bartosz Baziński - 2013-01-30

Big thanks, everything works fine now.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Log in to post a comment.