[Hsqldb-developers] Version 1.9 Alpha 1 is released

2009-03-20 Thread fredt
The first alpha version of 1.9 is now available. Please download from http://hsqldb.org and test this package as soon as possible. Early feedback will accelerate QA and result in an early release. More information is provided in the download package. I'd like to thank all our users for the enco

[Hsqldb-developers] HSQLDB 1.8.0.10 released

2008-06-02 Thread fredt
The latest release of HSQLDB fixes some bugs. No new features have been added since the last point release. All users are encouraged to switch to this release. We will now concentrate on the release of the next major version, 1.9, in the coming weeks. Fred Toussi Maintainer, HSQLDB Project -

Re: [Hsqldb-developers] String aggregate functions

2007-10-26 Thread fredt
Hi Manatel, I'm writing off list as this is related to donations. We would welcome donations as mentioned on our web site. I would like to clarify the feature that you require. The SUM() aggregate function would return the concatenations of the strings in different rows. So if there are three r

Re: [Hsqldb-developers] String aggregate functions

2007-10-22 Thread fredt
There may be something in the patches section. The class that handles the aggregates is SetFunction and it is relatively easy to add new functions to this class. But references to any new function should also be added to Parser and Expression classes, so that they are recognised and evaluated.

[Hsqldb-developers] HSQLDB 1.8.0.8 released

2007-08-30 Thread fredt
The latest bugfix release of HSQLDB 1.8.0 branch is now available. This version of the engine is fully compatible with the last point release. Please read the changelist_1_8_0.txt file in the /doc folder for the list of fixes and enhancements. Among the utilities, the SqlFile utility has under

Re: [Hsqldb-developers] does FileOutputStream.close imply sync?

2007-08-09 Thread fredt
Thanks, The close() method should save the contents of the file. But since we have previously seen cases of Java runtimes not working consistently, it would be a good idea to add the synch() explicitly. I have added the extra line to the CVS. Fred - Original Message - From: "Yudhi Wi

Re: [Hsqldb-developers] Retrieving autogenerated keys

2006-09-19 Thread fredt
This will be added before the end of the year. Fred - Original Message - From: "Christian Hauser" <[EMAIL PROTECTED]> To: Sent: 19 September 2006 20:15 Subject: [Hsqldb-developers] Retrieving autogenerated keys Hello There's an optional feature of JDBC 3.0 that allows for retrieving a

Re: [Hsqldb-developers] Re: Issue with SEQUENCE

2006-05-16 Thread fredt
FOR SIMPLE_SEQ FROM DUAL),'Name1')   works where DUAL is a table I created that has 1 record.   Is there a more elegant way of inserting the sequence without using the DUAL table?           On 4/21/06, fredt <[EMAIL PROTECTED]> wrote: I

Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.

2006-04-27 Thread fredt
rs] FW: 1.8.0.4 seems to have some problems.   Fred seems to have replied but I didn't get it for some reason (Hsqldb mailing lists are sometimes very sporadic - I saw this through the web interface)   From: fredt <[EMAIL PROTECTED]...> Re:

Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.

2006-04-27 Thread fredt
some problems.   Fred seems to have replied but I didn't get it for some reason (Hsqldb mailing lists are sometimes very sporadic - I saw this through the web interface)   From: fredt <[EMAIL PROTECTED]...> Re: 1.8.0.4 seems to have some prob

Re: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems.

2006-04-27 Thread fredt
@lists.sourceforge.net Sent: 27 April 2006 20:26 Subject: RE: [Hsqldb-developers] FW: 1.8.0.4 seems to have some problems. Fred seems to have replied but I didn't get it for some reason (Hsqldb mailing lists are sometimes very sporadic - I saw this through the web interface) From:

Re: [Hsqldb-developers] French translation of error messages

2006-04-24 Thread fredt
Hi Frederic,   Thanks for the effort. We do have a French translation, but it is always better to have more than one person reviewing and maintaining each translation. The translations have been so far maintained by the OpenOffice.org project, where they have a regularly updated list in the

[Hsqldb-developers] HSQLDB / OOo and Google Summer of Code

2006-04-24 Thread fredt
The Google Summer of Code project http://code.google.com/summerofcode.html provides monetary rewards to students for work on Open Source projects. This year, two HSQLDB-related projects will be sponsored by OpenOffice.org. One of these will be co-mentored by myself and concerns the introduction

Re: [Hsqldb-developers] Re: Issue with SEQUENCE

