1.9 online backups & syntax questions

[gould-4]

Hi, been using 1.9 for a few days now, and everything is going well so far.

A few backwards incompatabilities that I've noticed, not sure which ones are intentional or not for stricter standards adherence:

PreparedStatement.setObject no longer accepts a byte[] for a varbinary column.

ResultSet.getBinaryStream no longer works for a varbinary column. getBlob(index).getBinaryStream() does work.

Underscores no longer accepted as the leading characters in table names.

None of these things bother me very much (I've already worked around them), just thought you might want to know.

I only have one question so far: Does doing an online backup (BACKP  DATABASE  TO...) perform a checkpoint defrag first, or should I perform one manually before the backup? Thanks for this feature, by the way, it is extremely useful.

Thanks,
Carl Gould
Inductive Automation

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user

[Fred Toussi-2]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Thanks Carl. These points are interesting.

 

The longvarbinary and longvarchar types are translated inside the engine to varbinary and varchar. I have meant to allow an option for these types to be translated to BLOB and CLOB, but haven't done it yet.

 

setObject - needs fixing.

getBinaryStream  - probably needs fixing

 

Undercore is not accepted because it is against the standard. But as the standard usage is for introducing character sets, and these are not commonly used, I might allow an option for sql conformance in this area and allow the underscore.

 

The online backup performs a CHECKPOINT (without defrag) for speed. Perhaps we should add an option for defrag.

 

Thanks are due to Blaine Simpson for the research and implementation of the backup feature and its internal TAR functions.

 

Fred

 

 

On Fri, 16 Oct 2009 14:15 -0700, gould@... wrote:

Hi, been using 1.9 for a few days now, and everything is going well so far.

 

A few backwards incompatabilities that I've noticed, not sure which ones are intentional or not for stricter standards adherence:

PreparedStatement.setObject no longer accepts a byte[] for a varbinary column.

ResultSet.getBinaryStream no longer works for a varbinary column. getBlob(index).getBinaryStream() does work.

Underscores no longer accepted as the leading characters in table names.

None of these things bother me very much (I've already worked around them), just thought you might want to know.

 

I only have one question so far: Does doing an online backup (BACKP  DATABASE  TO...) perform a checkpoint defrag first, or should I perform one manually before the backup? Thanks for this feature, by the way, it is extremely useful.

Thanks,
Carl Gould
Inductive Automation

------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Hsqldb-user mailing list
Hsqldb-user@...
https://lists.sourceforge.net/lists/listinfo/hsqldb-user