With the increasing problems of the jdbc - odbc bridge and it not being supported at all in Java 8, I've been trying to use this in my pamguard project. https://sourceforge.net/projects/pamguard/
This project already contains a lot of SQL which currently works with Access (32 bit via the bridge), open office databases and MySQL. I'm having a couple of problems with ucanaccess, in particular
When I create a table, even though I specify a 255 wide column for one of the fields, it only creates a 50 character column.
When I write strings, it sometimes (not always) objects if the string is shorter than the filed length
No support yet for addcolumn.
I'll keep monitoring your site to see if these things improve. I could potentially help with testing / debugging.
Best,
Douglas.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi Douglas,
thank you for your interest in my project!
Yes, in this stage Ucanaccess can't support alter table and in the last period I have focused on some advanced sql features (e.g.cross_tab queries, complex types read/write support and advanced access functions) instead of the DDL support.
I've fixed the bug mentioned in the point 1 in the trunk and so, for example, the following statement will create the text columns with the right length:
...
st.execute("CREATE TABLE AAA ( baaaa text(3) PRIMARY KEY,A long default 3, C text(255))");
Regarding point 2, could you help me to reproduce the bug (for example by posting some code with the create table and the problematic insert statement)?
UCanAccess1.0.2 (with fixes) will be released before the end of june.
My best, Marco
Last edit: Marco Amadei 2013-06-22
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Looks like an exciting project.
With the increasing problems of the jdbc - odbc bridge and it not being supported at all in Java 8, I've been trying to use this in my pamguard project. https://sourceforge.net/projects/pamguard/
This project already contains a lot of SQL which currently works with Access (32 bit via the bridge), open office databases and MySQL. I'm having a couple of problems with ucanaccess, in particular
When I create a table, even though I specify a 255 wide column for one of the fields, it only creates a 50 character column.
When I write strings, it sometimes (not always) objects if the string is shorter than the filed length
No support yet for addcolumn.
I'll keep monitoring your site to see if these things improve. I could potentially help with testing / debugging.
Best,
Douglas.
Hi Douglas,
thank you for your interest in my project!
Yes, in this stage Ucanaccess can't support alter table and in the last period I have focused on some advanced sql features (e.g.cross_tab queries, complex types read/write support and advanced access functions) instead of the DDL support.
I've fixed the bug mentioned in the point 1 in the trunk and so, for example, the following statement will create the text columns with the right length:
...
st.execute("CREATE TABLE AAA ( baaaa text(3) PRIMARY KEY,A long default 3, C text(255))");
Regarding point 2, could you help me to reproduce the bug (for example by posting some code with the create table and the problematic insert statement)?
UCanAccess1.0.2 (with fixes) will be released before the end of june.
My best, Marco
Last edit: Marco Amadei 2013-06-22