[Opensim-dev] DB - NHibernate tests (part 1)
Impalah
impalah at gmail.com
Wed Feb 13 15:24:24 UTC 2008
I' ve sent the project to Jon Cundill, the affected files only for not to do
duplicated job (as we were doing right now).
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").
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).
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...).
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).
The last thing, and yes, is a noob question: I need to include the
*hbm.xmland 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).
For the next future... I have to implement the DDL generation from hibernate
for not to have to execute SQL files.
Greetings
2008/2/13, Stefan Andersson <stefan at tribalmedia.se>:
>
> Great job, guys;
>
> may I suggest that you send in whatever you have so we can work together
> with you to get faster results?
>
> Is this a separate OpenSim.Framework.Data.NHibernate project, or how have
> you solved it?
>
> /Stefan
>
>
> ------------------------------
> Date: Wed, 13 Feb 2008 09:51:10 +0100
> From: impalah at gmail.com
> To: opensim-dev at lists.berlios.de
> Subject: Re: [Opensim-dev] DB - NHibernate tests (part 1)
>
> Sorry Jon for not to upload my job... this morning I will try to merge
> what I did.
>
> 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 (http://www.mono-project.com/MoMA) to check code
> compatibility.
>
> Greetingzzz
>
>
> When the integration finishes we'll run complete tests
>
>
>
> 2008/2/13, jon cundill <jcundill at gmail.com>:
>
> Thanks for the info
>
> Currently I am not - but Impalah may be - only got windows box here,
> so can only test mono on windows.
>
> Will check this out over next few days. Any specifics would be great.
>
> jonc
>
>
> On 13/02/2008, Adam Johnson <adjohn at gmail.com> wrote:
> > This is some great work, looking forward to seeing more. Are you also
> > testing under Mono? I know someone was having some issues with
> nhibernate
> > and mono, but I am not sure what those issues were specifically.
> >
> > Adam J
> >
> >
> > On Feb 13, 2008 9:06 AM, Impalah <impalah at gmail.com> wrote:
> > > Slow is the development, not hibernate :-)
> > >
> > >
> > >
> > >
> > > 2008/2/13, Sean Dague <sean at dague.net>:
> > > >
> > > >
> > > >
> > > > On Tue, Feb 12, 2008 at 08:58:50PM +0100, Impalah wrote:
> > > > > Second report:
> > > > > ---------------------------------
> > > > >
> > > > > - Created a new assembly:
> > Opensim.Framework.Data.Hibernate.
> > > > > - Opensim.ini: new configuration ===> asset_database = "hibernate"
> > > > >
> > Every other server,
> > > > > example: inventory_plugin =
> > "OpenSim.Framework.Data.Hibernate.dll"
> > > > > * I don't want
> > to do deep changes now
> > > > > so it is implemented as a plugin like the others (mysql,
> sqlite...)
> > > > > - Changes in database: minimums by now, only some primary keys
> created
> > and
> > > > > TEXT fields changed to VARCHAR
> > > > > - All the database objects mapped to hibernate.
> > > > > - Tested on MySQL. When completed will be tested in sqlite & mssql
> > (maybe
> > > > > oracle if I have time)
> > > > > - Status: Opensim starts up step by step until
> > > > > RegionApplicationBase.SetupScene. I have stopped (I'm
> > very tired :-P, today
> > > > > I coded 10 hours w/o rest )
> > inscene.performParcelPrimCountUpdate();
> > > > >
> > > > > Well, seems that is quite easy to make the change, but is really
> > really
> > > > > really sloooooooow. I hope in 5 or 6 days could have a stable
> server,
> > then I
> > > > > will upload the files and documentation where you tell me.
> > > >
> > > >
> > > > Any idea what is the cause of the slowness?
> > > >
> > > >
> > > > -Sean
> > > >
> > > > --
> > > >
> > __________________________________________________________________
> > > >
> > > > Sean Dague
> > Mid-Hudson Valley
> > > > sean at dague dot net Linux
> > Users Group
> > > > http://dague.net
> > http://mhvlug.org
> > > >
> > > > There is no silver bullet. Plus, werewolves make better neighbors
> > > > than zombies, and they tend to keep the vampire population down.
> > > >
> > __________________________________________________________________
> > > >
> > > >
> > > > -----BEGIN PGP SIGNATURE-----
> > > > Version: GnuPG v1.4.6 (GNU/Linux)
> > > >
> > > >
> > iD8DBQFHsi5uSamXem9TdyYRAu+2AJ9kySyJYeB5i0tUHIecSLR/VsYDOQCdEGkC
> > > > IWt2vMxtiFfp8BwzFet/J8I=
> > > > =uIlj
> > > >
> > > > -----END PGP SIGNATURE-----
> > > >
> > > > _______________________________________________
> > > > Opensim-dev mailing list
> > > > Opensim-dev at lists.berlios.de
> > > > https://lists.berlios.de/mailman/listinfo/opensim-dev
> > > >
> > > >
> > >
> > >
> > > _______________________________________________
> > > Opensim-dev mailing list
> > > Opensim-dev at lists.berlios.de
> > > https://lists.berlios.de/mailman/listinfo/opensim-dev
> > >
> > >
> >
> >
> > _______________________________________________
> > Opensim-dev mailing list
> > Opensim-dev at lists.berlios.de
> > https://lists.berlios.de/mailman/listinfo/opensim-dev
> >
> >
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
>
> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080213/dfad6ed5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Opensim DB Model General.jpg
Type: image/jpeg
Size: 93492 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080213/dfad6ed5/attachment-0001.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Integration.zip
Type: application/zip
Size: 122704 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080213/dfad6ed5/attachment-0001.zip>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: DB.sql
Type: application/octet-stream
Size: 11955 bytes
Desc: not available
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080213/dfad6ed5/attachment-0001.obj>
More information about the Opensim-dev
mailing list