|
»
»
»
NoClassDefFoundError while running HSQLDB
|
View:
New views
4 Messages
—
Rating Filter:
Alert me
|
 |
NoClassDefFoundError while running HSQLDB
by Shashidhar Rampally
::
Rate this Message:
I am getting a NoClassDefFoundError when I try to start the hsql
database server. Please let me know what I could be doing wrong! Thanks, Shashi c:\hysqld/lib> java -cp hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb [Server@186db54]: [Thread[main,5,main]]: checkRunning(false) entered [Server@186db54]: [Thread[main,5,main]]: checkRunning(false) exited [Server@186db54]: Startup sequence initiated from main() method [Server@186db54]: Loaded properties from [C:\!downloads\Hibernate\hsqldb\lib\server.properties] [Server@186db54]: Initiating startup sequence... [Server@186db54]: Server socket opened successfully in 10 ms. Exception in thread "HSQLDB Server @186db54" java.lang.NoClassDefFoundError at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.Server.openDatabases(Unknown Source) at org.hsqldb.Server.run(Unknown Source) at org.hsqldb.Server.access$000(Unknown Source) at org.hsqldb.Server$ServerThread.run(Unknown Source) ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
olap functions
by Stephen Ince
::
Rate this Message:
Does hsql have support for the Olap functions? e.g row_number().
I was trying to find the top N row in a group. The typical cross join it too expensive. Here is an example query in db2. select virtual_user_id, web_resource_id from ( SELECT virtual_user_id, web_resource_id, row_number() over( partition by virtual_user_id order by min(page_view_id)) as rn FROM page_view where test_run_id = 22 group by virtual_user_id, web_resource_id ) as t where rn = 1 Steve ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: olap functions
by fredt
::
Rate this Message:
In 1.8.0 / 1.9.0 we do not support this OLAP feature but have some
functionality that may be used for this purpose. The queries become a a bit complex though : - LIMIT and OFFSET keywords allow retrieval of part of an ordered set of rows - scalar subqueries using search conditions that use the above keywords, or MAX() and MIN() - extensive support for GROUP BY where columns need not be in the select list Fred ----- Original Message ----- From: "Stephen Ince" <since@...> To: "HSQLdb user discussions" <hsqldb-user@...> Sent: 26 April 2008 03:15 Subject: [Hsqldb-user] olap functions Does hsql have support for the Olap functions? e.g row_number(). I was trying to find the top N row in a group. The typical cross join it too expensive. Here is an example query in db2. select virtual_user_id, web_resource_id from ( SELECT virtual_user_id, web_resource_id, row_number() over( partition by virtual_user_id order by min(page_view_id)) as rn FROM page_view where test_run_id = 22 group by virtual_user_id, web_resource_id ) as t where rn = 1 Steve ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
|
|
Re: NoClassDefFoundError while running HSQLDB
by fredt
::
Rate this Message:
May be your database is referencing an external stored procedure, especially
in a view definition. Fred ----- Original Message ----- From: "Shashidhar Rampally" <shashi.rampally@...> To: <hsqldb-user@...> Sent: 25 April 2008 22:57 Subject: [Hsqldb-user] NoClassDefFoundError while running HSQLDB I am getting a NoClassDefFoundError when I try to start the hsql database server. Please let me know what I could be doing wrong! Thanks, Shashi c:\hysqld/lib> java -cp hsqldb.jar org.hsqldb.Server -database.0 file:mydb -dbname.0 xdb [Server@186db54]: [Thread[main,5,main]]: checkRunning(false) entered [Server@186db54]: [Thread[main,5,main]]: checkRunning(false) exited [Server@186db54]: Startup sequence initiated from main() method [Server@186db54]: Loaded properties from [C:\!downloads\Hibernate\hsqldb\lib\server.properties] [Server@186db54]: Initiating startup sequence... [Server@186db54]: Server socket opened successfully in 10 ms. Exception in thread "HSQLDB Server @186db54" java.lang.NoClassDefFoundError at org.hsqldb.Database.reopen(Unknown Source) at org.hsqldb.Database.open(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.DatabaseManager.getDatabase(Unknown Source) at org.hsqldb.Server.openDatabases(Unknown Source) at org.hsqldb.Server.run(Unknown Source) at org.hsqldb.Server.access$000(Unknown Source) at org.hsqldb.Server$ServerThread.run(Unknown Source) ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user ------------------------------------------------------------------------- This SF.net email is sponsored by the 2008 JavaOne(SM) Conference Don't miss this year's exciting event. There's still time to save $100. Use priority code J8TL2D2. http://ad.doubleclick.net/clk;198757673;13503038;p?http://java.sun.com/javaone _______________________________________________ Hsqldb-user mailing list Hsqldb-user@... https://lists.sourceforge.net/lists/listinfo/hsqldb-user |
| Free Forum Powered by Nabble | Forum Help |