I received the following on the MySQL site regarding this:
The SQL INTEGRITY ENHANCEMENT FACILITY also includes CHECK
CONSTRAINTS, which MySQL doesn't have, so we can't return true for
this method. I suppose we could add a configuraiton parameter for
this, but it's not going to make it into Connector/J 3.1.11.
-Mark
--
Mark Matthews
MySQL AB, Software Development Manager - Client Connectivity
www.mysql.com
And I asked this question back, today.
I suppose my only question would be, is there any ramifications on
either end.
Let's say you did this. Then the it would be up to the user whether to
set this configuration parameter or not, and thats good.
Question - is there any situation where doing this causes a problem.
In other words is there a case where issuing a FOREIGN KEY Constraint
from OpenOffice Base to the MySQL server causes an error on the server?
I'll pass along the response when I get it.
Andrew Jensen wrote:
Ocke Janssen wrote:
Hi Andrew,
Andrew Jensen wrote:
Actually this is two questions?
Using MySQL the Relationship dialog in Base will not open stating
that Realtionships are not supported for this
database. Now, using MyISAM I can understand this, but if the MySQL
server has been configured to use InnoDB
engine as the default then it does support foerign keys. Should not
the relationship dialog open in this scenario?
We ask the driver if he returns true for the method
XDatabaseMetaData::supportsIntegrityEnhancementFacility. If not
you'll see the error dialog.
I don't know if there is a driver available which supports or just
returns true. :-) We could add an extra entry for this case as we've
done for many other
properies we have to ha..
I will try a query over at the MySQL site then. See if I am missing
something on the J/Connector settings. I did try this, just FYI with
both the ODBC and JDBC drivers
and I think it's latest stable, JDBC driver, 3.18.
Second question - Again with MySQL, Are there any plans to allow the
user to select which engine they want
a table definition to use, when the server supports multiple
engines? MyISAM, InnoDb, BDB on MySQL for example.
Yes, this a good idea as well. The first shot could be toset the type
via a property of the data source settings.
The next step then should be to show it in the UI. If you want to try
it :-) the source is in connectivity/source/drivers/mysql/YTables.cxx
and connectivity/source/commontools/dbtools2.cxx
createSqlCreateTableStatement
Every help is welcome ;-)
At my last corporate job I had to field requests from large customers
for enhancements that THEY had to have...my response was often
...would you like to talk about a client funded initiative..and then
show the fully loaded coast of a software engineer man month (Fully
loaded meaning with the cost of support, doc, qa and mgmgt added
in)...usually made them think twice.. :-$
From what I have read so far just getting the build environment setup
on my machine is gonna be a barrell of fun. :-!
I will take a look and if I am not totally lost I will try. Expect
lots of questions (mostly dumb ones) from me as I go, OK.
Best regards,
Ocke
Thanks
Andrew Jensen
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
