Projects / xlSQL / Comments

Comments for xlSQL

24 Jul 2004 01:16 jimcp

xlSQL Yn Development Branch
xlSQL is in active development. New development builds are available on a daily basis. If you would like to contribute to xlSQL through source, tests, comments or feature requests subscribe to the development branch first.

18 Jul 2004 01:48 jimcp

xlsql.properties file in Y4 - ( ? java.sql 1.4.2 bug ? )
The driver searches for a xlsql.properties file in the directory from which the calling program has been started. (The calling program could be a custom Java class or some generic JDBC gui.)

If the driver finds a xlsql.properties file it tries to read the MySQL connect properties. If it does the driver will use MySQL as the host SQL engine.

If the driver cannot connect to MySQL because it is down, the user / pass is incorrect etc., a problem occurs within the java DriverManager. The program starts to loop and crashes with a stack overflow. This situation cannot be catched with some exception.

No harm is done, check the properties and restart. The bug has been reported to Sun and is being investigated. When there is a fix it will be included in xlSQL Yn.

08 Jul 2004 06:51 jimcp

xlSQL Y3 Warning
*** ALERT ***

Directory C:\workbooks

MyBook1.xls

···sheet1······SQL

···sheet2······INVALID AS SQL TABLE

···sheet3······SQL

MyBook2.xls

···sheet1·········INVALID AS SQL TABLE

SomeWordDocument.doc

Y3 behaviour: 2 tables are created, case-sensitive and between quotes ( ! )

"MyBook1.sheet1"

"MyBook1.sheet3"

CREATE TABLE "MyBook1.sheet2" (COL1 VARCHAR, COL2 DOUBLE);

will in some ( most ? ) cases destroy sheet2 or make the workbook unreadable for Excel.

This bug is fixed in Y4.

Screenshot

Project Spotlight

ReciJournal

An open, cross-platform journaling program.

Screenshot

Project Spotlight

Veusz

A scientific plotting package.