Google wasn’t awful­ly help­ful whi­le I was sear­ching for solu­tion to word wrap­ping a text when dra­wing in Java, so let’s teach Google this: 😉

    private void drawStringRect(Graphics2D graphics, int x1, int y1, int x2, int y2, 
        float interline, String txt) {
        AttributedString as = new AttributedString(txt);
        as.addAttribute(TextAttribute.FOREGROUND, graphics.getPaint());
        as.addAttribute(TextAttribute.FONT, graphics.getFont());
        AttributedCharacterIterator aci = as.getIterator();
        FontRenderContext frc = new FontRenderContext(null, true, false);
        LineBreakMeasurer lbm = new LineBreakMeasurer(aci, frc);
        float width = x2 - x1;

        while (lbm.getPosition()  txt.length()) {
            TextLayout tl = lbm.nextLayout(width);
            y1 += tl.getAscent();
            tl.draw(graphics, x1, y1);
            y1 += tl.getDescent() + tl.getLeading() + (interline - 1.0f) * tl.getAscent();
            if (y1 > y2) {
                break;
            }
        }
    }

After upgra­ding Net­Be­ans to 6.5 the ‑post-com­pi­le task I added so JiBX bin­dings are com­pi­led stop­ped wor­king for me thro­wing an excep­tion abo­ut bin­dings not found at runtime.

The solu­tion to this is to disa­ble „Com­pi­le on Save” featu­re in pro­ject properties.

Can You tell a dif­fe­ren­ce between

SELECT *, format(Data_ur, "yyyy-mm-dd") AS Datur FROM Czlonkowie

and

SELECT *, format(Data_ur, 'yyyy-mm-dd') AS Datur FROM Czlonkowie

?

It turns out that when using ODBC to con­nect to Micro­soft Access data­ba­se (in an mdb file), one has to use sin­gle quotes when wri­ting func­tion para­me­ters. The first sta­te­ment runs fine from the Access itself, but when cal­led thro­ugh the ODBC (for instan­ce when using PHP and PDO) it returns emp­ty set (it doesn’t even throw an exception).

The second sta­te­ment (with sin­gle quotes) runs fine thro­ugh ODBC. Worth remembering.