-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: One-to-one mapping
PostPosted: Sat Jul 04, 2009 4:02 am 
Newbie

Joined: Thu Jan 15, 2009 6:41 am
Posts: 9
Hi, i'm newbie with HB, and i have problems to understand foreign mappings.

Now, i can mapping one "one-to-one" relation.

My three MySQL DB tables
Code:
`jforum_users` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_active` tinyint(1) default NULL,
  `username` varchar(50) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` bigint(20) default '0',
  `user_session_page` int(11) NOT NULL default '0',
  `user_lastvisit` datetime default NULL,
  `user_regdate` datetime default NULL,
  `user_level` tinyint(4) default NULL,
  `user_posts` int(11) NOT NULL default '0',
  `user_timezone` varchar(5) NOT NULL default '',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) NOT NULL default '',
  `user_dateformat` varchar(20) NOT NULL default '%d/%M/%Y %H:%i',
  `user_new_privmsg` int(11) NOT NULL default '0',
  `user_unread_privmsg` int(11) NOT NULL default '0',
  `user_last_privmsg` datetime default NULL,
  `user_emailtime` datetime default NULL,
  `user_viewemail` tinyint(1) default '0',
  `user_attachsig` tinyint(1) default '1',
  `user_allowhtml` tinyint(1) default '0',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmilies` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) default '1',
  `user_allow_pm` tinyint(1) default '1',
  `user_allow_viewonline` tinyint(1) default '1',
  `user_notify` tinyint(1) default '1',
  `user_notify_always` tinyint(1) default '0',
  `user_notify_text` tinyint(1) default '0',
  `user_notify_pm` tinyint(1) default '1',
  `user_popup_pm` tinyint(1) default '1',
  `rank_id` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) NOT NULL default '',
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(255) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_biography` text,
  `user_actkey` varchar(32) default NULL,
  `gender` char(1) default NULL,
  `themes_id` int(11) default NULL,
  `deleted` tinyint(1) default NULL,
  `user_viewonline` tinyint(1) default '1',
  `security_hash` varchar(32) default NULL,
  `user_karma` double default NULL,
  `user_authhash` varchar(32) default NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


rc_rompecabezas` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `nombre` varchar(45) NOT NULL,
  `fecha_creacion` datetime NOT NULL,
  `n_preguntas` int(10) unsigned NOT NULL,
  `tipo` varchar(15) NOT NULL,
  `descripcion` text,
  `estado` tinyint(1) NOT NULL,
  `ganador` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


`rc_usuario_rompecabezas` (
  `id_usuario` int(11) NOT NULL,
  `id_rompecabezas` int(10) unsigned NOT NULL,
  `n_preguntas` int(10) unsigned NOT NULL,
  KEY `FK_rc_usuario_rompecabezas_1` (`id_usuario`),
  KEY `FK_rc_usuario_rompecabezas_2` (`id_rompecabezas`),
  CONSTRAINT `FK_rc_usuario_rompecabezas_1` FOREIGN KEY (`id_usuario`) REFERENCES `jforum_users` (`user_id`),
  CONSTRAINT `FK_rc_usuario_rompecabezas_2` FOREIGN KEY (`id_rompecabezas`) REFERENCES `rc_rompecabezas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


Hibernate mapping for `rc_usuario_rompecabezas` table
Code:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
[b]<hibernate-mapping>
  <class name="com.destrozatumente.utils.objetos.UsuarioRompecabezas" table="rc_usuario_rompecabezas">
    <one-to-one name="idUsuario" class="com.destrozatumente.utils.objetos.Usuario" />
    <one-to-one name="idRompecabezas" class="com.destrozatumente.utils.objetos.Rompecabezas" />
    <property column="n_preguntas" name="nPregunta" not-null="true" type="integer" />
  </class>
</hibernate-mapping>[/b]


And her Java class
Code:
public class UsuarioRompecabezas {

        private int idUsuario;
        private int idRompecabezas;
        private int nPregunta;

    public int getIdUsuario() {
        return idUsuario;
    }

    public void setIdUsuario(int idUsuario) {
        this.idUsuario = idUsuario;
    }

    public int getIdRompecabezas() {
        return idRompecabezas;
    }

    public void setIdRompecabezas(int idRompecabezas) {
        this.idRompecabezas = idRompecabezas;
    }

    public int getnPregunta() {
        return nPregunta;
    }

    public void setnPregunta(int nPregunta) {
        this.nPregunta = nPregunta;
    }
   
}


Output Java console sais me the next error:
"org.hibernate.InvalidMappingException: Could not parse mapping document from resource com/destrozatumente/utils/objetos/UsuarioRompecabezas.hbm.xml"

Where is the problem? Thanks.
"


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.