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

[Impalah]

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'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???
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080215/2ae735e0/attachment-0001.html>