MyEclipse: JBoss Hibernate Tools Plugin Conflict in MyEclipse 4.1
jimwatkins - Jan 24, 2006 - 01:37 AM
Post subject: JBoss Hibernate Tools Plugin Conflict in MyEclipse 4.1
Hi,

I know this falls under the general problem of plugin dependencies conflicting with each other, but I'm hoping somebody made this work.

I have traditionally used the jboss projects hibernate tools, and so far still like them better. This has never been a problem until 4.1, where I now don't get any of the hibernate views, tools, or perspectives if I enable myeclipse. I can roll back to 4.03 and boom, full functionality back.

I use myeclipse as a manual install seperate from my std plugins which are also done as an extension location (hibernate tools and subclipse basically), so it's pretty easy to toggle these things around.

I've tried Eclsipe 3.1 and 3.1.1 and all manner of -clean stuff. I'm just looking for tips on how to dig deeper into this issue.
support-rkalla - Jan 24, 2006 - 01:43 AM
Post subject:
Jim,
The reason is that in 4.1 we integrated work from the hibernate tools project (the mapping generator) so now there are conflicts between the projects. Moving forward we will continue to pull in the better features from HT so hopefully you won't need the two of them side by side.

What is it about HT that you use most?
jimwatkins - Jan 24, 2006 - 02:55 PM
Post subject:
In 2 words, schema export/regeneration. I have complex java objects and manage the mapping files myself, but then as the objects get richer I often regenerate the schema for our embedded derby databases. I know I have some other options for this, especially ant tasks, but just wanted to keep using what I know, and I didn't see this functionality in my cursory review of hibernate functionality in myeclipse. Did I miss something?
support-rkalla - Jan 24, 2006 - 11:40 PM
Post subject:
No you didn't, but I have added this to our TODO list.
jimwatkins - Jan 25, 2006 - 02:39 AM
Post subject:
Great, thanks. I went to vote on it, but didn't see it as an option for 5. I guess I will hold at 4.03 or learn to use the ant tasks in the meantime. Thanks for the prompt responses.
thomsongale - Jan 26, 2006 - 08:10 PM
Post subject:
We are also using the JBoss toolset and got a big surprise when we upgraded. The feature that we will miss the most is the HQLScratchPad. Without this, we'll probably stay on the old version...
jnermut - Jan 30, 2006 - 10:58 PM
Post subject: Very poor form
I can't believe you integrated hibernate tools and then turned features off!
This is very poor form.

Either integrate the whole thing, or leave it alone.

We use the hibernate console and other aspects of the hibernate tools, and want to move to hibernate tools beta 2. But it wont the plugin wont even load because of ME's half assed version of the plugin.

Now I'm just going to have to try and hack it...
jnermut - Jan 30, 2006 - 11:25 PM
Post subject:
Your right, there is a definite incompatibility between ME 4.1 and Hibernate Tools 3.1 beta 2.
The ME hibernate plugin fails on startup with:

Caused by: java.lang.NoSuchMethodError: org.hibernate.eclipse.HibernatePlugin.getDefault()Lorg/hibernate/eclipse/HibernatePlugin;
at com.genuitec.eclipse.hibernate.core.HibernateCore.getDataPlugin(HibernateCore.java:178)
at com.genuitec.eclipse.hibernate.core.HibernateCore.computeMyEclipseHibernateVarPath(HibernateCore.java:164)
at com.genuitec.eclipse.hibernate.classpath.HibernateClasspathVariableInitializer.initialize(HibernateClasspathVariableInitializer.java:33)
at org.eclipse.jdt.core.JavaCore.getClasspathVariable(JavaCore.java:1443)
at com.genuitec.eclipse.hibernate.core.HibernateCore.initializeDefaultPreferences(HibernateCore.java:448)
at com.genuitec.eclipse.core.GenuitecPlugin.getPreferenceStore(GenuitecPlugin.java:75)
at com.genuitec.eclipse.hibernate.core.HibernateCore.<init>(HibernateCore.java:107)

Could you please fix the incompatibility and release a point version with the latest version of hibernate tools, with the console *turned on* ?
I will have to wait for this before I can upgrade our dev environment.

Thanks,

Jon
support-michael - Jan 31, 2006 - 12:09 AM
Post subject:
After reviewing the underlying assumptions between MyEclipse 4.X and Hibernate Tools 3.X it appears that we made an honest mistake by not completing an update of the MyEclipse Hibernate Tools integration to coexists cleanly with JBoss HT. We apologize for the inconvenience and the problem will be remedied in the upcoming ME 4.1.1 at the end of Feb.
jnermut - Jan 31, 2006 - 04:28 AM
Post subject:
OK thanks Michael. Is there any chance of a patch before 4.1.1?

