[prev in list] [next in list] [prev in thread] [next in thread] 

List:       juddi-dev
Subject:    [jira] Commented: (JUDDI-44) MySQL "InnoDB" complains of foreign
From:       "Kurt Stam (JIRA)" <juddi-dev () ws ! apache ! org>
Date:       2007-07-12 1:49:04
Message-ID: 796903.1184204944559.JavaMail.jira () brutus
[Download RAW message or body]


    [ https://issues.apache.org/jira/browse/JUDDI-44?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12511926 \
] 

Kurt Stam commented on JUDDI-44:
--------------------------------

I'm not seeing this issue using mysql5. I think if we don't get any more reports on \
this in the next few weeks we should "reject" the issue, assuming it was a mysql4 \
problem.

> MySQL "InnoDB" complains of foreign keys with jUDDI schema
> ----------------------------------------------------------
> 
> Key: JUDDI-44
> URL: https://issues.apache.org/jira/browse/JUDDI-44
> Project: jUDDI
> Issue Type: Bug
> Affects Versions: 0.9rc3
> Environment: Mac OS X 10.3.5, MySQL 4.0.21
> Reporter: David Smiley
> Assignee: Steve Viens
> Priority: Minor
> 
> I prefer to use the "InnoDB" MySQL storage engine whenever possible because it is \
> the only one that is ACID compliant.  I tried to load the create_database.sql \
> script though I got 3 errors.  MySQL couldn't create the BUSINESS_SERVICE, \
> BINDING_TEMPLATE, and PUBLISHER_ASSERTION tables for the same reason: ERROR 1005: \
> Can't create table './juddi/<table-name-here>.frm' (errno: 150) This is an InnoDB \
> error code that has to do with foreign key constraints.  I've searched the net a \
> bit and studied the SQL hard and I really can't figure out why it's failing. Good \
> luck fixing this one.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: juddi-dev-unsubscribe@ws.apache.org
For additional commands, e-mail: juddi-dev-help@ws.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]