[Opensim-dev] Opensim + Hibernate: It works!!!

[Sean Dague]

On Fri, Feb 15, 2008 at 12:40:02AM +0100, Impalah wrote:
> Hi:
> 
> I've finished for today... I'm tired :-) But I have the work almost done, at
> least it's "functional" (tested on Opensim version of february 5th)
> 
> It's here for download:
> http://ai-designstudio.net/index.php?option=com_docman&task=doc_details&gid=41&Itemid=88889037&lang=en
> 
> There is a prebuild.xml file but we must include "by hand" the
> hibernate.cfg.xml file and all the hbm.xml into the project Persistence.
> Later we must copy these files to the main bin directory (not into mappings
> in bin). The xml files must be configured as "Embedded resources".
> 
> I've included an Opensim.ini file with the configuration. For configuring
> the database:
> - Create A NEW SCHEMA for testing
> - Open hibernate.cfg.xml and set the values for database, user and password.
> - Execute the SQL Alltables.sql (careful with the database name into the
> script, I've used "nhopensim").
> 
> Rebuild and launch...
> 
> What is working now:
> - Create user from the console (maybe any little problem with inventories).
> - Login, build, modify prims (except texture and shape... it's my fault but
> I'm too tired to look for the error). Copy prims, delete, etc.
> - Inventory, create new items, delete, etc.
> - The objects in the region are persisted so they will be there when you
> reboot opensim.
> 
> And the errors:
> - Primshapes and related, sometimes has errors.
> - No "lock" in any method, maybe sometimes there will be threading
> problems... I need to solve this.
> - Sometimes is slow, I need to polish up the code (transactions and
> flushes).

I'm quite excited by this. :)  I'll take some time today to poke at it.

> I've tested the code in Windows with mySql both in .NET and mono. It worked
> ok in both cases.
> 
> I have pending jobs: one is to finish the integration and stabilize, the
> other is to test completely opensim with sqlite and mssql.
> 
> This morning I tested the automatic database model generator (it will be
> included in opensim core) at work, over mssql and sqlite; it worked ok, and
> passed the nunit tests, so I think there won't be any problem (Oracle is
> another objective, maybe next week).
> 
> I will be very grateful if someone test the code and tell me how it works.
> And if there is the possibility of having a SVN repository where Jon and I
> can work it will make easy our work (a branch with an opensim version where
> we can upload the files).
> 
> Greetings
> 
> 
> PD - Ah... the dummy question again: what's the parameter of prebuild to
> include the xml files as embedded resources???

There is an example in the section for MySQL database plugin in ours
today.

	-Sean


> _______________________________________________
> Opensim-dev mailing list
> Opensim-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-dev


-- 
__________________________________________________________________

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.
__________________________________________________________________
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080215/aaea74c2/attachment-0001.pgp>