schemaSupport for HSQLDialect remote connections doesn't work

Description

Using a remote DataSource on an (in memory) HSQLdb leads into the issue.
The HSQLDialect only enabled schemaSupport if schemaManager is defined in org.hsqldb.Database. This class is not available locally, since I'm using a remote data source.
Workaround: Put hsqldb.jar on my classpath.

Is a depependency of EJBTHREE-1050.

Environment

AS 5.0 rev 65579

Activity

Show:
wolfc
September 24, 2007, 1:01 PM

134 try {
135 // Does present HSQLDB Database class support schemas?
136 // yuck! Perhaps we should think about a new dialect? Especially
137 // if more things are going to break back-compat moving forward
138 ReflectHelper.classForName( "org.hsqldb.Database" ).getDeclaredField( "schemaManager" );
139 schemaSupport = true;
140 }
141 catch (Throwable t) {
142 schemaSupport = false;
143 }

Steve Ebersole
October 3, 2007, 7:26 AM

Do you know the version in which schema support was added?

Steve Ebersole
October 3, 2007, 7:33 AM

It would appear to be 1.8.0: http://fisheye1.cenqua.com/browse/hsqldb/hsqldb-dev/src/org/hsqldb/SchemaManager.java

I'll try to verify that. If that is the case, then I have no issue simply switching to assume schema support since we report to only support 1.8.x anyway...

Steve Ebersole
October 16, 2007, 11:09 PM

trunk / 3.2

Assignee

Steve Ebersole

Reporter

wolfc

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

Pull Request

None

backportDecision

None

Affects versions

Priority

Major
Configure