Re: COUNT(*) : the real problem

Turns out, the reason I wasn't using the latest and greatest is because it 
does not build. After running "ant jar" in hsqldb-1.8.0-7/build I get

 hsqldb.jar        641095
 hsqldb.jar.orig 643806

"orig" is the distribution jar, note the size difference. After unpacking it 
recursive diff reports 27 classes missing from the locally-built jar. They 
*seem* to be unnecessary, e.g. Zaurus stuff, but running with locally built 
jar results in

Exception in thread "main" java.lang.NoClassDefFoundError
        at org.hsqldb.Database.reopen(Database.java:317)
        at org.hsqldb.Database.open(Database.java:258)
        at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:213)
        at org.hsqldb.DatabaseManager.newSession(DatabaseManager.java:139)
        at org.hsqldb.jdbc.jdbcConnection.<init>(jdbcConnection.java:2378)
        at org.hsqldb.jdbcDriver.getConnection(jdbcDriver.java:183)
        at org.hsqldb.jdbcDriver.connect(jdbcDriver.java:161)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)

That does not happen if I use the original distribution jar.

So, either your build.xml or your readmebuild.txt is broken: the working 
distribution jar is not what I get after running "ant jar". It's been broken 
since at least 1.7.2-3 (search ML archive for "build broken").

My current setup is Fedora 5 with Sun's 1.5.0_11 JDK. In 2004 it was RedHat 
something or other with whatever Sun's JDK was current at the time.

Dima
-- 
Dimitri Maziuk
Programmer/sysadmin
BioMagResBank, UW-Madison -- http://www.bmrb.wisc.edu

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/