2006-04-22 Thread fredt
additional records in which case it will create a problem. Is there a way to lock it or to have a SYSTEM table that always has 1 record that I can use the NEXT VALUE FOR clause?   CREATE TABLE dual (test  INTEGER NOT NULL); INSERT INTO dual VALUES (1);  On 4/21/06, fredt <[EM

Re: [Hsqldb-developers] Re: Issue with SEQUENCE

2006-04-21 Thread fredt
); INSERT INTO dual VALUES (1);  On 4/21/06, fredt <[EMAIL PROTECTED]> wrote: >> was similar to DUAL in Oracle   The dual table is Oracle is just a table with a single row. You can make your own.   >>  the first field of the

Re: [Hsqldb-developers] Re: Issue with SEQUENCE

2006-04-21 Thread fredt
cord into test_sequence table INSERT INTO test_sequence VALUES (1,'test');   5. Try again SELECT NEXT VALUE FOR sequence_seq_id FROM test_sequence; This time it returns 1 (shouldn't it be 2).   Please help.   Nitin On 4/21/06, fredt <[EMAIL PROTECTED]>

[Hsqldb-developers] Re: Issue with SEQUENCE

2006-04-21 Thread fredt
SYSTEM_SEQUENCES should not be used for getting sequence values. Use your own tables. For example   SELECT NEXT VALUE FOR login_password_SEQ FROM  my_table;   Sequences are designed mainly for inserting new rows, or for updating existing rows, e.g.   INSERT INTO my_table (a, b, c) VALUES (NEXT

Re: [Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

2006-04-20 Thread fredt
s] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4 Thanks Fred - it works.   But in several use groups this question about SEQUENCES not working has popped up perhaps because they do not know that INFORMATION_SCHEMA needs to be prepended.   Best Regards.   Nitin  On 4/20/06,

[Hsqldb-developers] Re: SEQUENCES DO NOT WORK IN HSQLDB 1.8.0.4

2006-04-20 Thread fredt
You need to use:   SELECT * FROM INFORMATION_SCHEMA.SYSTEM_SEQUENCES   Please read the docs on SCHEMA and SEQUENCE support. Also note that you do not use the above query in order to access the sequences. The _expression_ used is "NEXT VALUE FOR a_sequence"   Fred - Original Message

Re: [Hsqldb-developers] HSQLDB 1.8.0.4 Released

2006-04-17 Thread fredt
IL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of fredt Sent: Monday, April 17, 2006 1:28 PM To: hsqldb-developers; hsqldb-user Subject: [Hsqldb-developers] HSQLDB 1.8.0.4 Released This is the latest bug-fix update to 1.8.0. All reported bugs have been fixed in this update. There is also a

[Hsqldb-developers] HSQLDB 1.8.0.4 Released

2006-04-17 Thread fredt
This is the latest bug-fix update to 1.8.0. All reported bugs have been fixed in this update. There is also a change to the way the .properties file is saved, avoiding deletion of this file when database and system shutdown coincide. Details in changelist_1_8_0.txt file An enhancement to Server

Re: [Hsqldb-developers] Typo on user manual

2005-12-16 Thread fredt
Thanks, We should count them more carefully :) But the [[AS] label] brackets are needed because AS is optional and not required with a lebel. Fred - Original Message - From: "Jérôme Paschoud" <[EMAIL PROTECTED]> To: Sent: 16 December 2005 10:32 Subject: [Hsqldb-developers] Typo on us

[Hsqldb-developers] localizing HSQLDB error messages - call for contribution

2005-11-21 Thread fredt
ready have an italian translation in the same folder which you can use as example. Fred Toussi, Maintainer, HSQLDB Project - Original Message - From: "Frank Schönheit" <[EMAIL PROTECTED]> To: Cc: "fredt" <[EMAIL PROTECTED]> Sent: 21 November 2005 1

Re: [Hsqldb-developers] architecture of the persistence package...?

2005-11-10 Thread fredt
Well, you need to study the sources further as such capabilites already exist. Depending on table type, we store the data in different forms. One of these forms (for CACHED tables) has similarities to the paged file storage used by other products. In short, you can build and access a database w

Re: [Hsqldb-developers] Survey of Scanners and Parsers

2005-10-18 Thread fredt
Last year, work was carried out off list and two partial / demo implementations, one with JFlex + CUP and one with JavaCC were produced. As the two developers that participated had to concentrate on other work, this was not progressed since. My assessment of the whole project can be summarized

Re: [Hsqldb-developers] HsqlTimer.shutdown()

2005-10-18 Thread fredt
Yes, this would be a good thing to add to the code. Note that the timer can serve more than one database, so the code should check the count of remaining databases in org.hsqldb.DatabaseManager Fred - Original Message - From: "Tobias Bocanegra" <[EMAIL PROTECTED]> To: Sent: 18 October

Re: [Hsqldb-developers] Persistant storage

2005-10-13 Thread fredt
care of themself to backup or is it better to have a new package that takes as an input a table an that returns a byte array representing the table? I hope that it's now clear where I want to go. CU Jerome fredt wrote: > Well done! > > What do you mean by this question? If there is n

Re: [Hsqldb-developers] Persistant storage

2005-10-13 Thread fredt
Well done! What do you mean by this question? If there is no file system, where do you intend to save the tables and views? Do you mean you want to create a database outside the J2ME environment that contains the tables and data, then read it inside the J2ME environment? Perhaps you should loo

Re: [Hsqldb-developers] Parser / extended SQL syntax

2005-09-13 Thread fredt
No parser generator. Classes to look at are Parser.java, Expression.java, etc. Fred - Original Message - From: "Johannes von Stetten" <[EMAIL PROTECTED]> To: Sent: 13 September 2005 17:49 Subject: Re: [Hsqldb-developers] Parser / extended SQL syntax Hi again, fred

Re: [Hsqldb-developers] Access to Database Server

2005-09-12 Thread fredt
The full connection URL should be as follows. jdbc:hsqldb:hsql://localhost/mydb Fred - Original Message - From: "Dianing Galih Yudono" <[EMAIL PROTECTED]> To: Sent: 13 September 2005 07:02 Subject: [Hsqldb-developers] Access to Database Server How to access a specific database in da

Re: [Hsqldb-developers] General Architecture Informations

2005-09-12 Thread fredt
e removed or how to Patch? -Can org.hsqldb.lib.SimpleLog be removed or how to Patch? -In package org.hsql.persist I remove everything exept CacheObject, HsqlDatabasePoperties and hsqlProperties. Is there something missing or is that the desired minimum? Thanks Jerome fredt wrote: > You can remove all those clas

Re: [Hsqldb-developers] General Architecture Informations

2005-09-12 Thread fredt
UnzipFile class? Can I remove safelyn the org.hsqldb.lib.FileAccess class? What to do with org.hsqldb.lib.java.JavaSystem? Thanks Jerome fredt wrote: > You need to remove the dependencies. The Locale can be removed from the > Collation class. You can also remove the use of the Properties

Re: [Hsqldb-developers] GROUP_CONCAT (was: SUM for Strings)

2005-09-09 Thread fredt
- Hash: SHA1 Thanks Fred, I implemented it that way. You were right, this was fairly straight forward. Are you interested in the patches, should I post them somewhere? Thanks for your help, Wolfgang fredt wrote: > The correct thing to do is actually implement GROUP_CONCAT. Just check the &

Re: [Hsqldb-developers] General Architecture Informations

2005-09-09 Thread fredt
a.util.Locale. Their is no localisation system in J2ME (no java.text.Format, no java.io.Reader). If you could help me on that I could go a bit further. CU Jerome fredt wrote: > You can determin class loading by looking at the uses of Class and > Class.forName() etc. > > If you rem

Re: [Hsqldb-developers] SUM for Strings

2005-09-09 Thread fredt
The correct thing to do is actually implement GROUP_CONCAT. Just check the code base and find all the uses of Token.T_SUM and Expression.SUM. Then add a new Token.T_GROUP_CONCAT and a new Expression.GROUP_CONCAT and some code to handle this case to all the places where Token.T_SUM and Expression

Re: [Hsqldb-developers] General Architecture Informations

2005-09-08 Thread fredt
You can determin class loading by looking at the uses of Class and Class.forName() etc. If you remove Log.java and its dependent classes, most of the IO related stuff would disappear. Fred - Original Message - From: "Jérôme Paschoud" <[EMAIL PROTECTED]> To: Sent: 08 September 2005 16

Re: [Hsqldb-developers] Re: [Hsqldb-developpers] General Architecture Informations

2005-09-08 Thread fredt
o you think about that, is it a good direction? CU Jerome fredt <[EMAIL PROTECTED]>wrote: > You should look at the jarmin target in build.xml which excludes all > the server-related classes and more. > > The org.hsqldb.util package is not part of the engine. > > You can al

Re: [Hsqldb-developers] General Architecture Informations

2005-09-07 Thread fredt
eeking informations on the architecture of HSQLDB, I've already found some (thanks to fredt) in the power point presentation called "Architecture HypersonicSQL". I'm mostly interested in finding what classes are usefull for a minimal, standalone, in memory table implementation. I think

[Hsqldb-developers] HSQLDB and Multiversion Concurrency Control

2005-08-30 Thread fredt
HSQLDB is breaking new ground! I am pleased to (pre) announce the HSQLDB 1.9.x series, featuring Multiversion Concurrency Control. In this series, all rows involved in transactions include the full change history. This allows multi-threaded, non-blocking reads and writes, with conflict detecti

Re: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-fix to the aggregates/build-in types problem

2005-08-24 Thread fredt
he problem to the original code and fixed it (in _expression_.updateAggregatingValue()). Have just committed the changes to the CVS hsqldb-dev module Fred - Original Message - From: "fredt" <[EMAIL PROTECTED]> To: Sent: 16 August 2005 16:04 Subject: Re: [Hsqldb-developers] hsq

Re: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-fix to the aggregates/build-in types problem

2005-08-24 Thread fredt
key. > >For Aggregates and CASE WHEN, I traced the problem to the original code and >fixed it (in Expression.updateAggregatingValue()). > >Have just committed the changes to the CVS hsqldb-dev module > >Fred > >- Original Message - >From: "fredt" <

Re: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-fix to the aggregates/build-in types problem

2005-08-18 Thread fredt
Expression.updateAggregatingValue()). Have just committed the changes to the CVS hsqldb-dev module Fred - Original Message - From: "fredt" <[EMAIL PROTECTED]> To: Sent: 16 August 2005 16:04 Subject: Re: [Hsqldb-developers] hsqldb - added features like Right Join support, e

Re: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-fix to the aggregates/build-in types problem

2005-08-16 Thread fredt
Thanks for the effort. I have done the first review of the patches: DOW: This looks fine. SET NOT NULL: This has yet to check for values in existing rows. We have a similar test for another alter command and can reuse it. RIGHT OUTER: This looks fine. I need to check and test it further. Aggregat

Re: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-fix to the aggregates/build-in types problem

2005-08-15 Thread fredt
Thanks for the patches. I will review them later today and comment here. Fred - Original Message - From: "Marc de Hoop" <[EMAIL PROTECTED]> To: Sent: 15 August 2005 15:14 Subject: [Hsqldb-developers] hsqldb - added features like Right Join support, extract(dayofweek) and another bug-f

Re: [Hsqldb-developers] Right Join

2005-08-10 Thread fredt
This is doable but not very simple. The LEFT JOIN support is based on the fact that the outer table is before the inner table in the parsing order. You could probably parse RIGHT JOIN statements then reverse the order of the tables for join purposes. The data structure is an array of TableFilter

Re: [Hsqldb-developers] Patch format

2005-08-08 Thread fredt
Thanks, It's best to zip all the modified source files and upload them to Patch Tracker at our Sourceforge sit. https://sourceforge.net/tracker/?group_id=23316&atid=378133 Fred - Original Message - From: "Marc de Hoop" <[EMAIL PROTECTED]> To: Sent: 08 August 2005 10:26 Subject: [Hsqld

Re: [Hsqldb-developers] Type "bit" with value null in union craches Hibernate JDBC Connection

2005-07-15 Thread fredt
It must be something to do with the unspecified type of the literal null value. Try this instead: select id,cast(null as boolean) as b1 from test2 union select id,b1 from test1; Will include check to prevent this in a future point release. Fred - Original Message - From: "Michael Wyr

[Hsqldb-developers] HSQLDB 1.8.0.1 point release

2005-07-12 Thread fredt
HSQLDB 1.8.0.1 fixes the bugs that have been reported since the release of 1.8.0.0. This version is recommended as a replacement for 1.8.0.0. List of fixed issues is in the changelist doc in the zip package. Fred Toussi Maintainer, HSQLDB Project -

[Hsqldb-developers] HSQLDB SupportWare takes off

2005-06-29 Thread fredt
and other possible developments. Fred Toussi Maintainer, HSQLDB Project fredt (at) users.sourceforge.net http://hsqldb.org --- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps

Re: [Hsqldb-developers] custom aggregate function

2005-06-27 Thread fredt
Title: HSQLDB Help Needed Hi Steve,   This is supported in 1.8.0, alongside 3 other statistical aggregate functions. See the Syntax section of the Guide. The core class for these functions is SetFunction.   Fred  - Original Message - From: Stephen Ince To: hsqldb-develop

Re: [Hsqldb-developers] HSQLDB Help Needed

