Error showing content of blob with derby database

[chme]

[Serge]

In Derby (and in some other databases) LOB content valid only during transaction life-time.
So if you want to work with LOBs in Derby you need to enable transactional mode (just toggle auto-commut button in main toolbar and refresh table contents).

[chme]

[Serge]

What DBeaver version and what Derby version do you use?
Embedded or Server?

Also could you post complete stacktrace of this error (you can get it in Error Log view)?

Thanks

[chme]

[Serge]

You can't work with LOBs in auto-commit mode. You have to be in transactional mode. After switching into it just refresh table contents.

[chme]

[Serge]

Derby has some limitations in LOBs reading. If LOB value bigger than cache size (it depends on database - in my case it is 32kb) then LOB become invalid after statement close.
Workaround:
- Turn on preference Common->Result Sets->Keep open cursors in SQL editor
- Read LOBs from SQL editor (with SELECT .. FROM ..)

I'll add extra LOBs caching option in the next version.
Thanks for report.