[hibernate-dev] New version of HSQLDialect.java

2010-06-26 Thread Fred Toussi
I have made changes and additions to HSQLDialect to work with HSQLDB v.
2.0.x. The Hibernate unit tests now run well with HSQLDB 1.8.x and
2.0.x.

New snapshot jars of HSQLDB v. 2.0.1 (for jdk 1.5 or 1.6) are available
here: http://hsqldb.org/support/ and should be used in tests. These
reflect the HSQLDB SVN /base/trunk/ (see SourceForge project pages) The
GA 2.0.0 showed a few issues that have now been fixed.

Version 2.0.x is transactional and has been written to the SQL Standard
(but relaxes some requirements by default). Therefore, the dialect
distinguishes between 1.8.x and 2.0.x versions and treats them
differently.

I am hoping that any remaining issue with HSQLDialect are identified and
fixed now. So please check the dialect and let me know if you have any
recommendations.

Some Details:

The following connection URL's can be used:
"jdbc:hsqldb:mem:db;hsqldb.tx=mvcc;get_column_name=false" or with
"hsqldb.tx=locks" (mvcc or lock based transaction management). The
"get_column_name=false" causes the JDBC driver to return the column
labels when getColumnName() is used on ResultSetMetaData.

There are 4 test failures with 2.0.x. The one below is caused by HSQLDB.
In JDBC PreparedStatement, it does not allow a locator on an existing
database lob to be used as the source of an assignment to the database.
  testBlobClob(org.hibernate.test.legacy.SQLFunctionsTest)

I don't know the cause of the other failures.

Tests were performed with the latest Hibernate SVN code.

HSQLDB 2.0.x supports 3 URL properties to enforce strict type and name
checking according to ANSI SQL. The defaults for some of these are
relaxed. See http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html

Fred Toussi
HSQLDB Project
___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev


Re: [hibernate-dev] New version of HSQLDialect.java

2010-06-26 Thread Fred Toussi
The modified HSQLDialect is here:

http://hsqldb.svn.sourceforge.net/viewvc/hsqldb/base/trunk/src/org/hibernate/dialect/HSQLDialect.java?view=log

Sorry for the omission in the original post.

Fred Toussi

On Sun, 27 Jun 2010 02:01 +0100, "Fred Toussi"
 wrote:
> I have made changes and additions to HSQLDialect to work with HSQLDB v.
> 2.0.x. The Hibernate unit tests now run well with HSQLDB 1.8.x and
> 2.0.x.

___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev


[hibernate-dev] New HSQLDialect

2010-07-13 Thread Fred Toussi
I have attached the new version to HHH-5381.

The Hibernate test suite runs with few errors with HSQLDB 2.0.1 snapshot
(jars are at http://hsqldb.org/support/)

Several tests contain SQL that works only with a few products. I have
listed these issues on Jira HHH-5376 and HHH-5325. Most of the issues
can be fixed with minor changes to the SQL.

HSQLDB 2.0.1 has some rule enforcement settings that can be used as
connection or URL properties, all listed here:
http://hsqldb.org/doc/2.0/guide/dbproperties-chapt.html#N13D18
See the properties beginning with "sql.".

Some rules are relaxed by default, but if they are all turned on, more
tests result in failure.

Please review and ask any questions. I will help both with HSQLDB issues
and with general SQL issues.

Fred Toussi


___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev


[hibernate-dev] Hibernate Build and Tests

2010-12-18 Thread Fred Toussi
I had seen some instructions on how to set up InteliJ IDEA to build and
run Hibernate tests before the move to Gradle (I cannot find that how-to
page now). It worked with IDEA 9 and I was running the tests until the
build system change.

Is there a how-to, especially with IDEA 10 and Gradle support?

Fred Toussi
___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev


Re: [hibernate-dev] missing ANTLR dependency from gradle built pom.xml

2011-01-15 Thread Fred Toussi
I don't know if this is directly relevant (as it is a Maven build), but
the other day I downloaded the 3.6.0 final code from github and used
Idea 10 to create a (Maven) project from the sources. Once the project
was created, it did not compile, and the first visible errors showed
classes created by Antler were not present. I simply used the IDE to
build the POM's for different parts of the code and after a few builds,
the project would build and run. I did this to run the tests.

Later, I downloaded the 3.6.1 head and updated the changed files in the
previous Idea setup. The build was successful.

Fred

On Sat, 15 Jan 2011 11:40 -0600, "Steve Ebersole" 
wrote:
> Pretty sure I checked this previously.  The part you ask about configures
> the antlr plugin that generates the parsers from the grammar files. 
> Pretty
> positive that also used to add antlr to the project's set or exported
> deps.   That is where I think something changed.  Let me ask about this
> on
> the gradle channels.
> On Jan 14, 2011 12:39 PM, "Sanne Grinovero" 
> wrote:
> > Hello,
> > It seems that ANTLR is missing from the pom.xml generated by the new
> > gradle build of Hibernate Core.
> >
> > The following patch seems to fix it but I couldn't find any
> > information on the "antlr( libraries.antlr )" line, from the
> > documentation is seems it's only being used to choose the ANTLR
> > version to use to generate the parser code, but I couldn't find an
> > option to also include it as dependency so I added an additional line.
> >
> > Could anybody confirm this change is right? (It seems to work).
> >
> > diff --git a/hibernate-core/hibernate-core.gradle
> > b/hibernate-core/hibernate-core.gradle
> > index 59f80aa..4f28e93 100644
> > --- a/hibernate-core/hibernate-core.gradle
> > +++ b/hibernate-core/hibernate-core.gradle
> > @@ -12,6 +12,7 @@ dependencies {
> > compile( libraries.commons_annotations )
> > compile( libraries.jpa )
> > antlr( libraries.antlr )
> > + compile( libraries.antlr )
> > provided( libraries.javassist )
> > provided( libraries.cglib ) {
> > transitive = true
> >
> > thanks,
> > Sanne
> > ___
> > hibernate-dev mailing list
> > hibernate-dev@lists.jboss.org
> > https://lists.jboss.org/mailman/listinfo/hibernate-dev
> ___
> hibernate-dev mailing list
> hibernate-dev@lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
> 
___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev


[hibernate-dev] Please commit the HHH-5842 patch

2011-02-03 Thread Fred Toussi
This patch adds a BINARY type size parameter currently missing from the
HSQLDB dialect and affecting the latest HSQLDB versions with Hibernate
3.6.0 final. 

Fred
___
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev