Hi everyone:<br><br>I'm integrating the Hibernate model yet into my local opensim (downloaded 5/februay).<br><br>By now I'm trying to work with assets and seems to work ok, except for the first time loading from xml. The PK of the table is the UUID of the assets and seems that hibernate works only in two modes: it asigns automatically id's or the applicaion creates the ids.<br>
<br>Well, a little problem I think I could resolve today, but we won't use all the power of hibernate in some cases...<br><br>That's all. I'll keep you informed.<br><br>Greetingzzz<br><br><br><br><div><span class="gmail_quote">2008/2/7, Impalah <<a href="mailto:impalah@gmail.com">impalah@gmail.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
In opensim "in general" I don't know.<br>In the case of this example... it's just an example, you can change what you need, the DB configuration is "transparent" for nhibernate.<br><br><br><div>
<span class="gmail_quote">2008/2/7, Kyle Hamilton <<a href="mailto:aerowolf@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">aerowolf@gmail.com</a>>:</span><div><span class="e" id="q_117f358abbb1201c_1"><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#FFFFFF"><div>Just out of curiosity... Is there a specific reason we're not using utf8 unicode encoding for the tables? Is there something that will break if utf8 is used?</div><div><br></div><div>-Kyle H<br>
<br>Sent from my iPhone</div><div><span><div><br>On Feb 7, 2008, at 1:40, Impalah <<a href="mailto:impalah@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">impalah@gmail.com</a>> wrote:<br>
<br></div><div></div><blockquote type="cite"><div>Sorry I made a mistake in the sql file.<br><br>The good one is copied below.<br><br>I'm working now on the "persistence" layer, creating the basic utilities (i.e. factories) and testing selects, updates and deletes.<br>
<br>I hope in 2 or 3 days to have something "insertable" into the actual opensim.<br><br><br><br>CREATE DATABASE `opensimtest` /*!40100 DEFAULT CHARACTER SET latin1 */;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osprimitive_type`;<br>
CREATE TABLE `opensimtest`.`osprimitive_type` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `name` varchar(45) NOT NULL,<br> `params` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;<br>
<br><br>DROP TABLE IF EXISTS `opensimtest`.`ostexture`;<br>CREATE TABLE `opensimtest`.`ostexture` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `uuid` varchar(45) NOT NULL,<br> `name` varchar(45) NOT NULL,<br>
`path` varchar(45) NOT NULL,<br> `data` blob NOT NULL,<br> PRIMARY KEY (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osuser`;<br>CREATE TABLE `opensimtest`.`osuser` (<br>
`id` int(10) unsigned NOT NULL auto_increment,<br> `uuid` varchar(45) NOT NULL,<br> `name` varchar(45) NOT NULL,<br> `surname` varchar(45) NOT NULL,<br> `last_position` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`)<br>
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;<br><br><br><br>DROP TABLE IF EXISTS `opensimtest`.`osfaces`;<br>CREATE TABLE `opensimtest`.`osfaces` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `face` varchar(45) NOT NULL,<br>
`id_texture` int(10) unsigned zerofill NOT NULL default '0000000000',<br> `params` varchar(45) NOT NULL,<br> PRIMARY KEY (`id`),<br> KEY `FK_ostexture_faces_texture` (`id_texture`),<br> CONSTRAINT `FK_ostexture_faces_texture` FOREIGN KEY (`id_texture`) REFERENCES `ostexture` (`id`)<br>
) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br><br>DROP TABLE IF EXISTS `opensimtest`.`osprimitive`;<br>CREATE TABLE `opensimtest`.`osprimitive` (<br> `id` int(10) unsigned NOT NULL auto_increment,<br> `name` varchar(45) default NULL,<br>
`description` varchar(45) default NULL,<br> `uuid` varchar(45) NOT NULL,<br> `id_primitive_type` int(10) unsigned NOT NULL,<br> `id_creator` int(10) unsigned NOT NULL,<br> `id_owner` int(10) unsigned NOT NULL,<br> PRIMARY KEY (`id`),<br>
KEY `FK_osprimitive_type` (`id_primitive_type`),<br> KEY `FK_osprimitive_creator` (`id_creator`),<br> KEY `FK_osprimitive_owner` (`id_owner`),<br> CONSTRAINT `FK_osprimitive_type` FOREIGN KEY (`id_primitive_type`) REFERENCES `osprimitive_type` (`id`),<br>
CONSTRAINT `FK_osprimitive_creator` FOREIGN KEY (`id_creator`) REFERENCES `osuser` (`id`),<br> CONSTRAINT `FK_osprimitive_owner` FOREIGN KEY (`id_owner`) REFERENCES `osuser` (`id`)<br>) ENGINE=InnoDB DEFAULT CHARSET=latin1;<br>
<br><br><br><br><br><div><span class="gmail_quote">2008/2/7, Sean Dague <<a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sean@dague.net</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On Wed, Feb 06, 2008 at 11:06:14PM +0100, Impalah wrote:<br>> Hi everyone:<br>><br>> I've uploaded a file to my web page with a c# project testing NHibernate:<br>> <a href="http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=40&Itemid=88889037&lang=en</a><br>
><br>> Please, does not expect a miracle right now, it's just only a massive<br>> insertion test for checking if everything runs ok.<br><br>Thanks for all of this work. I just pulled the source and am going to<br>
poke it a bunch tomorrow. More comments as I get up to speed on this.<br><br> -Sean<br><br>--<br>__________________________________________________________________<br><br>Sean Dague Mid-Hudson Valley<br>
sean at dague dot net Linux Users Group<br><a href="http://dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://dague.net</a> <a href="http://mhvlug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="http://mhvlug.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mhvlug.org</a><br>
<br>There is no silver bullet. Plus, werewolves make better neighbors<br>
than zombies, and they tend to keep the vampire population down.<br>__________________________________________________________________<br><br>-----BEGIN PGP SIGNATURE-----<br>Version: GnuPG v1.4.6 (GNU/Linux)<br><br>iD8DBQFHqnZgSamXem9TdyYRApuZAJ9dzX9sZn5CYb5GYu4xQkTRI6XWLACfTHxf<br>
wditTaO4gROrub+bL0rPI2w=<br>=fqU2<br>-----END PGP SIGNATURE-----<br><br>_______________________________________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)"></a><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
<br></blockquote></div><br>
</div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>Opensim-dev mailing list</span><br><span><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Opensim-dev@lists.berlios.de</a></span><br>
<span><a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://lists.berlios.de/mailman/listinfo/opensim-dev</a></span><br></div></blockquote>
</span></div></div><br>_______________________________________________<br>Opensim-dev mailing list<br><a href="mailto:Opensim-dev@lists.berlios.de" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Opensim-dev@lists.berlios.de</a><br>
<a href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br><br></blockquote></span></div>
</div><br>
</blockquote></div><br>