SQLContainer and MySQL issue

Vaadin 6 / 7 / 8 Framework UI
1

Using Scala/Scaladin, but hopefully that shouldn’t matter

Using MySQL (well, latest MariadDB) and C3PO, with datasource via JNDI.

All seems fine at first.

  1. sorting doesn’t work. Defining in code or clicking on column header, no difference. I read something around 2 years
    ago about setting ANSI mode. Still true?

  2. If I scroll down a bit, its fine. scoll down a lot it takes ages to get back to me, often times out, coming back with either blank
    grid or lots of short rows with no data inside. Seems kind of random.

Makes the UX rather shaky. Scrolling though data in Heidi is smooth. DB is local, i.e. on my box.

Is there a way to log the sql being sent out by the sql container?

Thanks.

2

Hi,

your issue 2 is probably due to
http://dev.vaadin.com/ticket/11199
 or
http://dev.vaadin.com/ticket/11002
 (might be duplicates).

If you set up normal vaadin logging and set the log level properly (FINER) you should see the queries in your log.

3

Thanks for the info re 2)

Any idea if there is a fix for this? This is a terrible bug. Can’t tell users to scroll “just a bit”.

Thanks.

4

No luck re logging.

I’m using logback.xml

…

<root level="FINER">
    <appender-ref ref="CONSOLE" />
    <appender-ref ref="FILE" />
</root>

Can’t see any SQL like stuff. Can emit to the log just fine myself.

Is there something else I need to do to make Vaadin more chatty?

Thanks.

5

Check out
https://vaadin.com/book/-/page/advanced.logging.html
 for the logging.

And for the bug, I can’t really say when it might be fixed, maybe someone from our R&D could elaborate on that?

6

A bit more progress, got some debug from c3p0 going to log

https://vaadin.com/book/-/page/advanced.logging.html

Put in

 SLF4JBridgeHandler.install()

and
maven

org.slf4j
jul-to-slf4j
1.7.5

Still nothing from Vaadin.

7

Do you know if there is an alternative/working database grid control for Vaadin 7.1.8?

The current one is just unusable in its current state. This bug has been around for a while, amazed
it isn’t fixed.

Thanks.

8

Yeah, when I tried to use SQLContainer several months ago, I was shocked by critical issues it has though they were reported on forum like year ago. The remaining options for Vaadin 7 are Lazy Query Container and Vaadin JPAContainer. I was not experimenting with the latter but Lazy Query Container seems usable to me, though I ended up with creating my own container (because of very special requirements I was not able to achieve just by extending LQC).