openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Milosz Tylenda (JIRA)" <>
Subject [jira] Commented: (OPENJPA-1367) H2 Database Engine does support cross join
Date Fri, 05 Feb 2010 18:05:28 GMT


Milosz Tylenda commented on OPENJPA-1367:

Prashant, most likely some (or even most of) connections are still open at the end of test
but not because of not closing EntityManagers. The cause is rather a connection pool (Apache
DPCP) being used by the test suite. I haven't seen the exceptions you mention, maybe because
I did not enable trace log in H2.

Looking at your stack trace, I would say you use H2 in kind of one-connection-only mode. Is
this the case? I am not very familiar with H2.

I don't have answer for your question on H2 configuration. I would try tweaking DBCP connection
properties and H2 settings. If you have an IDE with OpenJPA source, you can also try running
some test from there, without DBCP. Below I am including my settings for your reference:


> H2 Database Engine does support cross join
> ------------------------------------------
>                 Key: OPENJPA-1367
>                 URL:
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: docs, jdbc, sql
>    Affects Versions: 1.2.1, 2.0.0-M1
>            Reporter: Thomas Mueller
>            Assignee: Milosz Tylenda
>            Priority: Minor
>             Fix For: 2.0.0
>         Attachments: OPENJPA-1367.patch, openjpa-h2-test-results.txt
> The documentation says that the H2 database does not support cross joins:
> H2 does support cross join since a long time (I don't remember what version). See:
(CROSS). A condition is not required for cross join.
> I think the documentation should be changed, and probably the H2Dictionary should be
changed as well (crossJoinClause = "CROSS JOIN"; requiresConditionForCrossJoin = false;).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message