I' ve sent the project to Jon Cundill, the affected files only for not to do duplicated job (as we were doing right now).<br><br>By now there is only 2 new packages (*Framework.Persistence for table mappings and *Framework.Data.Hibernate for db plugin definition ) and one affected file of Opensim core: OpenSimMain.cs (just included a new "if" when decoding parameters from opensim.ini, asset_server="hibernate").<br>
<br>The current status: Server starts ok, but having problems when trying to create an user (my first test with console) due to the raw implementation of hibernate (the zip attached is from this morning, maybe it could have some errors).<br>
<br>So this evening I'm redesigning the db model, I'm sorry but I can't maintain the current, I need some tables (relations between regions->prims->prim_items->assets...).<br><br>I've attached the model I'm working on (does this server allow to send mail attachments?). It is not finished and I'm trying to not affect the current model (just including new tables and adding some foreign keys).<br>
<br>The last thing, and yes, is a noob question: I need to include the *hbm.xml and the hibernate.cfg.xml into the cs projects as Embedded Resources... what's the command in prebuild.xml? These files need, by now, to be in the bin directory (later attributes will be used and these files will be unnecessary, but I need them now).<br>
<br>For the next future... I have to implement the DDL generation from hibernate for not to have to execute SQL files.<br><br>Greetings<br><br><br><br><div><span class="gmail_quote">2008/2/13, Stefan Andersson <<a href="mailto:stefan@tribalmedia.se">stefan@tribalmedia.se</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><div style="text-align: left;">Great job, guys;<br><br>may I suggest that you send in whatever you have so we can work together with you to get faster results?<br><br>Is this a separate OpenSim.Framework.Data.NHibernate project, or how have you solved it?<br>
<br></div>/Stefan<br><br><br><blockquote><hr>Date: Wed, 13 Feb 2008 09:51:10 +0100<br>From: <a href="mailto:impalah@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">impalah@gmail.com</a><span class="q"><br>
To: <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>Subject: Re: [Opensim-dev] DB - NHibernate tests (part 1)<br><br>
</span><div><span class="e" id="q_1181330b999fc7d9_2">Sorry Jon for not to upload my job... this morning I will try to merge what I did.<br><br>About mono and Hibernate: I've tested the first test version (independent of Opensim, but containing almost the same code) and runs ok. And, of course, I'm using MoMA (<a href="http://www.mono-project.com/MoMA" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.mono-project.com/MoMA</a>) to check code compatibility.<br>
<br>Greetingzzz<br><br><br>When the integration finishes we'll run complete tests<br><br><br><br><div><span>2008/2/13, jon cundill <<a href="mailto:jcundill@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">jcundill@gmail.com</a>>:</span><blockquote style="padding-left: 1ex;">
Thanks for the info<br> <br> Currently I am not - but Impalah may be - only got windows box here,<br> so can only test mono on windows.<br> <br> Will check this out over next few days. Any specifics would be great.<br> <br>
jonc<br> <br><br> On 13/02/2008, Adam Johnson <<a href="mailto:adjohn@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">adjohn@gmail.com</a>> wrote:<br> > This is some great work, looking forward to seeing more. Are you also<br>
> testing under Mono? I know someone was having some issues with nhibernate<br>
> and mono, but I am not sure what those issues were specifically.<br> ><br> > Adam J<br> ><br> ><br> > On Feb 13, 2008 9:06 AM, Impalah <<a href="mailto:impalah@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">impalah@gmail.com</a>> wrote:<br>
> > Slow is the development, not hibernate :-)<br> > ><br> > ><br> > ><br> > ><br> > > 2008/2/13, Sean Dague <<a href="mailto:sean@dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">sean@dague.net</a>>:<br>
> > ><br>
> > ><br> > > ><br> > > > On Tue, Feb 12, 2008 at 08:58:50PM +0100, Impalah wrote:<br> > > > > Second report:<br> > > > > ---------------------------------<br> > > > ><br>
> > > > - Created a new assembly:<br> > Opensim.Framework.Data.Hibernate.<br> > > > > - Opensim.ini: new configuration ===> asset_database = "hibernate"<br> > > > ><br>
> Every other server,<br> > > > > example: inventory_plugin =<br> > "OpenSim.Framework.Data.Hibernate.dll"<br> > > > > * I don't want<br>
> to do deep changes now<br> > > > > so it is implemented as a plugin like the others (mysql, sqlite...)<br> > > > > - Changes in database: minimums by now, only some primary keys created<br> > and<br>
> > > > TEXT fields changed to VARCHAR<br> > > > > - All the database objects mapped to hibernate.<br> > > > > - Tested on MySQL. When completed will be tested in sqlite & mssql<br>
> (maybe<br> > > > > oracle if I have time)<br> > > > > - Status: Opensim starts up step by step until<br> > > > > RegionApplicationBase.SetupScene. I have stopped (I'm<br> > very tired :-P, today<br>
> > > > I coded 10 hours w/o rest )<br> > inscene.performParcelPrimCountUpdate();<br> > > > ><br> > > > > Well, seems that is quite easy to make the change, but is really<br> > really<br>
> > > > really sloooooooow. I hope in 5 or 6 days could have a stable server,<br> > then I<br> > > > > will upload the files and documentation where you tell me.<br> > > ><br> > > ><br>
> > > Any idea what is the cause of the slowness?<br> > > ><br> > > ><br> > > > -Sean<br> > > ><br> > > > --<br> > > ><br> > __________________________________________________________________<br>
> > ><br> > > > Sean Dague<br> > Mid-Hudson Valley<br> > > > sean at dague dot net Linux<br> > Users Group<br> > > > <a href="http://dague.net" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://dague.net</a><br>
> <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> > > ><br> > > ><br> > > > -----BEGIN PGP SIGNATURE-----<br> > > > Version: GnuPG v1.4.6 (GNU/Linux)<br>
> > ><br> > > ><br> > iD8DBQFHsi5uSamXem9TdyYRAu+2AJ9kySyJYeB5i0tUHIecSLR/VsYDOQCdEGkC<br> > > > IWt2vMxtiFfp8BwzFet/J8I=<br> > > > =uIlj<br> > > ><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)">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>
> > ><br> > ><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)">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> > ><br> ><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)">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> ><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>
</blockquote>
</div><br>
</span></div></blockquote></div>
<br>_______________________________________________<br>
Opensim-dev mailing list<br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Opensim-dev@lists.berlios.de">Opensim-dev@lists.berlios.de</a><br>
<a onclick="return top.js.OpenExtLink(window,event,this)" href="https://lists.berlios.de/mailman/listinfo/opensim-dev" target="_blank">https://lists.berlios.de/mailman/listinfo/opensim-dev</a><br>
<br></blockquote></div><br>