According to the JavaDocs, the last parameter for the getColumns() method is a "name pattern", that selects which columns to return. Passing "%" for all columns (as % is the SQL wildcard) does not return anything. To get all columns, you must pass null instead. The JavaDocs are not entirely clear whether null is allowed or not, but all other JDBC drivers I know work correctly using "%".
Last edit: TomK 2013-05-31
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Thomas,
You are totally right, it's a regression. I have found (and patched) this bug today, while I was testing integration between UCanAccess and Libre Office for the release 1.0.1 (Libre Office 4 passes a '%' in both the getTables and getColumns methods).
So it will be patched in the release 1.0.1.
UCanAccess 1.0.1 will be posted tonight.
Cheers Marco
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
According to the JavaDocs, the last parameter for the getColumns() method is a "name pattern", that selects which columns to return. Passing "%" for all columns (as % is the SQL wildcard) does not return anything. To get all columns, you must pass null instead. The JavaDocs are not entirely clear whether null is allowed or not, but all other JDBC drivers I know work correctly using "%".
Last edit: TomK 2013-05-31
Hi Thomas,
You are totally right, it's a regression. I have found (and patched) this bug today, while I was testing integration between UCanAccess and Libre Office for the release 1.0.1 (Libre Office 4 passes a '%' in both the getTables and getColumns methods).
So it will be patched in the release 1.0.1.
UCanAccess 1.0.1 will be posted tonight.
Cheers Marco
Thanks for the quick reply (and fix).
I noticed that when I tested UCanAccess with my SQL Workbench/J (a SQL GUI client similar to Squirrel)
Okay,
please feel free to report to me any problem you may find.
Thanks.
Last edit: Marco Amadei 2013-06-03