I note also that Hibernate Tools has put out beta4 yesterday. It is unfortunate that HT is in such active development, it must be a struggle to keep up.
mkoetter - Feb 03, 2006 - 03:23 PM
Post subject:
Here's how to get hibernate-tools 3.1beta4 to work, disabling any MyEclipse Hibernate functionality (NOTE: This is only meant as a workaround if you absolutely NEED hibernate-tools, following the steps below might seriously screw your Eclipse/MyEclipse installation. So please only proceed if you really know what you're doing!)

OK, on to the gory details...


  1. Locate the MyEclipse install location, it should contain two folders "plugins" and "features". Let's call this $MYECLIPSE.
  2. Create two folders named "disabled_plugins" and "disabled_features" in $MYECLIPSE.
  3. Move the MyEclipse Hibernate feature (folder: $MYECLIPSE/features/com.genuitec.myeclipse.hibernate_4.0.100 ) to the "disabled_features" folder
  4. Move the following folders from $MYECLIPSE/plugins to "disabled_plugins":

    1. com.genuitec.eclipse.hibernate_4.0.100
    2. com.genuitec.myeclipse.hibernate_4.0.100
    3. org.hibernate.eclipse.console_4.0.100
    4. org.hibernate.eclipse.mapper_4.0.100
    5. org.hibernate.eclipse_4.0.100

  5. Last step: remove the dependency from the main MyEclipse feature. Open the file $MYECLIPSE/features/com.genuitec.myeclipse.enterprise.workbench_4.0.100/feature.xml.
    Locate the following snippet:
    Code:
    <includes
             id="com.genuitec.myeclipse.hibernate"
             version="4.0.100"
             name="MyEclipse Hibernate Support"/>

    ... and comment it out, like:
    Code:
    <!--
    <includes
             id="com.genuitec.myeclipse.hibernate"
             version="4.0.100"
             name="MyEclipse Hibernate Support"/>
    -->



Now restart Eclipse (preferably using "-clean" switch), install hibernate-tools 3.1 (if you have not already done so) and enjoy!
mkoetter - Feb 03, 2006 - 04:44 PM
Post subject:
Just noticed that I still had 4.1 Milestone1... however, I install 4.1GA and repeated the procedure, it still seems to work. Just replace all version numbers with "4.1.0" in the previous post!
aming - Feb 05, 2006 - 08:31 AM
Post subject:
I am using hibernate tools too -- just want to run the hsql on eclipse... so I am using tow Eclipse Platform, one using ME4.1, the other use hibernate tools^_^
jnermut - Feb 05, 2006 - 10:14 PM
Post subject:
Bump. Any chance of a quick fix before the end of the month?
oberinspector - Feb 05, 2006 - 11:06 PM
Post subject:
i used the reverse engineering tool with a mysql innodb and in the generated mappings some of the foreign key constrains were missing... i could not find any switch in your database console to selct innodb... in the hibernate console you can specify the mysql innodb dialect... i tried your workaround to activate the hibernate tools, but this crashed my installation... i moved also back to a basic eclipse wtp version to use the original hibernate tools and everything was fine... i also would like to see full hibernate tools support in myeclipse!
support-michael - Feb 06, 2006 - 01:37 AM
Post subject:
Quote:
Bump. Any chance of a quick fix before the end of the month?


The next release will enable MyEclipse Hibernate tools and Jboss HT to coexists. We are evaluating a plan to accelerate 4.1.1 but there are a number of other features that are planned for this release that must be accounted for. So at the moment the answer is we are pushing for an end of Feb 4.1.1 release.
support-snpe - Feb 06, 2006 - 02:09 AM
Post subject:
Oberinspector,
can you send me schema with master table and foreign key table with missing foreign key ?
oberinspector - Feb 06, 2006 - 08:14 AM
Post subject:
since the reverse engineereng seems not to work as i expected. i spend not to much time analysing the problem... some of the many-to-one mappings were missing some don't. probably i have made a mistake, but i fall backt to an eclipse with hibernate tools enabled and everything was as i expected.