2005-06-25 Thread fredt
Title: HSQLDB Help Needed What is the HSQLDB question here?   Fred - Original Message - From: Kandikattu, Sunil To: hsqldb-developers@lists.sourceforge.net Sent: 24 June 2005 20:47 Subject: [Hsqldb-developers] HSQLDB Help Needed Hi I am sunil , I am using H

[Hsqldb-developers] Our new website at HSQLDB.ORG

2005-06-23 Thread fredt
I have just launched our new web site at HSQLDB.ORG. The new web site will allow us to improve documentation and support and help in fundraising for the next version of HSQLDB. The new SupportWare program is featured on the new site. Please see http://hsqldb.org Fred Toussi Maintainer, HSQLDB

[Hsqldb-developers] 1.8.0 RC12 Released

2005-06-16 Thread fredt
I am pleased to announce the latest (and really the final) Release Candidate for HSQLDB 1.8.0 is now available on the file download page. A few relatively minor issues were reported and fixed in this RC. Due to popular demand, a new option has been added to allow the database to shutdown when t

[Hsqldb-developers] OpenOffice.org Conference and HSQLDB

2005-06-15 Thread fredt
The third International OOoCon will be held this year from 28 to 30 September in Koper - Capodistria, Slovenia (near Trieste in Italy). HSQLDB will be featured in the Conference as the integral database engine for OOo 2.0. Conference orginisers need more sponsorships and support. So if you can

[Hsqldb-developers] Bogus Open Source Survey

2005-06-14 Thread fredt
A clearly bogus email signed by "Students Erasmus University Rotterdam" is being circulated. It asks Open Source developers to participate in a survey. This is probably the beginning, and there will be more to come in different shapes. Please warn all Open Source mailing lists to keep an eye fo

Re: [Hsqldb-developers] Collation / Collator /

2005-05-25 Thread fredt
probably needs additions to the code to specify the strength. Fred - Original Message - From: "Nils Meier" <[EMAIL PROTECTED]> To: Sent: 24 May 2005 03:35 Subject: [Hsqldb-developers] Collation / Collator / Hi in 1.7.x I'm able to configure all columns to use a collator for comparison

[Hsqldb-developers] Remaining Work for 1.8.0

2005-05-19 Thread fredt
The final release of 1.8.0 should be out by the end of the month. In the meantime, any reported bugs will be fixed and committed to CVS. Already a few minor changes have been committed. There is other tidying up work to do in the meantime. 1. MSDOS batch files for building HSQLDB are out of da

[Hsqldb-developers] 1.8.0 RC 10 Released

2005-05-17 Thread fredt
The Release Candidate 10 package for 1.8.0 is available from the file download page on the site. There are some new features and enhancements in this RC. This is the final release candidate for 1.8.0. Please test and report any issues. The jar is compatible with OpenOffice.org beta 1.9.100 and c

Re: [Hsqldb-developers] Connection is broken error when trying to get connection

2005-04-06 Thread fredt
User name and password may be incorrect. By default, they are "SA" and "" respectively. Please post help request to the hsqldb-users mailing list. Fred - Original Message - From: "Sanjeev Tripathi" <[EMAIL PROTECTED]> To: Sent: 06 April 2005 20:07 Subject: [Hsqldb-developers] Connecti

Re: [Hsqldb-developers] Update Problem

2005-04-04 Thread fredt
You should be able to do this with an explicit select from the other table. E.g.    update turq_bills set bill_document_no=(SELECT turq_bill_commons.bill_document_no FROM turq_bill_commons where turq_bill_commons_id=turq_bill_commons.id); Fred- Original Message - From: Onsel

Re: [Hsqldb-developers] (no subject)

2005-04-04 Thread fredt
Sure, but you should post to the hsqldb-user mailing list. This list is not for support. Fred - Original Message - From: "Samoylov010180" <[EMAIL PROTECTED]> To: Sent: 04 April 2005 15:57 Subject: [Hsqldb-developers] (no subject) Hello! I am Nick, java developer. Can i get some hsqld

[Hsqldb-developers] PolePosition database speed test

2005-04-02 Thread fredt
I was informed of a new SourceForge project for a database speed test framework. The web site is at www.polepos.org . The framework allows setting up different test scenarios, based on a motor racing model, and executes them against different database engines. As usual, HSQLDB shows its speed in

Re: [Hsqldb-developers] isolation support in HSQL 1.8.0 version

