Code

Programming Languages: Java

License: BSD License

Repositories

browse code, statistics, last commit on 2013-05-21 svn co https://hsqldb.svn.sourceforge.net/svnroot/hsqldb hsqldb

browse code, statistics cvs -d:pserver:anonymous@hsqldb.cvs.sourceforge.net:/cvsroot/hsqldb login

cvs -z3 -d:pserver:anonymous@hsqldb.cvs.sourceforge.net:/cvsroot/hsqldb co -P modulename

browse code, statistics git clone git://hsqldb.git.sourceforge.net/gitroot/hsqldb/hsqldb (read-only)

Show:

What's happening?

  • Followup: RE: INSERT error in SERVER connection type

    +1 How did you solve the problem? What was the cause?.

    2013-05-22 05:18:42 PDT by madkroll

  • Followup: RE: Advice: Truncate Table, drop indexes?

    No. Leave the indexes as they are.

    2013-05-22 02:15:05 PDT by fredt

  • Advice: Truncate Table, drop indexes?

    I am truncating a table and adding new data. - Do indexes need to be dropped and recreated?.

    2013-05-21 18:48:25 PDT by dever6

  • Comment: Create view based on selection from another view

    Ok, Thanks for response! Unfortunately I have no chance to use snapshot version. So I decided to avoid of such view creation and use tables directly.

    2013-05-21 15:18:15 PDT by madkroll

  • Comment: Create view based on selection from another view

    This works with the latest snapshot jars for 2.3.0.

    2013-05-21 15:15:10 PDT by fredt

  • HyperSQL Database...

    fredt committed revision 5243 to the HyperSQL Database Engine (HSQLDB) SVN repository, changing 6 files.

    2013-05-21 14:34:18 PDT by fredt

  • Create view based on selection from another view

    Failed to create view which based on selection from another already created view. If it is based on selection from existent table - there is no any problem, it works well. Environment: - HSQLDB 2.2.9 - PostgreSQL compatibility mode enabled - java 1.6 Script: CREATE VIEW ab AS ( SELECT 'a' as fst, 'b' as snd ); CREATE VIEW ab_wrapper AS ( SELECT fst, snd FROM ab );...

    2013-05-21 13:56:02 PDT by madkroll

  • Comment: getting values

    Your table does not have any indexes. Therefore any SELECT with LIMIT will load the full set of data into memory to sort and you will run out of memory. Before you insert into the table, add an index on the column you will use for ORDER BY. You can add more than one indexe (on different columns) but the data insert will get slower when there are indexes. Do not add indexes after inserting...

    2013-05-20 02:12:59 PDT by fredt

  • Comment: Bulk Data Insert Problem

    Hi fredt, Thanks for u help problem is solved . But another error coming after inserting the data(15 millions rows and 103 columns and 10.5 GB), then getting the value using sql Query(select * from db_10gb order by col3 limit 10 offset 0). I got a error message as below Exception in thread "Thread-4" java.lang.OutOfMemoryError: Java heap space at...

    2013-05-19 22:24:37 PDT by kunalghosh84

  • Comment: Bulk Data Insert Problem

    What is the size of your .data file after the program terminates with the error? If the size of your .data file reaches 64 GB, then this is the limit. You can increase this limit by uncommenting this line. // execute(con, "SET FILES SCALE 128"); If the size reached is much less than 64GB, the provide the csv. There may actually be an error in your code and rows may be...

    2013-05-19 04:20:16 PDT by fredt

Our Numbers