User Activity

  • Posted a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    That's right, Keith. Competing with that limitation, SqlTool has the advantage that if the SQL can be written in portable fashion (not possible if using proprietary SQL additions), the same script can be executed against HyperSQL and PostgreSQL.

  • Posted a comment on discussion Help on HyperSQL Database Engine (HSQLDB)

    I suggest you use SqlTool, which is designed to execute SQL files, and can detect and handle errors more reliably and with more control than Database Manager.

  • Posted a comment on discussion Open Discussion on HyperSQL Database Engine (HSQLDB)

    SqlTool doesn't support input or output of times without dates. This isn't a HyperSQL database limitation, but a SqlTool limitation so that SqlTool can behave the same regardless of database back end. Relevant code comment: // N.b. WE SPECIFICALLY DO NOT HANDLE TIMES WITHOUT // DATES, LIKE "3:14:00", BECAUSE, WHILE THIS MAY BE // USEFUL AND EFFICIENT, IT IS NOT PORTABLE. You can customize output format however you wish to by coding the Java extraction and string formatting around line 3927 of SqlFile.java...

  • Posted a comment on discussion Open Discussion on HyperSQL Database Engine (HSQLDB)

    When I have time on the weekend, I'll check if there is a direct way. In the mantime, you can specify the column list explicitly instead of "*" and use a SQL function to format the date/column as you want it. (FYI, you don't have to quote PUBLIC).

  • Committed [r5756]

    Merge revs 5753-5755 from truk unto tag 2.3.5

  • Committed [r5752]

    Merged in commit 5748 from trunk into tag 2.3.5

  • Committed [r5751]

    Prep for release 2.3.5

  • Committed [r5750]

    Release tag for 2.3.5. Tag adjustments forthco...

View All

Personal Data

Username:
unsaved
Joined:
2002-05-22 15:09:54

Projects

Skills

  • No skills entered.

Personal Tools