2005-03-31 Thread fredt
You should use the hsqldb-dev CVS version for this.   Fred - Original Message - From: Irum Godil To: hsql Sent: 30 March 2005 21:24 Subject: [Hsqldb-developers] isolation support in HSQL 1.8.0 version Hi,   I downloaded HSQL version 1.8.0 from the website an

Re: [Hsqldb-developers] isolation supported

2005-03-31 Thread fredt
Hi Irum,   You have lots of questions all the thime :).    1) This code has not been released. By the time it does, it will allow only some isolation levels. In its current form it does not support more than one level.   2) The locks are on modified rows not predicates. Don't be too concerne

Re: [Hsqldb-developers] Thanks for the Transfer util, and patches

2005-03-30 Thread fredt
Thanks Sumit, One-off small patches posted here are fine. For bigger changes please use the HSQL Utilities patch tracker on our SourceForge site. Fred - Original Message - From: "Sumit Bando" <[EMAIL PROTECTED]> To: Sent: 30 March 2005 07:09 Subject: [Hsqldb-developers] Thanks for the

Re: [Hsqldb-developers] Closing of Databases

2005-03-29 Thread fredt
You should execute the SQL command "SHUTDOWN" to shutdown the database. You are obviously not doing this and relying on autorecovery at the next startup. Please read the documentation.   Fred - Original Message - From: Irum Godil To: hsql Sent: 29 March 2005 19:43 Subj

Re: [Hsqldb-developers] Transactions in Hsql

2005-03-27 Thread fredt
will really appreciate your responses to the above and they will tremendously help me in my research.   Thanks. Sincerely, Irum Godil .     fredt <[EMAIL PROTECTED]> wrote: Your understanding of the implementation is correct. There is no transaction isolat

Re: [Hsqldb-developers] Scripting in HSQL

2005-03-19 Thread fredt
-developers@lists.sourceforge.net Sent: 19 March 2005 23:24 Subject: Re: [Hsqldb-developers] Scripting in HSQL But all the files in scriptio package such as ScriptWriterText, ScriptReaderBase, etc. are only useful for persistent databases right?fredt <[EMAIL PROTECTED]>

Re: [Hsqldb-developers] Scripting in HSQL

2005-03-19 Thread fredt
Sure, see the documentation. Both "SCRIPT" and "SCRIPT " can be used for pure in-memory databases and are obviously useful commands.   Fred - Original Message - From: Irum Godil To: hsql Sent: 19 March 2005 22:01 Subject: [Hsqldb-developers] Scripting in HSQL H

[Hsqldb-developers] Need Test Files for Collations

2005-03-18 Thread fredt
For OpenOffice.org integration, we have developed a new feature to specify the collation (sorting order) for all character-based columns in the database.   The collations we are planning to use are listed below. We need word list files for different languages that demonstrate how different w

Re: [Hsqldb-developers] Transaction Commit

2005-03-12 Thread fredt
Yes Campbell, the enhancement you suggest is being implemented for 1.8.0 Fred - Original Message - From: "Lorna Burnet" <[EMAIL PROTECTED]> To: Sent: 12 March 2005 22:24 Subject: Re: [Hsqldb-developers] Transaction Commit It happens because in hsqlsb, currently, data definition langu

Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0

2005-03-10 Thread fredt
Using ant, you need to set the environment variable JAVA_HOME to the JDK you want to use. So JAVA_HOME should be different when you use JDK 1.3 to compile the sources. TestBase.java has a flag in the source to use a server. It does not use a -D flag. I don't know how writing to one database ca

Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0

2005-03-10 Thread fredt
Thanks, Seems you're making progress. The instructions for CodeSwitcher are also in the Guide document. The main tests to run are those in the org.hsqldb.test directory, especially TestSelf.java. Some of these tests require JDK > 1.1, so you can exclude them. For client/server, you should mod

Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0

2005-03-07 Thread fredt
ginal Message - From: "Carfield Yim" <[EMAIL PROTECTED]> To: Sent: 07 March 2005 14:29 Subject: Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0 On Mon, 7 Mar 2005 11:28:29 -, fredt <[EMAIL PROTECTED]> wrote: > There may be such problems, that'

Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0

2005-03-07 Thread fredt
Fred - Original Message - From: "Carfield Yim" <[EMAIL PROTECTED]> To: Sent: 07 March 2005 11:04 Subject: Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0 On Mon, 7 Mar 2005 10:14:34 -, fredt <[EMAIL PROTECTED]> wrote: > Hi Carfiled, > > The buil

Re: [Hsqldb-developers] Fwd: Small developer tasks for 1.8.0

