Get started
Loading...
Important Notice - Forums is archived

To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Product icon
TUTORIAL

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

CssImport when using Component Exporter by Mikhail Shabarov, 1 month ago
Recent Posts
Vaadin Forum3. Vaadin 6, 7, 8Framework Data Binding

SQLContainer and DB2

Evgeny Minkevich
10 years ago Apr 20, 2012 7:03am

Could someone please confirm if the current version of SQLContainer supports LazyLoading with DB2?

If I udnerstood correctly, the previous versions of the container did not (https://vaadin.com/directory#addon/vaadin-sqlcontainer).

Thank you.

Kirk Rasmussen
9 years ago Nov 07, 2012 10:37pm

I've got it working ok with a couple of SQLContainers and DB2. I did have to patch the code to handle empty result sets correctly. I logged a bug report for this already along with the code changes needed to workaround the bug.

Here's the bug report along with an attachment that will patch the JAR (see gradle build file):

http://dev.vaadin.com/ticket/10032

This was based off 6.8.3. Changing the order of operations did the trick:

1068d1067
< boolean resultExists = rs.next();
1069a1069
> boolean resultExists = rs.next();
1680a1681
>

Last updated on Nov, 7th 2012
Buck Woodson
7 years ago Dec 29, 2014 4:12pm

What is required to adapt a SQLContainer for use with DB2?  Do you have examples you could provide?