I've exposed an external mySQL schema to LabKey, and this is and has been working perfectly well for a number of months. When I try to make it editable, however, no luck. I have granted the mySQL user permissions and granted select, insert, update, delete permissions on particular tables, and reloaded the schema but the "editable" checkbox remains gray.
Also, the tables in mySQL have primary keys.
Any suggestions on where I am going wrong?
thanks,
b |
| |
| jeckels responded: |
2013-02-12 09:10 |
Hello,
We don't yet support editing tables in external schemas for MySQL. This likely wouldn't be a lot of work, but isn't something that we've tested. I suspect there are a few MySQL-specific things that we'd need to handle, such as finding out the sequence value that was inserted for auto-incrementing columns.
In the core LabKey Server Java code, this is controlled by the isEditable() method on SqlDialect. MySqlDialect (server\modules\bigiron\src\org\labkey\bigiron\mysql\MySqlDialect.java) doesn't override isEditable(), so it gets the default implementation from SimpleSqlDialect, which always returns false.
Thanks,
Josh |
| |
| bront responded: |
2013-02-12 11:01 |
Josh,
Thanks for getting back with me. I think we will migrate the data into postgres and go from there... for now.
cheers,
b |
| |
|
|