editable external mySQL schema

LabKey Support Forum (Inactive)
editable external mySQL schema jeckels  2013-02-12 09:10
Status: Closed
 
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