Database Defined Relations->Create

Classic Servoy
1

Running Servoy 2.0 on Linux (java 1.4 now ;-) with MySQL backend and dependencies defined in the MySQL database - but the “create” button in “Database Defined Relations” doesn’t appear to do anything (i.e. the defined constraints don’t turn up).

What have I missed?

Thanks,
Neale.

2

Yes it seems that MySQL even with using the latest drivers, mysql version and using innodb as its table type that the driver still doesn’t return any information of its foreign keys.
As long as it doesn’t do that we can’t do anything.

3

FWIW, still using Servoy 1.2 and upgrading from the Servoy-provided MySQL JDBC driver to latest stable (3.0.9) changes behaviour from silently doing nothing to producing an error:

com.servoy.j2db.persistence.RepositoryException: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

Any idea if we’re likely to see the situation improve any time soon?

Thanks,
Neale.

4

We don’t have any control of wat the driver tells us.

That question should be asked to MySQL