In my schema i have a base Entity table with some helper tables (EntityI18N, Entry, EntryI18N, History, Authorisations, Icon...) which is the parent for most of the other tables. Since inheritance mapping is not supported by hibernates reverse engineering (would also be very nice to have!), i converted the reverse engineered hbm.xml of the child classes with xslt to the joined-subclass mapping.

as i remeber one of the problems, the myeclipse reverse engineering did not include the relations to the transfer table in the account table mapping... If i have more time i could repeat the reverse engineering, but at the moment it's no blocking point for me...

I think the problem is related to the diffrent dialects of the mysql myisam and mysql innodb. Especialy the foreign keys were the reason to move to the mysql innodb.

thank you for your help!

My schema used on a mysql innodb:

Code:

#========================================================================== #
#  Tables                                                                   #
#========================================================================== #

CREATE TABLE Article (
    id BIGINT NOT NULL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Path (
    id BIGINT NOT NULL,
    GPX TEXT,
    pathLength FLOAT,
    pathCharacter INTEGER,
    minlat DECIMAL,
    minlon DECIMAL,
    maxlat DECIMAL,
    maxlon DECIMAL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Category (
    id BIGINT NOT NULL,
    CONSTRAINT PK_Category PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Person (
    id BIGINT NOT NULL,
    nickname VARCHAR(40),
    email VARCHAR(80) NOT NULL,
    passwd VARCHAR(30) NOT NULL,
    forename VARCHAR(40),
    surename VARCHAR(40),
    lang VARCHAR(10),
    sex ENUM('male','female'),
    birthday DATE,
    CONSTRAINT PK_person PRIMARY KEY (id),
    UNIQUE UC_Person_nickname (nickname),
    UNIQUE UC_Person_email (email)
)
Type=InnoDB;

CREATE TABLE Usergroup (
    id BIGINT NOT NULL,
    groupname VARCHAR(40),
    CONSTRAINT PK_Usergroup PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Task (
    id BIGINT NOT NULL,
    tasktype TINYINT,
    expiryDate DATE NOT NULL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Vote (
    idVote BIGINT NOT NULL AUTO_INCREMENT,
    idVoter BIGINT NOT NULL,
    idFingerprint BIGINT,
    idRating BIGINT,
    ratingvalue TINYINT NOT NULL,
    ratingtimestamp TIMESTAMP NOT NULL,
    PRIMARY KEY (idVote),
    UNIQUE UN_Evaluation_1 (idVoter)
)
Type=InnoDB;

CREATE TABLE Roles (
    id BIGINT NOT NULL,
    rights BIGINT DEFAULT 0,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Point (
    id BIGINT NOT NULL,
    pointCharacter SMALLINT,
    lat DECIMAL,
    lon DECIMAL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Area (
    id BIGINT NOT NULL,
    GPX TEXT,
    areaSize FLOAT,
    areaCharacter INTEGER,
    minlat DECIMAL,
    minlon DECIMAL,
    maxlat DECIMAL,
    maxlon DECIMAL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Pixelmap (
    id BIGINT NOT NULL,
    mapType SMALLINT,
    mapURL VARCHAR(200),
    minlat DECIMAL,
    minlon DECIMAL,
    maxlat DECIMAL,
    maxlon DECIMAL,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Query (
    id BIGINT NOT NULL,
    queryString TEXT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Image (
    id BIGINT NOT NULL,
    height SMALLINT,
    whidth SMALLINT,
    imageURL VARCHAR(200),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Container (
    id BIGINT NOT NULL,
    idEntity BIGINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Entry (
    idEntry BIGINT NOT NULL AUTO_INCREMENT,
    idEntity BIGINT NOT NULL,
    idNode BIGINT,
    OrderNr SMALLINT,
    flags BIGINT,
    number INTEGER,
    creationtime TIMESTAMP,
    PRIMARY KEY (idEntry)
)
Type=InnoDB;

CREATE TABLE Date_Time (
    id BIGINT NOT NULL,
    Days TINYINT,
    StartTime TIME,
    StopTime TIME,
    StartDate DATE,
    StopDate DATE,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Account (
    id BIGINT NOT NULL,
    account FLOAT(0,2),
    currency VARCHAR(3),
    owner_name VARCHAR(40),
    account_number VARCHAR(10),
    bank_code VARCHAR(8),
    bank VARCHAR(40),
    iban VARCHAR(36),
    bic_swift_code VARCHAR(11),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Trace (
    id BIGINT NOT NULL,
    logintime TIMESTAMP,
    logofftime TIMESTAMP,
    staticFp VARCHAR(200),
    dynamicFp VARCHAR(200),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Grid (
    idGrid BIGINT NOT NULL AUTO_INCREMENT,
    Grid INTEGER NOT NULL,
    idEntity BIGINT NOT NULL,
    geolevel TINYINT,
    lat DECIMAL,
    lon DECIMAL,
    PRIMARY KEY (idGrid),
    UNIQUE UN_Grid_1 (Grid, idEntity)
)
Type=InnoDB;

CREATE TABLE Entity (
    id BIGINT NOT NULL AUTO_INCREMENT,
    idOwner BIGINT,
    ownerAccess TINYINT,
    publicAccess TINYINT,
    flags INTEGER,
    creationdate TIMESTAMP,
    lastchange TIMESTAMP,
    version SMALLINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Entityi18n (
    idEntityi18n BIGINT NOT NULL AUTO_INCREMENT,
    idEntity BIGINT NOT NULL,
    lang VARCHAR(10),
    title VARCHAR(200),
    summary TEXT,
    content TEXT,
    PRIMARY KEY (idEntityi18n),
    UNIQUE UN_Entityi18n_1 (idEntity, lang)
)
Type=InnoDB;

CREATE TABLE Transfer (
    id BIGINT NOT NULL,
    value DECIMAL,
    currency VARCHAR(3),
    srcAccount BIGINT,
    destAccount BIGINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Advertising (
    id BIGINT NOT NULL,
    adtype TINYINT,
    bannerURL VARCHAR(200),
    advertisingURL VARCHAR(200),
    loads INTEGER,
    clicks INTEGER,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Commentary (
    id BIGINT NOT NULL,
    title VARCHAR(100),
    comment TEXT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Adorder (
    id BIGINT NOT NULL,
    idAd BIGINT NOT NULL,
    startDate DATE,
    stopDate DATE,
    position TINYINT,
    percent TINYINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Entryi18n (
    idEntryi18n BIGINT NOT NULL AUTO_INCREMENT,
    idEntry BIGINT NOT NULL,
    lang VARCHAR(10) NOT NULL,
    title VARCHAR(200),
    summary TEXT,
    content TEXT,
    PRIMARY KEY (idEntryi18n),
    UNIQUE UN_Entryi18n_1 (idEntry, lang)
)
Type=InnoDB;

CREATE TABLE Link (
    id BIGINT NOT NULL,
    linkURL VARCHAR(200),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE History (
    id BIGINT NOT NULL,
    idOrigin BIGINT NOT NULL,
    changedby BIGINT,
    main_Version SMALLINT NOT NULL,
    predecessor SMALLINT,
    comment TEXT,
    PRIMARY KEY (id),
    UNIQUE UN_Storyi18nHist_1 (main_Version, idOrigin)
)
Type=InnoDB;

CREATE TABLE Address (
    id BIGINT NOT NULL,
    country VARCHAR(40),
    state VARCHAR(40),
    postcode VARCHAR(20),
    city VARCHAR(80),
    street VARCHAR(80),
    tel_privat VARCHAR(40),
    tel_mobil VARCHAR(40),
    tel_business VARCHAR(40),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_Usecase (
    id BIGINT NOT NULL,
    pattern VARCHAR(200),
    accessflags SMALLINT,
    rights BIGINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_Message (
    id BIGINT NOT NULL,
    i18n_Key VARCHAR(200),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_Layout (
    id BIGINT NOT NULL,
    layout TEXT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_Component (
    id BIGINT NOT NULL,
    can_Name VARCHAR(40),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_File (
    id BIGINT NOT NULL,
    filetype VARCHAR(20),
    folder VARCHAR(200),
    filename VARCHAR(20),
    content TEXT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Sys_Site (
    id BIGINT NOT NULL,
    site_Name VARCHAR(40),
    site_URL VARCHAR(200),
    folder VARCHAR(200),
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Authorisations (
    authorisation_Id BIGINT NOT NULL,
    idEntity BIGINT NOT NULL,
    idPeople BIGINT NOT NULL,
    accessflags TINYINT,
    PRIMARY KEY (authorisation_Id)
)
Type=InnoDB;

CREATE TABLE Sys_Types (
    id BIGINT NOT NULL,
    table_Name VARCHAR(20) NOT NULL,
    class_Name VARCHAR(30),
    PRIMARY KEY (id),
    UNIQUE (table_Name),
    UNIQUE (class_Name)
)
Type=InnoDB;

CREATE TABLE Rating (
    id BIGINT NOT NULL,
    range TINYINT,
    rating FLOAT,
    totalsum VARCHAR(40),
    votes INTEGER DEFAULT 0,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Choice (
    id BIGINT NOT NULL,
    votes INTEGER,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Price (
    id BIGINT NOT NULL,
    value DECIMAL,
    currency VARCHAR(3),
    destAccount BIGINT,
    PRIMARY KEY (id)
)
Type=InnoDB;

CREATE TABLE Icon (
    id BIGINT NOT NULL,
    iconurl VARCHAR(200),
    PRIMARY KEY (id)
);

#========================================================================== #
#  Foreign Keys                                                             #
#========================================================================== #

ALTER TABLE Article
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Path
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Category
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Person
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Usergroup
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Task
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Vote
    ADD FOREIGN KEY (idVoter) REFERENCES Person (id);

ALTER TABLE Vote
    ADD FOREIGN KEY (idFingerprint) REFERENCES Trace (id);

ALTER TABLE Vote
    ADD FOREIGN KEY (idRating) REFERENCES Rating (id);

ALTER TABLE Roles
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Point
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Area
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Pixelmap
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Query
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Image
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Container
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Container
    ADD FOREIGN KEY (idEntity) REFERENCES Entity (id);

ALTER TABLE Entry
    ADD FOREIGN KEY (idEntity) REFERENCES Entity (id);

ALTER TABLE Entry
    ADD FOREIGN KEY (idNode) REFERENCES Entity (id);

ALTER TABLE Date_Time
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Account
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Trace
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Grid
    ADD FOREIGN KEY (idEntity) REFERENCES Entity (id);

ALTER TABLE Entity
    ADD CONSTRAINT Owner FOREIGN KEY (idOwner) REFERENCES Entity (id);

ALTER TABLE Entityi18n
    ADD FOREIGN KEY (idEntity) REFERENCES Entity (id);

ALTER TABLE Transfer
    ADD FOREIGN KEY (srcAccount) REFERENCES Account (id);

ALTER TABLE Transfer
    ADD FOREIGN KEY (destAccount) REFERENCES Account (id);

ALTER TABLE Transfer
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Advertising
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Commentary
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Adorder
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Adorder
    ADD FOREIGN KEY (idAd) REFERENCES Advertising (id);

ALTER TABLE Entryi18n
    ADD FOREIGN KEY (idEntry) REFERENCES Entry (idEntry);

ALTER TABLE Link
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE History
    ADD CONSTRAINT Entity_History FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE History
    ADD FOREIGN KEY (changedby) REFERENCES Person (id);

ALTER TABLE History
    ADD FOREIGN KEY (idOrigin) REFERENCES Entity (id);

ALTER TABLE Address
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_Usecase
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_Message
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_Layout
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_Component
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_File
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Sys_Site
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Authorisations
    ADD FOREIGN KEY (idEntity) REFERENCES Entity (id);

ALTER TABLE Authorisations
    ADD FOREIGN KEY (idPeople) REFERENCES Entity (id);

ALTER TABLE Sys_Types
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Rating
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Choice
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Price
    ADD FOREIGN KEY (id) REFERENCES Entity (id);

ALTER TABLE Icon
    ADD FOREIGN KEY (id) REFERENCES Entity (id);
 


applefritter - Feb 11, 2006 - 06:46 AM
Post subject:
Is there a way to generate ddl from .hbm.xml files? That is the functionality I am interested in.
Support-Brian - Feb 11, 2006 - 12:35 PM
Post subject:
DDL generation is currently not possibile. We are looking at getting that integrated by MyEclipse 4.2.
It might be in an upcoming 4.1.1 maintanence release, but we haven't comitted to this timeframe.

Best,
Brian.
support-snpe - Feb 11, 2006 - 02:12 PM
Post subject:
oberinspector,

Please send us:

- your version mysql and jdbc
- what foreign key is missing

Thanks
Support-Brian - Feb 12, 2006 - 09:22 AM
Post subject:
operinspector,

On page 2 of the RE wizard, could you make sure "Generate basic typed composite IDs" is checked?
Let us know if that gets you what you need.

Best,
Brian.
jnermut - Feb 28, 2006 - 10:29 PM
Post subject:
Hi,
Could I get an update of how far away is a new version that supports the hibernate console is?

Thanks,

Jon
All times are GMT - 6 Hours
Powered by PNphpBB2 © 2003-2004 The PNphpBB Group
Credits