Release notes.
The data type conversion has been improved. The main documentation of the add-in explains how this is being done starting with this version.
This version has been tested under the following platforms:

• OpenOffice 2.3 (Spanish), 2.4.x (US English), and 3.0.x (US English)
• Linux
• Windows 2000, and XP SP2 & SP3

with the following drivers:

• JDBC MySQL JDBC driver (com.mysql.jdbc.Driver class) ver. 5.0.8
• Oracle JDBC thin driver (ojdbc14.jar) with Oracle Database 10g Release 10.2.0.2.0 - 64bit Production
• HXTT DBF JDBC Driver ver. 4.2

Known bugs

• When a date field contains NULL, Calc displays #VALUE! in all cells (07-feb-2009 by jc). A possible workaround is to use MySQL IFNULL() function to avoid null values on date fields.

Release notes.

• When a connection is lost (i.e. closed), the code attempts to reconnect (i.e. to obtain a new connection from the driver manager)
• Improved error handling
• The names of the parameters are now correctly localized for the Spanish locale
• The messages for the parameters in the function wizard are now more explicit (hopefully)

Bugs

• The MySQL tinyint(1) data type is being returned as a Boolean, which Calc does not recognize, resulting in an empty cell value (for nulls) or zero (for any other value)
• Sometimes, an unsigned int(11) is being returned as a Long and not being recognized by Calc

Adds the SQLREQUEST function to CALC. This function is similar to the SQL.REQUEST function of MS-Excel.
SQLREQUEST is an array function. This means that it results in an array containing the data returned by the data source. The online help of Calc includes the "Array Functions" section explaining how to use them.
The following is an example of a typical call using the MySQL J/Connector driver:
=SQLREQUEST("com.mysql.jdbc.Driver";"jdbc:mysql://server_ip_address/?user=name&password=abc";"SELECT * FROM table")
Release notes.

1. This is the first release :)
2. Data type conversion.
   • SQL Date values are converted to a Calc compatible number.
   • SQL Decimal values are converted to doubles, so be aware of the possible loss of precision.
     All your suggestions to improve this point are appreciated!
3. This version has been tested using:
   • OpenOffice 2.3.0 (US English)
   • Windows XP SP2
   • JDBC MySQL JDBC driver (com.mysql.jdbc.Driver class)
4. There is a bug in this version. If the connection to the data source is lost (once it has been established), the code will not attempt to reconnect. As a result, OpenOffice must be restarted to reconnect.