2005-03-07 Thread fredt
Hi Carfiled, The build process has changed over different versions. We cannot change it as you suggest, as the issue is not just the use of collections and io stuff. The primary issue that requires different JDK's is the changes in java.sql interfaces between different JDK releases. For buildi

[Hsqldb-developers] 1.8.0 RC9 and HSQLDB / OOo appeal

2005-03-04 Thread fredt
This is a repeat post of a messag sent over 24 hours ago and held up by some mailserver on the way. Sent: 03 March 2005 12:11 Subject: 1.8.0 RC9 and HSQLDB / OOo appeal The latest RC9 is available from the file download page. This RC fixes a number of bugs (some significant) and extends type co

Re: [Hsqldb-developers] Transactions in Hsql

2005-02-28 Thread fredt
Your understanding of the implementation is correct. There is no transaction isolation in the version you have studied, but this feature is being added. The methods for isolation levels are part of the JDBC standard.   Isolation may be necessary for certain applications, especially existing

Re: [Hsqldb-developers] Another way to access a database

2005-02-23 Thread fredt
If you run HSQLDB as a server, you can access it from different processes. You can divide very large deletes or selects from CACHED tables into smaller ones using a range of values in an indexed column. Fred - Original Message - From: "Alexandre Boaventura" <[EMAIL PROTECTED]> To: Se

[Hsqldb-developers] HSQLDB Featured in JDJ Readers Choice Poll

2005-02-21 Thread fredt
HSQLDB is among the 12 (mostly closed-source) RDBMS choices in the Best Enterprise Database category in Java Developers' Journal readers poll. http://www.sys-con.com/java/readerschoice2004/liveupdate.cfm?BType=3 Please vote for the RDBMS of your choice. The page mentions that votes will be audi

Re: [Hsqldb-developers] Some Question of HSQLDB

2005-02-17 Thread fredt
Hi Yu, This sounds good. Generally the answer is positive and many of the points have been covered on our web site. Latest stable version is 1.7.3.3 but 1.8.0 is nearing release and is better. If you want more detailed answers, you can buy professional support for HSQLDB via http://www.hxsql.

Re: [Hsqldb-developers] Re: hsqldb-developers digest, Vol 1 #379 - 1 msg

2005-02-15 Thread fredt
;Re: Contents of hsqldb-developers digest..." :: :: :: Today's Topics: :: :: 1. Small developer tasks for 1.8.0 (fredt) :: :: --__--__-- :: :: Message: 1 :: From: "fredt" <[EMAIL PROTECTED]> :: To: "hsqldb-user" <[EMAIL PROTECTED]>, :: "hsqldb-dev

[Hsqldb-developers] Small developer tasks for 1.8.0

2005-02-14 Thread fredt
For 1.8.0, these tasks are remaining. Volunteers needed to finish them. They must already be familiar with the code area and the functionality. In the past, I've done this sort of thing myself, but currently I have not got enough time over and above fixing the reported bug and the overal relea

[Hsqldb-developers] HSQLDB 1.7.3.3 Released

2005-02-07 Thread fredt
This is a maintenance release of 1.7.3. This reviison fixes a bug with loggin of deletes / updates from tables without primary keys. If the a row from such tables contained a null value and was deleted / updated, the operation was not logged correctly. Subsequently, if there was an abnormal te

[Hsqldb-developers] HSQLDB 1.8.0 RC5

2005-01-24 Thread fredt
Latest Release Candidate for 1.8.0 is now available from the Files page. New features are listed in the changelist file in the /doc folder. Fred Toussi Maintainer, HSQLDB Project --- This SF.Net email is sponsored by: IntelliVIEW -- Interacti

[Hsqldb-developers] HSQLDB 1.8.0 RC4

2005-01-20 Thread fredt
RC4 can be downloaded from the project file download page. This version restores support for text tables and fixes a few bugs. Please note that as a result of introduction of support for extended ResultSetMetaData in client/server mode, you need to use RC4 both as client and server. Fred Touss

[Hsqldb-developers] HSQLDB 1.8.0 RC 3 is out

2005-01-16 Thread fredt
A couple of bugs have been fixed in this RC. There is also a new mechanism to automate the defragmentation of the .data file. This and previous improvments should allow a JBoss installation of HSQLDB to work seamlessly for an indefinite period without running out of .data file space. The Sourc

[Hsqldb-developers] 1.8.0 Release Candidate 2 is out

2005-01-14 Thread fredt
Bugs related mainly to failure to keep the data backup file and similar have been fixed in this version. It is certainly getting more like a full release. Tests indicate that overall performance is up to 10% better than 1.7.3. Please test and report your findings. Fred Toussi Maintainer, HSQL

[Hsqldb-developers] First Release Candidate for HSQLDB 1.8.0

2005-01-10 Thread fredt
I am pleased to announce the release of 1.8.0.RC1. This release features the code needed for embedding into OpenOffice.org, added by Ocke Janssen of OOo. There are lots of code enhancements which were originally developed for HyperXtremeSQL (http://www.hxsql.com). These include a rewritten imp

Re: [Hsqldb-developers] JPG's added for NewDatabaseManagerSwing Look and feels

2004-12-30 Thread fredt
Yes, the code will be released in the next few days as part of the 1.8.0 RC1 release.   Fred - Original Message - From: IchBin To: hsqldb-developers@lists.sourceforge.net Sent: 30 December 2004 02:11 Subject: RE: [Hsqldb-developers] JPG's added for NewDatabaseMana

Re: [Hsqldb-developers] Problem with runUtil.sh

2004-12-28 Thread fredt
m right and you're wrong. I'm saying that it is "debatable" whether runUtil.sh helps a starter to understand the way hsql works. I have shown why I believe that, at least in some cases, it hinders an understanding of how Hsqldb works. >I can volunteer to help rectify the s

Re: [Hsqldb-developers] Problem with runUtil.sh

2004-12-27 Thread fredt
It is assumed that people know how to run a Java program in their particular environment. The supplied short scripts are just examples to provide hints. Fred - Original Message - From: "Amit Handa" <[EMAIL PROTECTED]> To: Sent: 27 December 2004 06:17 Subject: [Hsqldb-developers] Proble

Re: [Hsqldb-developers] problem running the tests

2004-12-23 Thread fredt
Thanks, Please submit the script in .zip form to the Patch Tracker on the HSQLDB SourceForge site. Fred - Original Message - From: "Leen De Schutter" <[EMAIL PROTECTED]> To: "hsqldb-developers" Sent: 23 December 2004 10:21 Subject: Re: [Hsqldb-developers] problem running the tests Ok

Re: [Hsqldb-developers] problem running the tests

2004-12-23 Thread fredt
roblem running the tests Done - should I write a documentation file detailing how to execute the tests? Leen On Thu, 2004-12-23 at 12:45 +, fredt wrote: > Thanks, > > Please submit the script in .zip form to the Patch Tracker on the HSQLDB > SourceForge site. > > Fred > ---

[Hsqldb-developers] Free HyperXtremeSQL Licenses

2004-12-08 Thread fredt
As a seasonal token of appreciation for all those who have consistently helped with HSQLDB development and support, the following goodies are now available: 1. A user license (LIC-001-005-BAS) for HyperXtremeSQL is available free of charge to all project developers who are on the list and also

[Hsqldb-developers] HSQLDB 1.7.3 Released

2004-12-05 Thread fredt
The new 1.7.3 release features improved handling of the BOOLEAN type according to SQL standards. This is the first major update contributed by Thomas Mueller since the beginning of the HSQLDB project. Apart from this change, all other features are identical to 1.7.2.10, also released today. whi

Re: [Hsqldb-developers] 1.3.1 and 1.4.1 End of Life question

2004-11-28 Thread fredt
"End of Life" JDK's have regularly been revived as new platforms for small devices. Also, on some platforms, there are still issues with "current" versions, so the "End of Life" versions have to be used. As a result, we have established the following policy over the last couple of years.   H

Re: [Hsqldb-developers] DatabaseManagerSwing modifications/enhancements Question

2004-11-20 Thread fredt
I cannot comment on building and running with eclipse. The simplest way to recompile and test manually is:   -install ant -expand the distribution zip -change directory to /hsqldb/build -type ant jar   This will replace the /lib/hsqldb.jar with a new version.   Now copy your modified and chan

Re: [Hsqldb-developers] Adding a table Remarks attribute

2004-11-15 Thread fredt
This enhancement is supposed to reflect the relevent column returned by the JDBC DatabaseMetaData call, getTables().   At the time of 1.7.0, this column was supposed to return CACHED or TEXT or MEMORY from the HSQLDB engine. Since the metadata support was rewritten for 1.7.2, this column ret

[Hsqldb-developers] New 1.7.2 revision 8

2004-11-15 Thread fredt
The latest revision 8 of 1.7.2 is now available. I will wait a week before releasing 1.7.3, which is essentially the same code with the addition of SQL standard BOOLEAN support. Please try the latest version and help find any regression errors that might have appeared in this version. Fred To

  1   2   3   >